Integration Consultant - ETL, API and Python

Intent Design
Peoria, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 110K

Job location

Peoria, United States of America

Tech stack

API
Amazon Web Services (AWS)
Azure
Cron
ETL
Data Mapping
Database Queries
IBM InfoSphere DataStage
DevOps
File Transfer
Github
JSON
Python
OAuth
Performance Tuning
Cloud Services
Standard Sql
Swagger
Shell Script
Simple Object Access Protocol (SOAP)
SQL Stored Procedures
SQL Server Integration Services
Talend
XML
Datadog
Data Logging
Scripting (Bash/Python/Go/Ruby)
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.

Benefits & conditions

$104,000 - $110,000 a year - Full-time

Apply for this position