SQL-Data Integration Developer

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

•      Bachelor's 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.