Data Integration Lead

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.