Who Can Apply
- Candidates must be legally authorized to work in Canada
Job Description
Insight Global is looking to hire an experienced Oracle E-Business Suite (EBS) Technical Developer for a data extraction and conversion project supporting a migration from Oracle EBS to Oracle Fusion. This consultant will play a key role in developing extract scripts, writing complex SQL queries, and supporting data transformation activities to ensure accurate and complete data migration.
The ideal candidate has strong hands-on experience with Oracle EBS backend development, data extraction, and conversion activities. Experience supporting HCM/HR data conversions (including Absence Management) is highly preferred. Candidates with both HCM and Finance knowledge are ideal, as Finance conversions will come in a later release. This role is remote and 6 months with extensions to come.
RESPONSIBILITIES
- Develop and write extract scripts to support data conversion from Oracle E-Business Suite to Oracle Fusion.
- Write, optimize, and execute complex SQL queries against Oracle EBS databases to extract required data.
- Perform data transformations using SQL outside of EBS using tools such as Oracle SQL Developer.
- Support HCM/HR data conversions, including Absence Management and related HR data objects.
- Collaborate closely with functional teams and client resources to validate data mapping and extraction logic.
- Ensure data accuracy, integrity, and completeness throughout extraction and conversion cycles.
- Troubleshoot data issues and support reconciliation and validation activities.
- Document extraction logic, assumptions, and conversion processes as required.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
- 8+ years of experience as an Oracle EBS Technical Developer, with a strong focus on data extraction and conversion.
- Extensive experience writing SQL and PL/SQL for data extraction from Oracle EBS databases.
- Experience supporting Oracle EBS HCM conversions, including HR and Absence Management data.
- Strong understanding of Oracle EBS backend tables and data models.
- Hands-on experience supporting Oracle Fusion migration projects, specifically data conversion efforts.
- Experience working closely with functional teams (HCM and/or Finance) to understand data requirements.
- Strong communication skills and ability to work independently in a project-based environment.
Nice to Have Skills & Experience
- Experience supporting data conversion and extraction for Oracle Finance modules (e.g., GL, AP, AR)
- Bilingual in French and English
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.