Description

Design and develop ETL processes across the full software development life cycle.

Responsibilities

• Build ETL workflows using Informatica Power Center to integrate diverse data sources.
• Manage data loading into HDFS on Hadoop clusters and monitor job logs.
• Perform data validation, integrity checks, and reconciliation via Unix Shell Scripts.
• Write Oracle SQL queries for verification, testing, and troubleshooting.
• Execute performance tuning for ETL sources, transformations, and sessions.

Required Skills

• Informatica Power Center, BDM, and Power Exchange.
• Hadoop ecosystem: Hive, Sqoop, Spark, Oozie, and ZooKeeper.
• Teradata SQL, Oracle, and SQL Server.
• MapReduce and Data Modeling.
• Unix Shell Scripting for server connectivity and reconciliation.
• 2+ years of experience in ETL or Hadoop development.
• Master’s degree in Computer Science, Engineering, or related field.

Preferred Skills

• Willingness to work on-site in Princeton, NJ, and travel to other US locations as needed.

Key Skills

Education

Master’s degree