Must Have Technical/Functional Skills
Primary Skill: SQL ,PL/SQL
Secondary: Informatica
Experience: Minimum 10 years
Roles & Responsibilities
We are seeking an experienced SQL Developer with Informatica expertise to design, develop, and support enterprise data integration and data warehousing solutions. The ideal candidate should have strong hands-on experience in SQL development, ETL processes, data modeling, and Informatica PowerCenter/IDMC within a large-scale enterprise environment.
Key Responsibilities
• Design, develop, test, and maintain complex SQL queries, stored procedures, functions, views, and database objects.
• Develop and support ETL workflows using Informatica PowerCenter and/or Informatica Intelligent Data Management Cloud (IDMC).
• Analyze business requirements and translate them into technical data solutions.
• Perform data extraction, transformation, and loading (ETL) activities from multiple source systems.
• Optimize database performance through query tuning and indexing strategies.
• Troubleshoot ETL failures, data quality issues, and performance bottlenecks.
• Collaborate with business analysts, data architects, and application teams to deliver data integration solutions.
• Implement data validation, reconciliation, and quality checks.
• Support production deployments and resolve production incidents.
• Create and maintain technical design documentation and operational runbooks.
• Participate in data migration, modernization, and cloud transformation initiatives.
• CI/CD deployments
• Experience in Git/Bitbucket
TCS Employee Benefits Summary:
Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternal & Parental 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.
Salary Range: $100,000 - $120,000 a year
