Job Description
Job Description
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.