Req ID: 384089

We are currently seeking a Data Engineer - Hybrid On-Site to join our team in Merrimack, New Hampshire (US-NH), United States (US).

Roles and 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.

Basic 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.

Preferred Qualifications:
• Strong working experience in ETL tools like Informatica (Power Center)
• Strong working knowledge of Data warehousing patterns and Dimensional Modelling techniques using Oracle.
• Experience building scalable patterns for data integration in a cloud-based as well as on-prem environments
• Working knowledge of Batch scheduling tools like Control-M, Autosys.
• Experience with business intelligence and analytics tools such as OBIEE/OAS

NTT DATA provides a reasonable range of compensation for U.S.-based positions. The starting pay range for this role is $102,675-$136,900. Actual compensation will depend on a number of factors, including the candidate's relevant experience, technical skills, and other qualifications.

This position may also be eligible for incentive compensation based on individual and/or company performance.

This position is eligible for company benefits including medical, dental, and vision insurance with an employer contribution, flexible spending or health savings account, life and AD&D insurance, short and long term disability coverage, paid time off, employee assistance, participation in a 401k program with company match, and additional voluntary or legally-required benefits.

Whenever possible, we hire locally to NTT DATA offices or client sites. This ensures we can provide timely and effective support tailored to each client's needs. While many positions offer remote or hybrid work options, these arrangements are subject to change based on client requirements. For employees near an NTT DATA office or client site, in-office attendance may be required for meetings or events, depending on business needs. At NTT DATA, we are committed to staying flexible and meeting the evolving needs of both our clients and employees. NTT DATA recruiters will never ask for payment or banking information and will only use [redacted].com, [redacted].com and [redacted].nttdataservices.com email addresses. If you are requested to provide payment or disclose banking information, please submit a contact us form, https://us.nttdata.com/en/contact-us.