Job Seekers, Please send resumes to resumes@hireitpeople.com

Detailed Job Description:

6+ years experience in master data management strategies and tools, Oracle Hyperion Data Relationship Management (DRM) and Hyperion Data Relationship Governance (DRG) solutions. Expertise in using DRM for managing users, properties, verifications and validations, managing system categories, node types, migrating DRM metadata, working with formulas and transaction requests. 4+ years of database development and maintenance activities (DDLs, SQL, ETL processes, scripting) for Microsoft SQL Server, Oracle, Teradata. 2+ years of experience in a data governance, data steward, and/or business process performance function. Excellent proficiency in dimensional modeling techniques (both Star Schema and Snow-Flake Schema) and managing slowly changing dimensions (SCD Type II). Strong knowledge and expertise in optimization of dimension building and data loading. Responsible for hands-on implementation and support of data governance systems, including, but not limited to, Oracle DRM/DRG. Work with business customers to understand data management requirements and develop specifications for large-sized projects. Identify data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Oversee, coordinate, and participate in organizational, operational, and procedural analyses to determine information input, work processes, and desired output for a large number of users; reviews and analyzes a variety of forms, documents, reports, data output, and record-keeping requirement. Design and code from business and functional requirements; analyzes, evaluates, tests, debugs, documents, and implements complex software apps. Use coding methods in specific programming languages to initiate or enhance program execution and functionality Perform project management of estimating, scheduling, and monitoring tasks Interface with different departments within the organization regarding new deployments Monitor program execution for expected performance Application owner of Oracle DRM (Data Relationship Manager). Manage and administer the tasks and activities associated with DRM and the underlying database tables; including designing and developing workflow tasks and models, establishing hierarchies and managing versions, integration with other reporting tools, and user access group definition and set up. Develop and implement processes and procedures to capture and track the measures and metrics needed related to the governance of data and report out any anomalies so that action can be taken to address issues as required. Provide support and guidance to the Data Steward community as it relates to the data governance systems. Proficient Oracle PL/SQL proven backend development experience is required Experience in large Data warehouse projects done ETL process using PL/SQL scripts Excellent knowledge of Oracle Database concepts.

Minimum years of experience*: 6+