Design and develop Extraction, Transformation, Load (ETL) processes for enterprise data warehouse using Informatica; Deep hands-on expertise with Informatica ETL processes, development, data management, data profiling, data flows, data relationships, and data quality standards and processes
Hands-on experience with data warehouse development and testing (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc. but preferably Oracle
Analyzing and generating technical requirements and design
Hands on experience with data modeling preferably in a data warehouse environment
Experience with Informatica product suite in the Informatica cloud
Creating source to target mapping database documentation
Assist with migrating data from legacy database to new target database
Preferred Skills:
More than one type of RDBMS (DB2, SQL Server, Oracle)