Integration Consultant - ETL, API and Python

Intent Design

Peoria, IL, United States

19 days ago

Apply on www.indeed.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Compensation

$104,000.0 - $110,000.0

Working hours

Regular working hours

Job source

www.indeed.com

Tech stack

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

+35 more

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

Job 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.

Requirements

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.