IBM DataStage Tech Lead

What Working at Hexaware offers:

Hexaware is a dynamic and innovative IT organization committed to delivering cutting-edge solutions to our clients worldwide. We pride ourselves on fostering a collaborative and inclusive work environment where every team member is valued and empowered to succeed.

Hexaware provides access to a vast array of tools that enhance, revolutionize, and advance professional profile. We complete the circle with excellent growth opportunities, chances to collaborate with highly visible customers, chances to work alongside bright brains, and the perfect work-life balance.

With an ever-expanding portfolio of capabilities, we delve deep into and identify the source of our motivation. Although technology is at the core of our solutions, it is still the people and their passion that fuel Hexaware s commitment towards creating smiles.

At Hexaware we encourage to challenge oneself to achieve full potential and propel growth. We trust and empower to disrupt the status quo and innovate for a better future. We encourage an open and inspiring culture that fosters learning and brings talented, passionate, and caring people together.

We are always interested in, and want to support, the professional and personal you. We offer a wide array of programs to help expand skills and supercharge careers. We help discover passion the driving force that makes one smile and innovate, create, and make a difference every day.

The Hexaware Advantage: Your Workplace Benefits
Health benefits with low-cost employee premium.
Range of voluntary benefits such as Legal, Identity theft and Critical Care Coverage training and upskilling opportunities through Udemy and Hexavarsity

Role - IBM DataStage Tech Lead
Location - Mclean, VA- Onsite

Key Responsibilities:
We are seeking an experienced ETL Developer to design, develop, maintain, and modernize enterprise data integration solutions. The role involves building robust ETL pipelines, upgrading legacy batch processes, integrating with cloud data platforms, and collaborating with cross-functional Agile teams to deliver scalable and high-performing data solutions.

Key Responsibilities
Design, develop, test, deploy, and support enterprise ETL applications using IBM DataStage, typically version 11.x or later.
Develop and maintain reliable Extract, Transform, and Load pipelines for enterprise data processing.
Modernize legacy batch processes and migrate workloads to contemporary data platforms and architectures.
Integrate data solutions with cloud technologies, including AWS and Snowflake.
Build scalable and efficient data pipelines using Python and PySpark.
Write, optimize, and troubleshoot complex SQL queries and data transformations.
Develop and maintain UNIX Shell scripts to support ETL workflows and batch processing.
Monitor production jobs, investigate failures, and implement corrective actions to ensure operational stability.
Tune ETL jobs and data pipelines for performance, scalability, and reliability.
Collaborate with product owners, data analysts, developers, testers, and other stakeholders within Agile teams.
Participate in requirements analysis, technical design, code reviews, testing, deployment, and production support activities.
Support integration with legacy technologies and enterprise scheduling platforms.

Required Skills and Experience
Strong hands-on experience with IBM DataStage, preferably version 11.x or later.
Proficiency in SQL and relational database concepts.
Strong experience with UNIX/Linux Shell scripting.
Experience designing, developing, and supporting enterprise ETL and batch-processing solutions.
Practical knowledge of Python and PySpark for data engineering and pipeline development.
Experience working with cloud platforms such as AWS.
Experience with cloud data warehouses, particularly Snowflake.
Strong troubleshooting, analytical, and performance-tuning skills.
Experience working in Agile development environments and collaborating with cross-functional teams.

Privacy Statement:
The information you provide will be used in accordance with the terms of our Privacy Policy and will be used specifically for the business/processing purpose of the event. You should be aware that we may share your details with our approved vendors for this event to be handled successfully.