SQL Developer Module Lead
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
Requirements
Department: Engineering, Development, Applications
Function: Information Technology
Experience Level: Associate