Job Description

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 GDS - Data and Analytics (D&A) -Talend- senior


As part of our EY-GDS D&A (Data and Analytics) team, we help our clients solve complex business challenges with the help of data and technology. We dive deep into data to extract the greatest value and discover opportunities in key business and functions like Banking, Insurance, Manufacturing, Healthcare, Retail, Manufacturing and Auto, Supply Chain, and Finance

The opportunity


We're looking for Senior with strong technology and data understanding having proven delivery capability and client experience. This is a fantastic opportunity to be part of a leading firm as well as a part of a growing Data and Analytics team.

: .

• Primary Skills:
+ ETL Talend
+ Java (for custom code routine)
• Secondary Skills
+ Snowflake
• 8+ year's experience ETL developer or Lead, expertise in Talend, SQL and experience in writing custom JAVA code routine in Talend.
• Understanding of data warehousing principles, including dimensional modelling, star and snowflake schemas, and ETL best practices.
• Familiarity with various databases like MySQL, Oracle, SQL Server, and the ability to write complex SQL queries.
• Ability to perform data mapping, transformation, and cleansing tasks.
• Experience using Talend Open Studio (7.x) and (8.0) experience with Talend Management Console (TMC) or Talend Administration console(TAC).
• Understanding of Source and Target Systems: Knowledge of the systems involved in the migration, including the legacy system and the new target system.
• Experience in complex data management or Application integration solution and deployment in areas of data migration, data integration, application integration or data quality.
• Experience in creating complex Talend jobs, (Joblets, routines, data processing, orchestration, parallelization, transformations and ETL Fundamentals.
• XML and Web Services: Understanding of XML structures, XSD, and experience with SOAP and RESTful web services
• Experience with version control systems like Git or SVN to manage changes in the project
• Skills in testing methodologies to validate the migrated data against source data for accuracy.
• Ability to manage changes effectively and adapt to new requirements during the migration process.
• Strong analytical and problem-solving skills to troubleshoot and resolve issues that arise during the migration.
• Basic project management skills to plan, execute, and monitor the migration project.
• Excellent communication skills for collaborating with team members, stakeholders, and to document the migration process,

Responsibilities:

• Work with business analysts and stakeholders to understand the data migration requirements, including source and target systems, data formats, volume, and quality
• Work closely with other team members, including database administrators, data analysts, and project managers, to ensure a coordinated approach to the migration project.
• Analyse the structure, dependencies, and quality of the data in the source system to identify any potential issues that may arise during migration.
• Design the ETL architecture and plan the migration strategy, including the mapping of data between source and target systems, transformation rules, and the overall project timeline.
• Develop Talend jobs and components to extract data from the source system, transform it according to business rules, and load it into the target system
• Map source data fields to their corresponding target data fields, ensuring that the data transformation meets the business requirements.
• Optimize Talend jobs for performance by tuning job configurations, managing memory usage, and optimizing database queries.
• Implement robust error handling and logging mechanisms within Talend jobs to capture and resolve any issues during the migration process.
• Work independently to create and maintain optimal data pipeline architecture.
• Automating the workflow monitoring process.
• Create detailed documentation for the developed ETL processes, data mappings, and any custom components or configurations.
• Identify, design and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

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:

• Support, coaching and feedback from some of the most engaging colleagues around
• Opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that's right for you

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.