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.
Responsibilities- 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.
Skills Required
- Extensive hands-on experience with Teradata
- Proficiency with BTEQ scripts
- Strong SQL skills; ability to understand complex logic, joins, and procedures
- Experience in Data Warehousing/Data Mart optimization including Teradata query tuning
- Physical data modeling from logical models in Teradata
- In-depth understanding of Teradata architecture and concepts (PE, Bynet, Vdisks, AMPs, Vprocs, indexing, hashing, data distribution/duplication)
- Ability to choose appropriate indexes (NUPI, UPI, NUSI, USI) for load and extract operations
- Experience analyzing long-running queries using Explain Plan, Access Path, FTS, AMP operations, statistics, join strategy
- Ability to monitor and troubleshoot CPU consumption, disk/spool space, amp skewness and hot AMP issues to meet production SLAs
- Ability to work with TDBA/Teradata Admin and implement administrative solutions at application level
- Bachelor's degree with minimum 8 years IT experience OR High School Diploma/GED with 5+ years Teradata experience
- Strong database concepts
- Reporting and data visualization experience (QlikView or Power BI)
- Excellent communication, solution orientation, problem-solving, teamwork and interpersonal skills
What We Do
Choosing a digital partner is about more than capabilities — it’s about collaboration and character. Unrealistic overhauls and off-the-shelf products ignore what matters most — your unique needs, culture, goals, and your legacy data and technology environments. At EXL, our collaboration is built on ongoing listening and learning to adapt our methodologies. We’re your business evolution partner—tailoring solutions that make the most of data to make better business decisions and drive more intelligence into your increasingly digital operations. Whether your goals are scaling the use of AI and digital, redesign operating models, or driving better and faster decisions, we’re here to partner with you to help you gain—and maintain—competitive advantage with efficient, sustainable models at scale. Our expertise in transformation, data science, and change management helps make your business more efficient and effective, improve customer relationships and enhance revenue growth. Instead of focusing on multi-year, resource- and time-intensive platform designs or migrations, we look deeper at your entire value chain to integrate strategies with impact. We use our specialization in analytics, digital interventions, and operations management—alongside deep industry expertise — to deliver solutions that help you outperform the competition. At EXL, it’s all about outcomes—your outcomes—and delivering success on your terms. Share your goals with us and together, we’ll optimize how you leverage data to drive your business forward. For more information, visit www.exlservice.com.
