Interview questions on informatica power center or IICS -3
1.How do you raise ticket?
In our current project, we have raised a ticket (Incident or Service
Request) by using Service now tool. We can use different ticketing tools
like HP-ALM and also Jira.
2.In case of job failure in production whom will you report ?
As a L2 Team member, if any job failed in Production, first we will try
to restart the workflow. If it is still failed, we will check the
session log and try to find out the error and will resolve it.
If any code change is required for any job failure, we will report to L3
Support team to do the code change.
3.Explain end to end project life cycle from dev to production ?
We will follow the below steps from Dev to Production.
Dev (Development / Lower) Environment: ETL Developers will do the
mapping development in Dev Repository using the tables in
Development (DEV) Database (Which have sample data). Once the
mapping Development is completed, Developers will run the workflow
and load the data to Dev Database tables. Also, Developers will
Complete unit testing and move the code from Dev to Test Environment.
Test Environment (QA/SIT): ETL Testers will run the workflow which
is in testing (QA) repository. When they run the workflows, the data
(Near Realtime data) will load the Testing Database tables. ETL
testers will do thorough testing with the Testing database tables.
If thy find any discrepancies, testing team will raise
Incident/service request and assign to Dev team.
Dev Team, should see issue raise by Testing team, if any code changing
is required, Developers will change the code in Dev repository, they do
the unit testing and again developers will deploy the code from Dev to
Test Repository.
Testing team will do the thorough testing again until they see correct
data as per the logic in the target table which is in Testing database.
Once ETL Tester completes the Testing, He will give Testing Sign off.
Prod (Production / Higher) Environment: A Team lead or a senior team
mate will Deploy the code from Test environment to Prod Environment.
First Team lead will do the dry run with the data of 2 to 3 days. Once
the Run successfully completed, He will do the full load first, and then
daily the Workflow will run on daily basis in production.
4.How will you get updates in your projects from your client
Client will raise a BR (Business Request) or CR (Change Request) if
there is any new requirement. Based on the BR and CR raised by Client,
our team lead/scrum master will assign the work through the tasks in Jira.
5.Project - what is customer perspective in detail ?
In Data warehousing projects, Customers needed ultimately Business
reports. Customers expect the Different Reports like Daily, Weekly,
Monthly and Yearly Reports and also, they will expect Branch wise,
Citywide, Statewide, Zonal wide, Country wide reports from the Developers.
6.Can you plese tell me some acheivements done by you in your project ?
7.Explain end to end project life cycle from dev to production ?
Ans question no.3
8.What all other tools use in your project ?
I have used the below tools in project.
Informatica PowerCenter Client Tools
Oracle SQL Developer
Putty (for UNIX files)
WinSCP (for UNIX files)
Jira (For Tasks)
Service Now (to raise Incidents and Service Requests)
9.What is the flow of development in your project ?
10.If there are errors in UAT phase how will you resolve it how you are manintaing versions ?
If any there any Errors in UAT, Users will raise a ticket and assign to
Dev team. As an ETL Developer, I will modify the code in Dev
environment, and also, I will do the unit testing and then deploy the
code from dev to test Environment.
In this case we have used Versioning concept (Check-in & Check-out) to
maintain the mapping versions in Dev.
informatica interview preparation,informatica interview scenarios,informatica interview questions,informatica interview videos,informatica interview,informatica admin interview questions,informatica interview tips,informatica interview questions and answers,informatica powercenter interview questions,technical interview questions,informatica questions,informatica training,informatica answers,informatica powercenter,informatica tutorial
informatica intelligent cloud services, iics informatica tutorial, iics to cloud data base connection, iics data integration tutorial, iics cloud data integration services, iics training informatica, iics tutorial for beginners, iics informatica tutorial telugu, iics informatica, iics informatica interview questions, iics informatica resume, iics informatica training, iics data integration, iics data integration interview questions, what is informatica iics, iics login issue, informatica intelligent cloud services, iics, iics Informatica Cloud secure agent,
informatica or IICS interview question and answers for 2 years experience
informatica or IICS interview question and answers for 3 years experience
Смотрите видео Interview questions on informatica power center or IICS -3 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Technology with Kiran 01 Декабрь 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,835 раз и оно понравилось 27 людям.