Hi, Hope you are doing great, This is Syed Layeeq from New York Technology Partners. We have a requirement for *ODI Data Architect at Malden, MA*. Please review the Job description below and if you’d like to pursue this, please include a word copy of your latest resume along with a daytime phone number and rate in your response. You can also reach me at (201) 680-0200 x 7027
*Send profiles to [email protected] <[email protected]>* *Job title: ODI Data Architect* *Location: Malden, MA* *Job Description:* (This contract will be based on a 37.5 hour work week and when added up on a yearly basis, 48 weeks a year (i.e. the contractor is expected to take all state holidays, 10 sick/vacation days unpaid). Candidates must clearly be informed of this information.) *Duties and Responsibilities: * *Strategy & Planning* - Create short-term tactical solutions to achieve long-term objectives and an overall data management roadmap. - Assist with assessing and determining governance, stewardship, and frameworks for managing data across the organization. - 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. - Develop and deliver long-term strategic goals for data integration standards in conjunction with data users, department managers, clients, and other key stakeholders. *Operational Management* - Develop integration process data flows and data mapping analyses. - Address data-related problems in regards to systems integration, compatibility, and multiple-platform integration. - Develop and promote data integration methodologies and standards. - Act as an 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. Required Experience - 4-7 years Oracle ODI experience including experience with ODI 12c. - 4-7 years overall experience in Data Integration, Data Architecture, Data Modeling, and implementation. - 4-7 years of full lifecycle data warehousing experience. - In depth hands-on knowledge of ODI 11g including performance monitoring and tuning - In depth hands-on knowledge of Oracle 11g database performance monitoring and tuning - In depth hands-on experience designing, implementing and troubleshooting ETL/ELT processes - Knowledge of relational database designs and concepts including normalization and dimensional models - Knowledge of web services and XML at the level of using ODI to interface with pre-existing web services as data sources and/or targets. - Experience with Oracle RAC on RHEL 6 platform preferably an Exadata platform - Ability to coordinate and work with network team and other system administration groups to isolate resource bottlenecks (bandwidth/network, cpu, memory, disk/storage) - Experience reading and evaluating Oracle SQL and using the Oracle Explain Plan feature - Desired familiarity with IBM Cognos in terms of its use and interaction with Oracle (e.g. building cubes, creating extracts, running queries and reports submitted via Cognos) - Familiarity with student academic performance data and education data concepts - Experience in Installation, configuration and migration of ODI versions - Ability to develop ODI knowledge modules for checking, loading, and integration. - Experience in resolving ODI and database related data loading performance issues. - Implementation of 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 with Set up, configuring and administration of ODI according to requirements. - BI knowledge a requirement – 3-5 years in BI from ETL perspective. - 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. - Ability to observe steps and ascertain success of step or failure and root cause of step(s). - 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. - 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. *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. Thanks and Regards, Syed Layeeq New York Technology Partners – Rochester 332 Jefferson Rd. Rochester, NY 14623 T1: (201) 680-0200 x 7027 Fax: (201) 474-8533 [email protected] www.nytp.com Yahoo&Gtalk: Syedstaffing -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
