Why This Role Stands Out
This role offers a fantastic opportunity to leverage your advanced SQL and Python skills to build critical enterprise integrations, fostering significant career growth within a reputable company. If you excel at translating complex business logic into efficient code and enjoy impactful technical challenges, you'll thrive here and should definitely consider applying.
Quick Overview
Job Description
Role : Senior SQL Integrations Developer
Location: Plano, TX (Onsite)
Duration: Long-term Contract
Job Overview
Our client is seeking a hands-on Senior Developer with deep SQL expertise to join their Integration Team. This role designs, builds, and optimizes data transformations that power enterprise integrations and business applications — translating complex business rules into performant SQL logic across ERP, order management, warehouse, and e-commerce systems, and automating processes with Python.
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
- 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, refactor inefficient queries
- Support ETL/ELT pipelines across on-prem (DB2/iSeries, SQL Server) and cloud (Azure) environments
- Partner with integration developers to define data mappings, transformation rules, and reconciliation logic
- Conduct data profiling, root-cause analysis, and data quality remediation for production issues
- Document data models, transformation logic, and technical designs
- Collaborate with business analysts, QA, and cross-functional IT teams in onsite/offshore model
Required Skills
- 7+ years of hands-on SQL development: complex joins, window functions, CTEs, stored procedures, set-based transformation logic
- 2+ years of Python scripting (pandas, pyodbc/SQLAlchemy, REST API consumption)
- Expertise in performance tuning: execution plans, index design, statistics management, 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 across multiple systems
Similar jobs
- 3R
SharePoint / Power Platform Developer with Security Clearance
New3 Reasons Consulting, LLC
San Diego, CA🇺🇸On-siteYesterdaySQLSQL ServerAzure+2Technology - CS
Senior Full Stack Java Developer
NewCYNET SYSTEMS
Irving, Texas🇺🇸Hybrid45 minutes agoMicroservicesMongoDBMySQL+20Technology - EG
Mendix Developer
NewEnexus Global
Fremont, CA🇺🇸HybridYesterdaySOAPSQLScrum+3Technology - RI
Lead Full Stack Python Engineer
Rose International
Tampa, FL🇺🇸Hybrid1 week agoNode.jsScrumGenerative AI+5Technology - GO
COBOL Developer
GovCIO
United States🇺🇸$53.8k - $72.8k/yrRemote3 weeks agoCOBOLTechnology - LT
Java Full Stack + Gen AI – Design Developer
NewLorven Technologies, Inc.
United States🇺🇸HybridYesterdayDockerMicroservicesNode.js+18Technology - KT
Java Springboot Developer
NewKforce Technology Staffing
Irving, TX🇺🇸HybridYesterdayMicroservicesSpringSpring Boot+6Technology - SG
Applications Development - Sr. Java Developer
NewSoftware Guidance & Assistance
Jacksonville, FL🇺🇸HybridYesterdayDockerExpressMercurial+27Technology - UT
RPA Developer / UiPath Developer must to have UiPath Advanced Developer Certification
NewUnisoft Technology Inc
Washington, DC🇺🇸HybridYesterdayC#Computer Vision.NET+3Technology - SC
Oracle Integration Cloud (OIC) Developer
NewSRS Consulting Inc
Denver, CO🇺🇸HybridYesterdayOraclePL/SQLSQLTechnology - FT
Mid Level Onsite Python Developer with CDE Experience - $90000 - $110000 Hourly Wage
NewFutrend Technology, Inc.
Bethesda, Maryland🇺🇸On-site1 hour agoExpressMongoDBNode.js+16Technology - AA
Associate Developer/Developer, IT Applications
NewAmerican Airlines
Fort Worth, TX🇺🇸HybridYesterdayOracleSOAPOWASP+14Technology