What do your day-to-day responsibilities look like at your current job?
Developer Sql Server Etl Interview Questions
728 developer sql server etl interview questions shared by candidates
Regular questions - work experience, reason for leaving etc.
Mostly SQL Questions (joins, rank, row nums, subqueries), Tuning queries, Data Modeling, Data Warehousing Concepts, Unix,
Basic Etl questions like lookup vs joiner , parameters etc
Challenge faced during project implementation
questions on their day to day work
1. As usual tell me about yourself. 2. roles and responsibilities in the previous project. 3. If you get text file how you connect to power center and load into DWH. 4. What Dimension you used in your project? 5. Types of SCD and difference between SCD1 and SCD2. 6. How you maintained SCD2 in your project. 7. Then they asked a SQL query (many to many relationships).
Tell us something about the ETL Tools used.
How would get specific number record to target like 1st and 3rd. SCD Types Schema Change Handling Aggregation Working on performance tuning in Informatica Powercenter
Informatica concepts and data warehouse
Viewing 211 - 220 interview questions
See Interview Questions for Similar Jobs
Sql Server Bi DeveloperDatabase SqlAmministratore Del Database Sql ServerSenior Sql Server DbaOntwikkelaar Sql Server EtlSsis DeveloperProgrammer Analyst Sql Server DeveloperTalend Etl DeveloperSql Server DbaSviluppatore Di Database Sql ServerSviluppatore Sql Server EtlSql ServerDatabase Del Server SqlEntry Level Sql Server DbaSql Server ConsultantActimize DeveloperBusiness Intellignece AnalystSsis Ssrs Consultant