$100,000–$120,000 Per Year
Best Practices, Cloud Computing, Code Reviews, Continuous Deployment/Delivery, Continuous Integration, Data Analysis, Data Management, Data Mapping, Data Migration, Data Modeling, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Database Programming, Database Technology, Design Document, DevOps, Enterprise Architecture, Enterprise Data Integration, GCP (Good Clinical Practices), Identify Issues, Informatica, Legal, Linux Operating System, Loan Funding, Migration Strategy, Performance Tuning/Optimization, SQL Databases, Snowflake Schema, Source Code/Configuration Management (SCM), Star Schema, Student Loans, Systems Analysis, Technical Writing, Technical/Engineering Design, Unix Shell Programming
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.
T
Tata Consultancy Services Ltd