Data Warehouse & Integration Engineer — Optimize Enterprise Data Flows

Concept Plus, LLC; United States; Remote; USD 90,000 - 120,000; Full time

Job summary

Concept Plus, LLC is seeking a Data Warehouse/Integration Engineer to support the development, maintenance, and enhancement of an enterprise data warehouse and related integrations. The ideal candidate will bring hands-on experience with Informatica PowerCenter, SQL, and data integration in large-scale environments.

You will design and maintain mappings, sessions, workflows, and data interfaces; optimize performance; and contribute to ongoing data warehouse operations.

Qualifications

• US Citizen
• B.S. in Computer Science, a related technical field, or equivalent experience
• 2+ years of experience with SQL and relational data modeling
• 2+ years of experience with data integration, ETL/ELT, or enterprise data warehouse environments
• Good analytical and problem-solving skills Familiarity with Windows and/or Perl scripting
• Good written and verbal communication skills
• Preferred: Experience tuning Informatica and database performance

Responsibilities

• Support the design, development, and maintenance of Informatica PowerCenter mappings, sessions, workflows, web services, and related data integration processes
• Assist with building and supporting cross-system interfaces, including automated and manual data conversion activities Create and maintain data mapping, operations, and maintenance documentation, including standard procedures and recurring checklists
• Monitor system performance and support tuning efforts for Informatica workflows, SQL queries, and related database processes
• Contribute to the reliability and day-to-day support of enterprise data warehouse integrations and operations

Skills

SQL

Data modeling

ETL/ELT

Data integration

Analytical skills

Communication skills

Windows scripting

Education

B.S. in Computer Science or related field

Tools

Informatica PowerCenter

Perl scripting

Windows

Job description

Concept Plus, LLC is seeking a Data Warehouse/Integration Engineer to support the development, maintenance, and enhancement of an enterprise data warehouse and related integrations. The ideal candidate will bring hands-on experience with Informatica PowerCenter, SQL, and data integration in large-scale environments.

You will design and maintain mappings, sessions, workflows, and data interfaces; optimize performance; and contribute to ongoing data warehouse operations.