Data Integration Lead
Mexico4w ago
Key details
- Location
- Mexico
- Work style
- Onsite
- Level
- Senior
- Function
- other
- Focus area
- other
- Posted
- 4w ago
Skills
data integrationetlincident managementlinuxoraclepl/sqlproduction schedulingregression testingroot cause analysissdlcshell scriptingsnowflakesqlunixversion control
About the role
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
How well do you match this job?
Skills
Experience
Level
Title
Location
Salary
Freshness
Similarity
Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.