• Success
    Manage your Success Plans and Engagements, gain key insights into your implementation journey, and collaborate with your CSMs
    Accelerate your Purchase to Value engaging with Informatica Architects for Customer Success
    All your Engagements at one place
  • Communities
    A collaborative platform to connect and grow with like-minded Informaticans across the globe
    Connect and collaborate with Informatica experts and champions
    Have a question? Start a Discussion and get immediate answers you are looking for
    Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
  • Knowledge Center
    Troubleshooting documents, product guides, how to videos, best practices, and more
    Knowledge Center
    One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
    Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
    Information library of the latest product documents
    Best practices and use cases from the Implementation team
  • Learn
    Rich resources to help you leverage full capabilities of our products
    Role-based training programs for the best ROI
    Get certified on Informatica products. Free, Foundation, or Professional
    Free and unlimited modules based on your expertise level and journey
    Self-guided, intuitive experience platform for outcome-focused product capabilities and use cases
  • Resources
    Library of content to help you leverage the best of Informatica products
    Most popular webinars on product architecture, best practices, and more
    Product Availability Matrix statements of Informatica products
    Monthly support newsletter
    Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
    End of Life statements of Informatica products
Last Updated Date May 25, 2021 |

The Data Architect is responsible for the delivery of a robust scalable data architecture that meets the business goals of the organization. The Data Architect develops the logical data models and documents the models in Entity-Relationship Diagrams (ERD). The Data Architect will typically work with the Business Analysts, Data Integration Developers, and the Solution Architect to translate the business requirements into a logical model. The logical model is captured in the ERD, which then feeds the work of the Database Administrator who designs and implements the physical database.

This role involves developing the overall Data Warehouse logical architecture. The physical implementation of the architecture is the responsibility of the Database Administrator.


  • Understands Data Flow- Has a complete understanding of the data that resides in various Data Sources and how it flows through various applications.
  • Controls Data Model Changes- Reviews and analyzes the impact of changes to data structures in logical data models prior to allowing DBAs or Data Modelers to make physical changes.
  • Develops Data Standards- Creates and ensures the use of data standards regarding access, masking, sub-setting, and archiving are developed and communicated to project teams.
  • Applies/Integrates Data Governance Policies-Works with any Data Governance bodies within the organization to ensure architecture designs accommodate any applicable policies.
  • Establishes Data Model-Works with data modelers to create a robust data model for data sources, operational data stores, enterprise data warehouses, and data marts.
  • Maintains Logical Data Object Model- Determines the data elements and defines the process that will reside in the virtual layer. Assumes responsibility for maintaining logical data object models and logical data objects that reside and relate to each other.
  • Reviews Application Metadata- Owns and consolidates critical application metadata for the purpose of metadata and operational statistics reporting needs. Utilizes metadata tools and applies related best practices.
  • Assists Development Teams- Provides inputs on data flows and desired lineage for projects.
  • Maintains Data Quality Metrics- Sets target quality thresholds required for data elements and creates scorecards for monitoring.
  • Plans Data Architectures-Plans architecture and infrastructure to support data management processes and procedures.


  • Experience with the definition and implementation of Enterprise Data Strategy and Data Management Principles.
  • Expertise with data discovery and access, data analysis, data modeling and data virtualization.
  • Extensive experience with various integration areas such as data integration, application integration and business process integration.
  • Strong understanding of and experience with various capabilities like Data Governance, Data Content Management (reference data, master data, metadata, data life cycle, and data quality management), technologies and tools in data modeling, virtualization, profiling, quality management, performance and delivery.
  • Strong business analysis and problem-solving skills.
  • Understanding of multiple data architectures that can support a Data Warehouse.
  • Industry vertical experience is essential
  • Project Solution experience is desired
  • Has experience with at least one RDBMS
  • Ability to translate functional requirements into technical design specifications.
  • Experience in optimizing data loads and data transformations.
  • Interpersonal and leadership skills including collaboration, facilitation and negotiation.
  • Excellent written, verbal, and virtual communication skills.

Table of Contents


Link Copied to Clipboard