Senior Data Warehouse/Integration Engineer

Concept Plus is a mission-focused technology solutions provider that transforms IT concepts into impactful solutions for federal agencies. The Senior Data Warehouse/Integration Engineer will support the development, maintenance, and modernization of a large-scale enterprise data warehouse and related system-to-system integrations.

Responsibilities:

• Design, build, and maintain Informatica PowerCenter mappings, sessions, workflows, web services, and related data integration pipelines
• Build and support cross-system interfaces, including automated and manual data conversion processes, in alignment with project milestones
• Create and maintain accurate data mapping, operations, and maintenance documentation, including standard procedures and recurring checklists
• Assess system performance and implement tuning strategies for Informatica workflows, SQL queries, and related database processes
• Support ongoing integration reliability, scalability, and operational readiness across enterprise data warehouse environments

Requirements:

• US Citizen
• BS in Computer Science, a related field or equivalent experience
• 5+ year's experience with advanced SQL and relational data modeling
• 5+ year's experience with data integration, ETL/ELT, and enterprise data warehouse environments
• Strong analytical and problem-solving skills
• Knowledge of Windows and/or Perl scripting
• Strong written and verbal communication skills
• Experience tuning Informatica and database performance
• Knowledge of scripting languages such as Windows scripting and Perl
• Experience migrating from Informatica PowerCenter to Informatica Data Management Cloud
• Familiarity with APIs and web services in ITSM products such as ServiceNow and/or Learning Management Systems such as Cornerstone OnDemand