Production Support Engineer

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

Job summary

Systems Plus in Pune, India is seeking an ETL/Data Engineer to maintain and enhance SSIS packages, monitor Azure data pipelines, and support Databricks workloads. The role focuses on daily ETL operations, data validation, and collaboration with onshore teams to ensure timely, reliable data delivery.

You will analyze failures, perform RCA, contribute to data quality checks, and participate in production support with on-call rotation, adhering to SLAs and SOX audit requirements.

Qualifications

• Experience designing and maintaining SSIS packages and data pipelines.
• Proficient in SQL, data profiling and data quality checks.
• Experience with Azure data services and Databricks.
• Familiar with data warehousing concepts and ETL/ELT principles.

Responsibilities

• Maintain and enhance ETL/ELT pipelines and SSIS packages.
• Monitor daily ETL jobs and troubleshoot failures within SLA.
• Participate in RCA for data issues and optimize data loads.
• Support Databricks notebooks and Databricks job executions.
• Ensure compliance with production support procedures.

Skills

SQL Server

SSIS

Azure

Databricks

ETL/ELT Concepts

Data Warehousing Concepts

Good communication

Attention to detail

Job description

• Maintain, and enhance SSIS packages for Daily ETL processes.


• Monitor daily ETL jobs and analyze the root cause /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.


• Monitor Azure resources and data pipelines for successful execution.


• Collaborate with senior team members in cloud migration and modernization initiatives.


• Support security and access management activities in Azure environments.


• Monitor AZ 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 management and request management.


• Ensure compliance with support SLAs and operational procedures.


• Provide proactive status updates and communicate issues to Onshore and stakeholders.


• Create the issue logs and resolution details in confluence


• SOX Audit documentation on regular cycle basis

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.

Systems Plus offers GCC capabilities to help organizations enhance their agility, access specialized talent, and optimize costs while driving innovation. With over 20 delivered GCCs and more than three decades of experience in providing disruptive solutions, Systems Plus helps your organization become a global value organization. At Systems Plus, we provide access to a global talent pool, standardize processes, and enhance collaboration by providing a central hub for shared services and support.