Job ID: TX-3201900177 (910190517)
Informatica DW/ETL Developer (CDMP) with Oracle/SQL Server/DB2, data modeling, cloud, ERWin and government experience
Location: Austin TX (TWC)
Duration: 12 months
Positions: 2 (2/2)
Minimum Requirements:
Years Skills/Experience
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) and proven evidence to implement using databases like Oracle, SQL Server etc. but preferably Oracle
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.
Strong Communication, analytical and interpersonal skills at all levels.
Strong Strong technical writing skills.
Preferences:
Years Skills/Experience
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)
TWC is developing a data warehouse solution and requires a Data Warehouse Architect 2 – 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 facilitate and support TWC’s Enterprise Data Warehouse Project.
Other Special Requirements: We are interested in every qualified candidate who is currently eligible to work in the United States. The candidate must be available to begin work on the start date agreed upon by TWC and the vendor. TWC does not sponsor visas for staff augmentation contractors.