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.