Add office photos
Engaged Employer
i
This company page is being actively managed by
Ernst & Young Team. If you also belong to the team, you
can get access from
here
Ernst & Young
Compare
All Filters
1967 Ernst & Young Jobs
AI and DATA - Data Quality and IICS Developer - Senior
2-6 years
Bangalore / Bengaluru
1 vacancy
AI and DATA - Data Quality and IICS Developer - Senior
Ernst & Young
posted 1mon ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
EY-Consulting - Data and Analytics - Senior - Data Quality and IICS Developer
EYs Consulting Services is a unique, industry-focused business unit that provides a broad range of integrated services that leverage deep industry experience with strong functional and technical capabilities and product knowledge. EY s financial services practice provides integrated Consulting services to financial institutions and other capital markets participants, including commercial banks, retail banks, investment banks, broker-dealers & asset management firms, and insurance firms from leading Fortune 500 Companies. Within EY s Consulting Practice, Data and Analytics team solves big, complex issues and capitalize on opportunities to deliver better working outcomes that help expand and safeguard the businesses, now and in the future. This way we help create a compelling business case for embedding the right analytical practice at the heart of client s decision-making.
The opportunity
We re looking for a candidate with 5+ years of expertise in data quality and Cloud ETL skills. Act as Senior Developer to a larger team in EY GDS DnA team to work on various Data and Analytics projects
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
- Build ETL pipelines and implement complex transformation logic on IICS for data movement between systems
- Work with BA s and look at existing ETL login written in other ETL tools and convert them to IICS jobs
- Integrate IICS with rules/mapplets defined on IDQ
To qualify for the role, you must have
- BE/BTech with Minimum 3+ 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
- Minimum 4+ years of hands-on experience with IICS in a development role.
- Excellent knowledge on Informatica platform as a whole and the integration among different Informatica components and services
- Excellent data analysis and data profiling skills using Informatica and Excel
- Bachelor s degree in Computer Science or Information Technology is a plus
- 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
What we look for
- A Team of people with commercial acumen, technical experience and enthusiasm to learn new things in this fast-moving environment
- An opportunity to be a part of market-leading, multi-disciplinary team of 1400 + professionals, in the only integrated global transaction business worldwide.
- Opportunities to work with EY Consulting practices globally with leading businesses across a range of industries
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:
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
Employment Type: Full Time, Permanent
Read full job descriptionErnst & Young Interview Questions & Tips
Prepare for Ernst & Young Developer roles with real interview advice
People are getting interviews at Ernst & Young through
People are getting interviews through
(based on 760 Ernst & Young interviews)
Job Portal
Referral
Campus Placement
Company Website
Recruitment Consultant
Walkin
29%
21%
14%
8%
6%
4%
18% candidates got the interview through other sources.
High
Confidence
?
High Confidence means the data is based on a large number of responses received from the candidates.
What people at Ernst & Young are saying
Rating based on 2 Developer
reviews
Anonymous · It Software
in Banglore
Likes
Good Environment to work and caring managers like Balaji vengalpathy make us feel free to communicate and express our views towards growth.
Dislikes
Everything I good
Read 2 reviewsDeveloper salary at Ernst & Young
reported by
30
employees
with 1-5
years exp.
₹4
L/yr - ₹15
L/yr
20%
more
than the average Developer Salary in India
View more details
What Ernst & Young employees are saying about work life
based on 10k employees
Flexible timing
Monday to Friday
No travel
Day Shift
Ernst & Young Benefits
View more benefits
Compare Ernst & Young with
Deloitte
Compare
PwC
Compare
EY Global Delivery Services ( EY GDS)
Compare
Accenture
Compare
Cognizant
Compare
TCS
Compare
Amazon
Compare
Wipro
Compare
Capgemini
Compare
IBM
Compare
Compare
Microsoft Corporation
Compare
Infosys
Compare
KPMG India
Compare
Bain & Company
Compare
McKinsey & Company
Compare
BCG
Compare
ZS
Compare
Mercer
Compare
Willis Towers Watson
Compare
Similar Jobs for you
Ernst & Young Bangalore / Bengaluru Office Locations
Bangalore Office
Ernst & Young, 3rd Floor, Tower C, RMZ Infinity Municipal No. 3, Survey No 1477/2 & 10, Old Madras Road, Benniganahalli, K.R. Puram
Bangalore
Karnataka 560016
Karnataka 560016
Bengaluru Office
Ernst & Young
Tower C, 3rd Floor, RMZ Infinity
Municipal No. 3, Old Madras Road
Survey No 1477/2 & 10
Benniganahalli, K.R. Puram
560016 Bengaluru
Ernst & Young
UB City, Canberra Block
12th & 13th Floor
No. 24, Vittal Mallya Road
Bengaluru
Bengaluru
560001
560001
AI and DATA - Data Quality and IICS Developer - Senior
2-6 Yrs
Bangalore / Bengaluru
SAC Planning Functional Consultant
3-7 Yrs
₹ 8 - 18L/yr
Kolkata, Hyderabad / Secunderabad, Bangalore / Bengaluru
Share an Interview