Oracle ADWFAW data integrations

Work set-up: 
Full Remote
Contract: 
Experience: 
Senior (5-10 years)
Work from: 

Offer summary

Qualifications:

Minimum 8 years of IT experience with at least 6 years in Oracle Cloud analytics platforms., Proficiency in ODI/OBIA and implementing complex data pipelines., Experience with Oracle ADW, FAW, OAC, and data integration standards., Strong SQL, web services, and cloud data pipeline skills..

Key responsibilities:

  • Design and develop data integration solutions on Oracle Cloud platforms.
  • Translate business requirements into technical data pipelines and integrations.
  • Define and enforce data integration standards and best practices.
  • Collaborate with stakeholders and engineering teams to ensure scalable solutions.

APN Consulting Inc. logo
APN Consulting Inc. SME http://www.apnconsultinginc.com
201 - 500 Employees
See all jobs

Job description


Job Title: Oracle ADWFAW data integration Software Engineer
Location: Remote India
Work hours: 2 PM 11 PM IST
Duration: FTE

Job Description:
Senior Software Engineer specializing in Oracle ADWFAW data integrations, in the Corporate Applications team. This role provides an opportunity to serve as a senior member of the engineering team, designing and developing solutions on the Oracle Analytics Cloud. In this role you will work with stakeholders to translate business requirements into actionable operational insights. Will be responsible for developing solutions for fit and scalability, while ensuring that they conform to longterm strategic priorities. You will build partnerships with other engineering leaders, team members, and vendors to scale our global engineering capabilities.
Role and Responsibilities
  • Help guide data architecture decisions in concert with other team members to design and develop solutions based on Oracles Cloudbased data and analytics platforms including Fusion Analytics Warehouse (FAW), Autonomous Data Warehouse (ADW), Oracle Analytics Cloud (OAC) and Oracle Data Integrator (ODI).
  • Translate requirements into technical design and implement integrations pipelines between FAWADW and other Oracle and nonOracle business applications.
  • Define integration standards and enforce best practices
  • Perform all other jobrelated duties as requested
    • Skill RequirementsPreferences
      • Proficiency in ODIOBIA
      • Proficiency in implementing complex mission critical data pipelines and ELTbased data integration
      • Proficiency in FAW (ERP and SCM), ADW, OAC (Classic, Data Visualization, Semantic Model Development) and ODI
      • Knowledge of Oracle Cloud Financial System modules General Ledger, Accounts Payable and Asset Management
      • Technical knowledge of the table structures in Oracle EBS, Oracle Cloud ERP andor Oracle Cloud SCCM (for data extraction purposes)
      • Oracle Cloud Infrastructure Object Storage
      • Data warehouse design and data modeling for data warehouses (e.g., star schema)
      • Data lake design patterns and technologies – objectstorage based and otherwise
      • Security design including SSO and rowdata level security
      • Prior Oracle data warehouse experience, ideally with integration tofrom Oracle Applicationsthird party applications.
      • Excellent SQL query and debugging skills
      • Handson experience with Rest Web Services, web applications, JSM, transactional databases, and NoSQL databases
      • Working knowledge of software development tools and methodologies
      • Manage expectations with ease of handling conflict resolution, mindful of time management and team dynamics.
        • Education & Experience Requirements
          • 8+ plus years of IT experience.
          • 6+ years experience in a handson technical development role related to Oracles Cloudbased analytics platforms including OAC, ADW, ODI andor FAW. Please note that similar experience with Oracles onpremises solutions such as OBIEE or BI Apps will also be considered
          • Certifications in OAC andor ADW preferred
          • Must have experience integrating Oracle ERP and SCM data with CRM (Salesforce) andor HCM data (Workday)
          • Experience with common web connectivity and integration standardsprotocols like XML, SOAP, REST, JSON and JDBC
          • Experience with Alteryx, Spark or other commercial ETL tools and cloud data pipelines
          • Good communications skills, comfortable working with middle and senior management
          • 5+ years of experience in an Agile development environment. Experience with SAFe is a plus.

Required profile

Experience

Level of experience: Senior (5-10 years)
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Team Management
  • Time Management
  • Communication

Related jobs