Lead ETL Developer

Job highlights

• Should be able to take a loosely-defined assignment and produce robust programs
• At least 5 years of this experience should be ETL development experience.
• Expert in Oracle PL / SQL,SQL,and SQL tuning . Data architecture experience: familiar with relational and dimensional data model,able to design solution based on existing data models

1. Participate in project that will take existing Oracle transactional data and ETL into enterprise data warehouse and data mart.
2. Participate in solution design activities including requirements gathering, ETL design development
3. Develop detail ETL programs for the project.
4. Clearly document and communicate technical designs, solutions, and issues.
5. Help to support and maintain production environment as needed.
6. Adhere to and enforce client s software development methodology and standards, which include functional and technical designs, code reviews, unit integration testing, source control and packaging of code.
7. Collaborate with the quality assurance team in developing testing plans and streamlining testing activities

Required Skills:

1. Expert in Informatica for ETL development, data warehousing and ETL theory
2. Expert in Oracle PL/SQL, SQL, and SQL tuning
3. Data architecture experience: familiar with relational and dimensional data model, able to design solution based on existing data models.
4. A strong sense of ownership
5. An ability to work independently without strict oversight and without being handed a task-list of discrete steps. Should be able to take a loosely-defined assignment and produce robust programs.
6. An ability to accurately estimate and plan his/her design, development, and testing work.
7. The ability to work collaboratively with team members from IT (BA, PM, integration developer) and the business (business leads and SMEs)
8. An ability to quickly learn our specific environments, IT processes, and technical change management procedures, and then begin to productively complete design and development activities within two weeks of his/her start date.
9. Experience developing custom-built software using state-of-the-art software engineering principles and practices. This includes professional coding practices (modularity, documentation including code comments, high level designs, data flow diagrams, unit testing) as well as experience in different development methodologies (waterfall and agile). At least 5 years of this experience should be ETL development experience.