*Note: Please forward resumes to **vdo...@matrixonweb.com*<vdo...@matrixonweb.com>
Job title: Lead Informatica. Location: NYC Duration: 3 Months. *Note: Need local candidates.* *We are looking for an Lead Informatica developer with experience in BO and SQL.* *Basic Qualifications: * Designing and modeling the Rating Datamart to accommodate Bond related data. Also design and model the required staging tables and ODS for accommodating incremental and history data. Analyzing business and data requirements of the project for reports and data extraction. Analyzing source systems and understanding source data to determine the logic of extracting the required data from the source systems. Designing and developing transformation logic to be used to extract the data from the source databases to staging and operational tables and from staging tables to the Datamart. Designing and Developing the transformation logic to provide the data to Quant engine which processes the bond derived rating and z-score values. Implementing ETL logic using data warehousing tool Informatica to transform and load the data to staging and Datamart tables. Developing analytical reports using data warehousing reporting tool Business Objects (BO) which will be displayed on the Hugin application. Designing and developing the Business Objects Universe to create the analytical reports. Testing of the Informatica mappings and sessions developed and ensuring quality, validating the data and data correctness. Testing of Business reports to ensure the correct data is displayed and to ensure that the report requirements are met. Performance testing of ETL jobs and BO reports to ensure that they respond with data in the stipulated time mentioned in the user requirements Developing the ETL high level design document which details out the entire extraction and data load procedure and logic. Reviewing and updating the ETL Low level design and BO Report low level design documents. Implementing and integrating new processes created. *Required Qualifications:* Informatica : 5 years *Other Required Qualifications:* SQL, BO,PL SQL: 4 years Thanks and Regards, * * *Vasanth Dolai* *Sr. Technical Recruiter* Matrix Technology Group "Certified Minority Business Enterprise (MBE)" Phone: 732-479-0412 Fax: 732-909-2631 Email: vdo...@matrixonweb.com <v...@matrixonweb.com> Website : www.matrixonweb.com <http://www.matrixonweb.com/sap.php> Add - Yahoo : vasanthdo...@yahoo.co.in <iqbalk...@yahoo.co.in> -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" group. To post to this group, send email to oracle-projects@googlegroups.com. To unsubscribe from this group, send email to oracle-projects+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/oracle-projects?hl=en.