Data Warehouse Integration Engineer

conceptplus; United States; On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Paid time off

11 paid holidays

Tuition reimbursement

Unlimited training

Job summary

Concept Plus in Fairfax, VA is seeking a Data Warehouse/Integration Engineer to support enterprise data warehouse development, maintenance, and integrations. The ideal candidate has experience with Informatica PowerCenter, SQL, and data integration in enterprise environments.

You will contribute to ongoing operations, optimize performance, and help build cross-system interfaces, mappings, and documentation. US citizenship required; BS in CS or related field; 2+ years in SQL/data warehousing.

Qualifications

• US Citizen required.
• 2+ years of SQL and relational data modeling experience.
• 2+ years of data integration, ETL/ELT, or enterprise data warehouse work.
• Strong analytical and problem-solving abilities with good communication skills.

Responsibilities

• Design, develop, and maintenance of Informatica PowerCenter mappings and workflows.
• Support cross-system data interfaces and data conversion activities.
• Create and maintain data mapping, operations, and maintenance docs.
• Monitor performance and optimize Informatica workflows and SQL queries.

Skills

SQL

Relational data modeling

ETL/ELT

Analytical skills

Communication skills

Education

B.S. in Computer Science or related field

Tools

Informatica PowerCenter

Informatica Data Management Cloud

Windows

Perl scripting

Job description

About Concept Plus

Concept Plus is a mission-focused technology solutions provider that transforms IT concepts into impactful solutions for federal agencies. Headquartered in Fairfax, VA, we bring the agility, responsiveness, and customer intimacy of a small business combined with the quality and infrastructure of a larger firm.

Recognized as an award-winning Oracle partner, we have delivered innovative solutions across Defense, Intelligence, Civilian, Health IT, and Tribal sectors. Our highly certified experts build systems that drive efficiency, accelerate modernization, and ensure mission outcomes with certainty.

We offer competitive pay, comprehensive health, dental, and vision insurance, paid life insurance, paid time off, 11 paid holidays, performance bonuses, tuition reimbursement, unlimited training, and the opportunity to thrive in a collaborative, flexible, and innovative environment.

For more information, visit www.conceptplus.com.

About the role

The Data Warehouse/Integration Engineer will support the development, maintenance, and enhancement of an enterprise data warehouse and related system integrations. The ideal candidate has experience with Informatica PowerCenter, SQL, and data integration in enterprise environments, and can contribute to ongoing data warehouse operations and improvement efforts.

What you'll do

• 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

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
• Experience migrating from Informatica PowerCenter to Informatica Data Management Cloud

Concept Plus is an Equal Opportunity Employer. As such, we will give your application full consideration without regard to your race, color, religion, sex, age, national origin, disability, veteran status, sexual orientation, gender identity, or any other classification protected by federal, state, or local law.