Informatica Developer w/ Data Analyst experience
Leawood, KS. Posted 5 months ago
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,
Ability to reverse and forward engineering relational databases – MS SQL Server, Oracle, and
Ability to reverse and forward engineering of XSD and XML constructs.