Sr DataStage ETL Engineer

Title: Sr DataStage ETL Engineer

Work onsite:26th Street and Madison AveNew York

Type: Contract

Only GC/Citizen/H4 EAD/L2 EAD/TN Visa

Comm skills should be excellent.

Skills Need:

Must have 8 years of experience working for US companies in the US.

Must have 4 years of Recent Banking experience.

Must have at least 7 years of experience with IBM Data Stage version 9.1 11.5.

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

Must specialize in creating enhancing and supporting multiple data pipelines.

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

Must have at least 5 years of experience with different flavors of RDBMS such as Sql Server Oracle DB2 and Vertica)

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

Must have at least 5 years of strong experience in coding using SQL procedures functions and triggers.

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

Must have at least 2 years of working experience in agile development practices

Must have Excellent and Articulate communication skills are a must. Being able to easily identify and discuss with all team members any development needs or recommended approaches is critical.

The JOB:

Client is seeking consultants that will participate as seniors on there DataStage team. The team will ensure that the new database code meets company standards for readability reliability and performance.

Advise developers on the most efficient database designs (tables datatypes stored procedures functions etc).

Developing and maintaining ETL jobs using DataStage to load into the data warehouse.

Work with business analysts and other stakeholders to undersatnd business requirments and ETL jobs that meet thoses requirments.

Consultant must have experience:

1) Writing and improving SQL Server TSQL queries for at least a year. You will be known amongst the office as the goto person for TSQL questions. 2)

Designing tables and picking datatypes o Using Profiler traces and other tools to find the most frequently run queries.

3) Oncall troubleshooting for SQL Server service outages.

4) Deciding whether clustering log shipping mirroring replication etc are the right fit to solve a business problem.