ETL (Informatica) Lead/Architect

Role - ETL (Informatica) Lead/Architect
Experience Required - 5+ Years

Must Have Technical/Functional Skills

ETL Architect with Informatica expertise to design, develop, and optimize enterprise data integration solutions..

" Strong experience with Informatica PowerCenter
" Experience with Informatica IDMC and Google Cloud Platform (GCP)
" Expertise in ETL/ELT architecture and data warehousing concepts
" Strong SQL and database development skills
" Experience with databases such as:
Oracle Database
Microsoft SQL Server
DB2
Yellowbrick
BigQuery
" Knowledge of data modeling techniques (Star Schema, Snowflake Schema)
" Experience with cloud platforms:
Google Cloud
Informatica IDMC
" Familiarity with Unix/Linux shell scripting
" Knowledge of scheduling tools
" Understanding of DevOps, CI/CD, and version control

Roles & Responsibilities -

" Design and implement scalable ETL solutions using Informatica PowerCenter
" Develop enterprise data integration architecture and data migration strategies
" Analyze source systems and create efficient data mapping and transformation logic
" Build and maintain data pipelines for data warehouses and analytics platforms
" Optimize ETL performance, scalability, and reliability
" Collaborate with Product Teams, DBAs, and application teams
" Implement data quality, governance, and security standards
" Troubleshoot ETL failures, data discrepancies, and production issues
" Create technical design documents, architecture diagrams, and best practices
" Lead code reviews, deployment planning, and ETL framework improvements
" Support cloud migration and modernization initiatives.