Reason for the opening:
Someone from his team is leaving next week.
He needs an immediate consultant
Manager describes the need as a Data Engineer- backend schemas and tables.
Data Modeling and integrations
Tasks:
BI publisher reports for procurement/inventory, whole PTP cycle.
OIC
Need to know backend of DB
Need to be techno-functional
Need to have ERP side, not BI side
Overall project that is going on- inventory/procurement project: Its around transfer orders, inventory management
Here are his notes below. Highlighted points are must have.
At least 3 years of experience in Oracle Cloud.
- In-depth knowledge about Oracle Cloud ERP schema and writing SQL queries, Data Modeling and Data Engineering. Expertise in creating BI Publisher & OTBI reports and using the rtf templates.
- Expertise in building integrations using Oracle middleware platforms such as Oracle Integration Cloud (OIC), Oracle SOA CS etc.
- Deep understanding of REST and SOAP APIs made available in Oracle Cloud ERP. Building ETL based integrations through these APIs.
- Understanding of the Procure 2 Pay cycle with techno-functional knowledge in ERP modules – Product Hub (PDH), Inventory (INV), Procurement (PO), Account Payables (AP), and General Ledger (GL).
- Hands-on experience writing code using Python using multiple python libraries like Pandas, NumPy, Sci-Kit Learn and boto3.
- Experience working in Agile and Sprint based project environments.
Good to Have:
- Experience building microservices using the AWS technology stack (Lambda Functions, SQS, SNS, AWS Fargate, API Gateway, Step Functions, S3)
- Understanding of DevOps methodologies and CI/CD pipelines using Terraform, Jenkins, Ansible etc.