INFORMATICA ARCHITECT SKILLS, EXPERIENCES, AND JOB REQUIREMENTS

Published: Sep 4, 2025 - The Informatica Architect specializes in Master Data Management (MDM) solution design and architecture within the banking domain, with strong capabilities in creating and modifying both logical and physical solution architectures. This role requires expertise in Informatica MDM tools and technologies, including Hub components, data modeling, metadata management, cleansing, deduplication, and implementing data mappings to deliver full lifecycle MDM projects. The architect also works within Agile frameworks, ensuring alignment with technology trends and industry standards while holding multiple Informatica certifications.

Essential Hard and Soft Skills for an Informatica Architect Resume
  • Data Modeling
  • System Design
  • Data Mapping
  • Database Architecture
  • ETL Development
  • Informatica Tools
  • Metadata Strategy
  • Process Mapping
  • Requirement Analysis
  • Documentation Preparation
  • Business Analysis
  • Requirements Gathering
  • Policy Evaluation
  • Data Strategy
  • Technical Communication
  • Project Collaboration
  • Strategic Planning
  • Cross-Team Collaboration
  • Team Mentoring
  • Stakeholder Engagement

Summary of Informatica Architect Knowledge and Qualifications on Resume

1. BS in Data Science with 9 years of Experience

  • Experience in MDM/DG tools on-premise and in the cloud
  • Experience in Pre-Sales, worked on Setup Assessment, built MDM/DG Solutions, agile operating Model, estimations, responded to RFPs, Worked with Partners
  • Experience with at least one of the Master Data Management tools as Informatica MDM, Reltio MDM
  • Experience with at least one of the Data Governance tools as Informatica Axon/EDC, Azure Purview, Collibra
  • Strong understanding of Data Governance, Data Quality, Data Profiling, Data Standards, Regulations, and Security
  • Able to provide data integration services in the Data Management (Informatica PowerCenter, IICS or IDQ), PowerExchange for CDC, z/OS, Unix and PL/SQL scripting
  • Adept at setting and driving strategic initiatives in the functional area, as well as influencing at higher tiers of the organization
  • Expert-level industry knowledge and understanding of a customer's decision-making process, goals, strategies, and business objectives
  • Able to adapt to C-level audience presentations, financial acumen, negotiation, executive presence, and mentoring/coaching of subordinate managers and sales staff
  • Working knowledge of other Informatica (or other ETL) tools
  • Ability to discuss technical and commercial solutions to internal and external parties and adapt depending on the technical or business focus of the discussion
  • Proven track record of authoring high-quality documentation
  • Able to manage and adapt priorities according to client and internal requirements

2. BA in Business Analytics with 6 years of Experience

  • Working experience in Azure or AWS Cloud Architectures and design patterns
  • Experience in developing data analytics architectures
  • Experience in data integration technologies and design patterns
  • Working experience in leading and mentoring Analytics in a direct manager supervision role, mentoring, guiding and setting the direction for the team
  • Consulting expertise in Cloud Migration Readiness Assessment and Strategy development
  • Expertise in Application Portfolio / Workload assessments to identify candidates for Cloud Migration
  • Experience architecting, designing and developing Azure or AWS analytic solutions
  • Strong data management and EDW fundamentals with legacy and modern database and data integration technologies
  • Experience in developing Analytics Cloud and Azure thought leadership in multiple forms, including blogs, white papers and speaking engagements
  • Experience in advising clients about data on cloud migration approaches and applications
  • Experience working in agile development methodologies

3. BA in Operations Management with 4 years of Experience

  • Experience in developing and implementing a Data Warehouse through the ETL process
  • Good knowledge of ETL Informatica
  • Experience in developing Informatica mappings and designs as per business requirements
  • Able to define overall data strategy, tech approach, high-level, low-level design and estimates
  • Strong in DWH concepts and working experience in Oracle, SQL Server
  • Ability to optimize the data loads with a huge volume of data
  • Strong SQL skills on large-scale databases
  • Ability to understand data models

4. BA in Data Management with 6 years of Experience

  • IT expertise with a background in Software Engineering and Software Development
  • Working expertise as an Informatica Data Integration Architecture (Power Center and Data Information Hub)
  • Experience in Informatica Cloud Lake House ( Information Hub, Mass Ingestion and Data Integrations)
  • Experience in working with Azure or Amazon cloud environments
  • Experienced in migration of large on-prem solutions to the cloud
  • Experienced in applying modern Observability-based solutions to both on-prem and Cloud Informatica Platforms (Azure)
  • Experience in Informatica MDM implementation
  • Expertise in Supplier 360 and Informatica SDLC
  • Expertise in integration with ERP
  • Very strong communication skills
  • Significant platform experience in OnPrem and new Cloud platform
  • Able to handle proper data storage for a company or organization
  • Able to use Informatica software to design and maintain data storage systems

