Sr. Oracle C2M Data Architect - SQL

Role: 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 candidate must have a deep understanding of the Oracle Customer Cloud Solution (C2M/CCS) database table model and 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.

 
Email your resume to: usjobs@mavensoft.com 
To learn more about Mavensoft visit us online at http://www.mavensoft.com/