*Hi, * *Hope you are doing great. Please go through the below mentioned requirement and share the profiles at **a...@tresourceinc.com <a...@tresourceinc.com>** ASAP.*
*Job Title: Teradata ETL Consultant * *Location: 100 North Point, San Francisco, CA* *Type of hire: 6+ months Contract* *Interview Mode: Telephonic and F2F* Technical skills : Minimum of 2 to 3 years of Ab Initio, Unix, Teradata experience preferred Non-Technical skills: Good Communication, Professionalism Responsibilities: • Work with engineers from disparate source systems for data acquisition, transformation and data quality. • Understand the structure and meaning of data coming in the source systems through data profiling and applying business content to the data. • Define business rules and transformations for data coming from source systems into the data warehouse to match the business application of the data. • Design and develop production level data loads into the data warehouse that are optimized for fast performance and minimal maintenance. • Design dimensional data models that work well with the other components of the BI stack, like the database and reporting tools. • Identify data quality issues and their root causes. Implement fixes and design data audits to capture the issues in the future. • Implement indexing and partitioning strategies that maximize query performance based on how users access the data. Skills, Experience & Requirements: • Minimum of 2-3 years of Ab Initio experience (GDE and EME) and Unix experience • Minimum of 3-5+ years data warehouse and ETL processing experience • Teradata experience preferred; Excellent SQL skills required • Ability to explain technical concepts to non-technical associates and vice-versa a must • Experience with ETL design and code development in Ab Initio • Experience analyzing customer The ETL Consultant specializes in the design and development of the ETL environment, processes, programs, and scripts to acquire data from source systems and apply the data to the tables in the database. This individual must have the skills necessary to understand the overall data warehouse architecture. The ETL Consultant designs and builds the ETL environment with the specific toolset required by the client. The ETL Consultant may also provide input to the database designer to optimize the data loading of the physical database. The ETL Consultant may be the Lead Consultant on a project. Additional details: • Extensive Experience with Teradata development • Experience with Designing data models • Experienced with ETL Process modeling/architect design • Should be able to own and handle multiple deliverables at the same time • Capabilities to work with frequently changing requirements • Should be able to work with functional and business teams to identify/confirm requirements and design flexible and forwarding thinking data models and ETL processes • Retail industry Experience would be a plus Regards, Ali a...@tresourceinc.com 408-709-1760 EXT 859 -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to citrix-and-sap-problems+unsubscr...@googlegroups.com. To post to this group, send email to citrix-and-sap-problems@googlegroups.com. Visit this group at http://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.