Teradata Developer

Infosys

3–5 yrs Bengaluru Full Time Work from office
Infosys logo
Posted : today
Actively hiring

Job description

Join our dynamic delivery team as a Teradata Developer, where you'll be the primary point of contact for clients, ensuring exceptional quality assurance and issue resolution to drive high customer satisfaction.

Your role will involve understanding intricate requirements, crafting and meticulously reviewing designs, validating architectural integrity, and delivering superior technology solutions.

We encourage active participation in project estimation, contributing to solution delivery, managing technical risks, and overseeing code reviews and unit test plan assessments.

You will guide and mentor teams to produce optimized, high-quality code, foster continuous knowledge sharing, and uphold organizational standards and processes.

This is an exciting opportunity to be a key contributor in building efficient systems and helping clients accelerate their digital transformation journeys.

Responsibilities

Interface with clients to ensure quality assurance and resolve issues, driving customer satisfaction.

Understand client requirements, create and review technical designs, and validate architectural solutions.

Participate in project estimation, contribute to solution delivery strategies, and conduct technical risk planning.

Perform thorough code reviews and unit test plan reviews to maintain high standards.

Lead and guide development teams to deliver optimized, high-quality code and promote continuous learning.

Contribute to the development of efficient programs and systems, aligning with client digital transformation goals.

Qualifications

A minimum of 3 years of hands-on experience in Teradata Development is essential.

Possess strong proficiency in Teradata SQL, including complex queries, joins, subqueries, CTEs, and analytical/window functions.

Demonstrate a solid understanding of Teradata database architecture and experience with Teradata Utilities such as BTEQ, FastLoad, MultiLoad, TPump, and FastExport.

Familiarity with ETL development, data warehousing concepts, and the design of fact and dimension tables, along with Star/Snowflake schema knowledge.

Experience in developing Stored Procedures, Macros, and Views, and understanding of Primary Index, Secondary Index, Partitioning, and Statistics.

Ability to analyze Explain plans, optimize SQL queries for performance, and experience with Unix/Linux shell scripting.

Good understanding of batch jobs, scheduling, production support, troubleshooting, and defect resolution.

Essential Skills

TeradataTeradata SQLComplex SQL QueriesJoinsSubqueriesCTEsAnalytical FunctionsWindow FunctionsTeradata Database ArchitectureBTEQFastLoadMultiLoadTPumpFastExportETL DevelopmentData Warehouse ConceptsFact TablesDimension TablesStar SchemaSnowflake SchemaStored ProceduresMacrosViewsPrimary IndexSecondary IndexPartitioningStatisticsQuery Performance TuningExplain PlansSQL Query OptimizationUnix/Linux Shell ScriptingBatch JobsJob SchedulingProduction SupportTroubleshootingDefect Resolution

Highlights

  • Actively hiring

More Details

RoleTeradata Developer
DepartmentTechnology Analyst
Employment TypeFull Time, Work from office

About the Company

Infosys logo

Infosys

IT Consulting

Teradata Developer at Infosys | SkillMX | SkillMX