Sr DataStage ETL Engineer

Title: Sr DataStage ETL Engineer

Work Location:  26th Street and Madison Ave

Duration: 1yr renewable contracts.

Start: ASAP                 

Travel required?  No

Skills Need:

• Must have 12+ years of experience working for US companies.
• Must have at least 8+ years of experience with IBM Data Stage version 9.1 - 11.5. working for US companies in the US.

·       Must have 4 + years of ‘Recent’ Banking or Brokerage experience (Since 2019).

·       Must have min 7 years of experience with ETL using Datastage.

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

·       Perform ''Enhancements'' 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 their 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 understand business requirements and ETL jobs that meet those requirements.

·       Consultant must have experience:
1) Writing and improving SQL Server T-SQL queries for at least a year. You will be known amongst the office as the go-to person for T-SQL questions.
2) Designing tables and picking datatypes
o Using Profiler traces and other tools to find the most frequently run queries.
35) On-call troubleshooting for SQL Server service outages.
6) Deciding whether clustering, log shipping, mirroring, replication, etc are the
right fit to solve the business problems.