Tata Consultancy Services logo

ETL Developer (Teradata +Informatica)

0 years

0 Lacs

chennai tamil nadu india

Posted:1 month ago| Platform: Linkedin logo

Apply

Skills Required

etl developer teradata informatica testing data sql querying tuning design extract extraction analyze integration optimization query resolve integrity consistency documentation code coding database scalability

Work Mode

On-site

Job Type

Full Time

Job Description

Job Title: ETL Developer (Teradata & Informatica PowerCenter)

Location: Mumbai, Pune, Chennai

Years of Experience: 8 to 10 yrs

Mode of Interview: Virtual

Notice Period: 0-15/30 days or Immediate joiners are preferred


Job Summary:


The ETL Developer will be responsible for designing, developing, testing, and implementing robust and efficient ETL processes using Informatica PowerCenter to integrate data from diverse source systems into a Teradata data warehouse. This role requires strong expertise in SQL for data manipulation, querying, and performance tuning within the Teradata environment. The successful candidate will collaborate with business analysts, data architects, and other stakeholders to understand data requirements and deliver high-quality data solutions.


Key Responsibilities:

  • Design, develop, and maintain ETL processes using Informatica PowerCenter to extract, transform, and load data into the Teradata data warehouse.
  • Develop complex SQL queries, stored procedures, and scripts for data extraction, transformation, and loading in the Teradata environment.
  • Collaborate with business analysts and data architects to gather and analyze data integration requirements and translate them into technical specifications.
  • Perform performance tuning and optimization of ETL processes and SQL queries to ensure efficient data loading and optimal query performance.
  • Troubleshoot and resolve issues related to data integration, ETL processes, and data quality.
  • Ensure data integrity, consistency, and accuracy throughout the ETL process.
  • Develop and maintain documentation for ETL processes, data mappings, and data models.
  • Participate in code reviews and ensure adherence to coding standards and best practices.
  • Work closely with data modelers and database administrators to ensure the scalability and performance of the Teradata data warehouse.


Kindly attach your updated resume

More Jobs at Tata Consultancy Services

Tcs Hiring For GRC , Pan India

Pune, Bengaluru, Mumbai (All Areas)

7 - 12 yrs
|

INR 9 - 19 Lacs

Java / Spring boot with API Developer

Pune

5 - 10 yrs
|

INR 9 - 19 Lacs

SAP PP and QM Consultant

Pune

4 - 9 yrs
|

INR 8 - 18 Lacs

SAP BTP Consultant

Pune

4 - 9 yrs
|

INR 9 - 19 Lacs

Customer Service Associate

Pune

1 - 6 yrs
|

INR 1 - 5 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Google Play App Store
coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Tata Consultancy Services logo
Tata Consultancy Services

Information Technology and Consulting

Thane

RecommendedJobs for You

Tata Consultancy Services logo

ETL Developer (Teradata +Informatica)

Tata Consultancy Services

chennai, tamil nadu, india

Tata Consultancy Services logo

ETL Developer (Teradata +Informatica)

Tata Consultancy Services

chennai, tamil nadu, india