Role - ETL (Informatica) Lead/Architect
Experience Required -10+ 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 (Google Cloud Platform)
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