Oracle HCM Cloud Developer - Hybrid (Winchester, VA)

Oracle HCM Cloud DeveloperLooking for an experienced Oracle HCM Cloud Developer to support HR data integration and modernization projects. Candidate should have strong experience in Oracle HCM Cloud, SQL Server, Oracle SQL, Azure, BI Publisher, BICC, and reporting/analytics.Responsibilities include developing complex SQL queries, integrating Oracle HCM data, building reports, data validation, migration from legacy HR systems (PeopleSoft), documentation, and resolving data issues.Location: Hybrid – Winchester, VAExperience: 5–10 YearsWe are seeking an experienced Oracle HCM Cloud Developer (HR Data Integration Oracle HCM to Azure) - contractor to support advanced data development and modernization efforts within our HR analytics environment.This role will focus on developing complex queries and database objects across SQL Server and Oracle platforms, with a strong emphasis on sourcing, transforming, and validating Oracle HCM data to support enterprise reporting, analytics, and historical data needs.Job Title: Oracle HCM Cloud Developer (HR Data Integration Oracle HCM to Azure)Job ID: ***Visa Eligibility: Please confirm if the candidate is legally authorized to work in the United StatesLocation: Hybrid, Winchester, VARate / Salary: ***Requirement Release Date: 04/17/2026Experience Level: 5 - 10 YearsBasic DescriptionThe Technical Contractor – HR Data IntegrationWe are seeking an experienced contractor to support advanced data development and modernization efforts within our HR analytics environment. This role will focus on developing complex queries and database objects across SQL Server and Oracle platforms, with a strong emphasis on sourcing, transforming, and validating Oracle HCM data to support enterprise reporting, analytics, and historical data needs.Key ResponsibilitiesDevelop and maintain complex SQL and database objects across SQL Server and Oracle environments.Support HR data replication and modernization, translating legacy SQL Server logic to Oracle HCM–sourced data.Design and implement data structures, transformations, and database objects for analytics, reporting, and downstream consumption.Leverage Oracle Analytics tools (e.g., BI Publisher) to source, validate, and interpret Oracle HCM data and reporting logic.Analyze Oracle HCM frontend functionality and backend data structures to ensure accurate data usage.Partner with technical, analytics, and business stakeholders to define and validate requirements, metrics, and data logic.Create and maintain technical requirements and data documentation, including data definitions, business rules, source-to-target mappings, data lineage, and governance artifacts.Contribute to data quality checks, reconciliations, and cross-system issue resolution.Other duties as assigned.Required QualificationsAdvanced SQL experience, including complex joins, analytical/window functions, and performance optimization.Hands-on experience working with both:SQL ServerOracle SQLStrong experience with Oracle HCM Cloud, including both frontend configuration concepts and backend data structures.Experience using Oracle Analytics tools such as BI Publisher (BIP) and BICC for reporting, data extraction, or validation.Experience working with or modernizing data from legacy HR systems such as PeopleSoft.Solid understanding of enterprise data warehousing concepts, including fact tables and historical data design.Proven ability to produce clear, well-structured technical documentation supporting data governance initiatives.Required Soft SkillsAbility to work independently as a contractor and deliver on clearly defined outcomesStrong analytical and problem-solving skills, particularly when troubleshooting data or report logicClear communication skills to collaborate with technical and non-technical stakeholdersAdaptability in environments with evolving requirements and frequent system changesAttention to detail and commitment to data accuracy and qualityEmail: vijay.davuluri@smksoftinc.com