MDM Database Architect/Informatica MDM Database Architect 100% Closable
Location: Austin Texas
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 |
|