Senior DataStage ETL Engineer
3B Staffing LLC, New York, NY, United States
Title:
Senior DataStage ETL Engineer
About the Role:
We are seeking an experienced Senior DataStage ETL Engineer to join a dynamic team within the banking industry. As a senior member, you will be responsible for developing and maintaining ETL jobs, designing efficient database architectures, and optimizing SQL performance. You will collaborate with business analysts and other stakeholders to ensure that data pipelines are robust, scalable, and meet business requirements.
Key Responsibilities:
Develop and maintain ETL jobs using IBM DataStage (versions 9.1 - 11.5) to load data into the data warehouse.
Enhance legacy platforms with scalable and maintainable solutions.
Design efficient database structures including tables, data types, stored procedures, functions, and more.
Troubleshoot and resolve SQL Server service outages and performance issues.
Collaborate with business analysts to understand and meet business requirements.
Optimize database code for readability, reliability, and performance.
Advise on best practices for clustering, log shipping, mirroring, replication, and more.
Must-Have Skills & Qualifications:
8+ years of experience
working for U.S. companies within the United States.
4+ years of recent experience at a major bank
(since 2017).
7+ years of experience with IBM DataStage
(versions 9.1 - 11.5).
5+ years of experience with ETL using DataStage.
Proficient in creating, enhancing, and supporting multiple data pipelines.
Experience with
RDBMS platforms
(SQL Server, Oracle, DB2, Vertica) for at least 5 years.
Strong SQL skills including coding procedures, functions, and triggers.
Proficient in writing complex mapping, operational scripts, and triggers for data integration.
2+ years of experience with agile development practices.
Excellent communication skills
with the ability to clearly discuss development needs and recommended approaches.
Why Join Us?
Opportunity to work as a senior consultant on a high-profile banking project.
Work directly with business analysts and stakeholders to shape data strategies.
Engage in hands-on work with cutting-edge database technologies and optimization techniques.
Long-term contract with opportunities for career growth and professional development.
Senior DataStage ETL Engineer
About the Role:
We are seeking an experienced Senior DataStage ETL Engineer to join a dynamic team within the banking industry. As a senior member, you will be responsible for developing and maintaining ETL jobs, designing efficient database architectures, and optimizing SQL performance. You will collaborate with business analysts and other stakeholders to ensure that data pipelines are robust, scalable, and meet business requirements.
Key Responsibilities:
Develop and maintain ETL jobs using IBM DataStage (versions 9.1 - 11.5) to load data into the data warehouse.
Enhance legacy platforms with scalable and maintainable solutions.
Design efficient database structures including tables, data types, stored procedures, functions, and more.
Troubleshoot and resolve SQL Server service outages and performance issues.
Collaborate with business analysts to understand and meet business requirements.
Optimize database code for readability, reliability, and performance.
Advise on best practices for clustering, log shipping, mirroring, replication, and more.
Must-Have Skills & Qualifications:
8+ years of experience
working for U.S. companies within the United States.
4+ years of recent experience at a major bank
(since 2017).
7+ years of experience with IBM DataStage
(versions 9.1 - 11.5).
5+ years of experience with ETL using DataStage.
Proficient in creating, enhancing, and supporting multiple data pipelines.
Experience with
RDBMS platforms
(SQL Server, Oracle, DB2, Vertica) for at least 5 years.
Strong SQL skills including coding procedures, functions, and triggers.
Proficient in writing complex mapping, operational scripts, and triggers for data integration.
2+ years of experience with agile development practices.
Excellent communication skills
with the ability to clearly discuss development needs and recommended approaches.
Why Join Us?
Opportunity to work as a senior consultant on a high-profile banking project.
Work directly with business analysts and stakeholders to shape data strategies.
Engage in hands-on work with cutting-edge database technologies and optimization techniques.
Long-term contract with opportunities for career growth and professional development.