Informatica Developer w/ Data Analyst experience

Leawood, KS. Posted 5 months ago

Resource Informatics Group Inc
400 E Royal Lane
Posted By
Upendra Chiluka
6 Months
Start Date
Tech Category
6 - 8 Years
Tech Sub-Category
Data Analysis
Work Permit
Any Work Permit encouraged to apply
Tax Terms

Job Description

Assist in converting the existing OBIA/Informatica data warehouse into SQL Server because the

OBIA platform is nearing its end of life.

 Seeking an Informatica Developer who also worked as a Data Analyst/Modeler.

 In depth knowledge of the Oracle ERP (Finance and HR) concepts and OBIA warehouse


 Key requirement is someone with proven experience in Oracle ERP, OBIA

Warehouse/Informatica development as well as data modeling for a data warehouse.

 (Kimball Dimensional Modeling experience would be preferred).


 Deep understanding of conceptual, logical and physical entity-relationship and data flow


 Deep understanding of EAI (Enterprise Application Integration) data flow concepts.

 Deep understanding of API (Application Programming Interface) data flow concepts.

 Strong SQL skills including SQL Server and Netezza (PDA) technology; writing/updating

complex stored procedures, views, and DML.

 Proficient in data modeling for real time transactional systems.

 Proficient in data modeling dimensional data warehouse concepts.

 Proficient in creation of mapping documents that include tables, files, XML Schema’s – from

source to target.

 Proficient in Master Data Management (MDM) concepts surrounding locations, films, customer,

and products.

 Ability to reverse and forward engineering relational databases – MS SQL Server, Oracle, and


 Ability to reverse and forward engineering of XSD and XML constructs.

Key Skills
OBIA Data Analyst/Modeler

Similar Jobs