Short Description
Capgemini is hiring a Data Analyst who has the ability to understand Entity Relationship diagrams for relational databases.Job Description
- Duties Responsibilities Responsible for all in-scope deliverables within sensitive data discovery and data profiling workstream
- End to end analysis of all the tables in a database to identify sensitive information PII using various tools techniques Prepare inventory based on data analysis
- Liaise with various application owners to understand business imperatives needs of storing and using PII information
- Analysis of upstream-downstream dependencies of applications
- Works closely with the other technology architects to ensure that data privacy is properly provisioned in their technology domains
- Understand database models designs including referential integrity application enforced integrity data dependencies between applications
- Conduct knowledge sharing sessions meetings with the client's application owners to help them understand the drivers and obtain sign off on the final inventory
- Skill Experience General information required 4 6 years of experience as a Data Analyst Systems Analyst or Developer role in a Data Management organization
- Strong knowledge data profiling data discovery and data lineage
- Ability to understand Entity Relationship diagrams for relational databases
- Experience working with big data cloud solutions relational DBMS like DB2 Oracle SQL Server Sybase DB2
- Good understanding of database validations constraints syntax and data types Knowledge in SQL query scripting and comfortable in independently working with relational databases
- Proficient in MS Excel Word
- Working knowledge of UNIX Able to communicate clearly and concisely both orally and in writing to business and technology stakeholders
Data Analyst