Yash Athawale

Teradata Developer (Data Engineer)

Accenture Solutions Pvt. Ltd.•  August 2021 - Present•  Nagpur, India

Proficient in utilizing Teradata utilities such as BTEQ, MLOAD, FEX, and FLOAD for efficient data manipulation, loading, and extraction. Experienced in scripting with BTEQ to execute complex SQL queries and manage end-to-end ETL processes, ensuring data accuracy and performance. Validated and tested scripts to ensure alignment with business requirements, documenting detailed unit test cases. Skilled in using Teradata SQL Assistant and CA Workload Automation DE (D-Series) for job scheduling and monitoring. Automated data operations using Linux/Unix shell scripting to streamline workflows, optimize data pipeline efficiency, and ensure timely data loads. Proficient in upstream and downstream data analysis to troubleshoot issues and maintain data integrity across logically related tables, ensuring seamless data flow and accurate reporting. Optimized Teradata SQL queries and database structures for maximum performance, implementing query tuning and indexing strategies to enhance data processing efficiency. Collaborated with cross-functional teams to define reporting requirements and developed complex SQL views to support front-end applications, ensuring seamless integration of business data. Resolved inconsistencies in historical data reported by users by implementing structured validation and correction processes, ensuring data integrity and compliance with business rules. Experienced in ServiceNow for ticket handling and incident management. Led a team in resolving Teradata system incidents and served as the primary point of contact for business users.