ETL Tester Interview Experience - Gurgaon, India
Process
The interview started with the question of tell about the project details and the work which you used to do in current project, and the tools you use to complete the job. The total relevant exp. in ETL.
Some questions asked in the interview are:
- Junk Dimensions
- Indexes
- Degenerate keys
- Diff between natural and Surrogate keys
- Aggregate functions of SQL
- Data types usage CLOB, BLOB etc
- What is Data warehouse
- Diff between DDL and DML commands.
- Data Driven Testing
- Performance tuning in Joins.
- Conformed Dimensions
- ACID property
- Data Marts Definition
- What are Aggregate tables
- Explain Union, union all, minus, intersect
- Benefits of De-normalization in DB
- OLAP vs OLTP
- Star vs Bus Schema
- Cross Join usage
- Define Referential Integrity
And many questions were asked on SQL queries based on the tables imagined.
Questions
SQL queries were very tricky. In some questions answers were given like a, b, c, d but the answers would not be from the above given options. They used to provide options to confuse you. Don't fall for that, think and then answer.
Was this helpful?
Interview Statistics
The following metrics were computed from 1 interview experience for the UnitedHealth Group ETL Tester role in Gurgaon, India.
Success Rate
UnitedHealth Group's interview process for their ETL Tester roles in Gurgaon, India is incredibly easy as the vast majority of engineers get an offer after going through it.
Experience Rating
Candidates reported having very good feelings for UnitedHealth Group's ETL Tester interview process in Gurgaon, India.
