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.