ETL Data Integration Architect
Job Title: ETL Data Integration Architect
Location: Dubai, UAE
Start Date: December 2019
Duration: 12 months
Roles and Responsibilities:
Primary responsibility to work with Enterprise Information Systems teams to maintain and develop data integration solutions to support our Analytics platform.
Work closely with Business Analysts and help them in business requirement document completion.
Understand business requirements and convert them into detail technical specifications for ETL programs and Data models.
The solutions must align with EDW and dimensional modeling, ETL standards and guidelines.
Design and develop ETL programs using contemporary ETL toolsets (Informatica, Talend, SSIS, AWS Glue etc), PL/SQL, Unix Shell Scripts, and Python.
Performance improvement & tuning of data mappings, SQL & PL/SQL scripts
Technical reviews, data validation & end-to-end testing of ETL Objects, source data analysis and data profiling.
Create necessary documentation as per SDLC standards.
Maintain code version control.
Plan and participate in end-to-end testing.
Provide daily/weekly project status to the project manager.
Work with deployment team in code migration tasks across SDLC environments.
Triage the production issues and work on the code fixes.
Experience with ETL toolset monitoring, configuration, administration and security setup.
Coach and guide managed services team in terms of deployment of ETL jobs, and post production support.
Handle multiple projects in parallel.
Bachelor Degree in Computer Science or relevant
5+ years of experience in implementation of DWH/BI projects in large scale MPP data warehouse environments: Teradata, Greenplum, Netezza, Vertica or a variation.
5+ years of hands on experience in ETL tool architecture and products (Informatica, Talend, SSIS, AWS Glue etc).
5+ years of hands on experience with programming technologies (Python, Unix shell script, Perl etc).
5+ years of converting functional specifications into ETL technical specifications.
2+ years of hands on experience in reporting tools like Tableau, Cognos, etc
Knowledge of end-to-end SDLC process in DWH/BI projects.
Dimensional modelling and data warehouse concepts, such as star schemas, snowflakes, dimensions, facts etc.
Hands on experience with database like Oracle, MSSQL Server and database languages like SQL, PL/SQL and T-SQL.
Strong SQL, PL/SQL tuning & performance improvement skills.
Excellent understanding of data quality concepts.