ASSOCIATE PROJECT MANAGER - SQL

Happiest Minds Technologies; Bengaluru; On-site; INR 1,800,000 - 2,800,000; Full time

Job summary

Happiest Minds Technologies is seeking a hands-on Senior Developer with deep SQL expertise to join our Integration Team in Bengaluru. You will design, build, and optimize data transformations powering ERP, OMS, WMS, and e-commerce integrations, translating complex business rules into performant SQL logic and automating processes with Python.

The role emphasizes end-to-end data problem solving—from profiling source data to tuning complex queries and ensuring reliable data delivery across on-prem

Qualifications

• 7+ years of hands-on SQL development experience with complex joins, window functions, and set-based logic.
• 2+ years of Python scripting for data processing, automation, or integration tasks.
• Proven experience implementing business rules and data transformations for system-to-system integrations.
• Experience with at least one enterprise RDBMS: SQL Server, DB2, Oracle, or PostgreSQL.
• Strong data analysis and problem solving; ability to trace data issues across systems.
• Effective communication and experience working with distributed onsite/offshore teams.

Responsibilities

• Design and develop complex SQL transformations for enterprise integrations between ERP, WMS, OMS, product data, and e-commerce platforms.
• Implement business logic in SQL objects and transformation layers translating requirements into reliable code.
• Develop Python scripts for data movement, validation, automation, file processing, and API integrations.
• Tune query performance by analyzing execution plans, indexing strategies, and refactoring heavy queries.
• Support ETL/ELT pipelines across on-prem DB2/iSeries, SQL Server and cloud Azure environments.
• Collaborate with integration developers to define data mappings and reconciliation logic across Boomi interfaces.
• Profile data, perform root-cause analysis, and remediate data quality issues in production.
• Document data models, transformation logic, and deployment standards.

Skills

SQL Development

Python

Data Integration

Performance Tuning

Data Modeling

Data Profiling

Communication

Onsite/Offshore Collaboration

Education

Bachelor's degree in CS/IS/Engineering

Tools

SQL Server

DB2

Oracle

PostgreSQL

Azure Data Services

Job description

Position Summary

We are seeking a hands-on Senior Developer with deep SQL expertise to join our Integration Team. This role designs, builds, and optimizes the data transformations that power our enterprise integrations, and business applications translating complex business rules into performant SQL logic, supporting data flows across ERP, order management, warehouse, and e-commerce systems, and automating processes with Python. The ideal candidate is a strong individual contributor who thrives on solving data problems end-to-end: from profiling and modeling source data, to writing and tuning complex queries, to ensuring data lands accurately and on time in downstream systems.

Key Responsibilities

• Design and develop complex SQL transformations supporting enterprise integrations between core systems (ERP, order management, warehouse management, product data, and e-commerce platforms).
• Implement business logic in SQL stored procedures, views, functions, and transformation layers translating functional requirements into reliable, maintainable database code.
• Develop and maintain Python scripts for data movement, validation, automation, file processing, and API-based integrations.
• Perform query and database performance tuning: analyze execution plans, optimize indexing strategies, refactor inefficient queries, and resolve throughput bottlenecks in high-volume transactional and reporting workloads.
• Support ETL/ELT pipelines and data workflows across on-prem (DB2/iSeries, SQL Server) and cloud (Azure) environments.
• Partner with integration developers to define data mappings, transformation rules, and reconciliation logic for interfaces built on middleware platforms (e.g., Boomi).
• Conduct data profiling, root-cause analysis, and data quality remediation for production issues; provide timely resolution for integration and reporting defects.
• Document data models, transformation logic, and technical designs; follow change management and deployment standards.
• Collaborate with business analysts, QA, and cross-functional IT teams (onsite and offshore) throughout the development lifecycle.

Required Qualifications

• Bachelors degree in Computer Science, Information Systems, Engineering, or equivalent practical experience.
• 7+ years of hands-on SQL development experience, including complex joins, window functions, CTEs, stored procedures, and set-based transformation logic.
• Proven experience implementing business rules and data transformations for system-to-system integrations.
• 2+ years of Python scripting for data processing, automation, or integration tasks (pandas, pyodbc/SQLAlchemy, REST API consumption, or similar).
• Demonstrated expertise in performance tuning: reading execution plans, index design, statistics management, and query refactoring on large datasets.
• Experience with at least one enterprise RDBMS at scale (SQL Server, DB2, Oracle, or PostgreSQL).
• Strong data analysis and problem-solving skills; ability to trace data issues across multiple systems.
• Effective communication skills and experience working with distributed onsite/offshore teams.

Preferred Qualifications

• Strong hands-on experience with Microsoft SQL Server as the primary development platform (T-SQL, stored procedures, SSMS, query optimization), with the ability to work across heterogeneous database environments.
• Working knowledge of IBM DB2 on iSeries/AS400, Oracle, and other enterprise RDBMS platforms comfortable reading, querying, and integrating data from these systems as integration sources and targets.
• Exposure to Azure data services (Azure SQL, Data Factory, Synapse, Databricks, or Cosmos DB) and hybrid on-prem/cloud data environments.
• Familiarity with integration middleware such as Boomi, MuleSoft, or similar iPaaS platforms.
• Experience in supply chain, distribution, or retail domains order management (IBM Sterling OMS), warehouse management (Infor WMS), or product/master data (STIBO PIM/MDM).
• Experience with source control (Git), CI/CD for database code, and Agile delivery.