ETL & Data Integration Specialist

NTT DATA North America; Charlotte (NC); On-site; USD 90,000 - 120,000; Full time

Job summary

NTT DATA North America in Charlotte, NC is seeking an ETL developer to design, develop, and maintain complex mappings, workflows, and sessions using Informatica PowerCenter or Cloud.

You will write and optimize SQL queries, configure secure file transfers with IBM Sterling Connect:Direct, and build automated batch schedules with CA ESP Workload Automation. Familiarity with Unix/Linux scripting is required to support production operations.

Qualifications

• 5+ years in enterprise ETL development and production support.

Responsibilities

• Design, develop, and maintain complex mappings, workflows, and sessions using Informatica PowerCenter or IICS.
• Write, optimize, and tune advanced SQL queries and stored procedures (SPO).
• Configure and manage secure data file movements using IBM Sterling Connect:Direct across internal and external systems.
• Build, monitor, and maintain automated batch schedules using CA ESP Workload Automation.
• Integrate Informatica jobs and Connect:Direct transfers into ESP definitions and dependencies.
• Perform root-cause analysis for production scheduling abends, pipeline failures, and lag.

Skills

Informatica PowerCenter/Cloud

SQL/PL-SQL

IBM Connect:Direct for managed file

CA ESP Workload Automation

Unix/Linux scripting

Job description

NTT DATA North America in Charlotte, NC is seeking an ETL developer to design, develop, and maintain complex mappings, workflows, and sessions using Informatica PowerCenter or Cloud.

You will write and optimize SQL queries, configure secure file transfers with IBM Sterling Connect:Direct, and build automated batch schedules with CA ESP Workload Automation. Familiarity with Unix/Linux scripting is required to support production operations.