PLSQL Developer +ODI

Hi ,

Urgent Opening for PLSQL Developer +ODI with EY GDS at Pan India Location.

Please apply through below link :-

https://careers.ey.com/job-invite/1551080/

Core/Must Have skills.

• 3-8 years of expertise in designing and implementing data warehouses, data lakes using Oracle Tech Stack (DB: PLSQL)
• At least 4+ years of experience in Database Design and Dimension modelling using Oracle PLSQL.
• Should be experience of working PLSQL advanced concepts like ( Materialized views, Global temporary tables, Partitions, PLSQL Packages)
• Experience in SQL tuning, Tuning of PLSQL solutions, Physical optimization of databases.
• Experience in writing and tuning SQL scripts including- tables, views, indexes and Complex PLSQL objects including procedures, functions, triggers and packages in Oracle Database 11g or higher.
• Experience in developing ETL processes ETL control tables, error logging, auditing, data quality etc. Should be able to implement reusability, parameterization workflow design etc.
• Advanced working SQL Knowledge and experience working with relational and NoSQL databases as well as working familiarity with a variety of databases (Oracle, SQL Server, Neo4J)
• Strong analytical and critical thinking skills, with ability to identify and resolve issues in data pipelines and systems.
• Strong understanding of ETL methodologies and best practices.
• Collaborate with cross-functional teams to ensure successful implementation of solutions.
• Experience with OLAP, OLTP databases, and data structuring/modelling with understanding of key data points.

Good to have:

• Experience of working in Financial Crime, Financial Risk and Compliance technology transformation domains.
• Certification on any cloud tech stack.
• Experience building and optimizing data pipelines on AWS glue or Oracle cloud.
• Design and development of systems for the maintenance of the Azure/AWS Lakehouse, ETL process, business Intelligence and data ingestion pipelines for AI/ML use cases.
• Experience with data visualization (Power BI/Tableau) and SSRS.