EY - GDS Consulting - AI and DATA - AWS Plus Databricks - Senior

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.

AWS – Databricks - Senior : Job Description

• Expertise in Data warehousing and ETL Design and implementation
• Hands on experience with Programming language like Python/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
  
  

EY | Building a better working world

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.

Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.

Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.