Description

  • 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)
  • erwin or other equivalent data modeling tools
  • Experience in Amazon Web Services
  • Texas Workforce Commission experience

Education

Any Gradute