Kforce Oracle Data Architect in Malden, Massachusetts

Kforce has a client seeking an Oracle Data Architect in Malden, MA.Essential Functions: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 to guarantee the fidelity and performance of data architecture

  • Identify and develop opportunities for data reuse, migration, or retirement of systems

  • 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

  • BI knowledge a requirement - 3-5 years in BI from ETL perspective

  • 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

  • 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

Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.Compensation Type:Hours