Senior Data Engineer (IBM DataStage, ETL, SQL/PLSQL)_6+Yrs_Pune/Bangalore/Indore

Worldpay; Indor; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Global Payments in India seeks an experienced IBM DataStage ETL Developer to design, build and optimize data pipelines, integrating data from Oracle, DB2, Snowflake and more to support analytics and reporting.

You will collaborate with product managers and architects to translate business requirements into scalable ETL solutions, ensuring data quality, performance and governance across warehouse and lakehouse environments.

Qualifications

• IBM DataStage 11.7 or above with parallel jobs, sequencers, parameter sets, Job Monitoring, Administration and Performance Tuning.
• Advanced SQL and PL/SQL development in Oracle and DB2 environments.
• Design, develop, test, deploy and support complex ETL/ELT solutions using DataStage.
• Develop reusable ETL frameworks with parameterized jobs and metadata-driven workflows.
• Analyze requirements and translate them into scalable ETL designs.
• Implement extraction, transformation, validation, cleansing, reconciliation and loading with DataStage.
• Experience integrating data from Oracle, DB2, SQL Server, Snowflake, flat files, XML, JSON, Parquet and cloud storage.

Responsibilities

• Attend stand-up meetings and collaborate with Product Managers, Analysts and Stakeholders.
• Translate business needs into technical solutions for data pipelines.
• Build and enhance Snowflake data pipelines, data transformations and semantic models.
• Design data models, semantic views, APIs and data pipelines.
• Define source-to-target mappings and governance requirements.
• Evaluate performance, scalability and security considerations.

Skills

IBM DataStage

SQL

PL/SQL

Oracle

DB2

SQL Server

Snowflake

ETL/ELT

Job description

What you’ll own

Typical day will be to attend daily stand up meetings and will be a combination of the below activities

Product & Business Collaboration

• Meet with Product Managers, Product Analysts, and Business Stakeholders.
• Understand new business requirements.
• Discuss data needed for new product features, reporting, analytics, or AI use cases.
• Translate business requirements into technical solutions.

Development:

Build and enhance:

• Snowflake data pipelines
• Data transformations
• Semantic models
• Cortex AI solutions
• Data quality validations

Solution Design

• Work with architects and technology teams.
• Design data models, semantic views, APIs, and data pipelines.
• Define source-to-target mappings and governance requirements.
• Evaluate performance, scalability, and security considerations.

Design, develop, and support scalable IBM DataStage ETL solutions and enterprise data

pipelines for mission-critical applications. Collaborate with business and technology teams to

deliver high-quality, performant, and reliable data integration solutions aligned with enterprise

architecture standards. The ideal candidate will have extensive experience working with

multiple source and target systems including Oracle, DB2, Snowflake, flat files, cloud storage,

structured, semi-structured, and unstructured data sources.

The candidate should possess deep expertise in IBM DataStage, Snowflake, Unix Shell Scripting,

PL/SQL, and workflow orchestration tools such as Airflow/Astronomer. This role involves

warehouse, data lake, and Lakehouse platforms, and enabling enterprise analytics and

reporting solutions.

What you’ll bring

Required Skills & Experience

• Strong hands-on experience with IBM DataStage 11.7 or above including parallel Jobs, sequencers, parameter Sets, Job Monitoring, Administration, and Performance Tuning.
• Advanced SQL and PL/SQL development skills with strong experience in Oracle and DB2 environments.
• Design, develop, test, deploy, and support complex ETL/ELT solutions using DataStage and enterprise data pipelines.
• Develop reusable ETL frameworks using IBM DataStage, parameterized jobs, metadata-driven solutions, and automated data processing workflows.
• Analyze business and technical requirements and translate them into scalable ETL designs and data integration solutions.
• Implement data extraction, transformation, validation, cleansing, reconciliation, and loading processes using DataStage.
• Experience integrating data from Oracle, DB2, SQL Server, Snowflake, flat files, XML, JSON, Parquet, and cloud storage platforms using DataStage.

It’s a bonus if you have

• Experience in the payments processing industry
• Experience in handling sensitive data (PCI, PII)
• Experience with Agile Framework for delivering projects

About the team

Our inclusive and global teams win together every day. We’re proud to have the best minds in the industry, who you can learn from as you grow your career. The people, the energy, the connections – it’s unmatched. Come and be part of an ever-evolving company and get dynamic opportunities that go beyond borders.

What makes a Globalpayer?

Globalpayers think like a client, act like an owner and win as one team. We’re curious and innovative – always finding better ways to deliver impact. We empower each other to make decisions, and it’s our passion that drives excellence in everything we set out to do.

Does this sound like you? Then you sound like a Globalpayer.

We offer access to medical coverage that supports the health and wellbeing for you and your family

My Money

In addition to base salary, you may be eligible for bonuses and/or equity awards, determined by role, level, impact, and our policies.

My Lifestyle

We have a dedicated Wellness Week each year – which includes an extra paid day off - so you can take time to relax, recharge and invest in your wellbeing.

My Family

FLEX, our family inclusion community, offers support for all Globalpayers at every stage, from raising families to caring for loved ones

My Time Off

We offer paid time off and public holidays so you can rest, recharge and spend time on what matters most.

Privacy Statement

Global Payments is committed to protecting the privacy and security of all personal information that we process in order to provide services to our clients. For specific information on how Global Payments protects personal information online, please see the Online Privacy Notice.

Sourcing Model

Recruitment at Global Payments works primarily on a direct sourcing model; a relatively small portion of our hiring is through recruitment agencies. Global Payments does not accept resumes from recruitment agencies which are not on the preferred supplier list and is not responsible for any related fees for resumes submitted to job postings, our employees, or any other part of our company.