OEDQ- Oracle Enterprise Data Quality: Oracle Enterprise Data Quality provides a comprehensive data quality management environment, used to understand, improve, protect and govern data quality. The software facilitates best practice Master Data Management, Data Governance, Data Integration, Business Intelligence and data migration initiatives, as well as providing integrated data quality and other applications.
Main Duties and Responsibilities
Team based working
Work closely with onshore and offshore leads to support project and BAU needs
Contribute to project plans and the overall team status reports.
Implement, adhere to and strive to continually improve the standards across the team.
Engage with the product suppliers on the product management in the company environments.
Manage the application and vendor released software updates deployments, configurations and customizations in the test and production environments as part of the Project and CR deliveries.
Seamlessly integrate the applications with the interfacing upstream and downstream applications.
Version and change control the application software components.
Build a comprehensive knowledge base to manage the application and environment configurations.
Identify and resolve problems, working closely with the onshore/offshore solutions managers and vendors.
Application Development and Support
Design, develop and deliver innovative and tactical solutions to benefit the application community.
Provide Level 3 Support on the Live incidents and problems
Work on a variety of Projects and CRs.
Work closely with other areas of the business in Proof of Concept projects, integrating other services and data seamlessly.
Production and Delivery
Drive the Application Management function forward, both with good rounded knowledge of the systems used within the business, but also with the resolution of pipeline CRs
Analyse and identify common problems and look to provide root cause analysis. Build up a comprehensive knowledge base to reduce future resolution timeline for CRs
Strong on UNIX scripting, Oracle 11i and PL/SQL.
Worked on webservices related project; real time applications
Has good understanding at least of IBM WebSphere, Apache TomCat or any other well-known webserver
Excellent knowledge of working on Windows environment
Can write SQL scripts for data analysis, deployment, automation and housekeeping
Is conversant with general SQL commands related to file/directory handling, file transfers, delimited and fixed width file manipulations, vi editor, processes, space utilization etc.
Has excellent knowledge of RDBMS concepts such as primary keys, joins, indexes, triggers, cursors etc.
Is aware of Performance tuning concepts such as explain plan, query optimization, table scans etc.
Excellent skills in importing, cleaning, transforming, validating data for functional usage
Has been exposed to at least one workflow system and understands concepts such as workflow states, functional roles, permissions etc.