ETL/ODI Developer

SUMMARY:

The ETL Developer provides expertise in data mapping from transactional application to data warehouse and creation of Extract, Transform and Load ("ETL”) software programs. The incumbent will be responsible for designing, developing, testing and documenting ETL programs. The incumbent will be responsible for creating and maintaining logical and physical data models using established enterprise tools and best practices. The incumbent is expected to have solid understanding of database design principles as well as database administration methods and techniques.

ESSENTIAL DUTIES:

• Develop and maintain ETL processes that meet project-specific business and technical requirements and those of the overall enterprise data warehouse data integration portfolio
• Document all processes and support source code control using standard tools and processes
• Perform transactional applications (source) to data warehouse (target) data mapping
• Maintain current knowledge of the technology industry, including leading tools and best practices
• Perform data integrity checks and data validations
• Assist with ensuring the integrity and performance of data structures
• Set standards for technical documentation