Odi Developer

Hi ,

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

Please apply through below link :-

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

Core/Must Have skills.

• 3-6 years of expertise in designing and implementing data warehouses, data lakes using Oracle Tech Stack (ETL: ODI, SSIS, DB: PLSQL and AWS Redshift)
• At least 3+ years of experience in managing data extraction, transformation and loading various sources using Oracle Data Integrator with exposure on other tools like SSIS.
• At least 3+ years of experience in Database Design and Dimension modelling using Oracle PLSQL, Microsoft SQL Server.
• 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.
• Expertise in data Modelling and DB Design with skills in performance tuning.
• Experience with OLAP, OLTP databases, and data structuring/modelling with understanding of key data points.
• Experience building and optimizing data pipelines on Azure Databricks or AWS glue or Oracle cloud.
• Create and Support ETL Pipelines and tables schemas to facilitate the accommodation of new and existing data sources for the Lakehouse.
• Experience with data visualization (Power BI/Tableau) and SSRS.

Good to have:

• Experience of working in Financial Crime, Financial Risk and Compliance technology transformation domains.
• Certification on any cloud tech stack preferred Microsoft Azure.
• In depth knowledge and hands-on experience with data engineering, Data Warehousing and Delta Lake on-prem (Oracle RDBMS, Microsoft SQL Server) and cloud( Azure or AWS or Oracle cloud. )
• Ability to script (Bash, Azure CLI), Code (Python, C#), query (SQL, PLSQL, T-SQL) coupled with software versioning control systems (e, g GitHub) AND ci/cd systems.
• 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.