EY - GDS Consulting - AI and DATA - AWS - Manager

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

EY-Consulting - Data and Analytics –Manager – AWS– Databricks

EY's Consulting Services is a unique, industry-focused business unit that provides a broad range of integrated services that leverage deep industry experience with strong functional and technical capabilities and product knowledge. EY’s financial services practice provides integrated Consulting services to financial institutions and other capital markets participants, including commercial banks, retail banks, investment banks, broker-dealers & asset management firms, and insurance firms from leading Fortune 500 Companies. Within EY’s Consulting Practice, Data and Analytics team solves big, complex issues and capitalize on opportunities to deliver better working outcomes that help expand and safeguard the businesses, now and in the future. This way we help create a compelling business case for embedding the right analytical practice at the heart of client’s decision-making.

Your key responsibilities

• Expertise in Data warehousing and ETL Design and implementation
• Hands on experience with Programming language like Python, PySpark / Scala
• Good understanding of Spark architecture along with internals
• Expert in working with Databricks on AWS
• Hands on experience using AWS services like Glue(Pyspark), Lambda, S3, Athena, RDS, IAM, Lake formation
• Hands on experience on implementing different loading strategies like SCD1 and SCD2, Table / partition refresh, insert update, Swap Partitions,
• Experience in consuming and writing data from and to Flat files, RDMBS systems, MPPS, JSON and XML, Service, Streams, queues, CDC etc. Awareness of scheduling and orchestration tools
• Awareness of OS Compute, Networking, internal working and architecture of DB and ETL Server and its impact on ETL
• Experience on RDBMS systems and concepts
• Expertise in writing and complex SQL queries and developing Database components including creating views, stored procedures, triggers etc.
• Create test cases and perform unit testing of ETL Jobs
• Analytical mind with a problem-solving and debugging skills.
• Excellent Communication Skills
• Awareness of Replication, Synchronization and Disaster Management techniques
• Hand on experience in Data Quality Management
• Awareness of data governance concepts and implementation

To qualify for the role, you must have

What we look for

What working at EY offers

At EY, we’re dedicated to helping our clients, from start–ups to Fortune 500 companies — and the work we do with them is as varied as they are.

You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer :

EY | Building a better working world