Hi,
Hope you are doing fine. Please find the requirement below. If you have anyone available then kindly send updated resume ASAP.
Title: Sr. Informatica Developer
Duration: 6-12 months
STEVENS POINT, WI
COMMUNICATION SKILLS WILL BE VERY IMPORTANT
IN-PERSON INTERVIEW PREFERRED
INSURANCE EXPERIENCE STRONGLY PREFERRED
Scope of work
Type of Application: Informatica Developer/Analyst
Assignment Description (Analyst/Developer/DBA … etc.): Perform Analysis, Design, Development and Testing of new Informatica mappings.
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 testing of these Informatica mappings. This will include working with IT Data Analysts in a team environment to design, develop and unit test the required mappings. 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.
Informatica v9.1.0 will be used to develop mappings for SQL Server sources. Informatica Power Exchange 9.1.0 will be used to develop mappings to source multiple data types from the Mainframe including sequential file, IMS, DL1, DB2. Target databases are SQL Server. Being able to read and modify stored procedures in Microsoft SQL Server is a requirement. Familiarity with data warehousing technology is also a requirement.
Technical skills
| Skills by Priority | Version | Required or Desired | Light Medium Heavy |
| Written Communication Skills | NA | Required | Heavy |
| Oral Communication Skills | NA | Required | Heavy |
| Create/Update mappings, sessions and workflows | Informatica 9.1.0 | Required | Heavy |
| Knowledge and experience using Router, Union transformation types | Informatica 9.1.0 | Required | Heavy |
| Knowledge and experience using Normalizer, Filter, Joiner, Lookup, Stored Procedure, Aggregator, HTTP and Sorter transformation types | Informatica 9.1.0 | Required | Medium |
| Knowledge and experience in expression syntax | Informatica 9.1.0 | Required | Heavy |
| Knowledge and experience in using Source Qualifier transformations configured to use SQL Select statements as an override | Informatica 9.1.0 | Required | Heavy |
| Create/Update parameter files | Informatica 9.1.0 | Required | Medium |
| Ability to debug and understand session error logs | Informatica 9.1.0 | Required | Medium |
| Experience in integration test and system test of mappings | Informatica 9.1.0 | Required | Medium |
| Experience in performance tuning | Informatica 9.1.0 and SQL Server 2008 | Required | Medium |
| Experience in Select, Update and Delete statements | Microsoft SQL Server 2008 | Required | Medium |
| Stored Procedure Development | Microsoft SQL Server 2008 | Required | Medium |
| Technical Design Specification Creation | NA | Required | Medium |
| Reading of Data Models, specifically star and snowflake schemas | NA | Required | Medium |
| Test Plan Creation and Execution | NA | Required | Medium |
| Creating Power Exchange Data Maps for mainframe sources | Informatica Power Exchange 9.1.0 | Desired | Medium |
| Testing mainframe data using Power Exchange Navigator | Informatica Power Exchange 9.1.0 | Desired | Medium |
| Experience in Pre SQL and Post SQL functionality | Informatica 9.1.0 | Desired | Medium |
| Familiar with reusable objects | Informatica 9.1.0 | Desired | Medium |
| Trigger Development | Microsoft SQL Server 2008 | Desired | Medium |
| Experience working with data warehouses or data marts | NA | Desired | Medium |
| Insurance/Financial Industry Experience | NA | Desired | Medium |
| Familiarity with Informatica's slowly changing dimension functionality | Informatica 9.1.0 | Desired | Medium |
Thanks & Regards
Amber Srivastava
Sr. Recruiter - IT Staffing
201-524-9600 ext. 209,
US Tech Solutions Inc.
Minority Certified/ Microsoft Gold Certified Partner
--------------------------------------------------------------------------------------------------------------
Disclaimer: We respect your Online Privacy. This is not an unsolicited mail. Under Bill 1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include Contact Information and a method to be removed from our mailing list. If you are not interested in receiving our emails then please reply with a "REMOVE" in the subject line and mention all the email addresses to be removed with any email addresses.
--
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To post to this group, send email to sureshotjobs@googlegroups.com.
To unsubscribe from this group, send email to sureshotjobs+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/sureshotjobs?hl=en.
No comments:
Post a Comment