SQL Developer Module Lead

Location: Bengaluru, Karnataka, , India
Department: Information Technology

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.

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.