EY DET-RCE-Risk Data Engineer -Senior-GDSF02 

India, Karnataka, Bengaluru 

682475832

Job Description: -The Position is a senior technical, hands-on delivery role, requiring the knowledge of data engineering, cloud infrastructure and platform engineering, platform operations and production support using ground-breaking cloud and big data technologies.In this role you will:

• Ingestion and provisioning of raw datasets, enriched tables, and/or curated, re-usable data assets to enable variety of use cases.
• Driving improvements in the reliability and frequency of data ingestion including increasing real-time coverage
• Support and enhancement of data ingestion infrastructure and pipelines.
• Designing and implementing data pipelines that will collect data from disparate sources across enterprise, and from external sources and deliver it to our data platform.
• Extract Transform and Load (ETL) workflows, using both advanced data manipulation tools and programmatically manipulation data throughout our data flows, ensuring data is available at each stage in the data flow, and in the form needed for each system, service and customer along said data flow.
• Identifying and onboarding data sources using existing schemas and where required, conduction exploratory data analysis to investigate and provide solutions.
• Evaluate modern technologies, frameworks, and tools in the data engineering space to drive innovation and improve data processing capabilities.

Core/Must Have skills.

• Minimum 5+ years of experience on with end-to-end Datawarehouse, data implementation using ETL tools like Azure Data Factory (ADF), AWS Glue, SSIS, Oracle data Integrator (ODI).
• 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 (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.
• In depth knowledge and hands-on experience with data engineering, Data Warehousing and Delta Lake on Azure or AWS 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.
• 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.

EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.