What are the responsibilities and job description for the oracle data engineer position at TPA technologies?
W2 Only
No C2C
Locals only
We're hiring a Senior ETL / Oracle Data Engineer
Woburn, MA (Hybrid: Tue–Thu in office)
6 months contract
We're looking for a seasoned Oracle data professional with deep expertise in ODI and OAS to join a high-impact enterprise data team on a contract basis.
• Design and optimize ETL/ELT processes using Oracle Data Integrator (ODI) against large-scale on-prem Oracle data warehouses
• Perform data mapping from transactional source systems to warehouse targets with complex transformations
• Develop and maintain logical and physical data models using enterprise standards
• Build analytics and reporting solutions using Oracle Analytics Server (OAS) and Power BI
• Conduct data integrity checks, validations, and performance tuning of data structures
• Collaborate in agile environments and provide stakeholder training on analytics tools
Requirements
• 8 years of hands-on experience in Oracle DB environments
• Strong ODI (Oracle Data Integrator) experience: mappings, interfaces, and high-volume batch loads
• Oracle Analytics Server (OAS) proficiency for dashboard and reporting delivery •
Solid SQL skills; experience with both transactional and data warehouse systems
• Familiarity with data modeling, data warehousing principles, and source control
• Power BI experience is a plus
• Azure Data Factory / Synapse experience is advantageous but not the focus