Contract Position : Salesforce - Data Cloud
Experience: 5.0 - 18 years
Max Experience: 18
Day-to-Day Job Duties
Design, develop, and maintain ETL/ELT processes using Oracle Data Integrator (ODI).
Develop, enhance, and optimize complex PL/SQL packages, procedures, functions, triggers, and scripts.
Build and support data-integration workflows between multiple source and target systems.
Perform data extraction, transformation, and loading activities for enterprise data warehouse environments.
Analyze business and technical requirements and translate them into reliable data solutions.
Monitor and troubleshoot data pipelines, ETL jobs, and database performance issues.
Implement performance-tuning strategies for Oracle databases and PL/SQL programs.
Ensure data quality, consistency, integrity, and security across data platforms.
Collaborate with data architects, business analysts, reporting teams, and application developers.
Create and maintain technical design documents, ETL specifications, and operational runbooks.
Support production environments, incident resolution, and root-cause analysis.
Basic Qualifications
8+ years of data engineering or related Oracle data-integration experience.
Strong hands-on experience with Oracle Data Integrator (ODI).
Advanced experience developing and optimizing PL/SQL packages, procedures, functions, triggers, and scripts.
Experience designing and supporting ETL/ELT processes and enterprise data warehouse integrations.
Strong Oracle database performance-tuning and troubleshooting skills.
Experience with data quality, data integrity, data security, and data-reconciliation practices.
Experience supporting production data pipelines and participating in incident and root-cause analysis.
Ability to translate business and technical requirements into maintainable data solutions.
Travel
N/A
Degree
Bachelor’s degree in Computer Science or equivalent work experience (template default; validate)
Nice to Have
Experience collaborating with data architects, reporting teams, and application development teams.
Experience creating ETL specifications, technical designs, and operational runbooks.
Experience supporting enterprise data warehouse environments.