Browse Jobs
For Employers
Post JobLog inGet Started

ETL LEAD

Data Gear
Nozha, Cairo
Posted 8 years ago
47Applicants for2 open positions
  • 3Viewed
  • 1In Consideration
  • 1Not Selected
Search other opportunities

Job Details

Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:

Skills And Tools:

Job Description


Roles and Responsibilities:


  • Expertise in building solutions using leading Extract Transform Load (ETL) tools.
  • Experience with SDLC is a must, exposure to Agile/SCRUM practices is a plus.
  • Drive, design and determine the ETL requirements for the project. Participate in functional design sessions.
  • Ensure ETL design is implemented correctly by the development team.
  • Minimum of two end to end projects completed from ETL system requirements, data mapping, ETL Design, ETL configuration/development, database data modeling activities and ETL components integration.
  • Responsible for ETL design, optimization, development, and hand off to support. Solve unique and complex problems with broad impact on the business and apply version control on project documentations.
  • Develop reusable ETL components and routines that can be shared across multiple ETL processes.
  • Act as recognized subject matter expert (SME) across functional programs/applications/systems and as single point of contact for ETL in assigned projects.
  • Mentor and Coach ETL developers and transfer ETL design and development knowledge. Support developers by providing technical assistance, troubleshooting and alternative development solutions.
  • Determine organizational strategies for data integrity validation processes. Recommend policies and best practices for optimizing ETL data throughput/accessibility. Recommend a plan to expand ETL strategy and best practices from a project level to the enterprise level.
  • Drive the development of best practices for client and mentor developers, analysts and other members of the team. Lead the execution of testing layers such as Code Review and Unit Testing, as well as, participate in Integration Testing and User Acceptance Testing along with Quality Control Lead.

Job Requirements


  • Bachelor Certification from a reputable university.
  • At least 2 years of DWH experience with intensive SQL experience.
  • Minimum of 2 end to end projects completed from ETL system requirements, data mapping, ETL Design, ETL configuration/development, database data modeling activities and ETL components integration.
  • Minimum of 2 years of experience using Oracle Data integration and/or SAS Data Integration.
  • Minimum 5 years of experience in SQL programming.
  • Strong understanding of data integration, quality and validation.
  • In depth understanding of Data warehouse / Data mart concepts.
  • Experience moving data across different types of DBMS / RDBMS.
  • Strong understanding of various data modeling techniques including party model, star and snowflakes schemas.

Desired Skills:

  • Knowledge of SQL Server 2012 is a plus.
  • Experienced in SDLC. SCRUM Methodology is a plus.
  • Excellent written and verbal communication skills and able to interact with IT teams and business partners.
  • Excellent Team management and Coaching Skills.
  • Excellent Presentation skills.
  • Desired Certifications:
  • SAS DI
  • SAS Programming
  • Oracle DI

Featured Jobs

Similar Jobs

Search other opportunities
JobsIT/Software DevelopmentETL LEAD