EXL Logo

EXL

Teradata EDW

Posted 3 Months Ago
Be an Early Applicant
Hybrid
Chennai, Tamil Nadu, IND
Senior level
Hybrid
Chennai, Tamil Nadu, IND
Senior level
Design, develop, administer, and optimize Teradata EDW/Data Mart systems. Build and maintain BTEQ scripts and complex SQL/procedures, perform query tuning, physical data modeling, index selection, and explain-plan analysis. Monitor and troubleshoot CPU, spool space, AMP issues, and batch performance. Collaborate with analytics, business teams, and TDBA to deploy high-quality data models and meet production SLAs. Support reporting via QlikView/Power BI.
The summary above was generated by AI

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.
Qualifications
  • 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. 
About Us
EXL (NASDAQ: EXLS) is a leading data analytics and digital operations and solutions company. We partner with clients using a data and AI-led approach to reinvent business models, drive better business outcomes and unlock growth with speed. EXL harnesses the power of data, analytics, AI, and deep industry knowledge to transform operations for the world’s leading corporations in industries including insurance, healthcare, banking and financial services, media and retail, among others. EXL was founded in 1999 with the core values of innovation, collaboration, excellence, integrity and respect. We are headquartered in New York and have more than 54,000 employees spanning six continents. For more information, visit www.exlservice.com.


EXL never requires or asks for fees/payments or credit card or bank details during any phase of the recruitment or hiring process and has not authorized any agencies or partners to collect any fee or payment from prospective candidates. EXL will only extend a job offer after a candidate has gone through a formal interview process with members of EXL’s Human Resources team, as well as our hiring managers.

EXL Chennai, Tamil Nadu, IND Office

Chennai, India

Similar Jobs

11 Hours Ago
Hybrid
Chennai, Tamil Nadu, IND
Mid level
Mid level
Digital Media • Information Technology • News + Entertainment
Oversee network security safeguards, enforce secure hardware and software configurations, maintain disaster recovery plans, develop incident response policies, lead penetration testing and vulnerability assessments, conduct security audits, evaluate security technologies, and coordinate with network operations, development, and support teams. The role requires independent judgment and availability for nights, weekends, and variable schedules.
Top Skills: Disaster Recovery SystemsNetwork Security ProtocolsPenetration TestingVulnerability Assessment
11 Hours Ago
Hybrid
Chennai, Tamil Nadu, IND
Mid level
Mid level
Digital Media • Information Technology • News + Entertainment
Oversee network security safeguards, enforce secure hardware and software configurations, maintain disaster recovery plans, develop incident response policies, lead penetration tests and vulnerability assessments, conduct security audits, investigate security technologies, and coordinate with development, support, and network operations teams. The role requires independent judgment and availability for nights, weekends, and variable schedules.
Top Skills: Disaster Recovery SystemsNetwork Security ProtocolsNetwork Security SafeguardsPenetration TestingVulnerability Assessment
11 Hours Ago
Hybrid
Chennai, Tamil Nadu, IND
Mid level
Mid level
Digital Media • Information Technology • News + Entertainment
Oversee network security safeguards, enforce secure hardware and software configurations, maintain disaster recovery plans, develop incident response policies, evaluate security technologies, lead penetration tests and vulnerability assessments, and conduct internal and external security audits. The role also coordinates with network operations, development, and support teams and requires independent judgment, punctual attendance, and flexibility to work nights and weekends.
Top Skills: Disaster Recovery SystemsNetwork Security ControlsNetwork Security ProtocolsPenetration TestingVulnerability Assessments

What you need to know about the Chennai Tech Scene

To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account