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: sb...@sagetl.com <sb...@sagetl.com>* *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 "USITCV" group. To unsubscribe from this group and stop receiving emails from it, send an email to usitcv+unsubscr...@googlegroups.com. To post to this group, send email to usitcv@googlegroups.com. Visit this group at http://groups.google.com/group/usitcv. For more options, visit https://groups.google.com/d/optout.
