Are you married and having Kids? I dont see Married and women with Kids come on time and if you do, i will shout at you on the face. there is no WFH options and there is company cab, since you travel more than 25 kms within Bangalore, dont expect me to approve CAB.
Given some test fields and asking for the kinds of validation required to bring quality
Mostly related to your resume and experience and why you want to join the company.
Why do you want to work there? Describe previous work experience?
When can I start working?
It was typical interview process. Had good mix of coding, algo, design, project based, distributed systems, performance, conflict handling, cross team dependence etc.
About the Role, scenario based, technical questions
Basic Technical question. Oops,.net core, React, Agile, Design Pattern
Size of Team you managed. Were you responsible for their Appraisal What if someone is not performing well
The below are the hackerrank test questions 1.If a flat file has 100 million records and need to load the distinct records by eliminating the duplicates to the target table. 2.if a Workflow 1 runs then workflow 2 should trigger and then workflow 3 without using scheduling tool. 3.Workflow 1 should run and fail then after 1minute of time the same workflow should trigger the same should repeat to workflow 2 and workflow 3. explain the process. 4.we have n records in a file and it should load the data as n-2 records in target(need to filter the records) 5.Source table contains duplicate rows.the data has to load all the unique rows in 1 target while all the duplicate rows in another target.expalin the process? 6.what are mapping parameters and variables in informatica? explain with example 7.Explain about the SCD types and their implementation process? 8.What are the limitations in mapplet? 9.Difference between HTTP transformation and WSC(Web Service Consumer) Transformation. 10.What is top down approach and Bottom Up Approach and which one do you prefer? 11.What is the difference between copy and shorcut? 12.Difference between Joiner and lookup? 13.How to update a target record without using update strategy transformation? 14.Can you implement SCD type 2 in Source Qualifier transfomation and how? 15.Explain bottlenecks in informatica with an example? 16.Explain Static,Dynamic and Persistent caches? 17.Explain session partitioning in informatica with examples? 18.one multiple choice question total 20 questions they will ask
Viewing 1311 - 1320 interview questions