Kritika Parmar

‼️ American Express is Hiring for Data Engineer ‼️ 🙋🏻‍♂️ Link to apply : https://lnkd.in/g9fzkFJD Expectations from a Junior Data Engineer for FAANG+: The basics: 1. Mid level at Data Structures & Algorithms. 📊 2. In data structures and Algorithms: Good at string, array, data retrieval - like problems (Binary search) 🧩 3. Knowledge of advanced SQL 📚 4. Can write code with Spark ⚡ 5. Experience with airflow/cron jobs 🔄⏰ 6. Python or scala understanding 🐍🔄 7. Basic experience with cloud services ☁️ 8. Data engineering system design (Batch) 🛠️ Nice to have: 1. Data engineering system design (Streaming) 🌊 2. Basic knowledge of Kafka 🔄📊 3. Data warehousing knowledge 🏢 4. NoSQL Databases 📄 5. Writing test cases ✅ Checkout "my website" for FREE data Engineering learning guide. #hiring #data #dataEngineering

84

4 Comments

Netflix Movie Data Analyst Project 🎉✨ Netflix is known for its work in data science, AI, and ML, particularly for building strong recommendation models and algorithms that understand customer behavior and patterns I'm assuming that I'm working in a data-driven job role( Badi Soch ho to mere jaisi , job Vo bhi Netflix mein 😂), and i have a dataset of more than 9,000 movies 🤯 I need to solve some questions to help the company make informed business decisions accordingly 😎 Used Libraries : NumPy , Pandas , Matplotlib , Seaborn GitHub link : https://lnkd.in/gqHPez_w #numpy #pandas #matplotlib #curiosity #continuousLearning #python

16

🚀 𝗘𝘅𝗰𝗶𝘁𝗶𝗻𝗴 𝗠𝗶𝗹𝗲𝘀𝘁𝗼𝗻𝗲 𝗔𝗰𝗵𝗶𝗲𝘃𝗲𝗱: 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗦𝗤𝗟 𝗖𝗼𝘂𝗿𝘀𝗲 𝘄𝗶𝘁𝗵 𝗖𝗼𝗺𝗽𝗿𝗲𝗵𝗲𝗻𝘀𝗶𝘃𝗲 𝗖𝗮𝘀𝗲 𝗦𝘁𝘂𝗱𝘆! 🚀 I'm thrilled to share that I have successfully completed an advanced SQL course, and I couldn't be more excited about the skills and knowledge I've gained. This course stood out from the rest by not only being extensive and cutting-edge but also by teaching SQL through practical, real-life business scenarios. Here’s a glimpse of what I’ve learned: 🔹 𝗦𝗶𝗻𝗴𝗹𝗲 𝗧𝗮𝗯𝗹𝗲 𝗗𝗮𝘁𝗮 𝗥𝗲𝘁𝗿𝗶𝗲𝘃𝗮𝗹: SELECT, WHERE, DISTINCT, LIKE, BETWEEN, ORDER BY, GROUP BY, HAVING, IF, CASE. 🔹 𝗠𝘂𝗹𝘁𝗶𝗽𝗹𝗲 𝗧𝗮𝗯𝗹𝗲 𝗗𝗮𝘁𝗮 𝗥𝗲𝘁𝗿𝗶𝗲𝘃𝗮𝗹: INNER, LEFT, RIGHT, FULL JOINS, CROSS JOIN, Multi-table analytics. 🔹 𝗖𝗼𝗺𝗽𝗹𝗲𝘅 𝗤𝘂𝗲𝗿𝗶𝗲𝘀: Subqueries, ANY, ALL operators, CTEs. 🔹 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁: Normalization, ERDs, Data types, Keys, CRUD operations, User account privileges and Database Indexes. 🔹 𝘾𝙖𝙨𝙚 𝙎𝙩𝙪𝙙𝙮: 𝙁𝙞𝙣𝙖𝙣𝙘𝙚 𝙖𝙣𝙙 𝙎𝙖𝙡𝙚𝙨 𝘼𝙣𝙖𝙡𝙮𝙨𝙞𝙨 𝙬𝙞𝙩𝙝 𝘼𝙙𝙫𝙖𝙣𝙘𝙚𝙙 𝙎𝙌𝙇 𝙌𝙪𝙚𝙧𝙞𝙚𝙨: 𝗚𝗲𝗻𝗲𝗿𝗮𝘁𝗲𝗱 𝗶𝗻𝘀𝗶𝗴𝗵𝘁𝗳𝘂𝗹 𝗿𝗲𝗽𝗼𝗿𝘁𝘀: -Monthly Product Transactions -Total Sales Amount -Yearly Sales -Monthly Gross Sales -Pre-Invoice Discount -Top Markets, Customers, and Products 𝗘𝗻𝗵𝗮𝗻𝗰𝗲𝗱 𝗺𝘆 𝘀𝗸𝗶𝗹𝗹𝘀𝗲𝘁 𝘄𝗶𝘁𝗵: -User-defined SQL functions -Stored procedures -Performance improvements -Database views -Windows functions -Supply Chain Fundamentals -Helper & Temporary Table, Forecast Accuracy Report. A huge shoutout to Dhaval Patel , Hemanand Vadivel, and the entire Codebasics Team for making data-related courses so engaging, informative, and accessible. Your efforts are truly transformative! 𝗟𝗲𝗮𝗿𝗻 𝗺𝗼𝗿𝗲 𝗮𝗯𝗼𝘂𝘁 𝘁𝗵𝗲 𝗰𝗼𝘂𝗿𝘀𝗲 𝗵𝗲𝗿𝗲: https://lnkd.in/d2jeDg6J 𝗟𝗶𝗻𝗸 𝘁𝗼 𝘁𝗵𝗲 𝗾𝘂𝗲𝗿𝗶𝗲𝘀 𝗽𝗲𝗿𝗳𝗼𝗿𝗺𝗲𝗱 𝗶𝗻 𝘁𝗵𝗲 𝗰𝗼𝘂𝗿𝘀𝗲 : https://lnkd.in/d5tKaVQ2 Feel free to reach out if you’d like to discuss any of these topics or if you have opportunities where advanced SQL skills can make a difference! 🚀 #SQL #DataAnalysis #DatabaseManagement #ProfessionalDevelopment #DataDriven 🚀

