Technical Prep for Data Careers

Preparing for a technical interview in Data Engineering, BI, or Analytics?

This session is designed to help you prepare for technical interviews based on your experience level, target role, and the technologies you're expected to know.

Rather than following a fixed syllabus, we'll focus on the areas most relevant to your goals and identify any knowledge gaps before your interview.

Topics can include:

• SQL & SQL Server
• Snowflake
• dbt
• ETL / ELT concepts
• Data Warehousing
• Data Modeling
• Azure Data Factory
• Databricks
• Reporting & BI concepts
• Power BI / Tableau fundamentals
• Query optimization & performance tuning
• Query profiling and execution plans
• OLTP vs OLAP
• Medallion Architecture
• Scenario-based technical questions
• Real-world interview problems
• AI tools for Data Professionals (including AI-assisted development, MCPs, and modern workflows)

Throughout the session, I'll ask interview-style questions, discuss your thought process, and provide honest, actionable feedback on your technical knowledge, problem-solving approach, and communication.

Whether you're preparing for your first technical interview or interviewing for a senior Data Engineering or BI role, this session will be tailored to your background and objectives.

Please share your target role, years of experience, current technical stack, and (if available) the job description before the session so I can customize the interview accordingly.