ETL Informatica Developer

General Duties/Responsibilities: 

• Creates prototypes/ETL specifications based on requirements and analysis of data Designs and develops ETL mappings and workflows/sessions 
• Creates scripts for Oracle database tables and unit tests them Creates/modifies UNIX scripts 
• Ensures adherence to locally defined standards for all developed components 
• Supports the development and design of the internal data integration framework Performs unit tests and initial QA tests with test data Participates in DI design of new Data Warehouse projects 
• Participates in design and development reviews Creates change controls and coordinates approvals for implementation Works with source system owners to resolve source data issues and refine transformation rules Support all on-call production duties 

Education & Experience: 

• Bachelor’s degree in CS or relevant discipline 4+ years of experience as an ETL developer Informatica, Oracle and Unix skills essential 
• Informatica Certification preferred Metadata management and data integrity skills will be an added benefit 
• Effective oral and written communication skills required

Required Skills:

• 9+ years of overall experience and 4+ years of ETL Informatica development
• Knowledge in warehouse and containerization
• Metadata management and data integrity skills will be an added benefit.