Oracle SQL Consultant - Remote
Remote • Posted 7 hours ago • Updated 5 hours ago

The Dignify Solutions, LLC
Dice Job Match Score™
⏳ Almost there, hang tight...
Job Details
Skills
- PL/SQL
- PL/ SQL
- PL-SQL
- PLSQL
- ODI
- DATA INTEGTATOR
- DATAINTEGTATOR
Summary
- Strong design and development experience in Oracle SQL, PL/SQL, and Oracle Data Integrator (ODI) 11g & 12c.
- Must have experience in Oracle database design and data modeling.
- Good understanding of OLTP transaction processing and how operational data is modeled and handled in relational databases.
- Good understanding of financial data, metrics, and reporting requirements.
- Strong experience in creating ODI mappings, interfaces, and ODI procedures.
- Experience handling flat files and other file-based sources/targets through ODI, including file ingestion, transformations, and error handling.
- Understanding of OLAP concepts and processes.
- Experience monitoring, analyzing, and tuning reliability and performance for databases and ETL processes.
- Ability to develop strategies to resolve issues and implement preventive measures to avoid future occurrences.
- Data warehouse lifecycle management experience from design to implementation, including dimensional data modeling.
- Experience with normalized OLTP, MDM, and dimensional modeling techniques, including Star and Snowflake schemas, slowly changing dimensions, dimensional hierarchies, and data classifications.
- Experience maintaining, scaling, supporting, and expanding data persistence platforms using data integration tools and processes to populate and enhance reporting in distributed environments.
- Working knowledge and understanding of the OBIEE Suite (OBI Server, Dashboards, and Analytics).
- Knowledge of data modeling tools such as Oracle Designer, ERwin, TOAD, and DB Artisan.
- Experience working closely with architects, team members, and management to increase delivery capacity for existing and upcoming projects, enable knowledge sharing, and provide depth in data warehousing, data integration, and BI solutions.
- Exposure to the full software development lifecycle and AGILE/Scrum practices.
- Effective verbal and written communication skills with both technical and non-technical stakeholders.
- Dice Id: 91139083
- Position Id: 26-00065
- Posted 7 hours ago
Company Info
About The Dignify Solutions, LLC
The Dignify Solutions with Global Capabilities and Local Excellence – has combined experience of 30 +years in Client Services/ Engagement/ Relationship/ Partnership, Sales/ Account Management, Service Delivery, Recruiting, Staffing and Talent Acquisition for the whole gamut of skillsets in Information Technology (Digital Transformation, Artificial Intelligence, Machine Learning and other business domains).
The Dignify is dedicated to meeting the needs of two types of customers: our Clients and our Consultants. We ensure that our clients receive Top Talent while also allowing our consultants to accomplish their Professional Goals.
The Dignify honors & prioritizes the Philosophy of Client Centricity and Delivery Excellence. The Dignify has dedicated Sales and Delivery Teams with each client, to make sure our standards and yours are being met. From Banking and Financial Services, Manufacturing and Retail, Energy and Utilities, Communication and Media, Technology and Telecom Services and beyond, our goal is to maintain a High Quality, Customer-Focused Engagement Model.
We are driven by three core principles in changing Staff Augmentation for the better: Cost, Quality, and Responsiveness. Whatever your need – be it a single resource or a whole team, we will find you the right talent in a timely and cost-effective manner.
The Dignify offers the Best Skilled Potential Talent, Services and Solutions to help our clients, accomplish their goals. As Market Intelligence Leaders, we provide insight into industry factors that will give you the competitive advantage you need to stay a step ahead of others in your space.

Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs