ETL Integration Engineer

As an Assistant Vice President, you will play a crucial role in translating requirements into technical ETL designs, ensuring that our data processes are efficient, compliant, and optimized for performance. You will collaborate closely with Compliance and Operations teams, contributing to our ongoing success by mitigating risks and enhancing our IT infrastructure., * Translate requirements and data mapping documents into technical ETL designs.

• Create and review high-level design solutions.
• Conduct technical walkthroughs of amended DataStage ETL solutions for peer reviews.
• Develop, enhance, and maintain ETL code following JRIA best practices.
• Create and execute unit testing plans; support regression and system testing.
• Debug and resolve issues found during testing and production.
• Promote DataStage ETL code using Perforce and Urban Code deployment tools.
• Validate data for completeness and correctness; ensure ETL code meets expectations.
• Communicate status, issues, and blockers to project managers and ETL team leads.
• Identify and solve opportunities for continuous improvement of ETL interfaces.
• Update and publish documentation, system diagrams, and project plans.
• Attend project and ETL meetings; conduct knowledge transfer sessions.
• Assist Production support teams with resolving production incidents related to ETL processes as needed.

• Several years of hands-on experience with IBM DataStage and various versions.
• Involvement in full project life cycles, from requirements gathering to deployment and maintenance, preferably in Agile or Waterfall environments.
• Proven ability to write complex SQL queries and stored procedures, optimizing for performance with large datasets.
• Proficient in IBM DataStage, including architecture, components, and job design.
• Familiar with relational database systems (e.g., IBM Db2, Oracle, SQL Server) and SQL/PL-SQL programming.
• Experience in designing, developing, and deploying DataStage jobs and complex ETL processes.
• Strong data transformation, cleansing, and integration skills.
• Excellent problem-solving and debugging capabilities.

Pontoon is an employment consultancy. We put expertise, energy, and enthusiasm into improving everyone's chance of being part of the workplace. We respect and appreciate people of all ethnicities, generations, religious beliefs, sexual orientations, gender identities, and more. We do this by showcasing their talents, skills, and unique experience in an inclusive environment that helps them thrive. As part of our standard hiring process to manage risk, please note background screening checks will be conducted on all hires before commencing employment. We use generative AI tools to support our candidate screening process. This helps us ensure a fair, consistent, and efficient experience for all applicants. Rest assured, all final decisions are made by our hiring team, and your application will be reviewed with care and attention.