Senior Data Integration Consultant

Senior Data Integration Consultant

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 fulfill the following position.

"Senior Data Integration Consultant"

Work Location: 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

Key Area 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