Job ID :
27876
Company :
Internal Postings
Location :
Richardson, TX
Type :
Contract
Duration :
12 Months
Salary :
DOE
Status :
Active
Openings :
1
Posted :
04 Aug 2020
Job Seekers, Please send resumes to resumes@hireitpeople.com

Must Have Skills:

  • More than 10 years of experience in Teradata = designing, development and implementation of ETL/Data warehouse projects
  • 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. 
  • Experience in Database design, entity relationship modeling and dimensional modeling using Star and Snowflake schemas.
  • 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.
  • Experience in loading various data sources like Oracle, SQL Server, Teradata, DB2 and Flat Files into Datamarts. 
  • Experience in Performance Tuning and Debugging of existing ETL processes.
  • Experience in writing Triggers, Stored Procedures, Functions, and Packages etc using PL/SQL
  • Experience in UNIX Shell Scripting
  • Experience in Azure Cloud Platform
  • Experience with Cloud Data bases (Azure SQL Data warehouse, Azure SQL Database), Hadoop file systems, Hive Tables, Sqoop, Oozie, Hadoop & Spark HDI cluster
  • 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.

Minimum years of experience: 10

Certifications Needed: No

Top 3 responsibilities you would expect the Subcon to shoulder and execute:

  1. Architecture
  2. Design
  3. Development

Interview Process (Is face to face required?): No

Does this position require Visa independent candidates only? No