ETL Developer

ETL Developer

NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking an ETL Developer to join our team in New York, New York (US-NY), United States (US).

Day to Day Job Duties:

• Design, develop, test, and maintain ETL/ELT solutions to support enterprise data integration, migration, and reporting requirements.
• Analyze business and technical requirements and translate them into scalable ETL workflows, data mappings, and transformation logic.
• Develop and optimize data pipelines to extract, transform, and load data from multiple source systems into data warehouses, data lakes, and analytical platforms.
• Collaborate with business analysts, data architects, database administrators, and reporting teams to ensure data quality and consistency.
• Perform data profiling, cleansing, validation, and reconciliation activities to support accurate and reliable data movement processes.
• Monitor ETL jobs and workflows, troubleshoot failures, perform root cause analysis, and implement corrective actions.
• Optimize ETL performance by tuning SQL queries, workflows, transformations, and database objects.
• Develop technical specifications, source-to-target mappings, data dictionaries, and operational documentation.
• Support data migration, data conversion, and system integration projects across enterprise applications.
• Participate in code reviews, unit testing, system integration testing, user acceptance testing, and deployment activities.
• Work within Agile teams, participating in sprint planning, backlog grooming, daily stand-ups, and retrospectives.
• Ensure adherence to data governance, security, compliance, and enterprise architecture standards.
• Provide production support for ETL processes and resolve data-related incidents within established SLAs.

Basic Qualifications:

• Minimum 5+ years of experience in ETL Development, Data Integration, and Data Warehousing projects.
• Minimum 3+ years of hands-on experience with ETL tools such as Informatica PowerCenter, Informatica IICS, Talend, DataStage, SSIS, Ab Initio, Matillion, or equivalent platforms.
• Minimum 4+ years of experience writing complex SQL queries, stored procedures, views, triggers, and performance tuning.
• Experience designing and implementing ETL/ELT pipelines for large-scale data processing environments.
• Strong understanding of Data Warehouse concepts including Star Schema, Snowflake Schema, Fact Tables, Dimension Tables, and Data Modeling.
• Experience working with relational databases such as Oracle, SQL Server, PostgreSQL, MySQL, Snowflake, Teradata, or DB2.
• Experience integrating data from APIs, flat files, XML, JSON, cloud applications, and enterprise systems.
• Experience working with cloud-based data platforms such as Azure Data Factory, AWS Glue, Redshift, Synapse Analytics, Databricks, or Google BigQuery.
• Experience with data quality validation, data governance, metadata management, and data reconciliation processes.
• Understanding of Software Development Life Cycle (SDLC), Agile methodologies, and DevOps practices.
• Experience with version control tools such as Git, Azure DevOps, or SVN.
• Strong analytical, troubleshooting, problem-solving, and communication skills.
• Ability to independently manage multiple deliverables in fast-paced environments.

Travel: Travel may be required based on project and client needs (typically up to 10-20%).

Degree: Bachelor's degree in computer science, Information Technology, Engineering, Information Systems, or equivalent work experience.

About NTT DATA: NTT DATA is a $30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future.