Excellent Opportunity For Informatica Architect / Lead - RelevantZ

Job Description

Position: Informatica Architect / Lead
Experience: 10+ Years
Location: Offshore
Employment Type: Full-Time

Job Summary

We are seeking an experienced Informatica Architect / Lead with 10+ years of expertise in Enterprise Data Integration, Data Warehousing, and Cloud Data Integration. The ideal candidate will be responsible for designing scalable data integration architectures, leading ETL development initiatives, ensuring data quality and governance, and mentoring technical teams. This role requires strong hands-on experience with Informatica platforms, modern data architectures, and stakeholder management.

Key Responsibilities

• Design and implement enterprise-scale data integration architectures using Informatica technologies.
• Lead the development, enhancement, and optimization of ETL/ELT solutions.
• Architect and deliver end-to-end data integration solutions across on-premises and cloud environments.
• Collaborate with business stakeholders, architects, and technical teams to gather and translate requirements into scalable solutions.
• Define data models, data flow architectures, and integration standards.
• Ensure adherence to data governance, data quality, and security best practices.
• Design and implement real-time and batch integration solutions using APIs and integration frameworks.
• Perform performance tuning and optimization of ETL workflows and data pipelines.
• Provide technical leadership, code reviews, mentoring, and guidance to development teams.
• Troubleshoot complex data integration issues and drive root cause analysis.
• Participate in architecture reviews and contribute to enterprise data strategy initiatives.

Required Technical Skills

Informatica

• Informatica PowerCenter
• Informatica Intelligent Cloud Services (IICS/IDMC)
• ETL Design & Development
• Workflow and Mapping Optimization
• Performance Tuning

Data Warehousing & Modeling

• Dimensional Modeling
• Star & Snowflake Schema
• SCD Type 1 & Type 2
• Data Lake / Data Warehouse Concepts
• Data Migration Strategies

Database & SQL

• Oracle
• SQL Server
• PostgreSQL
• Snowflake
• Advanced SQL & Query Optimization