Hi,
Please find the requirement below and let me know your interest.. *POSITION* *Informatica Developer with Teradata (skype hire)* *Client: Wyndham * *Parsippany, NJ * *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. *Thanks and Regards,* *Shilpi Bist* *Technical Recruiter* *[image: images]* <http://www.sageci.com/> *email: [email protected] <[email protected]>* *Phone: 732 767 0010 Ext: 542* *Gtalk: shilpi.recruiter1* *Ymail: shilpi.recruiter* *[image: Linkedin_Logo]*<http://www.linkedin.com/pub/shilpi-bist/82/944/7a7/> -- You received this message because you are subscribed to the Google Groups "SAP Resource Center" 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/sap-resource-center. For more options, visit https://groups.google.com/d/optout.
