Job Summary
The Lead DataStage Administrator & Integration Engineer will manage, support, and maintain IBM DataStage environments while contributing to enterprise integration initiatives and automation improvements. The role requires deep hands-on DataStage expertise, strong database and scripting skills, and an architectural mindset to optimize legacy solutions, improve operational efficiency, and support a multi-technology integration environment. The engineer will independently resolve complex technical challenges and collaborate with distributed teams to ensure reliable integration operations.
Key Responsibilities
• Administer, support, and maintain IBM DataStage environments and related integration processes.
• Develop, maintain, and troubleshoot DataStage jobs and integration workflows.
• Support enterprise integration and middleware technologies across a multi-technology environment.
• Work with relational database management systems (RDBMS), develop and optimize complex SQL queries, and perform database performance tuning.
• Troubleshoot integration, database, and job execution issues, performing root cause analysis and implementing appropriate resolutions.
• Develop and maintain Unix/Linux scripts to automate operational tasks and improve integration workflows.
• Identify operational bottlenecks, improve legacy solutions, and implement enhancements to increase efficiency and reliability.
• Drive automation initiatives and continuous improvement across integration operations.
• Support workload scheduling and managed file transfer processes using tools such as Control-M and Managed File Transfer (MFT), where applicable.
• Independently manage complex technical challenges and drive assigned initiatives through completion.
• Adapt to new integration technologies and support evolving enterprise integration requirements.
• Collaborate with onshore and offshore teams to coordinate delivery, resolve issues, and maintain operational continuity.
• Communicate technical findings, implementation updates, and recommendations clearly to relevant stakeholders.
Required Qualifications
• 8+ years of hands-on IBM DataStage experience across administration, support, maintenance, and development.
• Strong experience with relational database management systems (RDBMS).
• Experience writing, analyzing, and optimizing complex SQL queries.
• Strong database performance tuning and troubleshooting skills.
• Proficiency in Unix/Linux scripting and automation.
• Strong analytical, problem-solving, troubleshooting, and root cause analysis skills.
• Ability to independently manage complex technical challenges and deliver initiatives to completion.
• Strong verbal and written communication skills.
• Experience collaborating in an onshore-offshore delivery model.
Preferred Qualifications
• Exposure to other enterprise integration and middleware technologies.
• Familiarity with Control-M or other workload automation tools.
• Experience with Managed File Transfer (MFT) solutions.
• Experience identifying architectural bottlenecks and improving legacy integration solutions.
• Demonstrated interest in automation, continuous improvement, and operational efficiency.
