Teradata Engineer

Key Responsibilities:
Design and develop ETL processes to extract, transform, and load data from various sources into Teradata.
Develop and optimize complex SQL queries, stored procedures, and macros.
Ensure data, integrity, consistency, and security in Teradata environment.
Implement data curation techniques to ensure the accuracy, consistency, and completeness of the data.
Use tools like Teradata Data Mover, informatica for data integrity and transformations.
Monitor and optimize database performance, including query performance and resource utilization.
Identify and resolve performance bottlenecks to ensure optimal database performance.
Performance database administration tasks including backup, recovery, and maintenance.
Manage database security, user access and roles.
Monitors database health, performance, regular maintenance activities.
Work closely with data analysts, data scientists, and business stakeholders to understand data requirements and deliver solutions.
Provide technical guidance and support to team members on Teradata best practices.
Document database designs, processes, and procedures.
Implement data quality checks and validation processes.
Develop aggregation strategies to summarize and consolidate data for reporting and analysis purposes.
Collaborate with cross-functional teams to understand data requirements and translate them into ETL specifications.
Optimize ETL workflows to improve performance, scalability, and reliability.
Conduct thorough testing and validation of ETL processes to ensure data integrity and quality.
Monitor ETL jobs and troubleshoot issues in a timely manner to minimize downtime and disruptions.
Document ETL processes, data mappings, and transformations for knowledge sharing and reference purposes.
Stay current with industry trends and best practices in ETL, data curation, and aggregation techniques.

Location - Pan India, hyderabad,ahmedabad,pune,chennai,kolkata.