Mainframe support Engineer(C2H): PAN INDIA

Sigma Allied Services; Pune District, Mumbai, Bengaluru; Hybrid; INR 800,000 - 1,100,000; Full time

Job summary

Sigma Allied Services is seeking a Mainframe Support Engineer to provide production support for IBM DataStage ETL applications in Pune, India. You will monitor workflows, troubleshoot failures, and ensure data integrity while collaborating with multiple teams.

Candidates should have hands-on DataStage experience, SQL knowledge, and familiarity with Unix/Linux. Experience with ServiceNow/Jira and scheduling tools is a plus.

Qualifications

• Hands-on IBM DataStage experience.
• Knowledge of ETL, data warehousing and data integration concepts.
• Experience with SQL, Oracle, DB2, MySQL or SQL Server.
• Production support experience and incident handling.
• Familiarity with ticketing systems such as ServiceNow or Jira.
• Strong analytical and communication skills.
• Unix/Linux commands and shell scripting proficiency.

Responsibilities

• Provide production support for IBM DataStage ETL applications.
• Monitor ETL workflows and batch processes in production.
• Investigate and resolve ETL job failures and data quality issues.
• Analyse logs, identify root causes, and implement fixes.
• Support data validation and reconciliation activities.
• Collaborate with database, application, and business teams.
• Handle incident, problem, and change management activities.
• Maintain support documentation and knowledge repositories.

Skills

IBM DataStage

ETL concepts

Data warehousing

Data integration

SQL databases

Production support

Ticketing systems

Unix/Linux scripting

Tools

DataStage

ServiceNow

Jira

Control-M

Job description

Mainframe Support Engineer

Location # India

JD

. DataStage Associate to support ETL applications and data integration processes. The role involves monitoring ETL jobs, troubleshooting failures, ensuring data integrity, and supporting production data processing environments

Key Responsibilities

• Provide production support for IBM DataStage ETL applications.
• Monitor and maintain ETL workflows and batch processes.
• Investigate and resolve ETL job failures and data quality issues.
• Analyse logs, identify root causes, and implement fixes.
• Support data validation, reconciliation, and issue resolution activities.
• Collaborate with database, application, and business teams.
• Handle incident, problem, and change management activities.
• Maintain support documentation and knowledge repositories.

Required Skills

• Hands-on experience with IBM DataStage.
• Knowledge of ETL concepts, data warehousing, and data integration.
• Experience working with SQL, Oracle, DB2, MySQL, or SQL Server.
• Ability to troubleshoot ETL job failures and performance issues.
• Experience in production support environments.
• Knowledge of ticketing systems such as ServiceNow or Jira.
• Strong analytical and communication skills.
• Familiarity with Unix/Linux commands and shell scripting.

Preferred Skills

• Exposure to cloud-based data platforms (AWS/Azure).
• Knowledge of scheduling tools such as Control-M.
• Experience in Healthcare, Insurance, Banking, or Retail domains.
• Understanding of data governance and data quality processes.