SysMind Tech
ETL Developer with OCDI Experience
SysMind Tech, Dallas, Texas, United States, 75215
Role:
ETL Developer with OCDI Experience
Location: Remote (
DALLAS, TX)
Long Term Contract - W2 & C2C
Job Description:
Skills & Qualifications: • Overall IT experience: 9-15+ Years. • Bachelor's degree in engineering, or a related scientific or technical discipline with at least 4-6 years of relevant experience. • Experience with Informatica Cloud, Oracle Cloud Fusion R13 22C CSM and Oracle Cloud Data Integration (OCDI). • Experience extracting and summarizing data from Oracle Cloud Fusion. • Experience in using Oracle PLSQL or SQL Plus Dimensional modelling experience. • Experience interfacing with business users and consultants and understanding their requirements. • Ability to learn and implement new and different techniques Outstanding written and verbal communication skills.
Role & Responsibilities: • Supporting data warehousing, data modelling, data integration, business intelligence and Oracle fusion processes. • Use Oracle Cloud Data Integration (OCDI) to create/update mapping using different transformations required to move data into data warehouse. • Develops ETL's using Informatica/OCDI to facilitate Extraction Transformation and data load from Oracle Cloud Fusion R13 22C CSM • Provide expertise of different modules within Oracle Fusion including BICC public view objects (PVO) associated with Oracle BI Applications. • Determine data orchestration and storage needs - evaluate the exact storage needs for the current data situation and analyze different orchestration of data loading options into the EDW Design and create a data warehouse • Designs a data warehousing system that meets needs and work with a development team to build the warehouse. • Conceptual, logical and physical data models to include data conversion, data conversion and data mining. Test and troubleshoot. • Test designs of new integration to ensure smooth operations and fix any issues that aris e. • Design schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. • Built Business Model and established relationships & Foreign Keys (Physical & Logical) between tables Identify and capture lessons learned, best practices, and information gained during performance of tasks.
Thanks & Regards,
Shikhar Kumar
Technical Recruiter | SysMind LLC
Email: shikharK@sysmind.com
Desk: 609-897-9670 x 4014
Direct (TextNow): 856-900-1794
ETL Developer with OCDI Experience
Location: Remote (
DALLAS, TX)
Long Term Contract - W2 & C2C
Job Description:
Skills & Qualifications: • Overall IT experience: 9-15+ Years. • Bachelor's degree in engineering, or a related scientific or technical discipline with at least 4-6 years of relevant experience. • Experience with Informatica Cloud, Oracle Cloud Fusion R13 22C CSM and Oracle Cloud Data Integration (OCDI). • Experience extracting and summarizing data from Oracle Cloud Fusion. • Experience in using Oracle PLSQL or SQL Plus Dimensional modelling experience. • Experience interfacing with business users and consultants and understanding their requirements. • Ability to learn and implement new and different techniques Outstanding written and verbal communication skills.
Role & Responsibilities: • Supporting data warehousing, data modelling, data integration, business intelligence and Oracle fusion processes. • Use Oracle Cloud Data Integration (OCDI) to create/update mapping using different transformations required to move data into data warehouse. • Develops ETL's using Informatica/OCDI to facilitate Extraction Transformation and data load from Oracle Cloud Fusion R13 22C CSM • Provide expertise of different modules within Oracle Fusion including BICC public view objects (PVO) associated with Oracle BI Applications. • Determine data orchestration and storage needs - evaluate the exact storage needs for the current data situation and analyze different orchestration of data loading options into the EDW Design and create a data warehouse • Designs a data warehousing system that meets needs and work with a development team to build the warehouse. • Conceptual, logical and physical data models to include data conversion, data conversion and data mining. Test and troubleshoot. • Test designs of new integration to ensure smooth operations and fix any issues that aris e. • Design schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. • Built Business Model and established relationships & Foreign Keys (Physical & Logical) between tables Identify and capture lessons learned, best practices, and information gained during performance of tasks.
Thanks & Regards,
Shikhar Kumar
Technical Recruiter | SysMind LLC
Email: shikharK@sysmind.com
Desk: 609-897-9670 x 4014
Direct (TextNow): 856-900-1794