Senior Data Integration Consultant

Senior Data Integration Consultant

We are hiring.

Position Required: Senior Data Integration Consultant 

Work Location: Nasr City, Cairo, Egypt

 

Requirements:

* Knowledge of any enterprise relational database (Teradata, Oracle, IBM)

* Knowledge of one of industrial ETL tool (Informatica, DataStage,  ODI, SAS DI or others)

* Strong SQL and Shell scripting

* 3+ years of experience with DWH and 5+ Data Engineering experience

* Experience in implementing ETL solutions for large, enterprise-grade customers

* Experience in implementing ETL solutions in Hadoop environment is an advantage

* Knowledge of MPP system – Teradata, is an advantage

* Knowledge of any programming language (Java, Python, Scala and others) is an advantage

* Any ETL tools, DB certified is an advantage

* Experience Unix/Linus OS

* Experience in Enterprise Data Warehouse SQL Optimization 

* Experience using Jira, Git, Jenkins is an advantage

* Knowledge of Metadata driven approach is an advantage

* Experience in Physical Model Optimization

* Advanced Communication skills: being able to communicate with heads of business departments

 

Job Responsibilities:

* Capture ETL Requirements

* Design, develop, test, support processes for extracting, transforming and loading data from source systems to DWH and Data Marts

* Design the processes to meet service level agreements for data timeliness and frequency

* Analyze and optimization current solutions, physical model optimization, query tuning

* Mentoring junior members of the team in data integration development best practices

* Analyze and improve query and solution performance, optimize physical model

* Developing project deliverable documentation