Tcs is hiring for DATASTAGE

TCS

4 - 9 years

Bengaluru

Posted: 27/11/2024

Job Description

Job Description
                   •             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

Location
Bangalore
Job Function
IT INFRASTRUCTURE SERVICES
Role
Developer
Job Id
340103
Desired Skills
DataStage
Desired Candidate Profile
Qualifications : BACHELOR OF TECHNOLOGY

About Company

Tata Consultancy Services (TCS) is one of the largest multinational IT services and consulting companies in the world, headquartered in Mumbai, India. It operates in over 50 countries and is a part of the Tata Group, India's largest business conglomerate. TCS offers a wide range of services including software development, consulting, digital transformation, and business solutions, serving industries such as finance, healthcare, retail, and telecommunications. Known for its global reach, technological expertise, and innovation, TCS is consistently ranked among the top IT services companies globally.

Services you might be interested in

One-Shot Campaign

Reach out to ideal employees in one shot!

The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).