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

- Valuable communication and stakeholder interaction skills.
- Strong attention to detail and data accuracy.

📌 Production Support Engineer (India)
🏢 systems plus
📍 India