9

3 Comments

🗳️ Exciting Update! Proud to share my recent project on #Loksabha Election Data Web Scraping and Visualization 🌐📊 As part of my data science journey at AlmaBetter, thanks to Alok Anand , I embarked on a mission to gather and visualize crucial election data, providing insightful analysis for informed decision-making. Key Highlights: Web Scraping Mastery: Developed robust scripts using BeautifulSoup and Pandas to extract election results data from multiple government websites seamlessly. Data Visualization Expertise: Transformed raw data into interactive visualizations using Python libraries like Matplotlib and Seaborn, enabling stakeholders to grasp trends at a glance. Actionable Insights: From constituency-wise trends to party performance, our project offers comprehensive insights for political analysts, journalists, and citizens alike. This project underscores our commitment to harnessing data for impactful storytelling and informed decision-making in public affairs. 📈📰 🔍 Stay tuned as we explore new avenues and expand our capabilities in data-driven insights! here is a link for project i posed on Medium : https://lnkd.in/dq_UXGxH github page is under construction GitHub :https://lnkd.in/d3eB3Qdp Kaggle: https://lnkd.in/dXsrcef2 feel free to comment your suggestion stay tune to see the dashboard #DataScience #ElectionData #WebScraping #DataVisualization #Python #Matplotlib #Seaborn #PublicAffairs #Coursera #PoliticalAnalysis #Almabetter #DataDrivenDecisions #loksabha_election2024 #general_election #kaggle

9

