Job id : TX-3201900081 (910190930)
Informatica ETL/DW Architect (CDMP) with Oracle/ SQL Server/ DB2, cloud, ERWin and Public Sector Experience
Location : Austin TX (TWC)
Duration : 12+ Months
II.WORKER SKILLS AND QUALIFICATIONS
Minimum Requirements:
Years Skills/Experience
7Design 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.
5Hands-on experience with data warehouse development (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc. but preferably Oracle
3 Experience with Informatica product suite in the Informatica cloud.
StrongProven ability to work successfully with technical and non-technical groups and manage multiple responsibilities.
StrongCommunication, analytical and interpersonal skills at all levels.
StrongStrong technical writing skills.
Preferences:
Years Skills/Experience
4 ERWin or other equivalent data modeling tools
4 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.