We have put together a detailed and real time list of interview questions which will help you to answers all levels of questions which are asked in an interview. These questions and answers are helpful to both fresher’s and experienced.
This guide is a consolidated effort of 7 Data Management consultants and 4 Data Architects. Over the past 5 years, the questions in this guide were either asked to them or asked by them to other interviewees in interviews. All the questions in this guide were asked in a real interview at least once. Every question is accompanied by detailed answer with examples or illustration.
Better yet, if you need any clarifications on any questions, all you need to do is ask and you will get the answer in a clear and concise way. This is a life time option and all future versions of Informatica Data Quality tool will be added with relevant topics and interview questions and answers. Check the sample questions on the basics of Data Quality here.
Note: This is not a video based course.
Your Instructor
Data Management and Business Intelligence Consultant/Trainer with 16+ years of extensive work experience on various client engagements. Delivered many large Data Management projects (Data Integration, Data Quality, Data Governance, Metadata Management, Master Data Management, Data Security, Data Catalog etc) and trained numerous professionals on various tools and technologies. Extensively worked on all facets of Data Managment including requirement gathering, gap analysis, database design, data integration, data modeling, enterprise reporting, data analytics, data quality, data visualization, OLAP.
Has worked on broad range of business verticals and hold exceptional expertise on various ETL tools like Informatica Powercenter, SSIS, ODI and IDQ, Data Virtualization, DVO, MDM.
Course Curriculum
-
StartWhat were the Issues in traditional data profiling?
-
StartExplain Profiling in Informatica Data Quality, who and when the data should be profiled?
-
StartExplain about Live data and Staged Data?
-
StartWhat is a Profile?
-
StartWhat is Profile Definition?
-
PreviewWhat are Profile Rules in IDQ?
-
StartExplain about Column Profiling?
-
StartExplain about compare profiles?
-
StartWhat types of profile statistics are performed in IDQ?
-
StartWhat is Enterprise Discovery Profile?
-
StartWhat is Join Analysis Profiling?
-
StartWhat is Mid-Stream Profiling?
-
StartWhat is Multiple Profile?
-
StartWhat are score cards?
-
StartCan you create score cards on physical database objects (PDO)?
-
StartWhat are Scorecard Thresholds?
-
StartHow did you configure notifications in Scorecards?
-
StartShould the profile be present and also be run every time you run the scorecard?
-
StartCan you generate Trend Charts in Informatica?
-
Startwhat type of stats can be exported from profile results?
-
StartWhich factors Improve Profile performance?
-
StartWhat are Reference Tables?
-
StartHow Reference Tables can be created?
-
StartExplain about different kinds of Reference Tables?
-
StartCan you change the Metadata of the Reference table created using UnManaged Editable option?
-
StartExplain about Valid column in Reference tables which are used for Data Standardization?
-
StartCan you use Reference tables created in Informatica Developer as source or target in transformations?
-
StartCan reference tables created in Analyst be used in Informatica Developer as a source?
-
StartCan Informatica Data Quality transformation support parameterized reference tables, if yes how can you configure the parameterized reference tables in the Transformations?
-
StartWhat are the different ways for updating Reference tables?
-
StartCan you parameterized reference tables?
-
StartWhich all Data Quality transformations supports parameterized reference tables?
-
StartWhat is IDQ Developer client tool?
-
StartExplain about IDQ Architecture?
-
StartWhat are the new features of IDQ 10.x?
-
StartDifference between PowerCenter and IDQ?
-
StartWhat are Projects in Developer?
-
StartExplain about Data objects in IDQ?
-
StartHow to Import the metadata changes for Physical data objects happened after the Initial import of object in IDQ.
-
StartExplain about Logical Data Object (LDO)?
-
StartExplain the difference between Physical objects and Logical Data Object (LDO)?
-
StartWhat is a mapping?
-
StartWhat are Rules or Mapplets in IDQ?
-
StartHow IDQ takes care of the Data Quality?
-
StartHow IDQ Transformations are categorized?
-
StartDifference between Data Integration and Data Quality transformation?
-
StartWhat is Data Viewer?
-
StartHow to limit the number of rows when you execute Data Viewer?
-
StartCan you execute Data viewer or compare profile on Write objects?
-
StartCan you join multiple tables (from the same database) in IDQ or write custom queries on multiple tables in IDQ?
-
StartCan multiple pipeline mappings be created using IDQ?
-
StartCan you specify the load order in a mapping which contains multiple targets with dependencies between each table (parent and child tables)?
-
StartIs it possible to create a mapping so that, if in future any new columns are added to any of the source tables, it should be able to detect the structure changes dynamically and able to map it to the target?
-
StartWhat are the different workflow objects available in IDQ?
-
StartWhat are the different ways of getting the status of IDQ workflows?
-
StartWhat is Standardization?
-
StartWhat is CMS (Content Management Service)?
-
StartWhat are the different types of reference data managed by Content Management Service?
-
StartWhat are the difference between Rules created in Informatica Analyst tool and Informatica Developer tool?
-
StartCan Data Quality jobs be scheduled?
-
StartCan you Parameters in SQL Override and Lookups in Informatica Data Quality?
-
StartWhat are tags in Informatica Developer?
-
StartWhat are cheat sheets in Informatica Developer?
-
StartHow to see all the available connections in Informatica Data Quality Developer?
-
StartWhat are Execution Modes in IDQ transformations?
-
StartExplain about strategies in Data Quality Transformations?
-
StartCan I create two strategies in IDQ transformation and configure each strategy to execute with a different execution mode?
-
StartIn which IDQ transformations strategies are not created?
-
StartHow can you logically group the IDQ Transformations?
-
StartExplain about Character Sets in IDQ?
-
StartWhich all the data quality transformations can use Character Sets?
-
StartExplain about Probabilistic models in IDQ?
-
StartExplain about Classifier models in IDQ?
-
StartAre Probabilistic models part of Informatica Base Content set?
-
StartAre Classifier models part of Informatica Base Content set?
-
StartHow do you create Probabilistic models in IDQ?
-
StartExplain about Regular Expressions used in IDQ?
-
StartWhat is the difference between Classifier model and probabilistic model?
-
StartExplain about Named Entity Recognition(NER) model?
-
StartExplain the difference between Regular Parsing and Probabilistic Parsing?
-
StartCan you create multiple Analyst service in Informatica Administrator?
-
StartExplain about System Services?
-
StartDo you need to create strategies in all the Data Quality Transformations?
-
StartName some IDQ transformations which support parameterizing the Cache directory?
-
StartWhich IDQ transformations can generate Score?
-
StartIs versioning enable in MRS when Administrator enable versioning in Domain?
-
StartCan you export all objects created in IDQ to PowerCenter?
-
StartWhat is Data Quality for Excel?
-
StartWhat are the prerequisites to use DQ for Excel?
-
StartName some data integration service plugins can be defined in DIS?
-
StartCan you use Delete HTTP Method in IDQ?
-
StartWhat Task Recovery Strategies did you use?
-
StartWhat types of Parameters can be created in IDQ?
-
StartCan you export Analyst objects using Analyst tool from one environment and import to another environment ?
-
StartWhich all transformations uses Execution Instances?
-
StartIn which all tools did you Integrate IDQ?
-
StartCan you perform Matching as part of a data profiling process?
-
StartCan you use Rules in Informatica Developer only?
-
StartWhat are the available Assets In Informatica Analyst?
-
StartExplain about Mapping Specifications?
-
StartCan you export Mapping Specifications to PowerCenter?
-
StartWhat are Parameter Sets?
-
StartName some transformations which can support Parameters?