Dutech’s Job

Database Architect/Informatica MDM Architect

Austin,TX

DatePosted : 9/11/2024 11:14:36 AM

JobNumber : DTS101766240
JobType : W2
Skills: Experience in Database Administration, Data Analysis, Research, or Architecture Work, Enterprise Data Warehouse and Storage Design Experience on-premise and cloud
Job Description

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 non-conformance to published data standards based on review of technical metadata of various source systems.

SALARY RANGE: 120K TO 130K Per Annum

CANDIDATE SKILLS AND QUALIFICATIONS

3 Years Required:

Experience in database administration, data analysis, research, or architecture work in Oracle database

Proven experience with data security, master data management, metadata management, and documentation (data dictionaries, data lineage flows)

Expertise in identifying architecture, infrastructure, and interfaces to data sources and tools, including security concerns and analytical models

Knowledge in defining and governing data modeling and design standards, best practices, and enterprise data models development

Experience in documenting data sources, risks, and controls, translating privacy and information security policies into operational procedures

Ability to engage with business groups and technology teams for data governance and stewardship practices

Experience with master data management, metadata, reference data, data warehousing, business intelligence processes, and technical architecture

Design and implementation experience of Informatica MDM, integrated with hybrid cloud and on-prem environments

2 Years Required:

Enterprise data warehouse and storage design experience on-premise and cloud

Exposure to data classification, clustering, and deduplication methodologies

Knowledge of enterprise information management processes, relational database management systems, and business intelligence/analytics tools

Knowledge of cloud technologies (Azure, AWS), engineered systems, and enterprise software products (Oracle)

Excellent communication skills, ability to tailor to various technical levels

Skill in project monitoring, measurement, and tracking tasks

Strong analytical skills in evaluating and summarizing data

Ability to document policies and procedures, make sound judgments, and maintain effective relationships

1 Year Preferred:

Knowledge of the Texas Project Delivery Framework

Knowledge of DFPS systems/programs such as IMPACT, PACES, ABCS, PEIRS, NEICE, and others

SHARE THIS JOB

;