Roles, responsibilities, domain knowledge, technical questions, scenarios.
Developer Sql Server Etl Interview Questions
728 developer sql server etl interview questions shared by candidates
Q: Can you describe a challenging ETL process you've worked on and the obstacles you faced? A: I spoke about migrating a large dataset into a new CRM/ERP system using Azure Data Factory and SQL Server. I explained how I addressed data validation, legacy compatibility issues, and compliance with data integrity requirements.
How do you debug an alerted code issue?
Give me an example of a time when you did not meet a client's expectation
Tell us about your work experience?
Related to project
Basic SQL and ETL flow
SQL, Informatica
tMap,tJoin,Context variables and global variables,Java components,how to solve memory issues when lookup table is big,how to schedule and deploy of jobs,what is the reporting tool used,Parallel exexcution,Debugging,How to get files from server, audit framework and Sql queries like,finding ,removng duplicates,nth highest salary,Rank and dense rank
Covered all the informatica related topics and some scenarios also asked about performance tuning and partitioning also
Viewing 561 - 570 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