Job Description :

Position: Teradata Developer

Location: Richardson - TX





Job Description:

Perform Teradata developer role 

3.Experience 6to10yrs 

4.Required Skills Technical Skills- ,Informatica PowerCenter,Unix Shell Scripting,Teradata,BTEQ scripts Domain Skills- ,PBM 

5.Nice to have skills Techincal Skills- ,Informatica AVOS Domain Skills- 

6.Technology Informatica 


Roles & Responsibilities:

  • Software development lifecycle activities: estimating, requirements, design, build, reviews, test and deployment of Data Warehouse applications.
  • Is accountable for database design leveraging constructs such as Join indexes, Statistics, and Partitioned tables
  • Design and develop load processes using SQL & PL/SQL, BTEQ and queries for very large databases (100 TB+) with complex workloads and large transaction volumes.
  • Work on identification and optimization of sub-optimal queries & load processes.
  • Review, update, and maintain Oracle related system architecture documentation, and create Oracle detail design documents that will be followed by the oracle developers to build data maps, packages, procedures and other build components.
  • Create design pattern templates for deliverable objects and communicate functional and technical requirements to application development teams.
  • Drive and lead projects during the implementation, test and deploy phases.
  • Understand data and develop subject matter expertise on complex applications.
  • Review logical and physical data models to support complex end user dashboard/reports and queries.
  • Proactively identify & mitigate technical issues and help with fine tuning queries for efficient performance.
  • Work in a matrix environment consisting of Solution, Business Intelligence, and Data Integration & Quality Assurance teams and successfully collaborate to meet the project objectives. 
  • Responsible for problem solving and troubleshooting design and development issues and provide appropriate solutions.
  • Works on one or more projects at all stages of the system lifecycle
  • Adopt features/best practices introduced in newer versions of Oracle/Teradata.
  • Assist development teams in writing complex queries in efficient way leverage Oracle/Teradata best standards and practices. 
  • Provide assistance in deployment and project/product migration efforts.
  • Serve as the subject matter expert for the system in production.
  • Experience in Oracle 

Similar Jobs you may be interested in ..