Hello, Hope you are doing great,
Please let me know on [email protected] if you have any good resources available for the below position. Role: Teradata ETL Consultant Location: San Francisco, CA Duration: long term Interview: phone/skype/face to face Job description: 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 samir Sr. Technical Recruiter (Team Lead) Rider Consulting Inc. [email protected] 980-272-1261 -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
