Job Description
At Oracle Health, we put humans at the heart of every conversation. Our mission is to create a human-centric healthcare experience powered by unified global data. As a global leader we re looking for a Data Engineer with BI to join an exciting project for replacing existing Data warehouse systems with the Oracles own data warehouse to manage storage of all the internal corporate data to provide insights that will help our teams to make critical business decisions Join us and create the future!
Roles and Responsibilities
Proficient in writing and optimising SQL queries for data extraction
Translate client requirements to technical design that junior team members can implement
Developing the code that aligns with the technical design and coding standards
Review design and code implemented by other team members. Recommend better design and efficient code
Conduct Peer design and Code Reviews for early detection of defects and code quality
Documenting ETL processes and data flow diagrams
Optimizing data extraction and transformation processes for better performance
Performing data quality checks and debugging issues
Conducting root cause analysis for data issues and implementing fixes
Collaborating with more experienced developers on larger projects, collaborate with stakeholders on the requirements
Participate in the requirements, design and implementation discussions
Participating in learning and development opportunities to enhance technical skills
Test storage system after transferring the data
Exposures to Business Intelligence platforms like OAC, Power BI or Tableau
Technical Skills Set :
You must be strong in PLSQL concepts such as tables, keys, DDL, DML commands, etc.
You need be proficient in writing, debugging complex SQL queries, Views and Stored Procedures.
Strong hands on in Python / PySpark programming
As a Data Engineer, you must be strong in data modelling, ETL / ELT concepts, programming / scripting Python language,
You must be proficient in the following ETL process automation tools
Oracle Data Integrator (ODI)
Oracle Data Flow
Oracle Database / Autonomous Data warehouse
Should possess working knowledge in any of the cloud platform like Oracle Cloud (Preferred), Microsoft Azure, AWS
You must be able to create technical design, build prototypes, build and maintain high performing data pipelines, optimise ETL pipelines
Good knowledge on Business Intelligence development tools like OAC, PowerBI
Good to have Microsoft ADF and Data Lakes, Databricks
Job Classification
Industry: IT Services & Consulting
Functional Area / Department: Engineering - Software & QA
Role Category: Software Development
Role: Software Development - Other
Employement Type: Full time
Contact Details:
Company: Oracle
Location(s): Kolkata
Keyskills:
Coding
Debugging
Healthcare
Data quality
Stored procedures
Oracle
Business intelligence
microsoft
Python
Data extraction