Data Engineer at Jubilee Insurance

Main Responsibilities

• Knowledge of online patching of EBS application patches
•  Experience working with WebLogic administration
• Working knowledge on setting up environment on RAC
• Troubleshooting and resolve issues related to oracle workflows/ integrations /ODI
• Design and build database, schemas, and database objects
• Working knowledge of version oracle database 11g/12c/19c
• Set up routine database backup procedures and disaster recovery procedures.
• Setup of disaster recovery site for production environment and monitor of the same
• Design and implement database security schemas
• Assist developers and end-users with database usage, query development, and tuning
• Perform cloning of application and database instances utilizing Oracles Rapid Clone methodology
• Good exposure on RMAN, ASM, Dataguard, Datapump Utilities.
• Develop, construct, test and maintain architectures
• Align architecture with business requirements
• Data acquisition
• Develop data set processes
• Use programming language and tools
• Identify ways to improve data reliability, efficiency and quality
• Conduct research for industry and business questions
• Use large data sets to address business issues
• Deploy sophisticated analytics programs, machine learning and statistical methods
• Prepare data for predictive and prescriptive modeling
• Find hidden patterns using data
• Use data to discover tasks that can be automated
• Deliver updates to stakeholders based on analytics
• Integrate new data feeds into a cloud-based data warehouse
• Design a high performing data schema to support a dashboard report
• Design and build a marketing database to support a client’s business needs
• Develop data automation and monitoring scripts
• Develop ETL scripts to perform data transformations
• Integrate with a legacy database system to support data analysis
• Create documentation and data dictionaries to support end-users of data systems
• Perform business analysis and requirements gathering to support a variety of data projects
• Define and implement web analytics

Key Competencies

• Exceptional mathematical skills, in order to perform computations and work with algorithms
•  Excellent written and verbal communication skills
• The ability to explain complex process to people who aren’t programming experts
• Strong analytical skills
• High attention to detail
• Innovation and creativity
• The ability to work with large, complex datasets.

Qualifications

• Bachelor ‘s degree in Computer Science, Mathematics, Information Management Technology or any other related field.
•  Oracle Certified Professional (OCP)
• Oracle EBS R12 (1ZO 238) Certified
• Database systems like SQL and NoSQL
• Data warehousing solutions
• ETL tools
• Machine learning
• Data APIs
• Python, Java, and Scala programming languages
• Understanding the basics of distributed systems
• Knowledge of algorithms and data structures

Relevant Experience

• Minimum of 5-6 years’ experience in a similar role.
•  Experience in Oracle EBS R12.X, installation, patching, backup/recovery, and cloning.
• Completed minimum 5 end to end installation on R12.
• Experience on working with EBS on cloud environment.
• Experience in recovering application & database in case of any eventuality.
• 3-5 years’ experience in technology/data roles
• Experience with relational database systems (MSSQL, Oracle, Sybase, MySQL, Postgres, SAP HANA)
• Advanced skills in data scripting and database development technologies (SQL, C#, Python, PowerShell, Ruby, Java, Batch Scripting)
•  Experience with Cloud platforms (AWS, Azure, Google Cloud)
•  Experience with Big Data Technologies (Hadoop, Spark, RedShift, Big Query, Apache) and basic understanding of NoSQL technologies (Splunk, ELK, AWS DynamoDB)