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.
Our Interview Practices
