Dear Partners,
please submit your profiles for the position Informatica Developer to pavan@siltekcorp.com,
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
You received this message because you are subscribed to the Google Groups "Entry level IT Jobs in US + H1B visa sponsor" group.
To unsubscribe from this group and stop receiving emails from it, send an email to entry-level-it-jobs-in-us-h1b-visa-sponsor+unsubscribe@googlegroups.com.
To post to this group, send email to entry-level-it-jobs-in-us-h1b-visa-sponsor@googlegroups.com.
Visit this group at http://groups.google.com/group/entry-level-it-jobs-in-us-h1b-visa-sponsor.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment