*Send resumes to sr...@bsmmgmt.com* *Role:* *Data Warehouse ODI specialist*
*Location:* Malden, MA *Duration:* 8 – 12+ Mon *Rate:* $ DOE /Hr C2C All inclusive *Interview:* Immediate (Telephonic followed by in-person) *# of Positions:* 4 *Start Date: * Immediate** *Visa: * USC/GC/EAD/H1B** *Client:* Public Sector * * *Data Warehouse ODI specialist.* Must have top level experience with ODI someone who is skilled enough to train others in ODI would be ideal. *Required Experience:* - 8+ years overall experience in Data Integration, Data Architecture, Data Modeling, and implementation. - Minimum of 5 years of full lifecycle data warehousing experience. - BI knowledge a requirement – 5 years in BI from ETL perspective. - Minimum of 2 years Oracle ODI experience. - Design experience of the detailed ETL architecture, including agents, scenarios, packages, data mapping, data extractions, transformations and validations. This ETL design and implementation should include stand-alone and Java EE agents, ODI data services, ODI Console, ODI studio, and other appropriate development tools. - Implement ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including, Relational Database Management servers (including Oracle RDBMS, flat files (including CSV, Excel, & XML file formats), and web services (SOAP, WS-I Security). - Experience in Master Data Management and Meta Data Management. - Experience in Dimensional Modeling. - Demonstrated ability to communicate the overall customer data architecture to both technical and business constituencies. - Set up and configure ODI according to requirements. - Creating Interfaces in order to move data from source to target. - Assist infrastructure personnel in implementing the ODI migration process to migrate the ODI configuration through various development, test, and production environments. - Develop system /integration test plans and scenarios for data loads and extracts. - Manage and monitor production and non-production ETL sessions. - Mentor and transfer ODI technical knowledge and processes to other team and department personnel, as requested. - Ability to observe steps and ascertain success of step or failure and root cause of step(s). *Desired Experience:* - Good knowledge of applicable data privacy practices and laws (FERPA). - Experience in an education environment a plus. - Experience with Oracle Exadata is a plus. *Strategy & Planning:* - Develop and deliver long-term strategic goals for data integration standards in conjunction with data users, department managers, clients, and other key stakeholders. - Assist with assessing and determining governance, stewardship, and frameworks for managing data across the organization. - Create short-term tactical solutions to achieve long-term objectives and an overall data management roadmap. - Establish methods and procedures for tracking data quality, completeness, redundancy, and improvement. - Conduct data capacity planning, life cycle, duration, usage requirements, feasibility studies, and other tasks. *Operational Management:* - Develop and promote data integration methodologies and standards. - Develop integration process data flows and data mapping analyses. - Address data-related problems in regards to systems integration, compatibility, and multiple-platform integration. - Act as a leader and advocate of data integration and management, including coaching, training, and career development to staff. - Develop and implement key components as needed to create testing criteria in order to guarantee the fidelity and performance of data architecture. - Identify and develop opportunities for data reuse, migration, or retirement of systems. ** Work Week*: 7.5 Hours Thanks and look forward to your prompt and positive response... *Srini Kumar * | Technical Recruiter Office: 732 777 0800 ext. *512* Learn: *bsm.us.com* *BS**M* - *Minority & Women Owned Business Enterprise* - 12+ years in business with referable clients - *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 The information contained in this e-mail transmission is confidential and may be privileged. It is intended only for the addressee(s) stated above. If you are not an addressee, any use, dissemination, distribution, publication, or copying of the information contained in this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately notify us in reply *with the word "REMOVE" in the subject line*. We apologize for inconvenience, if any caused. -- You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-vendor+unsubscr...@googlegroups.com. To post to this group, send email to sap-vendor@googlegroups.com. Visit this group at http://groups.google.com/group/sap-vendor. For more options, visit https://groups.google.com/groups/opt_out.
