Data Engineer: Oracle SQL & ETL Expert (Hybrid)

NTT DATA Americas; Merrimack (NH); Hybrid; USD 103,000 - 137,000; Full time

Job summary

NTT DATA Americas is seeking a Data Engineer - Hybrid On-Site in Merrimack, NH to design and optimize data pipelines. You will develop complex SQL and PL/SQL, build ETL workflows with Informatica PowerCenter, and implement robust code management with Jenkins and GitHub.

You will automate data processing with Python and Unix scripts, manage batch jobs with Control-M/AutoSys, and support BI reporting for OBIEE/OAS.

Qualifications

• 5+ years of Expert-level knowledge of writing complex SQL queries using Oracle.
• 5+ years of Expert-level knowledge of Oracle PL/SQL (Stored Procedures, Functions, packages, triggers)
• 5+ years of working experience in scripting and automation using Unix, Python in a Data Engineering environment.
• 6+ years of extensive experience with Relational Databases like Oracle including being able to implement performance tuning techniques
• 5+ years of working experience using GitHUB for Source Code Management (SCM) in a Data Engineering Practice.

Responsibilities

• Develop complex SQL queries, PL/SQL packages, stored procedures, functions, and triggers using Oracle databases.
• Build, enhance, and maintain ETL workflows using Informatica PowerCenter to extract, transform, and load data from multiple source systems.
• Implement source code management and version control best practices using Jenkins, GitHub and GitOps.
• Create automation scripts using Python and Unix shell scripting to streamline data processing, monitoring, and operational activities.
• Manage and schedule batch processing jobs using enterprise scheduling tools such as Control-M and AutoSys.
• Support reporting and analytics initiatives by providing optimized data structures and datasets for OBIEE/OAS and other BI tools.
• Collaborate with business stakeholders, data architects, and application teams to gather requirements and deliver data solutions aligned with business objectives.
• Create and maintain technical documentation, including data flow diagrams, ETL mappings, deployment procedures, and operational support documents.
• Ensure data quality, integrity, consistency, and security throughout the data lifecycle.
• Monitor, troubleshoot, and resolve ETL failures, database issues, and data-related production incidents.
• Participate in code reviews, design discussions, and continuous improvement initiatives to enhance data engineering practices.
• Work closely with cross-functional teams to support data migration, modernization, and cloud transformation projects.
• Ensure compliance with data governance, security standards, and organizational policies.

Skills

Oracle SQL

PL/SQL

Unix shell scripting

Python

GitHub

Jenkins

Data integration

Tools

Informatica PowerCenter

Control-M

AutoSys

Job description

NTT DATA Americas is seeking a Data Engineer - Hybrid On-Site in Merrimack, NH to design and optimize data pipelines. You will develop complex SQL and PL/SQL, build ETL workflows with Informatica PowerCenter, and implement robust code management with Jenkins and GitHub.

You will automate data processing with Python and Unix scripts, manage batch jobs with Control-M/AutoSys, and support BI reporting for OBIEE/OAS.