Mainframe Support Engineer

Sigma Allied Services; India; Hybrid; INR 600,000 - 800,000; Full time

Job summary

Sigma Allied Services in India is seeking a DataStage Associate to support ETL applications and data integration. The role focuses on monitoring ETL jobs, troubleshooting failures, ensuring data integrity, and supporting production data processing environments.

Key responsibilities include providing production support for IBM DataStage, monitoring workflows, investigating job failures, data quality issues, and collaborating with database, application, and business teams.

Qualifications

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

Responsibilities

• Provide production support for IBM DataStage ETL applications.
• Monitor 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 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

SQL / Databases

Unix/Linux scripting

ETL concepts

Production support

Data quality

Communication

Tools

ServiceNow

Jira

Control-M

Job description

1. Role #Mainframe Support Engineer
2. Location # India
3. JD is as below.

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 DataStageETL 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.
• Familiarity with Unix/Linux commands and shell scripting.
• Experience in production support environments.
• Knowledge of ticketing systems such as ServiceNow or Jira.
• Strong analytical and communication skills.

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.