Informatica Architect (15+)

InnoSoul • Austin, TX

1d • Hybrid

About The Position

TWC is developing a data warehouse solution and requires a Data Warehouse Architect – senior ETL developer with proven data warehouse experience to design, develop, and test ETL processes for the data warehouse. This role involves developing and documenting ETL processes to extract data from existing systems into the data warehouse, documenting the "as-is" schemas currently in use at TWC, and performing other analysis and documentation tasks as required to facilitate and support TWC's Enterprise Data Warehouse.

Requirements

• 15+ years of experience as an Informatica Architect
• Data warehouse/modeling experience
• Oracle/SQL Server/DB2 experience
• PL/SQL experience
• Dynamic SQL experience
• Cloud experience
• Government experience
• 7 – 8 years of hands-on experience with data warehouse development (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc., preferably Oracle.
• 7 – 8 years of experience with Oracle PL/SQL.
• 6 – 8 years of hands-on experience with data modeling preferably in a data warehouse environment.
• 3 years of 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 technical writing skills.
• Candidates must be residing in Texas or willing to relocate to Texas by their start date.

Nice To Haves

• 6+ years of experience with more than one type of RDBMS (DB2, SQL Server, Oracle).
• 4 years of experience in Public Sector delivery.
• 4 years of experience writing dynamic SQL.

Responsibilities

• 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.

What This Job Offers

• Career Level: Senior
• Education Level: No Education Listed