Author name: Kshitij Wagle

Kshitij Wagle is Data Engineer, specializing in data warehousing and ETL development. Holding a Master's in Information Technology, he shares his expertise through his blog, "Data Engineer Journey," where he explores data-related topics. Passionate about turning data into actionable insights, Kshitij is skilled in tools like Databricks, Talend, SQL and Power BI.

advanced sql

Blog, Interview, SQL

SQL Problem asked in FinTech – Trade & Stock

Kshitij Wagle / 16 February 2024

Question:Write a SQL to find trade couples satisfying the following conditions for each stock:– The trades should be within 10 […]

Interview, Talend/ETL

Questions to Ask Your Team Lead If you are Beginner in Analytics/ ETL Developer

Kshitij Wagle / 16 February 2024

Starting out as an ETL Developer? Asking smart questions is your secret weapon! First, inquire about the most commonly used

Dimensional Modelling – Key points you need to know

Kshitij Wagle / 16 February 2024

Star Schema: Dimensional data model, that has a fact table in the centre, surrounded by denormalized dimension tables. Snowflake Schema:

LinkedIn Networking, Message Template

Send this message to Hiring Manager – Template

Kshitij Wagle / 16 February 2024

People are hesitant to send message to HR once they apply the job, because they feel super weird reaching out