Job id : TX-3201900081 (910190930)
[Repost] Informatica ETL/DW Developer (CDMP) with Oracle/ SQL Server/ DB2, cloud, ERWin and Public Sector Experience
Location : Austin TX (TWC)
Duration : 12+ Months
II. WORKER SKILLS AND QUALIFICATIONS
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.
5 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
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.
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.