Senior Data Warehouse Developer
IntegrateUs LLC · Austin, TXClose:
Term:Full timeWork:OnsiteRemote
Type:EmployeeContract
We are looking for a full-time contractor or employee for a Senior Data Warehouse Developer role.
Perform duties such as design, develop and test Extraction, Transformation, Load (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.
Required Skills:
Perform duties such as design, develop and test Extraction, Transformation, Load (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.
Required Skills:
- 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 using different data sources
- Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities
- Communication, analytical and interpersonal skills at all levels
- Strong technical writing skills
Preferred Skills:
- ERWin or other equivalent data modeling tools
- More than one type of RDBMS (DB2, SQLServer, Oracle)
- Experience in Public Sector delivery
- Certified Data Management Professional (CDMP)
- 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
- Hands on experience with data modeling preferably in a data warehouse environment
- Experience with Informatica product suite in the Informatica cloud
- Texas Workforce Commission Experience
