ETL Developer

Company Overview:

Req ID: 389342

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 a ETL Developer to join our team in New York, New York (US-NY), United States (US).

Job Description:

Day to Day Job Duties: (what this person will do on a daily/weekly basis)

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: (what are the skills required to this job with minimum years of experience on each)

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.

Nice to Have; (But not a must)

Certifications in Informatica, Snowflake, Azure Data Engineering, AWS Data Analytics, Databricks, or equivalent technologies.

Experience with Big Data technologies such as Hadoop, Spark, PySpark, Hive, or Kafka.

Hands-on experience with data lake architecture and modern cloud data platforms.

Knowledge of Python, Shell Scripting, or Java for ETL automation and data processing.

Experience with BI and reporting tools such as Power BI, Tableau, Qlik, or Cognos.

Exposure to Master Data Management (MDM) and Data Governance solutions.

…