Teradata Consultant - (Bellevue, WA)

Responsible for gathering and understanding business qualifications from client and preparing Technical Design to build Data warehouse components in Datastage, Hadoop Utilities and Teradata Background in design and development of ETL frameworks Background in writing Teradata ETL/SQL Scripts for loading data to a hierarchical data model. Background in identifying process complexities, apply fine tune techniques using indexes, joins indexes, Partitioning Data etc. Proficient in coding of optimized Teradata batch processing scripts for data transformation, aggregation and load using BTEQ. Strong background in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata. Strong skills in coding and debugging Teradata utilities like Fast Load, Fast Export, MultiLoad and Tpump for Teradata ETL processing huge volumes of data throughput. Background in creating DB objects using Erwin Knowledge in Hadoop utilities Hive , HDFS, SPARK ,KAFKA ,SQOOP etc.