Design patterns, SQL, Resume, Spark, Hive
Etl Developer Interview Questions
1,579 etl developer interview questions shared by candidates
Tell me about yourself
- Prueba tecnica: Dado el ficheros adjunto (Sales Records), crear una ETL que lo cargue en una BBDD en formato analítico (modelo en estrella). Además, realizar las siguientes acciones: Realizar el diseño técnico de la solución (con diagrama relacional). Pensando que esta ETL se lanzar¡ a diario con datos nuevos, ¿Qué control de errores pondrías en la ETL? No es necesario implementarlo, solo explicar qué checks realizarás y cómo gestionarías los errores Análisis de datos: ¿Qué 3 errores hay en los datos del fichero?
Completely based on SQL and ETL.
Experience with etl, sql, ssis
It was a very easy one.
Basic Informatica questions, Also discussed about Oracle and Unix concepts.
explain tera data architecture
Can you walk us through the SSIS development process, from package creation to deployment and execution? How do you handle errors and exceptions in SSIS packages, and what tools or techniques do you use to troubleshoot issues? What are some best practices for optimizing the performance of SSIS packages, and how do you ensure that your packages run efficiently? Can you explain how you would handle data validation and cleansing in an SSIS package, and what types of transformations or tasks would you use?
previous worked project flow in details plus addition cross questions related to project
Viewing 831 - 840 interview questions