5. BA in Information Systems with 5 years of Experience

  • Overall experience in Informatica and ETL process
  • Good technical and architectural knowledge
  • Strong Backend and Frontend design
  • In-depth understanding of the ETL Process in doing extraction from different kinds of Source Systems
  • Ability to analyse requirements, evaluate alternate designs and propose solutions in an Informatica Environment
  • Excellent communication and facilitation skills
  • Good understanding of functional requirements and Business processes
  • Ability to facilitate and coordinate discussions and to manage the expectations of multiple stakeholders
  • Able to identify and implement process improvements in the Informatica development lifecycle
  • Able to work in an onsite-offshore model involving daily interactions with offshore teams to ensure on-time quality deliverables

6. BS in Cybersecurity with 6 years of Experience

  • Working experience in implementing enterprise applications
  • Working experience in implementing B2B and B2C Informatica MDM solutions
  • Working experience in implementing DQ ETL pipelines
  • Working knowledge of product MDM
  • Working knowledge of Java and/or Python
  • Proficiency in Informatica MDM (10.3/.4) and Data Quality (DQ)
  • Proficiency in at least one object-oriented programming language (Java)
  • Proficiency in at least one scripting language (Python)
  • Proficiency with flowcharting/diagraming tools such as draw.io
  • Familiarity with Atlassian products, including Confluence and Jira
  • Strong command of English in both its written and oral forms
  • Familiarity with job orchestration tools such as Airflow

7. BA in Digital Technology Management with 5 years of Experience

  • Experience in areas of Master Data Management solution design and architecture using Informatica MDM in the Banking domain
  • Able to create/modify technical and business solutions architectures (logical and physical)
  • Able to perform analysis and documentation for system design
  • Able to use specific technologies and tools in keeping with current technology trends and standards
  • Able to design and configuration of matching and merging rules and cleansing and deduplication rules
  • Ability to deliver full lifecycle MDM projects for clients including Data modeling and Metadata management, as well as to translate and implement data mappings
  • Hands-on experience with installation and configuration of core Informatica MDM Hub components such as Hub console, Hub Store, Cleanse Match Server and Cleanse Adaptor
  • Must have Informatica Certifications (Informatica MDM, Big Data MDM, MDM Hub Administrator, Hub Developer, Informatica Developer)
  • Experience working in Agile delivery setup with different frameworks, Scrum, Kanban, SAFe

8. BA in Computer Information Systems with 7 years of Experience

  • Experience with Informatica MDM (Configuration, Modelling and Development)
  • Understanding of data modelling, physical schema properties, triggers, and stored procedures
  • Knowledge in the configuration of Informatica Data Director (IDD), E360 and Hierarchy Manager
  • Expert in MDM development in HUB console, complex cleanse functions, Security Access Manager, Match/merge rules set up, Trust enablement, SIF
  • Experience in building SOAP and REST web Services and in using APIs to source data
  • Experience with either Oracle and/or DB2/SQL Server
  • Experience with UNIX and shell script programming
  • Experience with INFA PowerCenter or IICS interfaces
  • Ability to understand customer problems and the engagement objectives in regards to Master Data
  • Experience with Data Engineering
  • Advanced knowledge of data modelling (conceptual, logical and physical) as well as database design
  • Working in a complex environment with a solid understanding of integration
  • Ability to create design documents that illustrate the proposed solution
  • Ability to develop executive communications

9. BA in Data Management with 6 years of Experience

  • Experience in handling Data Projects in AWS Cloud with Informatica, Qlik, Snowflake, Spark, Python/Java
  • Experience in Informatica Cloud Integration platform as a service (iPaaS) solutions, including Data Integration, Cloud data Quality, Data Catalog, Data governance and CDC
  • Experience in Informatica CDC, any Change data capture tool
  • Strong in Data Modelling, SQL
  • Proficiency in any one programming language-python, Java
  • Hands-on experience architecting ETL solutions using Informatica PowerCenter
  • Proficient with Unix Scripting
  • Proficient with Oracle SQL and PL/SQL
  • Strong knowledge of DataStage 
  • Experience in ETL code Migration
  • Experience in automating the ETL flow
  • Extensive experience with building reusable containers/ETL code
Relevant Information
Informatica Administrator Skills, Experiences, and Job Requirements