Job ID: TX-2961721DA3ETL (917991109)10A
Informatica ETL/DW Architect (CDMP) with Oracle/SQL Server/DB2, data modeling, cloud, ERWin and government experience
Location: Austin TX (TWC)
Duration: 10 months
7 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.
7 Hands-on experience with data warehouse development (relational and dimensional) nd proven evidence to implement using databases like Oracle, SQL Server etc. but preferably Oracle using different data sources
6 Hands on experience with data modeling preferably in a data warehouse environment.
3 Experience with Informatica product suite in the Informatica cloud.
Strong Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities.
6 ERWin or other equivalent data modeling tools
6 More than one type of RDBMS (DB2, SQLServer, Oracle)
4 Experience in Public Sector delivery
Certified Data Management Professional (CDMP)
Strong Communication, analytical and interpersonal skills at all levels.
Strong Strong technical writing skills.
All work products resulting from the project shall be considered “works made for hire” and are the property of
TWC. TWC may include pre-selection requirements that potential Vendors (and their Workers) submit to and
satisfy criminal background checks as authorized by the Texas law. TWC will pay no fees for interviews or
discussions, which occur during the process of selecting a Worker(s).
TWC is developing a data warehouse solution and requires a Database Architect – senior ETL developer with
proven data warehouse experience to:
Design, develop, and test ETL processes for the data warehouse.
Develop and document ETL processes to extract data from existing systems into the data warehouse.
Document the “as-is” schemas currently in use at TWC.
Perform other analysis and documentation tasks as required to enhance data warehouse functionality.