Who are we?
Circana is a leading provider of technology, AI, and data solutions for consumer packaged goods companies, manufacturers, and retailers. Our predictive analytics and Liquid Data® platform help clients measure market share, uncover consumer behavior, and drive growth—powered by six decades of expertise and an expansive, high-quality data set.
At Circana, we are fueled by our passion for continuous learning and growth, we seek and share feedback freely, and we celebrate victories both big and small in an environment that is flexible and accommodating to our work and personal lives. We’re a global company dedicated to fostering inclusivity and belonging. We value and celebrate the unique experiences, cultures, and viewpoints that each individual brings. By embracing a wide range of backgrounds, skills, expertise, and beyond, we create a stronger, more innovative environment for our employees, clients, and communities. With us, you can always bring your full self to work. Join our inclusive, committed team to be a challenger, own outcomes, and stay curious together. Circana is proud to be Certified by Great Place To Work®. This prestigious award is based entirely on what current employees say about their experience working at Circana. Learn more at www.circana.com.
What will you be doing?
The purpose of this role is to provide technical support, maintenance, and continuous improvement for enterprise data loading and data processing applications built primarily on Microsoft .NET and legacy technologies. The role focuses on ensuring production stability, resolving incidents, supporting SQL Server-based data operations, and delivering application enhancements to meet business and operational requirements. A key aspect of the position is supporting Microsoft SQL Server stored procedures, SQL Agent jobs, and batch data processing workflows while driving operational excellence and system reliability.
Job Responsibilities
- Provide L2/L3 production support for data loading, data processing, and reporting applications.
- Monitor, troubleshoot, and resolve incidents impacting application availability, data integrity, and business operations.
- Support, maintain, and enhance applications developed using .NET technologies and legacy platforms.
- Develop, modify, debug, and optimize Microsoft SQL Server stored procedures, functions, views, and T-SQL scripts.
- Monitor and support SQL Server Agent Jobs, batch processing schedules, and automated data loading processes.
- Investigate failed SQL jobs, data load exceptions, and application errors, ensuring timely resolution within SLA commitments.
- Perform root cause analysis for recurring incidents and implement permanent corrective actions to improve system stability.
- Review execution plans and optimize SQL queries and stored procedures to improve performance and processing efficiency.
- Support application releases, deployments, and post-implementation validation activities.
- Work closely with business users, support teams, and developers to resolve production issues and implement enhancements.
- Validate data loads and troubleshoot data discrepancies across multiple systems and databases.
- Prepare and maintain support documentation, operational procedures, and knowledge base articles.
- Identify opportunities for automation and process improvements to reduce manual effort and recurring incidents.
Requirements Must have:
- 3-7 years of experience supporting enterprise applications in production environments.
- Strong experience with Microsoft SQL Server, including:
- Stored Procedures
- T-SQL Development
- Functions and Views
- Query Optimization
- Performance Tuning
- SQL Agent Jobs
- Database Troubleshooting
- Hands-on experience supporting data loading, ETL, data integration, or batch processing applications.
- Experience providing L2/L3 production support and incident management.
- Strong debugging and troubleshooting skills across application and database layers.
- Experience supporting applications developed in .NET (C#) and legacy environments.
- Proven ability to perform root cause analysis and problem management activities.
- Experience investigating job failures, data processing issues, and application performance bottlenecks.
- Strong understanding of application maintenance, defect resolution, and enhancement delivery.
- Excellent communication skills.
Nice to have:
- Knowledge of the FMCG business domain
- Knowledge of data warehousing and data pipeline concepts.
- Experience in Python
Experience: 3 to 7 Years
Skills: .NET & SQL Support, ETL, Troubleshooting, L2/L3 Support
Location: Whitefield, Bangalore (Hybrid Model)