Browse Jobs
Explore open roles across India.Explore active software roles. Sign up to apply and get AI match scores.
Top MatchesTop Job Matches
Loading jobs…
Lead Data Engineer - UPS DIGITAL
UPS
Chennai•On-site•5-8 Yrs•1 hour ago
Job description
Overview
Before you apply to a job, select your language preference from the options available at the top right of this page.
Responsibilities
- Design, develop, and maintain robust database schemas, tables, views, stored procedures, and functions.
- Architect scalable and performant solutions using Azure SQL Managed Instance; exposure to Azure SQL Hyperscale is a strong plus.
- Implement ETL pipelines using SSIS and integrate on-prem/cloud data workloads.
- Develop and maintain reports and dashboards using SSRS.
- Design and orchestrate data workflows using Azure Data Factory (ADF) including pipelines, triggers, and dataflows.
- Manage SQL Agent jobs, automation routines, and operational schedules.
- Collaborate with cloud engineers to ensure optimal performance, security, and reliability in Azure.
- Conduct query tuning, indexing, and performance troubleshooting across high-volume transactional and analytical workloads.
- Analyze execution plans and solve performance bottlenecks.
- Implement best practices for monitoring, alerting, and optimization.
- Lead a team of database developers and/or data engineers, providing technical guidance and code reviews.
- Mentor team members on best practices in SQL development, Azure data services, and optimized data design.
- Collaborate with cross-functional teams (application developers, QA, product owners) in an agile/scrum environment.
- Ensure database solutions adhere to enterprise standards for security, reliability, documentation, and compliance.
- Drive continuous improvement in database development processes and frameworks.
- Participate in sprint planning, backlog refinement, and technical design discussions.
Qualifications
- 14+ years of experience in SQL Server development and database engineering.
- Strong expertise with Azure SQL Managed Instance; exposure to SQL Hyperscale preferred.
- Hands-on experience with:
- SSIS (ETL development)
- SSRS (reporting)
- SQL Agent (job scheduling & automation)
- ADF (pipeline development)
- Advanced SQL skills including performance tuning, query optimization, indexing, and execution plan analysis.
- Solid experience in database design, normalization, table architecture, and data modeling.
- Proven experience leading development teams or acting as technical lead.
- Preferred Skills
- Knowledge of Azure cloud components such as Key Vault, Azure Storage, and monitoring tools.
- Familiarity with Power BI or other visualization tools.
- Strong communication, analytical, and problem‑solving skills.