Data Careers Resources & Job Updates | iamrupnath
20.2K subscribers
38 photos
2 videos
95 files
2.99K links
๐Ÿ‘‰ Connect LinkedIn :
https://www.linkedin.com/in/rupnath-shaw

Google Search => Techcompreviews
IG: @iamrupnath

Perfect channel for Data Careers, Job Updates

Learn Excel, SQL, Python, Tableau, Power BI, AI tools, AI tips & tricks and many more
Download Telegram
This media is not supported in your browser
VIEW IN TELEGRAM
Use my uploaded image as the exact identity and facial reference. Create a realistic cinematic photo of me sitting in the driver's seat of a modern car, facing the camera with a calm, confident expression.
Keep my facial features, hairstyle, skin tone, and overall appearance recognizable and natural.
Match the reference scene: close-up framing from inside the car, visible steering wheel at the bottom, beige leather seat/interior, dark tinted surroundings, strong natural sunlight and realistic shadows. Use a slightly low front-facing camera angle, authentic photography, sharp facial details, subtle cinematic contrast, and realistic skin texture.
Output must be exactly 3:4 portrait. No text, Ul elements, logos, watermarks, icons, or extra people.

drive link : https://drive.google.com/file/d/1tDt-DYB2jrddHIoaaMqIAUqWrmxYKae4/view?usp=sharing
โœ…SQL Roadmap: Step-by-Step Guide to Master SQL ๐Ÿง ๐Ÿ’ป

Whether you're aiming to be a backend dev, data analyst, or full-time SQL pro โ€” this roadmap has got you covered ๐Ÿ‘‡

๐Ÿ“ 1. SQL Basics
โฆ  SELECT, FROM, WHERE
โฆ  ORDER BY, LIMIT, DISTINCT 
   Learn data retrieval & filtering.

๐Ÿ“ 2. Joins Mastery
โฆ  INNER JOIN, LEFT/RIGHT/FULL OUTER JOIN
โฆ  SELF JOIN, CROSS JOIN 
   Master table relationships.

๐Ÿ“ 3. Aggregate Functions
โฆ  COUNT(), SUM(), AVG(), MIN(), MAX() 
   Key for reporting & analytics.

๐Ÿ“ 4. Grouping Data
โฆ  GROUP BY to group
โฆ  HAVING to filter groups 
   Example: Sales by region, top categories.

๐Ÿ“ 5. Subqueries & Nested Queries
โฆ  Use subqueries in WHERE, FROM, SELECT
โฆ  Use EXISTS, IN, ANY, ALL 
   Build complex logic without extra joins.

๐Ÿ“ 6. Data Modification
โฆ  INSERT INTO, UPDATE, DELETE
โฆ  MERGE (advanced) 
   Safely change dataset content.

๐Ÿ“ 7. Database Design Concepts
โฆ  Normalization (1NF to 3NF)
โฆ  Primary, Foreign, Unique Keys 
   Design scalable, clean DBs.

๐Ÿ“ 8. Indexing & Query Optimization
โฆ  Speed queries with indexes
โฆ  Use EXPLAIN, ANALYZE to tune 
   Vital for big data/enterprise work.

๐Ÿ“ 9. Stored Procedures & Functions
โฆ  Reusable logic, control flow (IF, CASE, LOOP) 
   Backend logic inside the DB.

๐Ÿ“ 10. Transactions & Locks
โฆ  ACID properties
โฆ  BEGIN, COMMIT, ROLLBACK
โฆ  Lock types (SHARED, EXCLUSIVE) 
   Prevent data corruption in concurrency.

๐Ÿ“ 11. Views & Triggers
โฆ  CREATE VIEW for abstraction
โฆ  TRIGGERS auto-run SQL on events 
   Automate & maintain logic.

๐Ÿ“ 12. Backup & Restore
โฆ  Backup/restore with tools (mysqldump, pg_dump) 
   Keep your data safe.

๐Ÿ“ 13. NoSQL Basics (Optional)
โฆ  Learn MongoDB, Redis basics
โฆ  Understand where SQL ends & NoSQL begins.

๐Ÿ“ 14. Real Projects & Practice
โฆ  Build projects: Employee DB, Sales Dashboard, Blogging System
โฆ  Practice on LeetCode, StrataScratch, HackerRank

