Review and Design the overall technical solution including data modelling, data mapping and overall solution architecture to translate User Requirements.
Working closely with all BUs to map their data and analysis requirements into EDW CLDM and finally projecting the detail/summary on Presentation Layer.
Gathers different BU requirements & Develops all the base business requirements specifications
Informatica ETL framework development.
Works on Teradata EDW and leads the optimization and performance area.
Provide expertise in ETL domain.
Design and code query / report / Informatica Workflows scripts.
Work extensively with ERwin or other data modelling tools.
Ensure data integrity and data quality in DWH BI environment, analysing business requirements. Defining data quality processes and produced documents.
Understanding data flow and load using variety of ETL Tools, and defining end-to-end ETL flow and development guidelines. Has hands on experience with Informatica Power Exchange & Data Exchange.
Follow-up on on-going projects and provide enhancements and best practises on existing systems.
Participate in providing technical support for existing Data Warehouse systems.
Define coding standards, exception handling strategy and metadata design
Follows IT software development processes.
Contribute in writing documentation to describe BI and corrections.
Complies with all Corporate IT security, audit and process standards.
Works with Big Data Solutions including Cloudera, Hadoop, GCP and other Open Source Applications.
Understand of Data Lake and provide a single presentation layer from Data Lake and Data warehouse.
Work with the appropriate project management methodology (Agile or Waterfall) based on project requirements.
Must have knowledge of TM Forum?s Information Framework Shared Information Data Model (SID) and apply in the standardized /non-standardized Data model.
