SQL Developer Module Lead

Sopra Steria Group; Bengaluru; On-site; INR 900,000 - 1,400,000; Full time

Job summary

Sopra Steria Group is seeking a highly motivated SQL Developer to build SQL solutions and contribute to Master Data Management (MDM) initiatives. The role focuses on data modeling, performance optimization, and collaboration with business and technical teams.

You will work on designing efficient database structures, tuning queries, and supporting data governance. Training in Semarchy MDM will be provided to develop into an MDM Consultant.

Qualifications

• Strong SQL expertise across complex joins, window functions and subqueries.
• Experience in data modeling, normalization/denormalization, and relational design.
• Familiarity with performance tuning, execution plans, and query optimization.
• Knowledge of MDM concepts and tools is a plus.

Responsibilities

• Develop complex SQL queries, stored procedures, functions, views, and scripts.
• Analyze and optimize SQL performance for large datasets.
• Design logical and physical data models and support data governance initiatives.
• Collaborate with analysts, architects, and stakeholders on requirements and design.

Skills

Complex Joins

Window Functions

CTEs

Subqueries

Query Optimization

Stored Procedures

Functions

Indexing Concepts

Execution Plan

Performance Tuning

Education

BE / B.Tech/ MS/ M.Tech/ MCA

Tools

Oracle

SQL Server

PostgreSQL

MySQL

Job description

Job Description:

Company Description

About Sopra Steria
Sopra Steria, a major Tech player in Europe with 51,000 employees in nearly 30 countries, is recognised for its consulting, digital services and solutions. It helps its clients drive their digital transformation and obtain tangible and sustainable benefits. The Group provides end-to-end solutions to make large companies and organisations more competitive by combining in-depth knowledge of a wide range of business sectors and innovative technologies with a collaborative approach. Sopra Steria places people at the heart of everything it does and is committed to putting digital to work for its clients in order to build a positive future for all. In 2025, the Group generated revenues of €5.6 billion.
The world is how we shape it.

Job Description

We are looking for a highly motivated and technically strong SQL Developer who is passionate about data and eager to build a career in Master Data Management (MDM).

The ideal candidate may not have prior experience in Semarchy MDM but should possess strong expertise in SQL development, database design, data modeling, and performance optimization. The candidate will be trained and mentored to become a Semarchy MDM Consultant and contribute to enterprise-scale data transformation initiatives.

Key Responsibilities:

SQL Development & Database Engineering

• Develop complex SQL queries, stored procedures, functions, views, and scripts.
• Analyze and optimize SQL performance for large datasets.
• Perform query tuning and troubleshooting using execution plans and database performance tools.
• Design and maintain efficient database structures.

Data Modeling & Data Management

• Design logical and physical data models.
• Analyze relationships between business entities and data objects.
• Support data quality, data governance, and data standardization initiatives.
• Identify duplicate and inconsistent data records and propose resolution approaches.

Collaboration

• Work closely with business analysts, architects, data governance teams, and stakeholders.
• Participate in requirement analysis and solution design discussions.
• Contribute to technical documentation and knowledge-sharing activities.

Mandatory Skills

Strong SQL Expertise

Candidate should have hands-on experience in:

• Complex Joins
• Window Functions
• CTEs (Common Table Expressions)
• Subqueries
• Query Optimization
• Stored Procedures
• Functions
• Indexing Concepts
• Execution Plan Analysis
• Database Performance Tuning

Data Modeling

• ER Modeling
• Normalization & Denormalization
• Relational Database Design
• Data Relationships & Hierarchies
• Data Integrity Concepts

Database Technologies

Experience in one or more:

• Oracle
• SQL Server
• PostgreSQL
• MySQL

Desired Behavioral Competencies:

Have strong analytical and problem-solving skills

Are passionate about learning new technologies

Demonstrate ownership and accountability

Show curiosity towards Data Management and MDM

Can quickly adapt to new business domains

Have excellent communication and stakeholder interaction skills

Nice to Have

• Data Migration Experience
• Data Profiling
• Data Quality Tools
• Semarchy, Informatica MDM, Reltio, Profisee, or similar platforms (not mandatory)

MDM Solution Development (Training Provided)

• Learn and contribute to Semarchy MDM platform implementation.
• Configure data models, workflows, validation rules, and business rules.
• Participate in matching, duplicate management, survivorship, and golden record creation processes.
• Support integration of master data across multiple enterprise systems.

Total Experience Expected: 4-8 years

Qualifications

BE / B.Tech/ MS/ M.Tech/ MCA

Additional Information

At our organization, we are committed to fighting against all forms of discrimination. We foster a work environment that is inclusive and respectful of all differences.

All of our positions are open to people with disabilities.

Requirements: