Teradata Developer

Qloron Pvt Ltd; Bengaluru; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Qloron Pvt Ltd is looking for an experienced Teradata Developer in Bengaluru, India, responsible for developing and optimizing SQL queries and ETL processes for large-scale data warehouse solutions. The ideal candidate should have 5+ years of hands-on experience in Teradata development, solid expertise in SQL and BTEQ scripting, and proficiency in Shell scripting and Python. Experience with cloud technologies like GCP is a plus. This role offers the opportunity to collaborate with cross-functional teams and ensure data integrity across all data pipelines.

Qualifications

• 5+ years of hands-on experience in Teradata development.
• Strong expertise in Teradata SQL and BTEQ scripting.
• Experience with Teradata utilities like MLOAD and TPT.
• Proficiency in Shell scripting for automation.
• Solid programming skills in Python for data processing.

Responsibilities

• Develop, optimize, and maintain Teradata SQL queries and data processing workflows.
• Design ETL processes for large-scale data warehouse environments.
• Utilize Teradata utilities for efficient data loading.
• Monitor and troubleshoot performance issues within Teradata databases.

Skills

Teradata SQL

BTEQ scripting

MLOAD

TPT

Shell scripting

Python

Job description

We are seeking an experienced Teradata Developer with strong expertise in SQL, BTEQ, and Teradata utilities (e.g., MLOAD, TPT). The ideal candidate will be responsible for developing, optimizing, and maintaining large-scale data warehouse solutions, ensuring high performance, data integrity, and scalability.

Key Responsibilities

• Develop, optimize, and maintain Teradata SQL queries, BTEQ scripts, and data processing workflows.
• Design, build, and maintain ETL processes for large-scale data warehouse environments.
• Utilize Teradata utilities such as BTEQ, MLOAD, and TPT for efficient data loading and processing.
• Write and maintain Shell scripts to automate operational and data‑related tasks.
• Develop and support Python scripts for data processing, transformation, and analytics.
• Monitor, troubleshoot, and resolve performance issues within Teradata databases.
• Perform query tuning and optimization to improve system efficiency and resource utilization.
• Collaborate with cross‑functional teams (e.g., Business, QA, DevOps) to translate requirements into technical solutions.
• Ensure data quality, integrity, and security across all data pipelines.
• Document technical designs, workflows, and best practices for knowledge sharing.
• Stay current with emerging technologies in Teradata, SQL, and cloud data platforms.

Required Qualifications

• 5+ years of hands‑on experience in Teradata development.
• Strong expertise in Teradata SQL and BTEQ scripting.
• Experience with Teradata utilities (e.g., MLOAD, TPT).
• Proficiency in Shell scripting for automation.
• Solid programming skills in Python for data processing.
• Experience in data warehouse design and development.
• Strong knowledge of query performance tuning and troubleshooting.
• Excellent analytical and problem‑solving skills.
• Ability to work independently and collaboratively in a team environment.
• Strong communication skills with the ability to engage stakeholders.

Preferred Qualifications

• Cloud experience in GCP (BigQuery, Dataflow, Cloud Storage, etc.)