๐Ÿ“ 15. Apply for SQL Dev Roles
โฆ  Tailor resume with projects & optimization skills
โฆ  Prepare for interviews with SQL challenges
โฆ  Know common business use cases

๐Ÿ’ก Pro Tip: Combine SQL with Python or Excel to boost your data career options.

๐Ÿ’ฌ Double Tap โ™ฅ๏ธ For More!
โค5
Infosys Interview Experience | Position: Data Engineer | Experience: ๐Ÿฏ+ ๐˜†๐—ฒ๐—ฎ๐—ฟ๐˜€.

๐—ฅ๐—ผ๐˜‚๐—ป๐—ฑ ๐Ÿญ - ๐—ง๐—ฒ๐—ฐ๐—ต๐—ป๐—ถ๐—ฐ๐—ฎ๐—น ๐Ÿญ (๐—ฃ๐˜†๐—ฆ๐—ฝ๐—ฎ๐—ฟ๐—ธ | ๐—ฆ๐—ค๐—Ÿ | ๐——๐—ฎ๐˜๐—ฎ ๐—ฃ๐—ฟ๐—ผ๐—ฐ๐—ฒ๐˜€๐˜€๐—ถ๐—ป๐—ด)
1๏ธโƒฃ Explain your end-to-end data pipeline โ€” from ingestion to data transformation and loading.
2๏ธโƒฃ How do you optimize PySpark jobs to handle large data volumes efficiently?
3๏ธโƒฃ What are the differences between repartition(), coalesce(), and repartitionByRange() in Spark?
4๏ธโƒฃ Write a PySpark job to calculate the top 3 products sold in each region.
5๏ธโƒฃ SQL question: Find the nth highest salary using different approaches.
6๏ธโƒฃ Explain how you handle null values, duplicates, and bad records in ETL processing.

๐—ฅ๐—ผ๐˜‚๐—ป๐—ฑ ๐Ÿฎ - ๐—ง๐—ฒ๐—ฐ๐—ต๐—ป๐—ถ๐—ฐ๐—ฎ๐—น ๐Ÿฎ (๐—”๐—ญ๐—จ๐—ฅ๐—˜ ๐——๐—”๐—ง๐—” ๐—™๐—”๐—–๐—ง๐—ข๐—ฅ๐—ฌ | ๐——๐—ฎ๐˜๐—ฎ ๐— ๐—ผ๐—ฑ๐—ฒ๐—น๐—ถ๐—ป๐—ด | ๐——๐—ฒ๐—น๐˜๐—ฎ ๐—Ÿ๐—ฎ๐—ธ๐—ฒ)
1๏ธโƒฃ How do you design an ADF pipeline for incremental data loads between databases?
2๏ธโƒฃ What are triggers in ADF, and how do you schedule pipelines efficiently?
3๏ธโƒฃ How does Delta Lake handle ACID transactions and schema evolution?
4๏ธโƒฃ What are the advantages of using Data Lakehouse architecture over a traditional warehouse?
5๏ธโƒฃ Explain SCD Type 1, Type 2, and Type 3 โ€” which one have you implemented and why?
6๏ธโƒฃ How do you monitor and handle pipeline failures or retries in ADF or Databricks?

๐—ฅ๐—ผ๐˜‚๐—ป๐—ฑ ๐Ÿฏ - ๐— ๐—ฎ๐—ป๐—ฎ๐—ด๐—ฒ๐—ฟ๐—ถ๐—ฎ๐—น / ๐—•๐—ฒ๐—ต๐—ฎ๐˜ƒ๐—ถ๐—ผ๐—ฟ๐—ฎ๐—น
1๏ธโƒฃ Describe a situation where you faced a data pipeline failure in production. How did you troubleshoot and fix it?
2๏ธโƒฃ How do you communicate technical issues to non-technical stakeholders?
3๏ธโƒฃ Whatโ€™s your approach when a deadline is tight and data validation is still pending?
4๏ธโƒฃ How do you manage work priorities across multiple projects?
5๏ธโƒฃ Tell me about a time you optimized cost or performance in a cloud-based data solution.
โค4๐Ÿ‘1