Short Description
Capgemini is hiring a Data Analyst who has the ability to understand Entity Relationship diagrams for relational databases.Job Description
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
Mid-Senior-level
Technology
|
Information
|
Information Technology
Full-time
Engineering
|
Other
|
Information Technology
|
Analyst
Data Analyst
With more than 190,000 people, Capgemini is present in over 40 countries and celebrates its 50th Anniversary year in 2017. A global leader in consulting, technology and outsourcing services, the Group reported 2016 global revenues of EUR 12.5 billion.
Together with its clients, Capgemini creates and delivers business, technology and digital solutions that fit their needs, enabling them to achieve innovation and competitiveness. A deeply multicultural organization, Capgemini has developed its own way of working, the Collaborative Business ExperienceTM, and draws on Rightshore®, its worldwide delivery model.