ETL/ODI DEVELOPERLooking for OAS experience, and preference given to people with Oracle cloud experiencePosition SpecificsExperience with ODI 12CExperience in Data warehousingStrong Communication SkillsWork directly with users to gather requirements and create ETL solutions.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 DutiesDevelop and maintain ETL processes that meet project-specific business and technical requirements and those of the overall enterprise data warehouse data integration portfolioDocument all processes and support source code control using standard tools and processesPerform transactional applications (source) to data warehouse (target) data mappingMaintain current knowledge of the technology industry, including leading tools and best practicesPerform data integrity checks and data validationsAssist with ensuring the integrity and performance of data structuresSet standards for technical documentation