Description

You will own the ETL development lifecycle for the data warehouse, ensuring code meets high standards for readability, reliability, and performance.

Responsibilities

• Develop and maintain ETL jobs using IBM DataStage to load data into the data warehouse.
• Translate business requirements into functional DataStage jobs and manage project enhancements.
• Advise developers on efficient database designs, including tables, datatypes, stored procedures, and functions.
• Troubleshoot SQL Server service outages and implement solutions such as clustering, log shipping, mirroring, or replication.

Required Skills

• 7+ years of experience with IBM DataStage (versions 9.1 - 11.5).
• 5+ years specializing in ETL using DataStage and creating multiple data pipelines.
• 5+ years of experience with RDBMS including SQL Server, Oracle, DB2, and Vertica.
• 5+ years of experience coding with SQL, procedures, functions, and triggers.
• Strong proficiency in writing and improving SQL Server T-SQL queries.
• Experience using Profiler traces to optimize frequently run queries.
• 8+ years of experience working for US companies in the US.
• 4+ years of recent experience in major banking environments.

Preferred Skills

• 2+ years of experience working within agile development practices.

Key Skills

Education

ANY GRADUATE