EY-GDS Consulting-AI and DATA-Informatica IDQ -Senior

EY

EY

Software Engineering, Data Science
Thiruvananthapuram, Kerala, India · United States
Posted on Saturday, June 15, 2024

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) – Informatica IDQ Developer

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 candidates with strong technology and data understanding in big data engineering space, having proven delivery capability. This is a fantastic opportunity to be part of a leading firm as well as a part of a growing Data and Analytics team.

Your key responsibilities

  • Profile source data and determine all source data and metadata characteristics
  • Design and execute a Data Quality Audit/Assessment
  • Design and execute the data quality mappings that will cleanse, de-duplicate, and otherwise prepare the project data
  • Implement data quality processes including transliteration, parsing, analysis, standardization and enrichment at point of entry and batch modes; Deploy mappings that will run in a scheduled, batch, or real-time environment.
  • Document all mappings, mapplets, and rules in detail and hand over documentation to the customer
  • Collaborate with various business and technical teams to gather requirements around data quality rules and propose the optimization of these rules if applicable, then design and develop these rules with IDQ
  • Utilize “Informatica Developer” and “Informatica Analyst” to design and develop custom objects and rules, reference data tables and create/import/export mappings
  • As per business requirements perform thorough data profiling with multiple usage patterns, root cause analysis and data cleansing and develop scorecards utilizing Informatica, Excel and other data quality tools
  • Develop "matching" plans, help determine best matching algorithm, configure identity matching and analyze duplicates
  • Build complex profiles and scripts to execute and test mappings and workflows to implement data stewardship and exception processing
  • Run data quality specific ETL jobs (address standardization and validation, email cleanups, name cleanup, parsing, etc.) utilizing IDQ and other ETL tools
  • Serve as the primary resource to team members and data stewards for training, problem resolution, data profiling etc.
  • Analyze and provide data metrics to management in order to help prioritize areas for data quality improvement
  • Participate in improvement of master data management process and support transactional systems and processes
  • Good knowledge on writing shell-scripts to invoke mappings or workflows
  • Good at writing SQL queries and verifying the results
  • Should be familiar in migrating object from IDQ to PowerCenter
  • Should be familiar in deploying and validating objects to different environments
  • Good at writing Test scenario and perform Unit Test and verifying the end results with business requirements
  • Perform both record-level and large-scale manual additions, adjustments and corrections to continuously ensure overall data quality and integrity
  • Maintain excellent working relationship between internal (team and the whole organization) and external parties (vendors, customers)
  • Assist with special projects or ad-hoc reviews as needed

To qualify for the role, you must have

  • Min 3- 5 years of hands-on experience with Informatica Data Quality (IDQ) toolset (Version 10.x preferred) and proficiency in IDQ development around data profiling, cleansing, parsing, standardization, verification, matching and data quality exception monitoring and handling
  • Excellent knowledge on Informatica platform as a whole and the integration among different Informatica components and services
  • Excelled knowledge on Advanced SQL
  • Knowledge on Terdata is plus
  • Excellent data analysis and data profiling skills using Informatica and Excel
  • Good understanding of data governance principals and strong experience on data quality development and issue management and remediation
  • Experience with at least one end to end Master Data Management implementation is required
  • Good communication and presentations skills and ability to lead meetings effectively
  • Ability to multi-task with strong attention to detail and analytical skills
  • Strong work ethic with a highly positive, hands-on, can-do attitude

Ideally, you’ll also have

  • Client management skills

What we look for

  • People with technical experience and enthusiasm to learn new things in this fast-moving environment

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

About EY

As a global leader in assurance, tax, transaction and consulting 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.

Join us in building a better working world.

Apply now

EY GDS Data and Analytics (D&A) – Informatica IDQ Developer

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 candidates with strong technology and data understanding in big data engineering space, having proven delivery capability. This is a fantastic opportunity to be part of a leading firm as well as a part of a growing Data and Analytics team.

Your key responsibilities

  • Profile source data and determine all source data and metadata characteristics
  • Design and execute a Data Quality Audit/Assessment
  • Design and execute the data quality mappings that will cleanse, de-duplicate, and otherwise prepare the project data
  • Implement data quality processes including transliteration, parsing, analysis, standardization and enrichment at point of entry and batch modes; Deploy mappings that will run in a scheduled, batch, or real-time environment.
  • Document all mappings, mapplets, and rules in detail and hand over documentation to the customer
  • Collaborate with various business and technical teams to gather requirements around data quality rules and propose the optimization of these rules if applicable, then design and develop these rules with IDQ
  • Utilize “Informatica Developer” and “Informatica Analyst” to design and develop custom objects and rules, reference data tables and create/import/export mappings
  • As per business requirements perform thorough data profiling with multiple usage patterns, root cause analysis and data cleansing and develop scorecards utilizing Informatica, Excel and other data quality tools
  • Develop "matching" plans, help determine best matching algorithm, configure identity matching and analyze duplicates
  • Build complex profiles and scripts to execute and test mappings and workflows to implement data stewardship and exception processing
  • Run data quality specific ETL jobs (address standardization and validation, email cleanups, name cleanup, parsing, etc.) utilizing IDQ and other ETL tools
  • Serve as the primary resource to team members and data stewards for training, problem resolution, data profiling etc.
  • Analyze and provide data metrics to management in order to help prioritize areas for data quality improvement
  • Participate in improvement of master data management process and support transactional systems and processes
  • Good knowledge on writing shell-scripts to invoke mappings or workflows
  • Good at writing SQL queries and verifying the results
  • Should be familiar in migrating object from IDQ to PowerCenter
  • Should be familiar in deploying and validating objects to different environments
  • Good at writing Test scenario and perform Unit Test and verifying the end results with business requirements
  • Perform both record-level and large-scale manual additions, adjustments and corrections to continuously ensure overall data quality and integrity
  • Maintain excellent working relationship between internal (team and the whole organization) and external parties (vendors, customers)
  • Assist with special projects or ad-hoc reviews as needed

To qualify for the role, you must have

  • Min 3- 5 years of hands-on experience with Informatica Data Quality (IDQ) toolset (Version 10.x preferred) and proficiency in IDQ development around data profiling, cleansing, parsing, standardization, verification, matching and data quality exception monitoring and handling
  • Excellent knowledge on Informatica platform as a whole and the integration among different Informatica components and services
  • Excelled knowledge on Advanced SQL
  • Knowledge on Terdata is plus
  • Excellent data analysis and data profiling skills using Informatica and Excel
  • Good understanding of data governance principals and strong experience on data quality development and issue management and remediation
  • Experience with at least one end to end Master Data Management implementation is required
  • Good communication and presentations skills and ability to lead meetings effectively
  • Ability to multi-task with strong attention to detail and analytical skills
  • Strong work ethic with a highly positive, hands-on, can-do attitude

Ideally, you’ll also have

  • Client management skills

What we look for

  • People with technical experience and enthusiasm to learn new things in this fast-moving environment

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

About EY

As a global leader in assurance, tax, transaction and consulting 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.

Join us in building a better working world.

Apply now

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.