**About EY**:EY, a global leader operating in more than 150 countries delivers unparalleled service in **Consulting** and assists clients to transform and upskill their capabilities.We serve our clients to build a better working world, helping them to create long-term value for people and society and build trust in the capital markets. That starts with a culture that believes in giving you the training, opportunities, and creative freedom to make things better. Whenever you join, however long you stay, the exceptional EY experience lasts a lifetime. And with a commitment to hiring and developing the most passionate people, we work towards our ambition to be the best employer.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.The exceptional EY experience. It's yours to build.We look forward you to joining us in the **Data & Analytics Consultant **team:**For Managerial level**:Years of experience: 6-10 solid years of Data engineering and architecture background**Experience**:- Design the Logical Data Model based on technical specification requirement- Design ETL logic to transform raw data from source into target table as per the Logical Data Model- Design big data ingestion, loading, and unloading data into a data lake.- Automate data quality error resolution and enforce rules- Prepared test cases and test plan based on the Logical Data Model, Data Mapping and technical specification**Technical skill**:- Proficient in data management, database design, ETL design, optimization and development- Proficient in BI development and visualization (optional)**Tools**:- Packaged ETL tools, i.e. Talend, HIVE and Hadoop, MapR platform- Any database and ETL tools- Cloud architecture**For Senior level**:Years of experience: 3-5 solid years of Data engineering background**Experience**:- Translate and develop Physical data model design of transactional and master tables- Data cleansing and data profiling (basic)- Develop big data ETL jobs, loading, and unloading data into a data lake.- Implement the delivery of enhancements for an existing Data Warehouse for a new data source system- ETL Unit testing and data validation**Technical skill**:- Proficient in data management, database design, ETL design, optimization and development- Proficient in BI development and visualization (optional)**Tools**:- Packaged ETL tools, i.e. Talend, HIVE and Hadoop, MapR platform- Any database and ETL tools- Cloud architecture**The opportunity**:You will help our clients navigate the business and technology transformation vision. We'll look to you to provide our clients with a unique business and technology perspective on how technology can transform and improve their entire organization - starting with key business issues they face. This is a high-growth, high-visibility area with plenty of opportunities to enhance your skill set and build your career.**Your key responsibilities**:You'll spend most of your time working with a wide variety of clients and your colleagues to deliver the latest trends, practices, technologies, and architecture to design, build and maintain scalable and robust solutions that unify, enrich, collaborate and deliver value.**Skills and attributes for success**:- Outstanding team player- High level of motivation- Strong work ethic- Self-starting attitude- Independent and able to manage and prioritize workload- Ability to quickly and positively adapt to change- Excellent written and verbal communication, presentation, client service, and technical writing skills, coupled with excellent executive presence.- Significant experience in managing and delivering medium to large teams on complex programs and projects.- Assessing, designing, architecting, and developing solutions leveraging the latest technologies and trends to exceed the business requirements- Unifying, enriching, and delivering value to derive insights and opportunities- Leveraging in-house and partners - platforms and solutions as needed and recommending and building new platforms/solutions as required to exceed business requirements- Communicating findings, recommendations, and opportunities to improve platforms and solutions- Demonstrating a deep understanding of technology, concepts, tools, features, functions, and benefits of different approaches- Seeking out information to learn about emerging methodologies and technologies- Clarifying problems by driving to understand the true issue- Looking for opportunities for improving methods and outcomes- Collaborating, influencing, and building consensus through constructive relationships and effective listening- Solving probl
