Teradata Developer

ITI Data; Pune City; On-site; INR 6,75,000 - 9,00,000; Full time

Job summary

An established industry player is actively seeking talented individuals for multiple positions including Ab Initio Developer and AWS Data Engineer. This full-time opportunity offers a chance to work on cutting-edge data solutions, focusing on Teradata development, optimization, and performance tuning. The ideal candidates will possess strong SQL skills and a deep understanding of data warehousing principles. Join a dynamic team that values innovation and excellence in the field of software development and banking. If you are ready to take your career to the next level, this is the perfect opportunity for you.

Qualifications

• Hands-on experience in Teradata development and SQL proficiency.
• Expert in optimizing I/O and storage performance.

Responsibilities

• Optimize Teradata applications and perform query tuning.
• Monitor and troubleshoot CPU consumption and disk space issues.

Skills

Teradata development

SQL proficiency

Data Warehousing

Performance Tuning

Cloud Migration

Tools

Teradata Utilities (Mload, FastLoad, TPUMP)

Viewpoint

SQL Assistant

Teradata Administrator

DataMover

Job description

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from ITI Data

Actively hiring for Multiple positions - Ab Initio Developer, AWS Data Engineer, PySpark Developer, Java API -(GraphQL EKS), API Kafka Python Dev, ETL…

Key Responsibilities

1. Hands on experience in Teradata development and proficient with BTEQ scripts, ability to understand complex logic based SQLs, joins & Procedures.
2. Experience in Data Warehousing/Data Mart application's optimization including Teradata Query Tuning, developing physical data modelling from Logical model in Teradata.
3. In-depth understanding of Teradata architecture & concepts - PE, Bynet, Vdisks, AMPs, Vprocs, Indexing, Hashing, Data Distribution/Duplication.
4. 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.
5. 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.
6. Capable to Monitor CPU consumption, Disk space issues, operational parameters and troubleshooting for reducing CPU consumption & batch processing to meet Prod cycle SLAs.
7. Expert in optimizing I/O & Storage Performance thru MVC/ALC/BLC.
8. Must know Teradata Utilities Mload, FastLoad, TPUMP, FastExport, BTQMAIN, TPT Wrappers.
9. Working knowledge of the Teradata suite of tools: Viewpoint, SQL Assistant, Teradata Administrator, PMON/Teradata Management Portlets, DataMover, BAR, TASM, TTU Tools, TPT, DBQL, PDCR, Querygrid.
10. Responsible for implementation and ongoing administration of Teradata infrastructure Solutions.
11. Must have hand’s on experience in Performance Tracking, Analysis, Optimization and Performance Tuning.
12. Cloud Migration experience beneficial.

Seniority level

Mid-Senior level

Employment type

Full-time

Job function

Consulting, Information Technology, and Project Management

Industries

Software Development and Banking