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
Questions on Data Profiling
Available in
days
days
after you enroll
-
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?
Reference Tables
Available in
days
days
after you enroll
-
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?
IDQ Developer and Informatica Analyst General Questions
Available in
days
days
after you enroll
-
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?
Frequently Asked Questions
Is this an online video based course?
No. This is a guide with questions and answers. All answers are illustrated with applicable screenshots and real time data examples.
When does the guide start and finish?
The course starts now and never ends! It is a completely self-paced online guide - you decide when you start and when you finish.
What if I am unhappy with the purchase?
We'd hate to see you go, but if you are unsatisfied for any reason, just contact us and we'll cancel your enrollment.
Will it be an interactive session?
Yes, you will be able to send a note to the trainer/instructor and communicate as well. If you are taking this guide, there are options to see the questions asked by you and also by other participants who have attended the interviews. This will not only help you to get the questions clarified but also you will know the different perspectives of the subject based on the questions asked in different real time interviews.
Will I get any material apart from the questions and answers?
We will support you with your questions, doubts and help you with all the presentations, documents and best practices with any existing code base to learn the content with more clarity.
Will you be helping me in my project once i get into a job?
We offer, various support plans based on the need. Please write to us at [email protected] or [email protected] for further information on this.
Please note, taking the course will not make us liable to support you for any job or job related activities.
What about trial classes for online/video based sessions?
Check our free course ‘Mini Course - Master Data Warehouse Concepts from Scratch and become an Expert’ from the home page. You can also view free session enabled for each course separately.
Do you teach on some/any real time scenarios / live projects?
Yes, all the content and examples taken during the explanations are from real time project implementations. Everything will be practical and on sample/simulated real time project implementation.
What is the payment procedure/mode?
Click on the Enroll now button and proceed with the steps mentioned.
What are the different topics which are covered in the interview guide?
All aspects of the tool are covered in the list of questions and answers.Please look at the course content for more information.
What is the refund policy?
If you do not like the guide or the content, full amount will be refunded (with in 30 days) provided you report within 2 days of getting the access and making the payment.
Will this help me in clear interview?
We encourage you to learn all the topics and prepare for success. All the questions and answers provided here have helped multiple other participants to clear the interviews with out any help. We do help you with any clarifications required.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this content for as long as you like - across any and all devices you own.