Teradata Developer

Infosys; Bengaluru; Vor Ort; INR 900.000 - 1.500.000; Vollzeit

Zusammenfassung

Infosys in Bengaluru seeks a Teradata Developer with 3+ years of hands-on experience to design and optimize data warehouse solutions. You will work with Teradata SQL, complex queries, and Teradata Utilities, supporting ETL processes and batch scheduling in a Linux environment.

You will contribute to star/snowflake schemas, implement partitions, and enhance query performance while ensuring production support and defect resolution for ongoing BI workloads.

Qualifikationen

• 3+ years of hands-on experience in Teradata Development.
• Strong knowledge of Teradata SQL.
• Experience with complex SQL queries, joins, subqueries, CTEs and analytic/window functions.
• Strong understanding of Teradata database architecture.
• Experience with Teradata Utilities – BTEQ, FastLoad, MultiLoad, TPump and FastExport.
• Experience in ETL development and data warehouse concepts.
• Good understanding of Fact and Dimension tables.
• Knowledge of Star/Snowflake schema.
• Experience with Stored Procedures, Macros and Views.
• Knowledge of Primary Index, Secondary Index, Partitioning and Statistics.
• Experience in query performance tuning.
• Ability to analyze Explain plans and optimize SQL queries.
• Experience with Unix/Linux shell scripting.
• Good understanding of batch jobs and scheduling.
• Experience in production support, troubleshooting and defect resolution.

Kenntnisse

Teradata SQL

ETL development

Explain plans analysis

Unix/Linux shell scripting

Batch job scheduling

Production support

Query performance tuning

Data warehouse concepts

Star/Snowflake schema

Stored Procedures

Macros & Views

Partitioning

Troubleshooting & defect resolution

Tools

BTEQ

FastLoad

MultiLoad

TPump

FastExport

Jobbeschreibung

• 3+ years of hands-on experience in Teradata Development
• Strong knowledge of Teradata SQL
• Good experience in complex SQL queries, joins, subqueries, CTEs and analytical/window functions
• Strong understanding of Teradata database architecture
• Experience with Teradata Utilities – BTEQ, FastLoad, MultiLoad, TPump and FastExport
• Experience in ETL development and data warehouse concepts
• Good understanding of Fact and Dimension tables
• Knowledge of Star/Snowflake schema
• Experience with Stored Procedures, Macros and Views
• Knowledge of Primary Index, Secondary Index, Partitioning and Statistics
• Experience in query performance tuning
• Ability to analyze Explain plans and optimize SQL queries
• Experience with Unix/Linux shell scripting
• Good understanding of batch jobs and scheduling
• Experience in production support, troubleshooting and defect resolution