Position: ETL/Data Warehouse Architect | Teradata
Location: Richardson, Texas
Duration: 12 Months
Client: INFOSYS - Kraft Foods
Job Description:
* More than 11 years of experience in application, architecting, designing, development and implementation of ETL/Data warehouse projects
* Expertise in data warehousing, ETL architecture, Data Profiling using Informatica Power Center/ Informatica Data Quality - Client and Server tools and building Design and building Enterprise Data warehouse/Data Marts.
* Experience in Database design, entity relationship modelling and dimensional modelling 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 DataMart's.
* 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.
Minimum years of experience*: 11 years of experience
Certifications Needed: NO
REMOTE: Initially YES
Interview Process (Is face to face required): NO
No comments:
Post a Comment