About the Role:
We are seeking a highly skilled Senior Data Engineer & SQL Developer to join our team in Pune. This role blends advanced database development expertise with modern data engineering skills, supporting enterprise-scale applications and driving data-driven solutions. You will collaborate with cross-functional teams to design, develop, and optimize data pipelines and database systems, ensuring high performance, reliability, and scalability.
Key Responsibilities:
Database Design & Development
- Design, define, and create robust database schemas for large-scale enterprise applications.
- Develop and optimize stored procedures, functions, complex queries, and indexing strategies for SQL Server and Azure SQL.
- Analyze and extend existing database applications, focusing on normalization, performance optimization, and improvement.
- Implement data security measures and maintain database objects.
Data Engineering
- Build and maintain highly optimized, reliable, and secure data pipelines for real-time and batch processing using technologies such as Apache Spark, Azure Databricks, and Azure Data Factory.
- Operationalize machine learning models in partnership with data scientists and business stakeholders.
- Champion data governance, metadata management, and operational excellence across data platforms.
- Ensure data quality and integrity through validation frameworks and monitoring mechanisms.
Performance & Monitoring
- Continuously identify opportunities to improve performance of production systems (OS, IO, SQL config, indexing, and SQL optimization).
- Partner with QA and application architects to identify and rectify performance bottlenecks pre-release.
- Establish proactive database-level monitoring of all production systems.
Collaboration & Leadership
- Work closely with Product Managers, Scrum Managers, Dev Teams, Test Leads, and other stakeholders.
- Mentor junior engineers and contribute to knowledge sharing across the team.
- Assist in analysis and reporting of aggregate application data to provide insights into operational and business trends.
Modernization & Transformation
- Support technology transformation initiatives, including migration to modern platforms and Azure.
- Leverage ETL tools (SSIS, ADF) and BI tools (Power BI, SSRS, SSIS) for data integration and reporting.
Required Skills & Experience
Technical Skills
- 5+ years of experience in database development and data engineering for large enterprise applications.
- Expert in SQL Server (2012 and above), T-SQL, PL/SQL, database tuning, and performance optimization.
- Strong experience with Azure SQL, SQL MI, and cloud-based data solutions.
- Proficiency in big data technologies (PySpark, Hadoop, Kafka, EventHub, Stream Analytics).
- Experience with ETL tools (SSIS, Azure Data Factory) and BI/reporting tools (Power BI, SSRS).
- Solid understanding of relational and dimensional data modeling, data warehousing concepts, and database normalization.
- Experience in implementing data security and monitoring solutions.
Other Skills
- Strong problem-solving, analysis, design, and estimation skills.
- Excellent communication and collaboration abilities.
- Experience working in Agile/Scrum environments and familiarity with DevOps practices.
- Experience with CI/CD pipelines and version control systems (e.g., Git).
Preferred Qualifications
- Bachelor’s degree in Computer Science, Engineering, or equivalent practical experience.
- 8+ years overall experience in data engineering or related fields.
- Azure Data Engineer Certification or equivalent is a strong advantage.
- Experience in the tax and accounting domain is a plus.
To maintain a fair and genuine hiring process, we kindly ask that all candidates participate in interviews without the assistance of AI tools or external prompts. Our interview process is designed to assess your individual skills, experiences, and communication style. We value authenticity and want to ensure we’re getting to know you—not a digital assistant. To help maintain this integrity, we ask to remove virtual backgrounds and include in-person interviews in our hiring process. Please note that use of AI-generated responses or third-party support during interviews will be grounds for disqualification from the recruitment process.
Applicants may be required to appear onsite at a Wolters Kluwer office as part of the recruitment process.
