Etl Informatica/hadoop Developer

Tata Consultancy Services

Plano (TX)

On-site

USD 95,000 - 120,000

Full time

2 days ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

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

Must-Have Technical/Functional Skills

Primary skill: ETL Informatica Development
Secondary skills: Oracle and SQL
Experience: Demonstrated extensive experience in ETL development using Informatica, Oracle, and SQL, with the expertise required to perform the responsibilities of the role.

Roles & Responsibilities

Bachelor's or master's degree in computer science or a related field.
Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools.
Demonstrate a deep understanding of HDFS, YARN, MapReduce, Hive, Pig, HBase, Flume, Sqoop, Zookeeper, and Oozie.
Apply experience with Spark, Kafka, and NoSQL databases.
Work effectively within Agile methodology.
Use code-versioning tools such as Bitbucket.
Use SQL/PLSQL to extract, transform, and load data.
Apply advanced transformations, including data transformations and parsing JSON/XML messages.
Use job-scheduling tools such as AutoSys.
Integrate data from various sources while ensuring data consistency and quality.
Design and maintain data warehouses to support business intelligence activities.
Optimize SQL scripts and queries for speed and efficiency.
Identify and resolve issues in ETL processes.
Create and maintain technical documentation for ETL processes.
Perform unit, integration, and system testing on ETL processes.
Collaborate with cross-functional teams to support the successful implementation of ETL processes.
Ensure data quality by implementing data-cleansing and transformation processes.
Develop and maintain relational and dimensional data modelsinnovative solutions for the industry