Complex SQl, Puzzles
Etl Developer Interview Questions
728 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.
Basic Informatica questions, Also discussed about Oracle and Unix concepts.
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
introduction, like tell me something about your self
Related to ETL. SQL questions. Query.
What could i provide the company
Viewing 391 - 400 interview questions