Employer Active
Job Alert
You will be updated with latest job alerts via emailJob Alert
You will be updated with latest job alerts via emailRole:Sr. Oracle C2M Data Architect - SQL
Duration: 5-6 Months(W2) (Extension Possible)
Location:Richmond VA. (Candidates should be available to be onsite at least once a month.)
Key Skills:Oracle Utilities Application Framework (OUAF) C2M/CCS MDM Oracle PL/SQL Power BI
The ideal candidatemust have a deep understanding of the Oracle Customer Cloud Solution (C2M/CCS) database table modeland possess advanced / expert level SQL query writing skills.
Responsibilities:
Develop optimize and maintain complex SQL queries to identify and extract required data.
Collaborate with project team members to understand complex data requirements and translate them into efficient database queries to retrieve the required data.
Document & organize authored queries for future reference.
Design implement and maintain efficient database queries to support Testing Reporting Conversion teams and other project needs as required
i. Project objectives:
Ensure schedule scope and budget are maintained.
Ensure end-user readiness
Performance standards:
Expert knowledge of the CCS Power BI MDM tables and OUAF data model
Expert level knowledge of Oracle SQL and PL/SQL developer tools
Expert in writing and optimizing complex SQL queries against large datasets to retrieve specific data Proficiency in Data Analysis and SQL Tuning
Experience using analytical functions to extract data such as rank and row number.
Excellent problem-solving skills attention to detail and work well under pressure.
Senior IC
Full Time