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.
Never miss an opportunity! Create an alert based on the job you applied for.