Data Warehouse Integration Engineer

Concept Plus
United States
3 days ago
Apply on www.clearancejobs.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
2 years minimum
Working hours
Regular working hours

Tech stack

Cloud Computing Databases Data Conversion Data Integration Extract Transform Load (ETL) Data Warehousing Relational Databases Perl (Programming Language) Monitoring of Systems Performance Tuning SQL Databases Systems Integration
+6 more
Web Services Windows Desktop Informatica Powercenter Database Performance Information Technology Data Management

Job description

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

Requirements

  • 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

Benefits & conditions

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.

About the company

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.clearancejobs.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

3:49 min

Container hosting options available on Amazon Web Services

Federico Fregosi · World Congress 2022

1:14 min

Evolution of distributed SQL database architectures

Wei Hu Wei Hu · World Congress 2024

5:19 min

Executing queries and scheduling pipeline jobs within DataWorks

Qiyang Duan · LIVE

1:52 min

Evolution of distributed SQL database management systems

Akmal Chaudhri Akmal Chaudhri · LIVE

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · World Congress 2022

Videos

See all

Related articles

See all