Sr. Data Integration Engineer

Envision Technology Solutions; Milwaukee (WI); On-site; USD 120,000 - 150,000; Full time

Job summary

Envision Technology Solutions in Milwaukee, WI seeks a Sr. Data Integration Engineer to lead hands-on ETL/ELT development and application connectivity across a modern enterprise landscape, with a focus on Talend and modernization of MuleSoft integrations.

This long-term contract role requires deep expertise in enterprise data integration and scalable solutions. You will partner with Solution Architects, Application Teams, Data Platform Teams and Business Analysts to design, test, and support

Qualifications

• Direct hands-on experience with Talend Data Integration.
• Solid understanding of OnPremise and hybrid Talend configurations including TAC, JobServers and Qlik Talend Cloud environments.
• Strong experience developing ETL and ELT solutions in enterprise environments.
• Experience analyzing, supporting or converting MuleSoft integrations.
• Strong SQL development and database integration experience.
• Experience integrating Salesforce platforms and APIs.
• Experience integrating Snowflake.
• Experience with Microsoft SQL Server.
• Experience developing integrations using REST APIs, SOAP services, JSON and XML.
• Experience with SFTP platforms and data exchange patterns.
• Experience with Git and CI/CD deployment processes.
• Strong troubleshooting, debugging and performance optimization skills.

Responsibilities

• Serve as a Talend SME for development, testing, deployment, and support of enterprise integration solutions.
• Design and develop Talend jobs, workflows, data pipelines, and orchestration processes.
• Build and maintain batch, near real-time, and event-driven integrations.
• Optimize Talend jobs for performance, scalability, maintainability, and reliability.
• Analyze existing MuleSoft integrations and migrate to Talend as part of modernization.
• Develop ETL/ELT solutions for enterprise apps, data warehouses, and analytics.
• Develop integrations across Salesforce, Snowflake, SQL Server, REST/SOAP APIs, and SFTP/file-based patterns.
• Maintain technical documentation, runbooks, and deployment procedures.
• Participate in Agile ceremonies including sprint planning and reviews.

Skills

ETL/ELT development

Data integration

Troubleshooting

Tools

Talend

MuleSoft

Salesforce

Snowflake

SQL Server

REST API

SOAP API

JSON

XML

SFTP

Git

CI/CD

Job description

Job Title: Sr. Data Integration Engineer

Location: Milwaukee, WI (5 days onsite)

Duration: Long term Contract

Job Description:

• Seeking a Senior Data Integration Engineer to serve as a hands-on subject matter expert SME for enterprise data integration ETL or ELT development and application connectivity across a modern enterprise technology landscape.
• Partners closely with Solution Architects Application Teams Data Platform Teams and Business Analysts to design develop test and support integration solutions with a primary focus on Talend and modernization of existing MuleSoft based ETL integrations.
• Responsible for building maintaining troubleshooting and enhancing enterprise integrations that support business critical applications data platforms analytics and operational processes.

Scope Accountability Impact

• 10+ years of experience in enterprise integration ETL or ELT development middleware platforms or data engineering.
• 5 years of hands-on Talend development experience including design development deployment and support of production integrations.
• Develops and supports enterprise integrations connecting cloud and on premise platforms within established architecture and governance standards.
• Identifies and escalates integration performance data quality and operational risks to Solution Architects and platform leadership.

Roles and Responsibilities:

Talend Development Integration Delivery

• Serve as a Talend subject matter expert responsible for developing testing deploying and supporting enterprise integration solutions.
• Design and develop Talend jobs workflows data pipelines orchestration processes and reusable integration components.
• Build and maintain batch near Realtime and event driven integration processes supporting operational and analytical workloads.
• Optimize Talend jobs for performance scalability maintainability and operational reliability.

MuleSoft Migration Modernization

• Analyze existing MuleSoft integrations APIs transformations and integration workflows.
• Translate MuleSoft integration logic and data transformation patterns into Talend based solutions.
• Support enterprise modernization initiatives involving migration of MuleSoft integrations to Talend
• Validate data integrity business logic and operational functionality during migration activities.

Data Integration Transformation

• Develop ETL and ELT solutions supporting enterprise applications data warehouses and analytics platforms.
• Implement data transformation cleansing validation enrichment reconciliation and error handling frameworks. Support data quality auditability lineage and operational monitoring requirements.

Platform Connectivity

• Develop and maintain integrations across Salesforce Snowflake Microsoft SQL Server REST APIs SOAP services SFTP platforms flat files cloud applications and enterprise data platforms.
• Build and support integrations utilizing JSON XML CSV API based file based and database based connectivity patterns

Operational Excellence

• Support production deployments troubleshooting root cause analysis incident resolution and performance tuning activities.
• Maintain technical documentation integration specifications deployment procedures and operational runbooks.
• Participate in Agile development activities including sprint planning backlog refinement code reviews and testing activities.

Required Qualifications:

• Direct hands on experience with Talend Data Integration required.
• Solid understanding of OnPremise and hybrid Talend platform hardware and software configurations including Talend OnPremise environments using Talend Administration Center TAC and JobServers and Qlik Talend Cloud environments using Qlik Talend Cloud QTC and Remote Engines.
• Strong experience developing ETL and ELT solutions in enterprise environments.
• Experience analyzing supporting or converting MuleSoft integrations.
• Strong SQL development and database integration experience.
• Experience integrating Salesforce platforms and APIs.
• Experience integrating Snowflake.
• Experience working with Microsoft SQL Server.
• Experience developing integrations utilizing REST APIs SOAP services JSON XML and related technologies.
• Experience with SFTP platforms file-based integration patterns and data exchange processes.
• Experience with Git source control management and CICD deployment processes.
• Strong troubleshooting debugging and performance optimization skills.

Preferred Strong Plus Qualifications:

• Talend Data Integration or Talend Cloud certifications.
• Experience with Azure Data Factory.
• Experience with Qlik Replicate CData Sync Informatica or similar data integration tools.
• Experience working within Snowflake based data platforms.
• Experience supporting Data Warehouse Data Lake or Medallion Architecture environments.
• Experience with scripting languages such as Python PowerShell or Shell Scripting.
• Experience supporting largescale enterprise integration environments utilizing Agile.