Technical Recruiters BSM REQ: Urgent Need For Senior Informatica Developer/Lead//Hoboken,, NJ//6+ Months

Dear Associate,

Hope you are doing great. Please review the below requirement thoroughly with your available resources and reply with matching profiles along with below details. 

 Please send your updated resume  to Raj@bsmsys.com

Role:	Senior Informatica Developer/Lead
Location:	Hoboken,, NJ
Position Type:	C2C
Duration:	6+ Months
Interview:	Telephonic
# of Positions:	2
Start Date:	Immediate
Client Industry:	Technology
Validated the exclusivity?:	NO
Requirement Description:
Project Summary and Goals:  Companies, Inc. (MMC) is one of the world's largest professional services and insurance brokerage firms and is based in the United States. BASYS is the current US billing and fiduciary system used for Invoice Billing, Accounts Receivable, and Accounts Payables. This 30 years old system requires manual and independent business processes resulting in operational inefficiencies and challenges in meeting client expectations. The initiative is to convert the current billing system to Oracle's financial system called Revenue Management & Billing (RM&B). There are number of downstream systems that require BASYS Revenue Files in their current format. It is therefore necessary, as part of the RM&B project, to reverse engineer required BASYS files. Participation: I was the Informatica Developer/Informatica Lead, responsible for developing and leading the onshore and offshore developers in designing, developing, implementing, and supporting five critical database systems that were used for data migration and conversion project. These systems are as follow: The Global Integration Data Stage database is a global system that is a repository for the Marsh's colleagues and product information. The Reference schema database contains translation and reference data. The pre-stage database contains the legacy data that was loaded from the BASYS flat files. The RMB staging area contains the transformed data that will be deployed to the RMB application. The Financial staging database contains Invoice Billing, Account Receivable and Payable transactions, and Reference data. The converted data is used to feed the consuming application and data warehouse. Created conceptual, logical and physical data models. Duties over the course of the project included: • Requirement Gathering and data Analysis of all supporting systems. Designed Informatica architecture and data flows. • Gather Business Requirements and translate into Technical Specifications for Informatica ETL team. • Provide technical strategies and directions to five onshore and four offshore Informatica developers. • Extracted data from data warehouse to feed downstream systems. (Bill Inmon, Ralph Kimbal Methodology) • Knowledge of extracting heterogeneous and homogeneous sources (XML, Flat Files, Tables, CSV) • Developed, tested and migrated Informatica ETL mappings for OLTP AND OLAP systems. Mappings include but not limited to the following: PLSQL Packages, Procedure and Functions, SQL Transformation, Update/Insert Strategy, Mapping Parameters and Variables. Documented all associated mappings by creating Low Level Design documents. These Documents are used by the production support teams.
BSM Additional Comments:
Need Resumes asap..
If interested, please reply with matching profiles along with their contact details, rate, availability, current location details.
Raj  | BSM | Account Manager Office: 7327770800x508 Learn: bsm.us.com
BSM Learn More - Facebook - LinkedIn - Twitter 13 years in business with referable clients Minority & Women Owned Business Enterprise Microsoft Certified Partner Oracle Certified Partner SWaM - Small, Women and Minority Vendor for State of VA APICS Corporate Member HQ: 2 Tower Center Blvd., 20th Floor, Suite # 2004 | East Brunswick, NJ - 08816 | United States Global: United States | Europe | MEA

--
--
Request: Please do not send any messages to this group which are nor related to IT staffing.
 
You received this message because you are subscribed to the Google
Groups "Technical Recruiters" group.
To post to this group, send email to
technical-recruiters@googlegroups.com
To unsubscribe from this group, send email to
technical-recruiters+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/technical-recruiters?hl=en?hl=en
---
You received this message because you are subscribed to the Google Groups "Technical Recruiters" group.
To unsubscribe from this group and stop receiving emails from it, send an email to technical-recruiters+unsubscribe@googlegroups.com.
To post to this group, send email to technical-recruiters@googlegroups.com.
Visit this group at http://groups.google.com/group/technical-recruiters.
To view this discussion on the web visit https://groups.google.com/d/msgid/technical-recruiters/CAKOi6qrwN-fhEsLqXntPRePF4K%3DqvT9rk9Km5Z-jruJtY5pzZg%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.