Enterprise Data Warehouse & ETL Engineer

JobCubby; Northern (KY); Hybrid; USD 85,000 - 120,000; Full time

Job summary

Concept Plus is seeking a Data Warehouse/Integration Engineer to support the enterprise data warehouse and related system integrations. You will design, develop, and maintain Informatica PowerCenter mappings, sessions, and workflows while contributing to reliability and data quality.

The role requires hands-on SQL and data integration experience, plus familiarity with Windows and Perl scripting. Candidates should be US citizens or eligible to work in the US.

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

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

Analytical and problem-solving

Written and verbal communication

Perl scripting

Windows familiarity

Education

Bachelor's degree in Computer Science or related field

Tools

Informatica PowerCenter

Informatica Data Management Cloud

SQL

Job description

Concept Plus is seeking a Data Warehouse/Integration Engineer to support the enterprise data warehouse and related system integrations. You will design, develop, and maintain Informatica PowerCenter mappings, sessions, and workflows while contributing to reliability and data quality.

The role requires hands-on SQL and data integration experience, plus familiarity with Windows and Perl scripting. Candidates should be US citizens or eligible to work in the US.