Production Support Engineer

Location: Pune Employment Type: full-time

Job Details

Key Responsibilities

SSIS Development & Support

• 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.

Azure Cloud Responsibilities

• 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.