SQL Developer Module Lead

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