Our Client is a leading Data Science company specialized in the connected multi-clouds data platform for enterprise analytics. Currently, they are looking for excellent calibers to join their team.
Position Required: Senior Data Integration Consultant
Work Location: Cairo / Egypt
Work Type: 1-year project
Key Areas of Responsibility:
- 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
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
