Teradata Developer

Infosys; Chandigarh, Hyderabad, Bengaluru; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Infosys in Chandigarh, India is seeking an experienced Teradata Database Developer/Analyst to design, develop, test, and maintain Teradata database solutions. The role focuses on writing complex SQL, procedures, and ETL processes.

You will optimize performance, ensure data quality, and collaborate with analysts and architects to meet business requirements. Knowledge of scheduling tools and Unix/Linux scripting is valued.

Qualifications

• Strong experience with Teradata Database.
• Expertise in Teradata SQL, Stored Procedures, Macros, and Utilities.
• Experience with BTEQ, FastLoad, MultiLoad, TPump, FastExport, TPT.
• Knowledge of Data Warehousing Concepts and Dimensional Modeling.
• Experience in ETL Development.
• Strong understanding of query optimization and performance tuning.
• Experience with Unix/Linux scripting.
• Knowledge of scheduling tools such as Control-M or Autosys.

Responsibilities

• Design, develop, test, and maintain Teradata database solutions.
• Write complex SQL queries, stored procedures, macros, and scripts.
• Develop and support ETL processes for data integration and migration.
• Perform data analysis, data profiling, and data validation activities.
• Optimize query performance and troubleshoot database issues.
• Create and maintain database objects such as tables, views, indexes, and joins.
• Monitor and improve database performance, space utilization, and workload management.
• Collaborate with business analysts, data architects, and application teams to understand requirements.
• Ensure data quality, security, and compliance standards are maintained.
• Prepare technical documentation and support production deployments.

Skills

Teradata SQL

Data warehousing concepts

ETL development

Query optimization / performance tunin

Unix/Linux scripting

Dimensional modeling

Tools

Teradata Database

Stored Procedures

Macros

BTEQ

FastLoad

MultiLoad

TPump

FastExport

TPT

Control-M

Autosys

Job description

• Design, develop, test, and maintain Teradata database solutions.
• Write complex SQL queries, stored procedures, macros, and scripts.
• Develop and support ETL processes for data integration and migration.
• Perform data analysis, data profiling, and data validation activities.
• Optimize query performance and troubleshoot database issues.
• Create and maintain database objects such as tables, views, indexes, and joins.
• Monitor and improve database performance, space utilization, and workload management.
• Collaborate with business analysts, data architects, and application teams to understand requirements.
• Ensure data quality, security, and compliance standards are maintained.
• Prepare technical documentation and support production deployments.

Required Skills:

• Strong experience with Teradata Database.
• Expertise in Teradata SQL, Stored Procedures, Macros, and Utilities.
• Experience with BTEQ, FastLoad, MultiLoad, TPump, FastExport, TPT.
• Knowledge of Data Warehousing Concepts and Dimensional Modeling.
• Experience in ETL Development.
• Strong understanding of query optimization and performance tuning.
• Experience with Unix/Linux scripting.
• Knowledge of scheduling tools such as Control-M or Autosys.