Description

You will design and implement high-quality ETL pipelines, ensuring data completeness, accuracy, and adherence to metadata standards.

Responsibilities

• Design and implement complex data pipelines using DataStage, leveraging extensive SQL and PL/SQL skills across MSSQL Server and Teradata.
• Write and optimize stored procedures and Unix shell scripts to support data processing and automation tasks.
• Create and review technical design documents, estimate work packages, and facilitate meetings for design, troubleshooting, and execution.
• Participate in walkthrough reviews of technical specifications, code, and unit test plans to ensure solution quality.
• Drive technical platform evolution, provide third-level support, and present technical topics at team meetings.

Required Skills

• 8+ years of experience in complex, time-sensitive development environments.
• Extensive hands-on experience with IBM DataStage for ETL development.
• Proficiency in PL/SQL and complex SQL within MSSQL Server and Teradata.
• Strong skills in Unix shell scripting and creating stored procedures.
• Working knowledge of GitHub, CI/CD pipelines, and the Software Development Life Cycle (Agile, Waterfall, Iterative).
• Ability to support at-scale testing, including simulations, UAT, and reporting.
• Strong interpersonal and communication skills to collaborate with development teams and promote best practices.

Preferred Skills

• Experience facilitating technical design meetings and managing low-level planning of work packages.

Key Skills

Education

Any Gradute