What are the responsibilities and job description for the ETL Developer position at Texas State Library and Archives Commision?
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 warehouse development and testing (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc. but preferably Oracle.
Experience in Data Science.
Hands on experience with data modeling preferably in a data warehouse environment.
Experience with Informatica product suite in the Informatica cloud.
Experience devising and utilizing algorithms and models to mine data; perform data and error analysis to improve models; clean and validate data for uniformity and accuracy.
Experience with detecting and providing solutions to addressing mismatched data in case management systems.
More than one type of RDBMS (DB2, SQL Server, Oracle).
Erwin or other equivalent data modeling tools.
Experience in Amazon Web Services.
Experience with detecting and providing solutions to addressing mismatched data in case management systems.
Hands-on experience with data warehouse development and testing (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc. but preferably Oracle.
Experience in Data Science.
Hands on experience with data modeling preferably in a data warehouse environment.
Experience with Informatica product suite in the Informatica cloud.
Experience devising and utilizing algorithms and models to mine data; perform data and error analysis to improve models; clean and validate data for uniformity and accuracy.
Experience with detecting and providing solutions to addressing mismatched data in case management systems.
More than one type of RDBMS (DB2, SQL Server, Oracle).
Erwin or other equivalent data modeling tools.
Experience in Amazon Web Services.
Experience with detecting and providing solutions to addressing mismatched data in case management systems.