EY EY-GDS Consulting-AI DATA-Informatica TDM -Senior 

India, Karnataka, Bengaluru 

609145441

Essential Duties and Responsibilities:

• Discover the PII across all the databases that are in scope for CCPA (California Consumer Privacy Act) project leveraging Informatica Data Privacy Management.
• Create ETL process using Power center to keep the database inventory current.
• Review the in scope PII attributes and create the metadata & data rules using the regular expressions.
• Schedule Database scan jobs in DPM to discover the PII.
• Perform manual analysis to curate the scan results for accuracy.
• Support ongoing data protection activities leveraging Informatica test data management tool.
• Create TDM packages for the databases to mask the PII.
• Create & update the masking rules in TDM based on the requirements.
• Automate the masking jobs using Control-M scheduling tool.
• Builds scalable and reliable ETL systems to pull large and complex data together from different systems efficiently.
• Works with Solution Architects to develop ETL/Data Integration/Data Processing Flows.
• Collaborates with other Data Engineers and Data Architects to build optimal and efficient ETL and Database code.
• Supports ETL Batch processing.
• Supports Oracle Deployments which involved deploying the scripts in databases using sqlplus or client tools.
• Provides on-call support of Data Integration Batch processes on a rotating basis and other on-call as required.
• Performs other duties and responsibilities as assigned.

Note- If the candidate doesn’t have Informatica DPM+TDM together, either of these separately will also suffice

Education/Previous Experience:

• Minimum of a Bachelor’s degree in Computer Science, MIS or related degree and three (3) to five (5) years of relevant development or engineering experience or combination of education, training and experience.

• Informatica Data Privacy Management, SQL, T-SQL, Control-M (any scheduling tool experience is fine)
• Hands Oracle database engineering skills with exposure to automation.

• Excellent verbal and written communication skills

• Informatica Test Data Management, Informatica Power Center
• Excellent verbal and written communication skills

• Scripting experience: Python and R
• Automated deployment experience
• Hands on experience in ServiceNow, Collaboration tools including automation and integration

• None required.

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.