Tera Data

Description :

RESPONSIBILITIES

Create, debug, and execute Teradata database schemas & scripts

Integrate scripts across multiple technology platforms (Hadoop, Teradata,Control-M).

Provide support during Testing & implementation

Should have Strong data warehousing background with expertise on the various data warehouse modelling approaches (Must be on Teradata )

Expertise onTeradata GCFR Framework and Unix scripts

Good analytical and creative problem solving skills for the design and development of software

Strong SDLC delivery experience for complex Enterprise BI-DWH solutions

Engaging and follow-up with various source system teams on the data requirement understanding discussions

Engaging business stakeholders to resolve sourcing data understanding gaps, if any

Should have strong domain knowledge of corporate data standards, reference data standards, business glossary terms, etc.

Gathering data sourcing estimations from various source systems and collate them with assumptions & other dependencies

Should have skills for data sourcing project planning & implementation with SDLC standards and to make sure relevant (Quality Maturity Framework) templates are followed

Documenting the sourcing requirement (functional & technical specifications) by working with source system teams

Should have efficient risk/issues management skills & able to highlight to relevant stakeholders at the right time

Should have basic technical knowledge about data files, layout, etc. & to assist team in interacting with source team to obtain files for data profiling/analysis & testing

Engage relevant teams for connectivity setup, test and implementation

Should able to work on data analysis and landscaping

Should have good communication, negotiation & presentation skills. Should be a team player, have can do attitude & can think of out-of-box approach if situation arises

Skills & Attributes

1.Very good knowledge of Teradata and In-depth knowledge of Teradata Utilities like Fastload, Multiload, Tpump, BTEQ, TPT

2.Very good knowledge of Teradata GCFR Framework and Unix Shell Scripting

3.Ability to write efficient SQL query building & exposure to query tuning

4.Understanding of Normalization and De-normalization concept.

5.Very good exposure to Data warehouse concepts and very good understanding of ETL methodology.

Nice to have

3-6 yrs of experience in scripting & developing a TD-DWH application

Very good understanding of Ctrl-M-Scheduling and Deployment/Support Skills

Expertise in developing complex dashboards, Visual Analytics , data modelling

Expertise in TD setup and administration in a Linux environment

Finance and HR domain knowledge is desirable.

Good to have certified inITIL.