Uneecops Technologies Senior SQL Developer Interview Questions and Answers

Q1. What is the difference between Informatica Powercentre and iics
Ans. 
Informatica Powercentre is an on-premise ETL tool, while iics is a cloud-based ETL tool.
• Informatica Powercentre is an on-premise ETL tool, meaning it is installed and run on the user's own hardware and infrastructure.

• iics (Informatica Intelligent Cloud Services) is a cloud-based ETL tool, allowing users to access and use the tool via the internet.

• Informatica Powercentre requires manual upgrades and maintenance, while i...read more
Answered by AI
Add your answer
Q2. How can you optimize session
Ans. 
Optimizing session involves tuning session settings, utilizing efficient data loading techniques, and minimizing resource usage.
• Tune session settings such as buffer size, commit interval, and block size for optimal performance

• Utilize efficient data loading techniques like bulk loading, incremental loading, and parallel processing

• Minimize resource usage by optimizing SQL queries, reducing unnecessary transformations, an
Answered by AI
Add your answer

They ask me to print a pattern based questions

Q1. Steaming platform, information architecture
Add your answer
Q2. Architectural best practices, data governance
Add your answer

Q1. More than a few things across data modeling, data engg
Add your answer

Q1. Architecture related, project related etc
Add your answer

Q1. How much salary hike is expected
Add your answer