5+ Years of Hands on Experience in Data processing & Analytics technologies
- 2 + year in Teradata development using tools like BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD
- Expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI and USI and NUSI and JI etc.) etc.
- In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance
- Expertise in SQL, PL/SQL and database query writing & performance tuning
- Knowledge with data warehousing architecture and data modeling best practices.
- Exposure to Agile development model and corresponding tracking tools like JIRA
- Source control with Git, SVN or Clearcase
- Knowledge on Configuration Management tools such as Puppet, Chef, Ansible, SaltStack