Senior Technical Analyst, ETL Integration Developer
- P2P SOFTTEK Staffing Services
3 Days Ago
NA
C2C
Peoria-IL
10-15 Years
Required Skills: ETl, SnapLogic, IBM DataStage, Python, AWS Lambda, Boto3, REST API integration, S3, SNS, SQS, DynamoDB, CloudFormation
Job Description
Roles & Responsibilities:
Technical (70%)
- Design, develop, and maintain ETL pipelines using SnapLogic and IBM DataStage for data ingestion, transformation, and integration workflows
- Develop and maintain Python-based AWS Lambda functions for event-driven processing pipelines (invoice processing, data routing, API integrations)
- Build and maintain integrations with enterprise systems such as Coupa AP, Mach1, and EDICOM e-invoicing platforms Perform unit, integration, and end-to-end testing across dev, preprod, and production environments
- Troubleshoot and resolve production issues by analyzing logs, audit trails, and data flow across pipeline components Support infrastructure-as-code (AWS CloudFormation) and CI/CD pipeline operations Ensure code quality, cross-environment parity, and adherence to platform standards
Business & Client Engagement (20%)
- Serve as a bridge between business stakeholders and technical teams — translate business requirements into technical solutions Engage directly with clients and internal stakeholders to gather requirements, provide status updates, and manage expectations
- Participate in solution design discussions, impact analysis, and sprint planning Document functional and technical specifications for integrations and pipeline changes
Team & Delivery (10%)
- Collaborate effectively within an onshore-offshore team model
- Support junior team members through code reviews and knowledge sharing Coordinate with cross-functional teams to ensure timely delivery of integration projects
Required Skills: - SnapLogic and/or IBM DataStage — ETL pipeline development and operations Python — AWS Lambda, boto3, REST API integrations
- AWS services — Lambda, S3, SNS, SQS, DynamoDB, CloudFormation Strong client-facing and communication skills
- Ability to manage priorities and deliverables with minimal oversight Prior experience working in or leading small technical teams
