Tcs is hiring for DATASTAGE

                   •             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 to analyze and improve query performance.

•             Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.

•             Experience in Atlassian toolset - Jira, confluence, Bitbucket,Bamboo etc

•             Experience in UNIX shell scripting needed

•             Created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc

•             Automated data warehousing and datamart refreshes using scheduling tool like  control - M

•             Worked on creating and managing the partitions.

•             Acted as a liaison between the offshore and onsite teams

•             Experience in SQL server, SSIS preferred

•             Experience in Dimensional Modelling preferred

•             Experience in reporting tool Qliksense preferred

•             Experience in Banking domain preferred

•             Experience in Regulatory reporting preferred