Day 69 of #75DaysOfCode: Solved Problem 236 - Lowest Common Ancestor of a Binary Tree 🧩🌳 Today, I tackled a classic problem in tree data structures: finding the Lowest Common Ancestor (LCA) of two given nodes in a binary tree. The LCA is the deepest node that has both nodes as descendants. Problem Description: Given a binary tree, find the lowest common ancestor (LCA) of two given nodes in the tree. Problem Link : https://lnkd.in/g5n5WKdS Solution Approach: To solve this problem, I used a recursive approach to traverse the binary tree. The key is to backtrack from the target nodes and determine their common ancestor based on their position in the tree. It's rewarding to see these algorithms in action and to reinforce my understanding of tree structures and recursion. On to the next challenge! #75DaysOfCode #CodeNewbie #CodingChallenge #BinaryTree #LCA #Algorithm

4

During Week 8 of the Ultimate Big Data Master's Program with Sumit Mittal Sir at TrendyTech - Big Data By Sumit Mittal, I explored a range of advanced Spark topics, including: **𝐀𝐩𝐚𝐜𝐡𝐞 𝐒𝐩𝐚𝐫𝐤 𝐨𝐧 𝐘𝐀𝐑𝐍 (𝐔𝐛𝐞𝐫 𝐌𝐨𝐝𝐞):** A focused study of the Uber Mode deployment of Spark on YARN. **𝐏𝐲𝐒𝐩𝐚𝐫𝐤 𝐂𝐨𝐥𝐮𝐦𝐧 𝐀𝐜𝐜𝐞𝐬𝐬:** Examining various methods for accessing and manipulating DataFrame columns in PySpark. **𝐒𝐢𝐦𝐩𝐥𝐞 𝐀𝐠𝐠𝐫𝐞𝐠𝐚𝐭𝐢𝐨𝐧𝐬:** Learning fundamental aggregation techniques in Spark. **𝐆𝐫𝐨𝐮𝐩𝐢𝐧𝐠 𝐀𝐠𝐠𝐫𝐞𝐠𝐚𝐭𝐢𝐨𝐧𝐬:** Performing aggregations on grouped data. **𝐖𝐢𝐧𝐝𝐨𝐰 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧𝐬:** Exploring powerful window functions such as `row_number`, `rank`, `dense_rank`, `lead`, and `lag`. **𝐋𝐨𝐠 𝐅𝐢𝐥𝐞 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬:** Techniques for effectively analyzing log files using Spark. **𝐏𝐢𝐯𝐨𝐭 𝐓𝐚𝐛𝐥𝐞𝐬 𝐢𝐧 𝐏𝐲𝐒𝐩𝐚𝐫𝐤:** Creating and working with pivot tables for data summarization and analysis. #BigData #PySpark #SQL #AzureDataEngineer

28

1 Comment

Hi everyone again!! I hope you are doing well 😊 Finally, we reached crucial point over OLAP and OLTP 😀 Well, we have already knew OLAP and OLTP from my previous posts but a big question comes as form of "𝑪𝑶𝑵𝑵𝑬𝑪𝑻𝑰𝑶𝑵 𝑩𝑬𝑻𝑾𝑬𝑬𝑵 𝑶𝑳𝑨𝑷 𝑨𝑵𝑫 𝑶𝑳𝑻𝑷" 🤔 In this post I am going to show two methods to come over this issue : ✅ One is 𝘚𝘘𝘓 𝘛𝘳𝘪𝘨𝘨𝘦𝘳 💡 ✅ Another is 𝘌𝘋𝘈 (𝘌𝘷𝘦𝘯𝘵-𝘋𝘳𝘪𝘷𝘦𝘯 𝘈𝘳𝘤𝘩𝘪𝘵𝘦𝘤𝘵𝘶𝘳𝘦) 💡 Precisely, I will dedicate a post lying into the heart of the problem covering pros and cons for each approach 😎 So keep watching me and checking my post!!! Have a good day, See you next post 🙋‍♂️ #merajomarov #sql #trigger #sqltrigger #EDA #OLAP #OLTP

16

I enrolled in Krish Naik sir's Course mathematics basics to advance for Data Science and GenAI. It is helping me a lot for understanding mathematics and its application in Data Science. I learnt a few concepts and here these are :- 📄 Understanding different between Scaler and Vector. 📄Addition, Multiplication of Vectors 📄Vector multiplication -- Element wise Multiplication 📄Vector- Scaler Multiplication 📄Matrices 📄 Matrices Operation All concepts guided smoothly with practical example. Thanks for making such an amazing Course. #math #learninpublic #AI

