Company Name: Deloitte Consulting India Private Limited
Job Description: Teradata Referral
Job Reference: 14911542000013672
Work Experience: 0 – 5 Years
Work Location: Bangalore
Education: UG - Other Graduate, PG - Other
DOCTORATE - Any Doctorate - Any Specialization, Doctorate Not Required
Job Description
Job DescriptionDeloitte is the brand under which tens of thousands of
dedicated professionals in independent firms throughout the world collaborate
to provide audit, consulting, financial advisory, risk management, and tax
services to selected clients. These firms are members of Deloitte Touche
Tohmatsu Limited ( DTTL) , a UK private company limited by guarantee. Each
member firm provides services in a particular geographic area and is subject to
the laws and professional regulations of the particular country or countries in
which it operates. DTTL does not itself provide services to clients. DTTL and
each DTTL member firm are separate and distinct legal entities, which cannot
obligate each other. DTTL and each DTTL member firm are liable only for their
own acts or omissions and not those of each other. Each DTTL member firm is
structured differently in accordance with national laws, regulations, customary
practice, and other factors, and may secure the provision of professional
services in its territory through subsidiaries, affiliates and/ or other entities.
In the United States, Deloitte LLP is the member firm of DTTL. Like DTTL,
Deloitte LLP does not provide services to clients. Instead, services are
primarily provided by the subsidiaries of Deloitte LLP, including:
Deloitte & Touche LLP
Deloitte Consulting LLP
Deloitte Financial Advisory Services LLP
Deloitte Tax LLP
Role: Teradata Sr ConsultantGroup: Information Management
ConsultingInformation Management ( IM) is one of the major service lines within
Technology practice of Deloitte US India Consulting org. Service lines are
composed of capabilities, of which IM has five, all of them focused on helping
clients manage and leverage their information. IM focuses on Business
Intelligence / Data Warehousing, Enterprise Content Management, Web Channel
Solutions, Enterprise Data Management and Performance Management Technologies.
Minimum of 7- 8+ years strong NCR Teradata and SQL, Data Warehouse
Modeling, Aggregates and building efficient views
Proficient with utilities like Teradata SQL Assistant, Teradata
Manager, Teradata Administration, Teradata design, DBA and Unix Scripting.
Certification in Teradata and Teradata SQL preferred.
Must be able to successfully:
Use Teradata utilities fastload, multiload, tpump to load data.
Write BTEQ scripts to transform data.
Write Fastexport scripts to export data.
Write, test and implement Teradata Fastload, Multiload and Bteq
scripts, DML and DDL.
Write views based on user and/ or reporting requirements.
SQL proficient.
Role: Datastage Consultant
Provide expert knowledge of Datastage best practices enabling the team
to leverage the platform as effectively as possible.
Provide technical leadership to help influence the short and longer
term Datastage roadmap
Handle consulting initiatives right from requirement gathering to
implementation of solutions
Excellent knowledge on Parallel Jobs
Good knowledge on Unix and Wql
Minimum 5 years of experience in Datastage
Have good consulting and implementation experience using Datastage
Good understanding of Datastage
Should have worked on parallel jobs
Good knowledge of unix and sqlWork Location: Hyderabad/ Bangalore
Desired Profile
BE/ Bsc/ BTech/ Msc/ ME/ MTech/ MCA/ MBA
Website: http://www.deloitte.com/view/en_IN/in/index.htm