Job Description :
Job Description

5+ years of experience in Datawarehousing ETL development projects.

Expertise working as a Teradata developer and strong skills in SQL queries, Teradata Macros, stored procedures.

Proficiency with Hive-QL and Unix scripting language, Azure Data Lake & BLOB

Knowledgeable about composing lengthy and intricate SQL queries.

Expert in building views, macros, tables, joins, functions, stored procedures in Teradata database.

Very good knowledge of different indexes (PI, SI, JI, PPI), Join Strategies, Data Protection.

Practical experience utilizing tools to query such as Teradata SQL Assistant.

Extensive working experience in Teradata utilities viz TPUMP, BTEQ, FastExport, FastLoad, MultiLoad, TPUMP.

Skillful with monitoring, performance analysis and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Teradata Viewpoint.

Very familiar with the Software Development Life Cycle (SDLC) and Data Ingestion

Proficient in analyzing and translating business requirements to technical requirements and modeling the Logical and Physical Data Models.

Participated in performance Tuning, Data Analysis, Mapping, Loading & Validation
Should be able to work independently