Data Integration Lead

Valce Talent Solutions; United States; Remote; USD 110,000 - 165,000; Full time

Job summary

Valce Talent Solutions is seeking a Data Integration Lead for a remote role. The ideal candidate will own DataStage production support, resolve defects, and deliver enhancements while interfacing with clients. Strong IBM DataStage, Oracle SQL/PLSQL, UNIX, and Control-M scheduling are required.

You will design and optimize DataStage jobs, tune performance, monitor pipelines, and collaborate with cross-functional teams to meet SLA targets in a production environment.

Qualifications

• Experience with IBM InfoSphere DataStage in development and admin contexts.
• Strong Oracle SQL/PLSQL skills including tuning and indexes.
• Solid UNIX/Linux skills with shell scripting and log analysis.
• Experience with production scheduling using Control-M or similar.

Responsibilities

• Own and resolve DataStage production incidents end-to-end.
• Design, develop, and optimize DataStage jobs for batch and real-time data integration.
• Perform performance tuning of DataStage jobs, Oracle SQL, and UNIX processes.
• Monitor pipelines, respond to alerts, and manage deployments across environments.

Skills

DataStage

Oracle SQL

PL/SQL

ETL

SLA management

Analytical thinking

CI/CD

Client-facing

Tools

Control-M

UNIX/Linux

Snowflake

Job description

Data Integration Lead Remote Advanced english Only México 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.