Sr. Software Engineer - MS SQL

Experience

5-7 Years

Job Summary

We are looking for a highly skilled SQL Developer with strong expertise in writing and optimizing complex SQL queries and building robust ETL pipelines. Experience with Snowflake and Azure Data Factory (ADF) is a plus. The candidate will play a key role in designing, developing, and maintaining scalable data solutions to support business intelligence and analytics.

Key Responsibilities

SQL Development

• Write, optimize, and maintain complex SQL queries, stored procedures, functions, and triggers.

• Perform query performance tuning and troubleshoot slow-running queries.

• Design and implement data models, indexes, and partitioning strategies for large datasets.

• Ensure data integrity and consistency across multiple systems.

ETL Development

• Design, develop, and maintain ETL workflows for data extraction, transformation, and loading from multiple sources.

• Implement data quality checks, error handling, and logging in ETL processes.

• Optimize ETL jobs for performance and scalability.

• Work with Azure Data Factory (ADF) or similar tools to orchestrate data pipelines.

Snowflake & Cloud Integration

• Develop and manage Snowflake data warehouse solutions including schema design and performance tuning.

• Integrate data from on-premises cloud sources into Snowflake.

• Leverage cloud-based services for data storage processing.

Collaboration & Documentation

Required Skills & Qualifications

• Strong proficiency in SQL (advanced query writing, optimization, indexing, and performance tuning).

• Hands-on experience with ETL concepts, data integration, and transformation techniques.

• Experience with relational databases (e.g., SQL Server, Snowflake).

• Experience with Snowflake (data warehousing, query optimization).

• Strong understanding of data modeling and normalization.

• Excellent problem-solving and analytical skills.

• Work closely with engineers, analysts, and business teams to understand requirements.

• Document technical designs, workflows, and best practices.

Good to Have

• Familiarity with Azure Data Factory (ADF) or other orchestration tools.

• Knowledge of cloud platforms (Azure preferred)

Required Technical/ Functional Competencies

Domain/ Industry Knowledge:

• Basic knowledge of customer's business processes- relevant technology platform or product.
• Able to prepare process maps, workflows, business cases and simple business models in line with customer requirements with assistance from SME and apply industry standards/ practices in implementation with guidance from experienced team members.

Requirement Gathering and Analysis:

• Working knowledge of requirement management processes and requirement analysis processes, tools and methodologies.
• Able to analyse the impact of change requested / enhancement / defect fix and identify dependencies or interrelationships among requirements and transition requirements for the engagement.

Product/ Technology Knowledge:

• Working knowledge of technology product/platform standards and specifications.
• Able to implement code or configure/customize products and provide inputs in design and architecture adhering to industry standards/ practices in implementation.
• Analyse various frameworks/tools, review the code and provide feedback on improvement opportunities.

Architecture tools and frameworks:

• Basic knowledge of architecture Industry tools & frameworks
• Able to analyse available tools and frameworks for review by the SME and plan for tool configurations and development.

Architecture concepts and principles:

• Basic knowledge of architectural elements, SDLC, methodologies.
• Able to apply various architectural constructs in the projects and identify various architectural patterns and implement.

Analytics Solution Design:

• High-level awareness of a wide range of core data science/analytics techniques, their advantages, disadvantages, and areas of application.

Tools & Platform Knowledge:

• Familiar with wide range of mainstream commercial and open-source data science/analytics software tools, their constraints, advantages, disadvantages, and areas of application.

Required Behavioral Competencies

Accountability:

• Takes responsibility for and ensures accuracy of own work, as well as the work and deadlines of the team.

Collaboration:

• Participates in team activities and reaches out to others in team to achieve common goals.

Agility:

• Demonstrates a willingness to accept and embrace differing ideas or perceptions which are beneficial to the organization.

Customer Focus:

• Displays awareness of customers stated needs and gives priority to meeting and exceeding customer expectations at or above expected quality within stipulated time.

Communication:

• Targets communications for the appropriate audience, clearly articulating and presenting his/her position or decision.

Drives Results:

• Sets realistic stretch goals for self & others to achieve and exceed defined goals/targets.

Certifications