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.
