ETL Informatica & Hadoop Engineer | Big Data Innovation

Tata Consultancy Services; Plano (TX); On-site; USD 95,000 - 120,000; Full time

Job summary

Tata Consultancy Services in Plano, TX is seeking an Engineer in Technology to design, develop, and maintain ETL processes using Informatica PowerCenter and related tools. The role requires strong proficiency in ETL development, Oracle, SQL, and a solid understanding of the Hadoop ecosystem.

You'll work in an Agile environment, collaborate with cross-functional teams, optimize SQL scripts, ensure data quality, and document ETL procedures.

Qualifications

• Bachelor's or master's degree in computer science or a related field.
• Experience designing, developing, and maintaining ETL processes using Informatica PowerCenter.
• Strong knowledge of HDFS, YARN, MapReduce, Hive, Pig, HBase, Flume, Sqoop, Zookeeper, and Oozie.
• Experience with Spark, Kafka, and NoSQL databases.
• Work in Agile environments.
• Proficient in SQL/PLSQL to extract, transform, load data.
• Use job-scheduling tools such as AutoSys.
• Ability to integrate data from multiple sources and ensure data quality.
• Design and maintain data warehouses for BI.
• Optimize SQL scripts for speed.
• Create technical documentation and perform testing.
• Collaborate with cross-functional teams.

Responsibilities

• Design, develop, and maintain ETL processes using Informatica PowerCenter.
• Ensure data quality and integrity across sources.
• Collaborate with cross-functional teams in Agile environment.
• Optimize SQL scripts for speed.
• Create and maintain technical documentation for ETL processes.
• Perform unit, integration, and system testing on ETL processes.

Skills

ETL Informatica

Oracle

SQL

Hadoop

Informatica

Spark

NoSQL

Hive

Pig

HBase

Flume

Sqoop

Zookeeper

Oozie

Education

Bachelor's degree in Computer Science

Tools

Bitbucket

AutoSys

Job description

Tata Consultancy Services in Plano, TX is seeking an Engineer in Technology to design, develop, and maintain ETL processes using Informatica PowerCenter and related tools. The role requires strong proficiency in ETL development, Oracle, SQL, and a solid understanding of the Hadoop ecosystem.

You'll work in an Agile environment, collaborate with cross-functional teams, optimize SQL scripts, ensure data quality, and document ETL procedures.