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.
SQL, Integrations, SQL Server, DB2
US
