An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.
AI summary of this job
Beta Read in 10 secondsA Data Performance Engineer role at NTT DATA in Gurugram, Bengaluru for people with 6–16 years of experience. You'll troubleshoot, tune, and templatize using SQL, Data, Oracle, Oracle Performance Tuning, Performance, Airflow, python, etl, apache airflow.
- Gurugram
- Work from office
- 6–16 years
What you'll do
- Troubleshoot performance end-to-end
- Tune across every layer
- Build reusable templates and standards
Good fit if you
- Have 8+ years in data engineering
- Know dbt and Apache Airflow
- Understand ETL, Linux, and Python
AI-generated from the job description. Check the full description before you apply.
Job Description
Senior Data Performance Engineer (Oracle, dbt, Airflow)
About the role
This role focuses on making data workflows built on dbt and Apache Airflow on Oracle run fast and reliably. Workflows migrated from Informatica must produce accurate data and perform as well as or better than the process they replace.
As a member of the performance engineering team, you will:
- Troubleshoot. Find the root cause of slow data workflows across the database, transformation and orchestration layers.
- Tune. Fix the bottleneck and prove the improvement with measurements, without affecting data accuracy.
- Templatize. Turn each fix into a reusable pattern, template or guideline that other developers can apply on their own.
This is a hands-on role for an engineer who enjoys tracking down where time is lost and building solutions that keep the same problem from coming back.
What you'll do
Troubleshoot performance end to end
- Profile slow workflows across the full execution path: scheduler, Airflow, containers, dbt and database.
- Separate actual database processing time from framework and orchestration overhead.
- Set performance baselines and compare results against legacy Informatica runtimes.
- Identify root causes and explain them clearly to technical and non-technical audiences.
Tune across every layer
- Oracle: Tune SQL and PL/SQL using execution plans, SQL Monitor, AWR/ASH and wait-event analysis. Resolve optimizer, cardinality, memory and parallelism issues. Tune distributed queries across database links so processing happens where the data lives.
- dbt: Design efficient models and materializations. Reduce parsing, compilation and run overhead, and keep large projects fast.
- Airflow: Design efficient DAGs and tasks. Reduce scheduling and start-up delays, and make workflows reliable through sound retry, restart and failure handling.
- Find and fix data accuracy and reliability issues uncovered during tuning.
Build reusable templates and standards
- Turn proven fixes into reusable templates, macros, utilities and shared components.
- Design shared changes so they can be adopted gradually and rolled back safely.
- Create tuning playbooks, troubleshooting checklists and automated performance checks that catch regressions before release.
- Mentor developers and review designs so new workflows perform well from the start.
Collaborate and influence
- Present findings, options, trade-offs and measured results to developers, architects, DBAs and leadership.
- Work with architecture and database teams to get approval for platform-level improvements.
What you bring
Required qualifications
- 8+ years of experience in data engineering or database engineering, with significant hands-on Oracle performance tuning.
- Production experience with dbt and an understanding of how dbt builds and runs models.
- Production experience with Apache Airflow DAG design and operations.
- Working knowledge of ETL concepts, ideally including Informatica PowerCenter.
- Working knowledge of Linux, shell scripting and Python.
- A data-driven approach: measure first, isolate the problem, change one thing and prove the result.
- Experience turning one-off fixes into standards or tools used by others.
- Strong written and verbal communication skills.
Nice to have
- Hands-on Informatica PowerCenter experience, including migration to modern platforms.
- Docker and container-based execution.
- Enterprise schedulers such as Control-M.
- Large-scale dbt projects or the dbt Python API.
- Oracle RAC and parallel execution.
- Git-based workflows and CI/CD for data pipelines.
- Experience in financial services or another regulated industry.
Skills
SQLDataOracleOracle Performance TuningPerformanceAirflowPerformance TuningData EngineeringPythonEtlSqlApache AirflowAirflowIf a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.
About Company
NTT DATA is a global IT services provider, headquartered in Tokyo, Japan, that delivers a broad range of innovative technology solutions across various sectors. As part of the NTT Group, one of the largest telecommunications companies in the world, NTT DATA specializes in consulting, IT and network services, and system integration. NTT DATA careers offer a vibrant landscape for professionals eager to develop cutting-edge technology solutions that drive significant transformations in business and society. Those pursuing NTT DATA careers can expect to engage in projects that blend global insights with local expertise, fostering a culture of innovation and a commitment to client success.
Similar Jobs
View allLooking for something similar?
New Data Science Analytics & Machine Learning roles in Gurugram.
One email a day. Unsubscribe any time.

