Good Morning
State of TX : Active and Available C2C Roles : 09/11/2024
MDM Database Architect/Informatica MDM Database Architect 100% Closable
Location: Austin Texas
Client : DFPS Texas Department of Family and Protective Services (DFPS)
Job ID :2025C0004
Candidates currently residing outside of the State of Texas will be required to relocate to Texas if selected for this position and the offer is accepted.
NOTE : Position Will Allow Remote Work Only Within Texas
Previous State Project Experience is Not Required
Exp: Minimum 17 Years
Work involves the following:
Establishes database and system requirements by analyzing and evaluating business operations applications and programming.
Coordinates and gathers data model requirements and assists with the analysis design modification and maintenance of database structures models and architectures.
Supports data analytics and business intelligence systems and coordinates the implementation of database changes to support new and modified applications ensuring that new designs conform to standards and guidelines.
Recommends and develops standards procedures and guidelines on creating and maintaining data models and governed data ensuring completeness and quality.
Reviews changes to logical and physical data modeling metadata relational database models and prepares physical data models from logical data models.
Supports improved data quality by charting the reduction of data redundancy fragmentation and elimination of unnecessary movement of data.
Assists in selecting data management tools and developing the standards usage guidelines and procedures for using those tools to ensure the integrity of the database environment.
Assists in performing root cause analyses related to information issues and nonconformance to published data standards based on review of technical metadata of various source systems.
Works under minimal supervision with considerable latitude for the use of initiative and independent judgment
Minimum Requirements:
Experience in database administration data analysis research or architecture work in Oracle database
Proven experience with data security master data management meta data management and support for creation of data dictionaries data lineage flows and other documentation
Identify the architecture infrastructure and interfaces to data sources tools supporting automated data loads security concerns analytical models and data visualization
Define and govern data modeling and design standards tools best practices and related development for enterprise data models
Experience with identifying and documenting data sources risks and data controls and ability to translate privacy and information security policies into operational procedures
Engage with various business groups and technology to research define and document proper governance and stewardship practices
Experience in master data management metadata reference data data warehousing and business intelligence principles and processes including technical architecture.
Design and Implementation experience of Informatica MDM and its integration with hybrid cloud and onprem environments.
Enterprise data warehouse and storage design experience on both onpremise and cloud
Exposure to data classification clustering deduplication methodologies
Knowledge of enterprise information management processes and methodologies relational database management systems and business intelligence/analytics tools frameworks and infrastructure
Knowledge of database software and technologies cloud technologies and engineered systems and enterprise software products including Microsoft Azure AWS and Oracle
Excellent verbal and written communication skills; ability to tailor communication to audiences of all levels of technical knowledge
Skill in monitoring projects and establishing measurement and tracking for project tasks
Ability to analyze evaluate and summarize data and information for accuracy and conformance to standards
Ability to document policies procedures and processes
Ability to exercise sound judgement critical thinking and analytical skills
Ability to establish and maintain effective working relationships at all levels of the organization
Skill Matrix :
Years
Experience
Experience in database administration data analysis research or architecture work in Oracle database
Proven experience with data security master data management meta data management and support for creation of data dictionaries data lineage flows and other documentation
Identify the architecture infrastructure and interfaces to data sources tools supporting automated data loads security concerns analytical models and data visualization
Define and govern data modeling and design standards tools best practices and related development for enterprise data models
Experience with identifying and documenting data sources risks and data controls and ability to translate privacy and information security policies into operational procedures
Engage with various business groups and technology to research define and document proper governance and stewardship practices
Experience in master data management metadata reference data data warehousing and business intelligence principles and processes including technical architecture.
Design and Implementation experience of Informatica MDM and its integration with hybrid cloud and onprem environments.
Enterprise data warehouse and storage design experience on both onpremise and cloud
Exposure to data classification clustering deduplication methodologies
Knowledge of enterprise information management processes and methodologies relational database management systems and business intelligence/analytics tools frameworks and infrastructure
Knowledge of database software and technologies cloud technologies and engineered systems and enterprise software products including Microsoft Azure AWS and Oracle
Excellent verbal and written communication skills; ability to tailor communication to audiences of all levels of technical knowledge
Skill in monitoring projects and establishing measurement and tracking for project tasks
Ability to analyze evaluate and summarize data and information for accuracy and conformance to standards
Ability to document policies procedures and processes
Ability to exercise sound judgement critical thinking and analytical skills
Ability to establish and maintain effective working relationships at all levels of the organization
***
Knowledge of the Texas Project Delivery Framework
***
Strong working knowledge of the following DFPS systems/programs (including but not limited to): IMPACT PACES ABCS PEIRS NEICE eReport eTravel General Placement Search and Community Based Care.
Thank you
ARJUN K
Manager
Office: (919)/ Ext 108
Mobile : (951)2995015