Production Support Engineer

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.

Disclaimer : This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.