Need || Sr. Incorta Architect || 12+ Months || Chicago, IL (Day 1 onsite). at Chicago, Illinois, USA |
Email: [email protected] |
* REMOVE in subject line. * HI, HOPE YOU ARE DOING GREAT TODAY. LET ME KNOW IF YOU ARE INTERESTED IN BELOW REQUIREMENT. PLEASE SEND THE SUITABLE RESUME ALONG WITH CONTACT DETAILS, CURRENT LOCATION ASAP ON [email protected] Job Title : Sr. Incorta Architect Location : Chicago, IL (Day 1 onsite) Duration : 12+ months Roles & Responsibilities: Job Requirement Should have 8+ years of experience in Incorta design and development . Initially to analyze, design and develop Incorta Schema/Table model from existing legacy HR SQL Server database. Convert the above Incorta model to get the consume the data from Oracle Cloud Fusion HR, instead of legacy HR SQL Server database. Complex ETL should be written in PySpark to create Incorta MVs (Spark SQL and/or python) Most of the Fusion Cloud model are SCDs with history maintained through Date Effective/Expires, which requires cleanup in staging, break the dates for duplicates and zip them to have the continuous Date Effective/Expires, without overlap dates. Should be capable of writing complex Analytics SQL using LEAD, LAG, FIRST_VALUE, RANK etc. Also write SQLs using WITH statement to generate the required MVs, instead of breaking into many redundant tables. Should be able to generate Incorta dashboards using the latest Result set in Incorta 5.2.1 version feature to generate Flexible/Dashboard Filterable Management Dashboards. Should be capable of designing security model to restrict the Incorta Data Rows and encrypt the Columns based on Business Users Levels and Functions. At the same time the developers should not be restricted. Develop new models based on continuous Business enhancements and requirement changes. Should have very good communication skills . Thanks & Regards Bhavanesh Eamani PH : 9724400073 Agile Enterprise Solutions Inc. 7460 Warren Pkwy,Suite 100, Frisco, TX 75034. Email: [email protected] Website: www.aesincus.com Thanks & Regards Bhavanesh Eamani PH : 9724400073 Agile Enterprise Solutions Inc. 7460 Warren Pkwy,Suite 100, Frisco, TX 75034. Email: [email protected] Website: www.aesinc.us.com * REMOVE in subject line. * Keywords: Illinois Texas |
[email protected] View all |
Mon Aug 28 21:36:00 UTC 2023 |