Senior Consultant - Tech Consulting - FS - TC - ETL Developer - Mumbai

Req id - 1581869

The opportunity

Job Description

The candidate will be working in a team providing ETL design & development (SQL & Internal ETL Framework, and/or Java (Scala) on Spark Framework with Morphir Rule Engine) as well as very intensive business & data analysis out of our Finance Data Warehouse (FDW) built in Teradata. In working closely with the local/global project manager, colleagues, and internal clients within Finance, the candidate will be involved in all stages of the development life cycle from requirements gathering to post-release and ongoing Lv3 support as escalation point.

Responsibilities:

• Perform business/data analysis to investigate into various business problems and propose the solution working closely with clients and team
• Design, implement, test and maintain ETL components for multiple applications – technology choice could vary depending on the types of components and team’s strategy
• Performance and scalability optimization to support large scale deployments
• Define new features in conjunction with product management, and provide specifications
• Ensure quality and completeness of the final product through unit testing, documentation and maintenance as appropriate.

Technical Skills

• Database: 2-4 years of experience in Database development (SQL/Data Modelling/Stored Procedures/Index/Performance Tuning e.g. Query Plan analysis). Teradata experience preferred.
• ETL Programming: 2-4 years of experience (Informatica - good to have)
• UNIX experience: Basic understanding of UNIX and shell commands is required, scripting (e.g. Python/Shell/Perl) experience preferred
• Job scheduler tools: Auto Sys experience preferred
• Experience with Java/Scala/Python and Spark Framework preferred
• Snowflake/Databricks exposure preferred
• Exposure to BFSI and finance industry preferred
• Power BI experience is preferred
• Angular UI Development: Experience building very reliable, working with large volumes of data and UI support for data slicing

Non-Technical Skills

• High interest in Finance business & data analysis required. Interest in Accounting preferred
• Eager to learn business in Finance such as financial products, regulatory requirement, and accounting, working closely with internal clients
• Ownership/Accountability and desire to take on an expanded role over time.
• Ability to multi-task and work against deadlines/priorities
• Eager to work with new technologies and apply them towards enterprise-level data solutions
• Capable of working with a global team and thriving in a team development environment
• Advanced problem-solving skills and the ability to deal with real world business issues

What working at EY offers

EY is committed to being an inclusive employer and we are happy to consider flexible working arrangements. We strive to achieve the right balance for our people, enabling us to deliver excellent client service whilst allowing you to build your career without sacrificing your personal priorities. While our client-facing professionals can be required to travel regularly, and at times be based at client sites, our flexible working arrangements can help you to achieve a lifestyle balance.

About EY

As a global leader in assurance, tax, transaction and advisory services, we’re using the finance products, expertise and systems we’ve developed to build a better working world. 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’ll make our ambition to be the best employer by 2020 a reality.

If you can confidently demonstrate that you meet the criteria above, please contact us as soon as possible