09 Sep
|
Happiest Minds Technologies
|
Bengaluru
09 Sep
Happiest Minds Technologies
Bengaluru
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 robust 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.
Collabora
📌 ASSOCIATE PROJECT MANAGER (Bengaluru)
🏢 Happiest Minds Technologies
📍 Bengaluru