> Markdown version of [/jobs/ext/1477864-integration-consultant-etl-api-and-python](https://www.wearedevelopers.com/jobs/ext/1477864-integration-consultant-etl-api-and-python). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Integration Consultant - ETL, API and Python - **Company:** Intent Design - **Location:** Peoria, IL, United States - **Experience:** Expert - **Salary:** $104,000.0 - $110,000.0 - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Amazon Web Services, Microsoft Azure, Cron, Extract Transform Load (ETL), Data Mapping, Database Queries, IBM InfoSphere DataStage, DevOps, File Transfer, Github, JSON, Python (Programming Language), OAuth, Performance Tuning, Cloud Services, Standard Sql, Swagger, Shell Script, Simple Object Access Protocol (SOAP), SQL Stored Procedures, SQL Server Integration Services, Talend, Extensible Markup Language (XML), Datadog, Data Logging, Scripting, Postman, Microsoft Power Automate, Informatica Powercenter, Boomi, Informatica Cloud, Zapier, SOAPAPI, Git, Servicebus, Pandas, Semi-structured Data, Deployment Automation, Cloud Integration, Api Design, Cloudwatch, Api Gateway, Splunk, Serverless Computing, Jenkins, Mulesoft - **Published:** July 29, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=13e9acbb5886ae5f ## About the Role * Python Programming - Strong experience with requests, pandas, JSON/XML parsing, asyncio, logging, and error handling. * ETL Tools - Hands-on experience with Informatica, Talend, SSIS, DataStage, or cloud ETL tools. * API Development - REST/SOAP, Postman/Swagger, API gateways, OAuth2/JWT. * SQL Expertise - Complex queries, stored procedures, performance tuning. * Unix/Linux - Shell scripting, cron jobs, file transfers. iPaaS Platforms - MuleSoft, Boomi, Workato, SnapLogic (preferred). * Cloud Services - Lambda, Functions, EventBridge, Logic Apps, Pub/Sub. ## Description The Integration Consultant (5-8 years experience) is responsible for designing, developing, and maintaining enterprise-grade data and application integrations. The role combines ETL development, API engineering, and Python automation, with additional value for candidates who have experience integrating Coupa or other procurement/supply-chain platforms., * ETL Development - Design, build, and optimize ETL pipelines for structured and semi-structured data across enterprise systems. * API Integration - Develop, consume, and orchestrate REST/SOAP APIs; implement authentication, throttling, and error-handling patterns. * Python Automation - Build Python scripts for ingestion, transformation, API orchestration, and workflow automation. * Data Mapping & Transformation - Create mapping documents, transformation logic, and integration specifications. * Cloud Integration - Implement serverless and managed integration services on AWS, Azure, or GCP. CI/CD & DevOps - Use Git, Jenkins, Azure DevOps, or GitHub Actions for automated deployments. * Monitoring & Logging - Implement dashboards and alerts using Splunk, ELK, CloudWatch, or Datadog. * Stakeholder Collaboration - Work with business and technical teams to gather requirements and deliver integration solutions. ## Related Videos - [From clicks to cribs - How to find your dream home with web scraping](https://www.wearedevelopers.com/videos/767-from-clicks-to-cribs-how-to-find-your-dream-home-with-web-scraping) - [Why make use of an integration platform in today's software developments and infrastructure?](https://www.wearedevelopers.com/videos/758-why-make-use-of-an-integration-platform-in-today-s-software-developments-and-infrastructure) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Our GitOps approach for deploying an Identity Provider and an API Gateway in a SaaS company](https://www.wearedevelopers.com/videos/776-our-gitops-approach-for-deploying-an-identity-provider-and-an-api-gateway-in-a-saas-company) - [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure) ## Related Articles - [The 13 Best Python Libraries for Developers in 2025](https://www.wearedevelopers.com/magazine/371-the-13-best-python-libraries-for-developers-in-2025) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers)