Location Name: Pune Corporate Office - Mantri
Job Purpose
Capability to design, develop, and manage SQL Server databases and SSIS-based data integration pipelines supporting Contact Center applications and enterprise systems. Responsible for ensuring reliable, optimized, and secure data operations across multiple platforms including SFTP, Azure Blob Storage, and internal systems, enabling seamless data availability for business operations, reporting, and analytics.c
Duties And Responsibilities
- Strong expertise in SQL Server database development including stored procedures, functions, views, and table design.
- Design, develop, deploy, and maintain SSIS packages for ETL processes across multiple data sources and systems.
- Manage high-volume data processing pipelines supporting operational and analytical workloads.
- Develop and manage SQL Agent jobs for scheduled tasks, batch processing, and automation of recurring processes.
- Automate file processing, monitoring, and operational tasks using PowerShell scripting.
- Manage SFTP integrations including file transfers, validation, monitoring, and failure handling.
- Handle Azure Blob Storage integrations for data ingestion, archival, and retrieval processes.
- Monitor daily ETL jobs and data loads to ensure data availability and adherence to defined SLAs.
- Perform root cause analysis (RCA) for failures and implement preventive fixes.
- Optimize SQL queries and database performance through indexing strategies, execution plan analysis, and query tuning.
- Collaborate with application teams, infrastructure teams, and business stakeholders for deployment and issue resolution.
- Maintain technical documentation including Understanding Documents (UD), Test Cases, MOM, and RCA reports.
- Ensure adherence to data quality standards, security guidelines, and IT governance policies.
Key Decisions / Dimensions
- Selection of optimal database design and query optimization strategies.
- Troubleshooting and resolution of ETL failures and production incidents.
- Implementation of automation mechanisms for file handling and data operations.
- Performance tuning decisions for SQL queries and database workloads.
- Scheduling and orchestration of batch jobs and ETL pipelines.
Major Challenges
- Managing high-volume data loads and ensuring consistent data availability across systems.
- Maintaining reliability and performance of complex ETL workflows involving multiple data sources.
- Troubleshooting production failures and minimizing downtime in SLA-driven environments.
- Handling secure file transfers and integrations with external systems using SFTP and cloud storage.
- Optimizing database performance in large operational datasets.
- Coordinating with multiple IT teams for deployments, troubleshooting, and system integration.
- Managing change requests and deployments without impacting production workloads.
Required Qualifications And Experience
- Minimum qualification required is BE / B.Tech in Computer Science, Information Technology, Electronics, or equivalent discipline from a recognized university.
- 57 years of experience in SQL Server database development, data integration, and ETL implementation.
- Hands-on experience in SQL Server (T-SQL), SSIS development, database performance tuning, and ETL pipeline management.
- Experience in automation using PowerShell, handling SFTP-based file transfers, and integration with Azure Blob Storage or cloud-based data platforms.
- Strong understanding of data processing, batch job scheduling, data validation, and SLA-driven data operations in enterprise environments.
- Experience in production support, troubleshooting ETL failures, performing root cause analysis (RCA), and implementing preventive fixes.
- Exposure to data visualization or reporting tools such as Power BI and familiarity with modern data platforms like Azure Data Lake or Event Hub will be an added advantage.
