Concept Plus, LLC
Posted 31 days agoVerified live 14h ago
Data Warehouse Integration Engineer
Brief overview
Remote
UndergradOr in progress
2+ yrsMinimum
Informatica PowerCenterSQLRelational Data ModelingData IntegrationETL/ELTEnterprise Data WarehousingWindows ScriptingPerl ScriptingInformatica Data Management CloudWritten and Verbal Communication
About the company
Concept Plus, LLCconceptplus.com
Concept Plus is a technology services company offering deep technical expertise, an experienced team, and a dedication to maximizing business productivity.
Job description
Summary
Concept Plus is a mission-focused technology solutions provider that delivers technology solutions for federal agencies. The Data Warehouse/Integration Engineer will support the development, maintenance, and enhancement of an enterprise data warehouse and related system integrations using Informatica PowerCenter, SQL, and enterprise data integration practices.
Responsibilities
- 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
Skills
- 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
- Experience tuning Informatica and database performance
- Experience migrating from Informatica PowerCenter to Informatica Data Management Cloud
Qualifications
Must Haves
- 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
Nice to Haves
- Experience tuning Informatica and database performance
- Experience migrating from Informatica PowerCenter to Informatica Data Management Cloud
Benefits
- Comprehensive health, dental, and vision insurance
- Paid life insurance
- Paid time off
- 11 paid holidays
- Performance bonuses
- Tuition reimbursement
- Unlimited training
- A collaborative, flexible, and innovative environment
More jobs like this
V