ETL (Informatica) Lead/Architect

Job description

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 Base Salary Range : $100,000 to $120,000 Per Annum TCS Employee Benefits Summary: Discretionary Annual Incentive.

Comprehensive Medical Coverage

Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.

Family Support

Maternal & Pa rental Leaves.

Insurance Options

Auto & Home Insurance, Identity Theft Protection.

Convenience & Professional Growth

Commuter Benefits & Certification & Training Reimbursement.

Time Off

Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance

Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing. </div