Job Description :
Hi Nick,

Role : Teradata Developer Lead ( Pharma Domain)
Work Location: Richardson, TX
Duration : 12+ months

Must Have Skills
End client is looking for a Teradata lead developer who has the following qualifications
o More than 5 years of experience in Teradata = designing, development and implementation of ETL/Data warehouse projects
o Expertise in data warehousing, ETL architecture, Data Profiling using Informatica PowerCenter/ Informatica Data Quality – Client and Server tools and building Design and building Enterprise Data warehouse/Data Marts.
o Experience in Database design, entity relationship modeling and dimensional modeling using Star and Snowflake schemas.
o Extensively worked with mappings using different transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Update Strategy, Unconnected / Connected Lookup, Aggregator and SCD Type-2.
o Experience in loading various data sources like Oracle, SQL Server, Teradata, DB2 and Flat Files into Datamarts.
o Experience in Performance Tuning and Debugging of existing ETL processes.
o Experience in writing Triggers, Stored Procedures, Functions, and Packages etc using PL/SQL
o Experience in UNIX Shell Scripting
o Experience in Azure Cloud Platform
o Experience with Cloud Data bases (Azure SQL Data warehouse, Azure SQL Database), Hadoop file systems, Hive Tables, Sqoop, Oozie, Hadoop & Spark HDI cluster
o Experience in Oracle 10g/9i/8i

Nice to Have
Big Data
Hadoop
Oracle
Teradata Architecture

Detailed Job Description
More than 10 years of experience in applicatio, architecting, designing, development and implementation of ETLData warehouse projectsExpertise in data warehousing, ETL architecture, Data Profiling using Informatica PowerCenter Informatica Data Quality Client and Server tools and building Design and building Enterprise Data warehouse, Data Marts.