Overview
Skills
Job Details
Role: Sr. Oracle C2M Data Architect - SQL
Duration: 6+ Months (Contract) W2
Location: Richmond VA. (Candidates should be available to be onsite at least once a month.)
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:
To learn more about Mavensoft visit us online at