ETL Developer - Informatica & PL/SQL

NTT DATA Services•Plano, TX

About The Position

NTT DATA is seeking ETL Developers to build and support data pipelines that transform and load vendor and legacy data into an Oracle 19c database. The role involves creating Informatica mappings and PL/SQL load procedures, developing staging tables, and reconciling source and target data to ensure accuracy and completeness. Day-to-day work includes supporting full and incremental loads, troubleshooting failures, testing mappings and procedures, and protecting sensitive data. The senior developer will also mentor the junior developer through mapping reviews, pairing, and load troubleshooting.

Requirements

  • For the senior opening, 5+ years of ETL development experience.
  • 3+ years of hands-on Informatica PowerCenter or IICS experience, including mappings, workflows, error handling, and restartable processing.
  • 3+ years of Oracle SQL and PL/SQL experience, including packages, stored procedures, bulk loading, and query tuning.
  • 3+ years of ETL design and development experience, including data transformation, full and incremental loads, data quality checks, and source-to-target reconciliation.

Nice To Haves

  • Bachelor’s degree in computer science, Engineering, or Mathematics.
  • Experience with Oracle 19c, staging table DDL, and large data sets.
  • Experience with DB2, fixed-width files, Azure Blob Storage, or mainframe data sources.
  • Experience with Control-M, utPLSQL, GitHub, Jenkins, shell scripting, or Linux.
  • Experience with financial services, retirement, or benefits data.
  • Strong problem-solving and communication skills, with the ability to collaborate across technical teams.

Responsibilities

  • Build and support data pipelines that transform and load vendor and legacy data into an Oracle 19c database.
  • Create Informatica mappings and PL/SQL load procedures.
  • Develop staging tables.
  • Reconcile source and target data to ensure accuracy and completeness.
  • Support full and incremental loads.
  • Troubleshoot failures.
  • Test mappings and procedures.
  • Protect sensitive data.
  • For the senior opening, mentor the junior developer through mapping reviews, pairing, and load troubleshooting.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service