Teradata EDW
Chennai · Staff/Principal
Applicants who checked fit first are 3.1× more likely to hear back
Your score for this role already exists
ASAI compared this JD against 41 signals - skills, seniority, domain, stack overlap etc. Add a resume and it unlocks in about 30 seconds.
Always free · no credit card · 1 tap with Google
What we know about this role
LOW
Our tracked job listings for fa-ewjt-saasfaprod1-cx2 show limited recent activity.
First 72 hours
Window passed - posted 64d agoEarly applicants get seen before the pile builds.
Not a repost
The first time we've seen this listing - it hasn't been closed and reopened.
Skills required
10 listedYou almost certainly match several of these already. Unlock your skill map to see the matches, the gaps, and what to fix first.
Job description
The Teradata Data Engineer should be from EDW or Data Mart Systems & should possess broad technical, architectural knowledge in Teradata to develop, enhance, administer and support large data platform spanning across Business Data landscapes, Data Warehouse Systems to make business applications more streamlined and performant to meet Production cycle SLAs. The data engineer will follow application design standards and frameworks related to model deployment and execution, collaborates with analytics and business teams to improve data models that feed business intelligence tools, increasing data accessibility, and fostering data-driven decision making across the organization. He or she will also ensure data deployments are to the highest quality and standards.
- Hands on experience in Teradata development and proficient with BTEQ scripts, ability to understand complex logic based SQLs, joins & Procedures.
- Should have Experience in Data Warehousing/Data Mart application's optimization including Teradata Query Tuning, developing physical data modelling from Logical model in Teradata.
- Should have in-depth understanding of Teradata architecture & concepts - PE, Bynet, Vdisks, AMPs, Vprocs, Indexing, Hashing, Data Distribution/Duplication.
- Ability to choose the correct Indexes for a Database - NUPI, UPI, NUSI, USI to support Load and Extract Data operations to achieve optimal performance for storage and access to the Database.
- Experience in analysing long running queries & Jobs and root cause of problems using Explain Plan, Access Path, FTS, #No. of AMP operations, Statistics, Confidence Level, Join Strategy etc.
- Capable to Monitor CPU consumption, Disk space issues, operational parameters and troubleshooting for reducing CPU consumption & batch processing to meet Prod cycle SLAs.
- Experience in understanding Spool Space, Amp Skewness, Hot AMP issues and providing solutions to overcome it.
- Should be able to work with TDBA/Teradata Admin to understand solutions provided & transform it to technical/application level to implement the same to improve SQL performance.
- Bachelor's degree with a minimum of 8 years of IT experience, OR in lieu of Degree, a High School Diploma/GED and 5+ years of experience in Teradata and proficient with BTEQ scripts.
- Strong database concepts
- Excellent communication skill.
- Solution orientation and problem-solving skill
- Reporting and Data Visualization QlikView/Power BI
- Strong analytical ability
- Strong teamwork and interpersonal skills.
Tools to land this role
PremiumYour match score, skill map and tracker stay free.
Ground Reality
PremiumSpot the dealbreakers in this 355-word post before you apply
Skip jobs with hidden dealbreakers. See what they actually need, what's easy to miss, and how they describe the team.
Ground Reality on every job, plus Insider Path, practice interviews and resume tailoring.
Insider Path
PremiumFind someone who can refer you here
We help you find people there who worked or studied where you did, and draft your first message and follow-up.
Free · no signup
Get tomorrow's jobs before you have to search
Daily job drops, skill trends and free resources - posted straight to the group. Leave any time.
No spam. Just jobs and resources.
Why people use ASAI
Someone shared one job with you. ASAI keeps finding the rest.
Scored, not searched. Every role ranked against your actual profile.
Alerts as often as hourly. Reach new roles while the pile is still small.
Skill gaps, spelled out. See exactly which requirements you don't meet yet.
Verified jobs, only. Say no to ghost jobs. Your time deserves respect.
More Data Engineer roles in Chennai
See all
Keep browsing