Senior ETL Designer & Developer

30 يناير، 2023

0 0 2 دقائق

الوصف الوظيفي

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.

الوصف الوظيفي

المهارات

Full functional knowledge of Data Warehouse concepts, designing and development of aggregates.
Have 7-10 years of Data warehousing Experience
Demonstrated skills in Teradata & SQL
Has worked on CLDM / CDM / SID or other Data Models for Telcos
Experience in Application development methods, techniques and standards.
In depth knowledge of data modelling methodologies and techniques.
Ability to work well with people from different disciplines with very degrees of technical expertise.
Ability to express complex technical Support for problem resolution.
Knowledge of Telecom industry.
In depth knowledge of Telco business processes and business information models.
Follow change concept and policies.
In depth knowledge of facilitation and conflict resolution processes
A team player with excellent English communication skills.
Experience with multi-national, distributed teams is a plus.

Additional Technical skills:

Must have experience with Teradata Database
Must have strong knowledge and working experience of ETL using Informatica & SQL.
Must have strong analytical skills to define functional requirements.
Experience in application development by using the following tools:
Teradata RDBM/SQL, Teradata Utilities, CLDM (communication Logical Model), HadoopStrong Erwin Experience.
Experience in working on Big Data and its related technologies (Hbase, Hive, NiFi, Impala, presto)