Data Warehouse Integration Engineer-PowerCenter Specialist

Concept Plus, LLC; Fairfax, Northern (VA, KY); Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Paid time off

11 paid holidays

Performance bonuses

Tuition reimbursement

Unlimited training

Job summary

Concept Plus, LLC is seeking a Data Warehouse/Integration Engineer to support development, maintenance, and enhancement of an enterprise data warehouse and related integrations. Ideal candidates have experience with Informatica PowerCenter, SQL, and data integration in enterprise environments.

The role emphasizes building and supporting cross-system interfaces, documenting data procedures, and tuning database performance to ensure reliable warehouse operations in a federal-facing tech

Qualifications

• B.S. in Computer Science or related 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.
• Strong analytical and problem-solving skills.
• Familiarity with Windows and/or Perl scripting.
• Excellent written and verbal communication skills.

Responsibilities

• Support 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 checklists.
• Monitor system performance and support tuning for Informatica workflows, SQL queries, and related database processes.
• Contribute to reliability and day-to-day support of enterprise data warehouse integrations and operations.

Skills

SQL

Relational data modeling

Data integration/ETL

Analytical skills

Perl scripting

Windows familiarity

Communication skills

Education

B.S. in Computer Science or related field

Tools

Informatica PowerCenter

Informatica Data Management Cloud

SQL Server (relational DB)

Job description

Concept Plus, LLC is seeking a Data Warehouse/Integration Engineer to support development, maintenance, and enhancement of an enterprise data warehouse and related integrations. Ideal candidates have experience with Informatica PowerCenter, SQL, and data integration in enterprise environments.

The role emphasizes building and supporting cross-system interfaces, documenting data procedures, and tuning database performance to ensure reliable warehouse operations in a federal-facing tech