*Dear Partners,*
*please submit your profiles for the position Informatica Developer to [email protected] <[email protected]>,* *Title: Informatica Developer Location: Stevens Point, WI Duration: 12 Months* *Job Description:* - Insurance experience is a MUST, State Farm, Allstate, American Family, West Bend Insurance, Nationwide, Prudential Insurance are all Positives. - Informatica 9.1 experience is a MUST - T-SQL is a MUST - SQL Server Database is a MUST - Create/Update mappings, sessions and workflows is a MUST - Performance Tuning is a MUST - integration test and system test of mappings is a MUST *SCOPE OF WORK* - Type of Application: Informatica Developer/Data Analyst - Assignment Description (Analyst/Developer/DBA ... etc.): Design, development and testing of Informatica mappings. Design, development and testing of T-SQL components *Assignment Responsibilities*: Under general supervision, assume primary responsibility for creating Informatica mapping technical design specifications based on functional designs and business requirements, as well as development and unit test the Informatica mappings. Based on technical designs, develop and test the required components in T-SQL. This will include working with IT Data Analysts and subject matter experts in a team environment to interpret the requirements and designs. Participate in the integration, system and performance testing of new and existing Informatica mappings and SQL Server stored procedures. Need to have the ability and willingness to perform analysis and defect resolution with limited guidance. Provide detailed input on technical decisions regarding design, testing, and maintenance. Produce documentation of the processes and code developed to support the above efforts. *TECHNICAL SKILLS* - Skills by Priority Version - Written communication skills - Oral communication skills - Create/Update mappings, sessions and workflows Informatica 9.1.0 - Knowledge and experience using Router, Union transformation types Informatica 9.1.0 - Knowledge and experience using Normalizer, Filter, Joiner, Lookup, Stored Procedure, Aggregator, HTTP and Sorter transformation types Informatica 9.1.0 - Knowledge and experience in expression syntax Informatica 9.1.0 - Knowledge and experience in using Source Qualifier transformations configured to use SQL Select statements as an override Informatica 9.1.0 - Create/Update parameter files Informatica 9.1.0 - Ability to debug and understand session error logs Informatica 9.1.0 - Experience in integration test and system test of mappings Informatica 9.1.0 - Experience in performance tuning Informatica 9.1.0 and SQL Server 2008 - Experience in Select, Update and Delete statements Microsoft SQL Server 2008 - Stored Procedure Development Microsoft SQL Server 2008 - Technical design specification creation - Reading of data models, specifically star and snowflake schemas - Test Plan creation and execution NA Required Medium - Experience working with batch processing environments *Desired Skills:* - Experience working with data warehouses or data marts - Insurance/financial industry experience - Experience in Pre SQL and Post SQL functionality Informatica 9.1.0 - Familiar with reusable objects Informatica 9.1.0 - Trigger development Microsoft SQL Server 2008 - Familiarity with Informatica's slowly changing dimension functionality Informatica 9.1.0 Thanks, *Pavan Gurram* *Siltek Corporation * *people. technology. innovation* 300 Brickstone Square Suite 201 Andover, MA 01810 (978) 475-3500 Direct (978) 623-7201 Fax *[email protected] <[email protected]>* www.siltekcorp.com -- You received this message because you are subscribed to the Google Groups "Open Source J2EE frameworks" 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/open-source-j2ee-frameworks. For more options, visit https://groups.google.com/groups/opt_out.
