DataStage Support/PL/SQL
Job Description
Role : DataStage Support/PL/SQL
\n
Location: Pennington, NJ / Addison TX
\n
Duration: Fulltime Role
\n
\n
Must Have Technical/Functional Skills
\n
Primary Skill: IBM DataStage, Oracle, SQL
\n
Preferred: UI –Linux shell script, Autosys
\n
Experience: Minimum 10 years
\n
Roles & Responsibilities
\n
· Provide Level 2/Level 3 production support for IBM DataStage ETL applications.
\n
· Monitor daily ETL batch jobs and ensure successful completion within defined SLAs.
\n
· Analyze, troubleshoot, and resolve production incidents, job failures, and data discrepancies.
\n
· Perform root cause analysis (RCA) and implement preventive measures to avoid recurring issues.
\n
· Monitor data loads, file transfers, scheduler jobs, and downstream system integrations.
\n
· Coordinate with business users, application teams, database administrators, and infrastructure teams for issue resolution.
\n
· Support release deployments, production migrations, and post-implementation validations.
\n
· Handle service requests, incident tickets, problem tickets, and change requests in accordance with ITIL processes.
\n
· Develop and maintain operational runbooks, SOPs, support documentation, and knowledge articles.
\n
Generic Managerial Skills, If any
\n
§ Incident Management, Problem Management, and Change Management experience.
\n
§ SLA monitoring and production support governance.
\n
§ Experience performing Root Cause Analysis (RCA).