Teradata Developer – 4 to 7 Yrs – Pune/Chennai

Role: Teradata Developer – 4 to 7 Yrs – Pune/Chennai

Job Description:

  • 4 to 7 years of experience in analysis, design,
    development & maintenance of quality product in an ETL process by using
    Teradata concepts and utilities.
  •  At least, 2 to 4 years of experience in
    Teradata and working knowledge of any ETL tool (preferably Informatica)
  • Expertise in Teradata architecture, database &
    datawarehouse concepts
  • Proficient in Teradata SQL programming and
    utilities like TPT, BTEQ, FLOAD, MLOAD, TPUMP and FEXPORT.
  • Good understanding of RDBMS principles
  •  Hands on performance tuning, query
    optimization, file and error-handling, restart mechanism
  •  Hands on experience on UNIX Shell Scripting
    and Informatica
  • Good communication skills and should be able to
    collaborate effectively with team for deliverables
  • An effective team player
  • Nice to have the following - Knowledge of Hadoop
    framework - Map Reduce, Hive, PIG, Sqoop, Flume etc.

Job Duties & Responsibilities:

  • Work with Leads on understanding the project
    requirements/user requests
  • Design, develop and implement data pipelines
    involving data fetched from diverse sources and housed in tables and views in
    the semantic layers
  • Write efficient queries (SQL) to transform data
    from staging layer and load the semantic layer
  • Responsible for ETL processes and tools as well as
    database loading and manipulation to ensure that the data needs are met
    throughout the course of the projects and support.
  • Ensure designs are in compliance with
    specifications
  • Prepare and produce releases of software components
  • Collaborate with other developers, business/data
    analysts and leads to design, develop and test project assignments

Job Purpose:

  • To ensure the development of in-house IT projects
    are delivered effectively, efficiently, on-time, in-specification and in a cost
    effective manner.
  • This Development Engineer should be familiar with
    the ETL concepts, data flow and application development.

Job Specifications:

  • 4 to 7 years of experience in analysis, design,
    development & maintenance of quality product in an ETL process by using
    Teradata concepts and utilities.
  • Design, develop and implement data pipelines
    involving data fetched from diverse sources and housed in tables and views in
    the semantic layers

Primary Skills: 

  • Teradata
  • SQL
  • Unix Shell Scripting

Secondary Skills:

  • Excellent oral and written communication skills
  • Excellent customer service skills
  • Excellent analytical and problem solving skills

Experience:

  • 4 to 7 Years

Location:

  • Pune/Chennai


Contact: Deepika Sohal (Deepika.sohal@capgemini.com)

Subhareddy Palakolanu (Subhareddy.palakolanu@capgemini.com)