Senior Technical Lead (IN)
HCLTech
HCLTech
We are seeking a skilled Teradata Developer to design, develop, and optimize data solutions on the Teradata platform. The ideal candidate will possess strong SQL expertise, experience in ETL processes, and a deep understanding of Teradata architecture and performance tuning. This role involves translating complex requirements into efficient and robust data solutions.
This is a full-time, onsite position requiring a minimum of 6 years of experience. We value candidates who can contribute to the success of our data initiatives through their technical acumen and problem-solving abilities.
Design and develop intricate SQL queries, stored procedures, and macros within the Teradata environment. Implement ETL workflows utilizing tools such as Informatica, BTEQ, or Teradata utilities like FastLoad, MultiLoad, and TPT. Optimize queries and manage performance tuning for large-scale data environments to ensure efficiency.
Collaborate closely with data architects and business analysts to translate business requirements into effective technical solutions. Conduct thorough data validation, troubleshooting, and issue resolution. Ensure strict adherence to data governance and security standards throughout all development processes.
A strong foundation in Teradata SQL, including expertise in joins, indexes, and explain plans, is essential. Demonstrate hands-on experience with Teradata utilities including FastLoad, MultiLoad, TPT, and BTEQ. Possess knowledge of ETL tools such as Informatica, DataStage, or similar platforms.
Familiarity with data warehousing concepts and BI tools is required. Proficiency in performance tuning and query optimization techniques is crucial. A good understanding of Unix/Linux scripting is also necessary. Excellent problem-solving and communication skills are paramount for success in this role. Experience with CAWA Scheduler is a plus.
HCLTech
IT Consulting