33

1 Comment

"𝐀 𝐜𝐨𝐦𝐦𝐨𝐧 𝐟𝐞𝐚𝐫 𝐟𝐨𝐫 𝐚𝐬𝐩𝐢𝐫𝐢𝐧𝐠 𝐝𝐚𝐭𝐚 𝐬𝐜𝐢𝐞𝐧𝐭𝐢𝐬𝐭𝐬: ⤵ "I’m not the best coder, so can I still become a Data Scientist?" As a fresher, I’ve had these thoughts too. I used to believe that being an expert coder was the only way to succeed in this field. But after working on projects like Machine Learning models and NLP applications, I realized it’s not all about mastering code. It’s about solving problems creatively, using the right tools, and focusing on making an impact through data. 🚀 Here’s what I’ve worked on so far: 1️⃣ LinkedIn Automation Tool: Built an automation tool with Selenium to make LinkedIn messaging faster and more efficient. 2️⃣ Sales Forecasting Model: Designed a model to predict sales trends, helping businesses optimize inventory and increase revenue. 3️⃣ Email Automation: Automated bulk emails for health professionals using Python, improving communication and engagement. 4️⃣ News Categorization Tool: Created a tool to pull news from RSS feeds and organize it using NLP tools like NLTK and spaCy. These projects taught me that success in data science isn’t about being the best coder—it’s about applying what you know to solve real-world problems. 💬 I’d love to connect with anyone interested in AI solutions, data science, or just exchanging ideas. Let’s chat! #DataScience #AI #MachineLearning #NLP #OpenToWork #DigitalTransformation Google Microsoft Tata Consultancy Services Accenture in India Facebook MERA Apple Infosys Wipro Genpact Cognizant KPMG India PwC India American Express Tiger Analytics Jio

6

2 Comments

Hello everyone 🌟 Here I am showing you how we build a neural network using TensorFlow and Keras . This is a part of my ongoing tutorials from Codebasics under the guidance of Dhaval Patel sir #DeepLearning #NeuralNetwork

9

❗Notify Me Weekly Update ❗ Hi all 🌻, here is a (bit late) Notify Me update for this week 📣 Updates: 🔹We have 2034 users (+61 since the last update ) 🔹Number of paying users: 4 (+0 since the last update) 🔹MRR: $24.96 🔹Monthly costs on GCP: ~$51.81 (with a downward trend due to scraper migration to Hetzner); Hetzner: $25.55 🔹Production scrapers are stable on Hetzner servers 🔹We’ve started gathering needed data for reducing the false positives. We are testing it on staging currently, and if everything goes well, we’ll move on to prod as well 🔹Biggest user jump in a while, directories traffic is starting to kick in, and we finally passed 2000 users mark 🔹Competition Tracker successfully ingested over 60000 pages and we’ll hopefully onboard our first user in the next couple of days ✅Do’s Try to have at least 1-2 hours of focused work each day, consistency does wonders. ❌Don’ts Try to be conservative when estimating time needed to complete something. Especially if there are unknowns - always account for them. Good general rule of thumb is just 3x-ing whatever your initial time estimate was. ❓ What is our goal for next week: 🔹One more paying customer 🔹Increasing traffic 🔹Improving false positive detection 🔹Having first Competition Tracker customer I hope this was helpful, and I wish you all an awesome week 🙌 #buildinginpublic #indiehacking #startups

6

2 Comments

Exciting News! 🌟 Thrilled to announce I've achieved the 5-Star Gold badge in SQL on HackerRank! 🏆 Thanks to HackerRank's challenges, my SQL skills are sharper than ever. Ready to tackle more complex projects! Big thanks to HackerRank and my network for the support. Let's keep learning together! 💼✨ #SQL #HackerRank #5StarGoldBadge #DataSkills #AchievementUnlocked 🚀

8

8 Comments

Hello Floks. I am a data scientist and front end engineer. I have experience working in both domain. Right now I am looking for opportunities to switch in. I have enlisted my skills. Interested person please dm. python machine learning javascript html css sql #datascience #machinelearning #angularjs #reactjs #python #frontend #sql

