Data Integration Specialist, Mid-Level

Jobright.ai; Houston (TX); On-site; USD 70,000 - 80,000; Full time

Benefits offered by this job

Medical insurance

Vision insurance

401(k)

Job summary

A leading technology company in Houston is seeking a mid-level Data Integration Specialist. This role involves designing and maintaining data integration solutions, collaborating with business users, and ensuring data quality. Candidates should have at least 5 years of experience with SQL and data integration tools like Informatica IDMC and GoAnywhere. This full-time position offers a salary range of $70,000 to $80,000.

Qualifications

• Minimum 5 years of SQL development experience.
• Experience working with data integration tools with some experience in Informatica IDMC.
• Ability to coordinate with third-party support providers for troubleshooting.

Responsibilities

• Collaborate with business users to gather requirements and design integration solutions.
• Develop, test, and maintain data integration solutions using relevant tools.
• Manage web services and API integrations with key systems.

Skills

SQL development

Data integration tools

Web services/API integrations

Problem-solving

Communication

Education

BS/BA in computer science or related field

Tools

Informatica IDMC

GoAnywhere

Microsoft SQL Server

Job description

Join to apply for the Data Integration Specialist, Mid-Level role at Jobright.ai

2 days ago Be among the first 25 applicants

Join to apply for the Data Integration Specialist, Mid-Level role at Jobright.ai

Jobright is an AI-powered career platform that helps job seekers discover the top opportunities in the US. We are NOT a staffing agency. Jobright does not hire directly for these positions. We connect you with verified openings from employers you can trust.

Job Summary:

Waukesha-Pearce Industries (WPI) is seeking a Data Integration Specialist to participate in the analysis, design, development, and support of data integration solutions. The role involves collaborating with business users to gather requirements, designing integration solutions, and ensuring data quality and reliability across various systems.

Responsibilities:

• Act as a technical analyst, collaborating directly with business users to gather requirements, understand workflows, and design integration solutions.

• Design, develop, test, and maintain data integration solutions using Informatica IDMC, GoAnywhere, and other data integration tools.

• Utilize Informatica’s database components for staging, metadata, and integration repositories.

• Write, optimize, and maintain complex SQL queries for data extraction, transformation, and loading (ETL).

• Manage web services and API integrations with JD Edwards (JDE) and ServicePro systems.

• Coordinate with third-party technical support providers for advanced troubleshooting and detailed technical issues as needed.

• Document integration processes, data flows, and technical specifications for both business and technical audiences.

• Ensure data quality, reliability, security, and adherence to industry best practices.

• Support and troubleshoot existing integrations in collaboration with users and third-party support partners.

Qualifications:

Required:

• BS/BA degree in computer science or related field preferred.

• Minimum 5 years experience working with data integrations tools in general with some experience with Informatica IDMC.

• Minimum 5 years of SQL development experience, Microsoft SQL server is preferred.

• Proven experience developing data integrations using SQL, GoAnywhere, and Informatica IDMC.

• Hands-on knowledge of Informatica’s database components for staging, metadata, and repository management.

• Experience designing, building, and consuming web services/APIs for system integrations.

• Strong user interaction and requirements analysis skills, with experience working directly with business stakeholders.

• Ability to coordinate with third-party support providers for detailed technical troubleshooting.

• Excellent problem-solving, communication, and documentation skills.

• Familiarity with other ETL tools or data integration platforms.

• Understanding of enterprise data management best practices, data governance, and security.

Preferred:

• Prior experience integrating with JD Edwards (JDE) and ServicePro, or similar ERP and field service platforms.

• Experience with cloud platforms such as AWS, Azure, or Google Cloud.

• Knowledge of additional programming or scripting languages (e.g., Python, Java, C#).

Company:

For over 97 years WPI has been dedicated to solving downtime dilemmas. Founded in 1924, the company is headquartered in Houston, US, with a team of 501-1000 employees. The company is currently Late Stage.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Industries

  Software Development

Referrals increase your chances of interviewing at Jobright.ai by 2x

Inferred from the description for this job

Medical insurance

Vision insurance

401(k)

Get notified when a new job is posted.

Sign in to set job alerts for “Data Integration Specialist” roles.

Houston, TX $70,000.00-$80,000.00 1 week ago

EMAT & UTCD Data Analyst Level 3 - Houston, Texas

Houston, TX $70,000.00-$80,000.00 22 hours ago

EMAT & UTCD Data Analyst Level 3 - Houston, Texas

Principal Governance Analyst, Data Practices & Learning

Entry Level Data Analyst, application via RippleMatch

Houston, TX $60,000.00-$70,000.00 6 days ago

Solutions Engineer | 100% Remote | VC-backed, SaaS Company

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.