Sr DataStage ETL Engineer

Job Description

Seeking Sr DataStage ETL Engineers that will advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc) as well as :

• Developing and maintaining ETL jobs using DataStage to load into the data warehouse.
• Work with business analysts and other stakeholders to understand business requirements and ETL jobs that meet those requirements.

Requirements

Skills

Required / Preferred

Years

Candidate Experience

Experience working for US companies in the US.

Required

Must have 4 + years of 'Recent' Banking experience (Since 2019).

Required

Experience with IBM Data Stage version 9.1 - 11.5.

Required

Must have min 5 years of experience with ETL using Datastage.

Required

Must specialize in creating, enhancing, and supporting multiple data pipelines.

Required

Perform 'Enhancements' to to legacy platforms by providing scalable and maintainable solutions.

Required

Experience with different flavors of RDBMS such as SQL Server, Oracle, DB2, and Vertica)

Required

Manage the development and deployment of New projects and enhancement in the ETL process using Datastage.

Required

Strong experience in coding using SQL, procedures, functions and triggers.

Required

Must have extensive experience writing complex mapping, operations scripts and triggers to load data in to data warehouses and database and integration.

Required

Working experience in agile development practices

Required

Benefits

Benefit Package includes :