This position will be a part of the State of Maine Employee Relations (SOMER) data project team. The project has identified the need to address data quality remediation practices in legacy systems, and ensure proper population of an enterprise HCM system. This work will primarily be accomplished via Oracle's Enterprise Data Quality Tool. In house expertise with this tool is limited. The SOMER project has a go live date of September 2018, and this resource is considered essential to the success of the project.
It is desirable for this service to be delivered as soon as possible. Allowing for postings, interviews etc., a start date as close as possible to 2/5/2018 is desired. These dates are based upon reviews of the SOMER project plan and current work backlog.
? Implementing Oracle enterprise data quality tools for standardizing, cleansing, and enriching the master data management entities including a variety of data types
? Leading solution design, functional design, and technical design for Oracle enterprise data quality implementation
? Configuring and customizing Oracle enterprise data quality tools
? Performing business requirement gathering and performing programming in Java, Oracle programming in Structured Query Language (SQL) and Procedural Language/Structure Query Language (PL/SQL)
? Documenting test plans, performing unit testing, integration testing, and system testing
? Designing and developing shell scripts for automation of file transfers and processing enterprise data quality processes
? Programming bug fixes and data conversions, data integrations, and migrations.
? Must have the following experience in Oracle Enterprise Data Quality (OEDQ):
? Processors including Profilers, Audit, Transformation, Matching, Maths, Text Analysis, Advanced,
? Read/Write (including Merge), Custom Processors
? Also experience with OEDQ Reference data, OEDQ Expression Language, Exports, Data Interfaces, External Tasks, Messaging, Reference data, Staging Data, Jobs, Server Console, Match Review, Case Management, Web Services, Packaging, Published Processors
? Must have the following experience with Unix: Shell Scripting and Navigation
? Must have experience mapping Data Files from various streams including but not limited to Server files (Flat file/XML/xls), Oracle DB, Microsoft SQL Server, etc.
? Must have knowledge of and experience using Ftp concepts and best practices
? Must have knowledge of and experience using DBMS / RDBMS concepts and best practices
? Must have experience with Java, Java Script, PL/SQL and SQL
? Must exhibit analytical Thinking and problem Solving
? UNIX/LINUX ? Expert
? Java ? Expert
? Java/UNIX Scripting? Expert
? PL/SQL ? Expert
? Oracle OEDQ Profiling, Audit and Dashboards ? Expert
? Oracle OEDQ Parsing and Standardization - Expert
? Oracle OEDQ Match and Merge ? Expert