Sr. Teradata Developer ---Teradata (Lidl-Germany) 01/2017-10/2018

Task:

• Created various fast performing set and Multiset table which was being used directly by reporting tools.
• Created various views on complex table for faster performance. Experience in creating join Index and Materialized view.
• Developed various SQL scripts using complex join and sub queries. Extensively worked on performance tuning using Explain, Collect Stats, Compression,NUSI and join Index.
• Extensively used various Teradata features as TPT, NUPI ,UPI, No PI.tera

Consultant ---Deloitte Consulting (Bangalore India) 08/2013 – 11/2016

Task:

• Worked in Healthcare domain for client (Anthem).
• Involved in gathering business requirements, logical modeling, physical database design, data sourcing, data transformation, data loading and SQL performance tuning.
• Designed and developed a number of complex mappings using various transformations like Source Qualifier, Aggregators, lookups, Filters, Sequence generators, Routers, Update Strategy, Expression, Sorter, Normalizer etc.
• Created reusable session, workflow, worklet, event wait and Raise, Email Task.
• Extensively used Mapping variables, Mapping parameters and Dynamic parameter Files for improved performance and flexibility.
• Experienced with identifying performance bottlenecks and fixing code for optimization.
• Involved in creating Unit test plan and testing the data for various applications. Used UNIX scripts to automate several ETL processes. and to handle deferent file processing.
• Lead small team of 5 and delivered all the solution on time.

Project Eng.—Wipro Technology (Bangalore India) 08/2010 – 08/2013

Task:

• Worked in Banking and Financial domain for client Lloyds bank.
• Designed and developed various Teradata BTEQ scripts.
• Documentation of end product for customer assistance.
• Performed Unit Testing & supported UAT(user Acceptance Testing) .

Sr. Teradata Developer ---Teradata (Lidl-Germany) 01/2017-10/2018

Task:

• Created various fast performing set and Multiset table which was being used directly by reporting tools.
• Created various views on complex table for faster performance. Experience in creating join Index and Materialized view.
• Developed various SQL scripts using complex join and sub queries. Extensively worked on performance tuning using Explain, Collect Stats, Compression,NUSI and join Index.

Extensively used various Teradata features as TPT, NUPI ,UPI, No PI.