ETL Informatica Developer

Collabera is seeking to hire an ETL Informatica Developer for one of its top banking clients.DayToDay Responsbilities:

• Design and development lead for Oracle data warehouse with Informatica ETL
• Coordinate onshore and offshore design and development efforts, including meeting with the team daily to discuss ongoing work
• Track project deliverables and meet deadlines using SAFe Agile methodology
• Review requirements and translate them into high-level and low-level design
• Responsible for design and development of Oracle tables and stored procedures using Third Normal Form
• Responsible for design and development of Informatica data mappings, sessions, workflows, and scripts
• Responsible for development of AutoSys job schedules that integrate with upstream and downstream systems
• Responsible for unit testing, code reviews, debugging, and performance testing, with key focus on data accuracy and integrity
• Responsible for release preparation activities, including implementation plan, change requests, code packaging, and resource planning.
• Work with the production support teams as needed to support production activities, including production migrations, L3 support, continuity testing, and environment migration activities.
• Must have impeccable written and oral communication skills down to the mapping documentation level

• 8+ years of Informatica Power Center 10.x or above
• Minimum of 5+ years of Oracle, Oracle Exadata, SQL Server, or another industry accepted database platform
• 3+ years of Data Warehouse / Data Mart / Business Intelligence
• 2+ years of Linux / shell scripting complementary with Informatica
• Experience job scheduling using AutoSys or another industry accepted scheduling tool
• Experience leading a team of developers
• Great communication and soft skills