Data Integration Lead

Posted One Month Ago
Be an Early Applicant
Hiring Remotely in México
Remote
Senior level
Information Technology • Consulting
The Role
Own and resolve DataStage production incidents and enhancements end-to-end. Design, develop, optimize, and tune DataStage ETL jobs and Oracle SQL/PLSQL. Monitor production pipelines, troubleshoot UNIX processes and scheduling (Control-M), perform root-cause analysis, regression testing, and follow SDLC/CI-CD release processes. Interface with clients and maintain SLAs.
Summary Generated by Built In
Summary Experienced Datastage Developer (Production Support & Enhancements) — responsible for resolving production defects, delivering enhancements, and interfacing with clients. Must be strong in IBM DataStage, Oracle, UNIX, Control-M scheduling, and analytical problem solving. Snowflake experience is a plus. Required technical skills - IBM InfoSphere DataStage (developer & admin familiarity) — job design, parallel jobs, parameterization, shared containers, etc. - Strong Oracle SQL and PL/SQL skills — query tuning, indexes, partitioning awareness. - Solid UNIX/Linux skills — shell scripting, job logs, file handling and basic process troubleshooting. - Production scheduling with Control M (or similar) — job definitions, dependencies, calendars, alerts. - Proven experience diagnosing and resolving production ETL issues under SLA pressure. - Strong analytical and problem-solving skills; able to trace data flow and isolate defects across systems. - Experience with version control, CICD/release processes and deployment across environments. - Good written and verbal communication; comfortable in client-facing situations. Key responsibilities - Own and resolve DataStage production incidents and bugs end-to-end, including root-cause analysis, fixes, regression testing, and deployment to production. - Implement and test enhancement requests and change requests (CRs) in the DataStage environment following SDLC and release processes. - Design, develop, and optimize DataStage jobs and parallel jobs for batch and real-time data integration scenarios. - Perform performance tuning of DataStage jobs, database SQL (Oracle), and UNIX processes to meet SLAs. - Monitor, troubleshoot, and maintain production ETL pipelines; respond to alerts and follow incident management procedures. - Work with Control M (or equivalent schedulers) to design, monitor and maintain job schedules and dependencies; troubleshoot scheduling failures.

Skills Required

  • IBM InfoSphere DataStage developer and admin familiarity (job design, parallel jobs, parameterization, shared containers)
  • Strong Oracle SQL and PL/SQL skills including query tuning, indexes, partitioning awareness
  • Solid UNIX/Linux skills including shell scripting, job logs, file handling and process troubleshooting
  • Production scheduling experience with Control-M or similar (job definitions, dependencies, calendars, alerts)
  • Proven experience diagnosing and resolving production ETL issues under SLA pressure
  • Experience with version control and CI/CD/release processes and deployments across environments
  • Strong analytical and problem-solving skills; ability to trace data flow and isolate defects across systems
  • Good written and verbal communication; comfortable in client-facing situations
  • Snowflake experience

Hexaware Technologies Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Hexaware Technologies and has not been reviewed or approved by Hexaware Technologies.

  • Healthcare Strength Feedback suggests health insurance is a standout element, often described as strong and comparable or better than many employers. Medical coverage and related protections are repeatedly highlighted as reliable pillars of the package.
  • Parental & Family Support Parental leave options, including extended paid leave in some locations, are offered and seen as valuable for family needs. Feedback suggests these policies complement core medical coverage for a more complete family safety net.
  • Wellbeing & Lifestyle Benefits Wellbeing resources such as an Employee Assistance Program, wellness initiatives, on-site gyms, and engagement activities provide lifestyle support. These offerings are reinforced by flexible work options and shift-related extras where applicable.

Hexaware Technologies Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Navi Mumbai, Maharashtra
27,000 Employees
Year Founded: 1990

What We Do

At Hexaware, we're not just a global technology and business process services company; we're a community of 27,000 Hexawarians dedicated to one singular purpose: creating smiles through the power of great people and technology. With a presence in 40+ offices across 19 countries, we empower enterprises worldwide to embark on their digital transformation journey with unparalleled scale and speed. As an employer, we're more than just a workplace. We put our people first, foster diversity and inclusivity, and prioritize their growth through robust learning and development programs. Our culture is a canvas for innovation as we work toward our shared vision of becoming the world’s most loved digital transformation partner. Exciting, isn’t it? Visit www.hexaware.com to join us in embracing the magic of technology, as we passionately advocate for its potential to transform lives today and shape a brighter future. Together, we'll make the digital world a better place.

Similar Jobs

Sequoia Connect Logo Sequoia Connect

Data Integration Lead

Information Technology • Consulting
Remote
México
30 Employees

Sequoia Connect Logo Sequoia Connect

SSIS - Data Integration Lead

Information Technology • Consulting
Remote
México
30 Employees

Mastercard Logo Mastercard

VP - Services Business Development

Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Remote or Hybrid
Mexico City, Ciudad De México, MEX
38800 Employees

Mastercard Logo Mastercard

Specialist, Implementation

Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Remote or Hybrid
Mexico City, Ciudad De México, MEX
38800 Employees

Similar Companies Hiring

Axle Health Thumbnail
Artificial Intelligence • Healthtech • Information Technology • Logistics
Santa Monica, CA
25 Employees
NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Sydney, AU
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account