*Informatica Developer with Teradata (skype hire)* *Client: Wyndham *
*Parsippany, NJ * *Max Rate: $50hr* *1+ year project* *Must have 4+ years of working with Teradata as a data source* *Details* *Job Description - (Provide: Selling Points, Required Skills, Desired Skills, Responsibilities, Client Environment, Practice info, must-haves, etc.)* · 7 + years of expert level Informatica ETL experience is required. · Expertise in Informatica Power Center (9.x) is highly desired. · Expertise in Informatica (9.x) suite of products like PowerExhange, IDQ, IDE etc. · A minimum of 3 -4 years strong hands on experience in Informatica development with Teradata platforms is required. · Expertise in developing high performance code using Informatica ETL tool sets and Teradata load scripts/utilities. · Develop ETL solution using the tool sets from Teradata and Informatica to develop high performing ETL to processes with huge volume of data. · Document the application development process following AIM guidelines in preparing SOD,DDD, Unit test cases etc. is required. · Develop and test ETL and ELT modules based on design specification. · Develop, test, deploy and maintain ETL workflows for multiple data sources like flat files, XML, Teradata, DB2, Oracle, SQL Server. · Plan, test, and deploy ETL mappings, and database code as part of application build process across the enterprise. · Review ETL workflows for performance and recommend for process improvements. · Must also have a solid background in Informatica Transformations like lookups, source qualifier, update strategy, router, sequence generator, aggregator, rank, filter jointer, sorter, mapplets, and other latest transformations like web services, Java etc. · Expertise in ETL performance tuning is required. · Extremely strong Teradata SQL skills. · Physical data modeling experience in Teradata. · Strong knowledge and current experience in Teradata query tuning, explain plans and performance triage/troubleshooting. · In depth and current knowledge of Teradata data distribution techniques and their applicability and usage. · Strong knowledge and recent experience in designing and implementing Teradata focused Primary Partitioning Indexes, Join Indexes, and other techniques for performance tuning. · Good understanding of Teradata parallel architecture and its physical implementation. · Experience using load Teradata utilities (standalone as well as with Informatica). · Exposure to OLAP, OLTP, Data warehouse, Data mart development, Fact and Dimensional Data base designs. · Strong understanding of fundamentals in dimensional Modeling (Star schema, Snowflake schema, Type 1/2/3 SCD's). · Experience with Software Development Lifecycle (SDLC) and AIM methodologies. · Coordinate between different business groups and Technical groups throughout HIT & other business units. Work within different IT teams to follow the full lifecycle development process working with PMO, BA, QMO, and Technical Services teams. · Ensure established ETL standards are followed. Strong problem diagnosis skills in developing ETL solution and Reusable Components · Provide day-to-day support for operational data needs. · Oversees offshore development team to oversee requirements and development efforts. · Working experience in UNIX shell environment. Scripting knowledge is a plus. · Knowledge of Trillium is a plus. -- Regards *Mayank Sharma* Technical Recruiter Sage Group Consulting Inc. Direct: 732-837-2134 :: Phone: 732-767-0010 Ext: 305 Email Id: mysha...@sagetl.com <dguss...@sagetl.com> Yahoo: mayank_sharma_recruiter gtalk: mayank.mayank999 Website: www.sageci.com -- You received this message because you are subscribed to the Google Groups "Companies Looking for IT Out Staffing & Recruitment" group. To unsubscribe from this group and stop receiving emails from it, send an email to arunsinh+unsubscr...@googlegroups.com. To post to this group, send email to arunsinh@googlegroups.com. Visit this group at http://groups.google.com/group/arunsinh. For more options, visit https://groups.google.com/d/optout.
