Production Support Engineer

Systems-Plus; Pune District; On-site; INR 600,000 - 900,000; Full time

Job summary

Systems-Plus is seeking a dedicated Production Support Engineer based in Pune, India. The role involves maintaining and enhancing SSIS packages, monitoring ETL processes, and supporting Azure cloud initiatives. Candidates should possess strong SQL and Azure skills as well as attention to detail.

Responsibilities include troubleshooting failures in ETL jobs, collaborating on cloud migrations, and participating in incident management. The ideal candidate will have a good understanding of data warehousing concepts and excellent communication skills.

Qualifications

• Experience with SQL Server, ETL/ELT concepts, and data warehousing.
• Knowledge of Azure and Databricks is essential.
• Good communication and stakeholder interaction skills are needed.

Responsibilities

• Maintain and enhance SSIS packages for daily ETL processes.
• Monitor daily ETL jobs and resolve failures within SLA.
• Perform data validation and reconciliation during loads.
• Monitor Azure resources and troubleshoot executions.
• Support ingestion of data into Azure Data Lake.
• Document SOX audit findings regularly.

Skills

SQL Server

SSIS

Azure cloud knowledge

Databricks knowledge

ETL/ELT concepts

Data warehousing concepts

Good communication skills

Attention to detail

Job description

Production Support Engineer

Location: Pune | Employment Type: Full Time | Designation: Production Support Engineer

Job Details

Key Responsibilities

• Maintain and enhance SSIS packages for daily ETL processes.
• Monitor daily ETL jobs, analyze root causes, and resolve failures within defined SLA timelines.
• Perform data validation, reconciliation, and quality checks during data loads.
• Participate in root cause analysis (RCA) for ETL failures and data issues.

Azure Cloud Responsibilities

• Monitor Azure resources and data pipelines for successful execution.
• Collaborate with senior team members on cloud migration and modernization initiatives.
• Support security and access management activities in Azure environments.
• Monitor Azure job executions and troubleshoot failures.

Databricks Responsibilities

• Maintain Databricks notebooks.
• Support ingestion of structured and unstructured data into Azure Data Lake.
• Monitor Databricks job executions and troubleshoot failures.

SQL & Database Management

• Write SQL queries, joins, and CTEs.
• Analyze source and target data structures.
• Perform data profiling and data quality analysis.

Production Support & KTLO Activities

• Monitor daily batch processes and data loads.
• Maintain ETL documentation, job schedules, and support runbooks.
• Resolve production incidents and service requests.
• Participate in on‑call support rotation.
• Follow incident and request management processes.
• Ensure compliance with support SLAs and operational procedures.
• Provide proactive status updates and communicate issues to onshore and stakeholders.
• Create issue logs and resolution details in Confluence.
• Document SOX audit findings regularly.

Required Skills

Technical Skills

• SQL Server
• SSIS (SQL Server Integration Services)
• Azure cloud knowledge
• Databricks knowledge
• ETL/ELT concepts
• Data warehousing concepts

Soft Skills

• Good communication and stakeholder interaction skills.
• Strong attention to detail and data accuracy.

Apply Now