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
Etl Engineer Interview Questions
1,579 etl engineer interview questions shared by candidates
challenges you face
root cause analysis
what are aggregators you used
what are the validations
what is test case
Mostly related to SQL and Query Optimization.
How to select unique values in a table without using distinct
write queries related to joins,ranks , group by clauses and many verbal questions.
SQL, Informatica
Viewing 1151 - 1160 interview questions
See Interview Questions for Similar Jobs
Big Data ArchitectData Warehouse ArchitectSenior Data Warehouse ArchitectSenior Data ArchitectTibco ArchitectBusiness Intelligence ArchitectOracle Data Warehouse DeveloperData EngineeringLead Data ArchitectData Mining EngineerSap BpcSenior Data EngineerData Warehouse Etl TestingSenior Data Warehouse DeveloperPower Bi ConsultantLead Data EngineerPrincipal Data EngineerSenior Data Consultant