Informatica/hadoop Developer

Tata Consultancy Services Limited

Charlotte (NC)

On-site

USD 115,000 - 125,000

Full time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Tata Consultancy Services Limited in Charlotte, NC is seeking an Informatica/Hadoop Developer to design and implement ETL solutions using Informatica PowerCenter and Hadoop components.

The role covers building mappings, mapplets, sessions, and workflows, tuning performance, and leveraging Spark, HiveQL, and NoSQL data stores to support data lake and analytics initiatives.

Qualifications

  • Strong hands-on experience in Informatica PowerCenter (Designer, Workflow Manager, Workflow Monitor, Repository Manager) for ETL design and development.

Skills

Informatica PowerCenter
Hadoop ecosystem
HiveQL
Spark (PySpark)
Oozie
Informatica IDQ
Informatica IICS
SQL (Teradata, Oracle)
Unix/Linux shell scripting
Git / Jenkins
NoSQL (HBase, Cassandra)
ETL design

Tools

HDFS
YARN
MapReduce
Hive
Pig
Sqoop
Oozie
HBase

Job description

Job Description

Informatica/Hadoop Developer

  • Strong hands-on experience in Informatica PowerCenter (Designer, Workflow Manager, Workflow Monitor, Repository Manager) for ETL design and development.
  • Experience building mappings, mapplets, sessions, worklets and workflows to load data from multiple sources into target systems.
  • Proficiency with core transformations: Source Qualifier, Expression, Lookup, Joiner, Router, Aggregator, Sorter, Union, Normalizer and Update Strategy.
  • Experience with reusable transformations, parameter files, mapping variables and dynamic workflow design.
  • Knowledge of SCD Type 1, Type 2 and Type 3 implementation, incremental/delta loads and CDC techniques.
  • Experience with Informatica performance tuning: pushdown optimization, partitioning, caching and session tuning.
  • Ability to implement error handling, audit, restartability and reconciliation frameworks in Informatica workflows.
  • Working knowledge of Informatica IDQ / Data Quality and Informatica IICS / Cloud Data Integration is an advantage.
  • Experience in Informatica Administration basics: repository, integration service, connections and job scheduling and monitoring.
  • Hands-on experience with Hadoop ecosystem components: HDFS, YARN, MapReduce, Hive, Pig, Sqoop, Oozie and HBase.
  • Strong understanding of HDFS architecture: NameNode, DataNode, block replication, and file formats and compression (Parquet, ORC, Avro, Snappy).
  • Strong hands-on experience writing and optimizing HiveQL queries, including partitioning, bucketing and external/managed tables.
  • Experience with Apache Spark (PySpark / Spark SQL / Scala) for large-scale data processing on Hadoop.
  • Experience scheduling and orchestrating Hadoop jobs using Oozie, Control-M or Autosys.
  • Experience integrating Informatica BDM / Big Data Management with Hadoop clusters (Hive, HDFS, Spark execution engine).
  • Understanding of Kafka and streaming / near real-time data ingestion into the Hadoop data lake.
  • Knowledge of data lake architecture: landing, raw, curated and consumption zones on Hadoop.
  • Experience with NoSQL databases such as HBase or Cassandra for large-volume data storage.
  • Strong SQL / Teradata / Oracl e skills for source analysis, data validation and ETL unit testing.
  • Proficiency in Unix/Linux shell scripting for file handling, job automation and log analysis.
  • Experience in Hadoop performance tuning and troubleshooting failed jobs, system memory utilization and resource issues using YARN and Spark UIs.
  • Knowledge of Hadoop security: Kerberos, Ranger / Sentry, encryption and data masking for sensitive banking data.
  • Experience with version control and CI/CD tools (Git, Jenkins) for ETL and Hadoop code deployment.
  • Ability to prepare technical design documents, source-to-target mappings and unit test cases, and support UAT and production deployments.

Salary Range- $115,000-$125,000 a year

Location

Charlotte, NC

Function

TECHNOLOGY

Role

Engineer

ID

438971

Skills

Informatica

Salary Range

$115,000 - $125,000

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Etl Informatica/hadoop Developer
Etl Informatica/hadoop Developer

Tata Consultancy Services Limited • Plano (TX)

On-site
USD 95,000 - 120,000
ETL Informatica/Hadoop Developer
ETL Informatica/Hadoop Developer

Envision Technology Solutions • Plano (TX)

On-site
USD 90,000 - 150,000
Hadoop Developer
Hadoop Developer

Tata Consultancy Services Limited • Charlotte (NC)

On-site
USD 100,000 - 120,000
Discretionary Annual Incentive
Medical Coverage: Medical & Health, 9/
Dental & Vision
+3
Informatica Developer
Informatica Developer

TechDigital Group • Purchase (NY)

On-site
USD 120,000 - 150,000
ETL Informatica Developer
ETL Informatica Developer

Envision Technology Solutions • Plano (TX)

On-site
USD 85,000 - 120,000
Hadoop Java Developer
Hadoop Java Developer

Tata Consultancy Services Limited • Charlotte (NC)

On-site
USD 100,000 - 120,000
Discretionary Annual Incentive
Medical Coverage (Health)
Vacation & Holidays
+2
Informatica ETL Developer
Informatica ETL Developer

Tata Consultancy Services Limited • Charlotte (NC)

On-site
USD 100,000 - 130,000
Discretionary Annual Incentive
Comprehensive Medical Coverage
Family Support
+5
Informatica Developer
Informatica Developer

Sonoma Consulting Inc. • Milwaukee (WI)

On-site
USD 90,000 - 130,000
Data Scientist
Data Scientist

Tata Consultancy Services Limited • Charlotte (NC)

On-site
USD 100,000 - 145,000
Discretionary Annual Incentive
Medical Coverage
Family Support Leaves
+9
ETL Developer
ETL Developer

Valiant Technologies LLC • Charlotte (NC)

On-site
USD 90,000 - 120,000