2

🎓 **From College Dreams to Career Realities**: Abhishek Kumar shares his journey from student life to becoming a seasoned data engineer. 📈 **Unlock Industry Insights**: Learn how to leavrage industry trends and skills to build a successful, future- proof career. 💡* *Career Growth Made* *Simple** : Get practical tips and Boost your Career. ❓* *Q&A Session** : Your chance to ask questions and receive personalized career guidance from an expert!! 🚀 *Don't miss out on this opportunity to fast-track your career – Join the conversation with Abhishek Kumar!**

24

1 Comment

Just Learn with Amaan Hello everyone. I am Amaan, a btech final year student at NIT Warangal. I am extremely excited to share with you all that I've started my youtube channel - Just Learn with Amaan. Passionate about data analytics, I have spent my past 2 years learning more and more about data analytics, experimenting and making plenty of mistakes along the way. Now, I am here to share with you all what I have learnt, guiding you through every aspect of data analytics. Through my channel, I'll also be documenting my journey until I land my first data analytics job. A few days ago, I posted my intro video, and today, I am excited to share my first educational video: "What is Data Analytics?" Go check out the video and don't forget to give feedback in the comment section. Also, subscribe to Just Learn with Amaan for more insightful content on data analytics. 🔗

19

1 Comment

[𝗗𝗮𝘆 𝟭𝟲 /𝟭𝟮𝟬] 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗖𝗵𝗮𝗹𝗹𝗲𝗻𝗴𝗲 🌟 Today's Focus: SQL and DSA 🔍 Learnings: 1️⃣ Python and Probability 2️⃣ Joins in SQL 3️⃣ Principle Component Analysis (More than half completed till now) 4️⃣ Solved 8 DSA Problems Excited to apply these learnings to real-world projects and continue pushing the boundaries of what's possible with data and ML! 🚀 #DataScience #ContinuousLearning Let's connect and share insights! What's been your favorite learning moment lately? 💡 #DataCommunity #DataScience #LearningJourney #DailyUpdate #DataScienceChallenge #MachineLearning #AI #BigData #Python #Statistics

15

2 Comments

Dear Connection, I am halfway through my Data Analyst Internship, just completed 3 months at Reliance Jio Platforms. Here are 3 things I learned in 3 months:✨ 1️⃣The art of constant learning: At Reliance Jio Platforms, I've learned new technical skills like PySpark and also Leveled up on my skills in MySQL. I also got a chance to work on Jio Meet and Jio Events servers. Additionally, I experimented with a lot of new internal tools like Apache Airflow, Apache Superset, and BigQuery. The last 3 months taught me that as a Data Analyst, you need to believe that you know 'enough' to take on a new challenge. The challenge itself will teach you the rest. 2️⃣The value of engineering excellence: At Reliance Jio Platforms, I saw engineering excellence in action at every step of the way. From writing clean, maintainable code to designing scalable systems, I've learned to prioritize quality and efficiency in everything I do. 3️⃣The importance of giving back: At Reliance Jio Platforms, I got a chance to work with so many amazing people who have always stood by me whenever I needed them. The spirit of giving back that I learned from my colleagues inspires me to keep writing on LinkedIn. I'm grateful for the valuable experiences and lessons learned so far, and I eagerly anticipate the growth and challenges that lie ahead in the remainder of my internship. Let's continue to learn, innovate, and inspire together. #LifeatJioPlatforms #DataAnalyst

412

19 Comments

Consolidated Interview Questions on "Extent Report" : 1) How would you handle a situation where Extent Report is not updating after execution? 2) Why do we need flush() method ? 3) What would you do if screenshots are not loading in the Extent Report? 4) What are the advantages of using Extent Reports over other reporting tools? 5) How do you log exceptions in Extent Reports? 6) How do you integrate Extent Reports with TestNG? 7) What is the difference between flush() and close() methods in Extent Reports? 8) How can you generate reports for parallel execution? 9) ExtentSparkReporter ??? #qa #sqa #tester #qatester #sqatester

4