Data Warehouse Integration Engineer

Concept Plus, LLC; United States; Teletrabalho; USD 90 000 - 120 000; Tempo integral

Resumo da oferta

Concept Plus, LLC is seeking a Data Warehouse/Integration Engineer to support the development, maintenance, and enhancement of an enterprise data warehouse and related integrations. The ideal candidate will bring hands-on experience with Informatica PowerCenter, SQL, and data integration in large-scale environments.

You will design and maintain mappings, sessions, workflows, and data interfaces; optimize performance; and contribute to ongoing data warehouse operations.

Qualificações

• 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

Responsabilidades

• 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

Conhecimentos

SQL

Data modeling

ETL/ELT

Data integration

Analytical skills

Communication skills

Windows scripting

Formação académica

B.S. in Computer Science or related field

Ferramentas

Informatica PowerCenter

Perl scripting

Windows

Descrição da oferta de emprego

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.