Required Skills and Topics

• LeetCode ( Array, Hashmaps, String Manupulation ) solving skills.
• SQL (self-joins, window functions, aggregation functions/group by, DDLs, schema design, partitioning and clustering, time/date-time)
• MySQL, Postgress DBs
• Cloud Platforms: AWS and GCP
• Dataframe Manipulation
• Data Generation (Python-faker)
• API Creation
• Logs Analysis
• Text Parsing
• Web Scraping
• Pipeline Creation and Orchestration (Airflow, Python)
• Data Analysis (Python)
• Docker Compose, Dockerfile
• Git and GitHub
• Software Engineering skills are a plus

Interview Process

1. HR Interview:
   • Questions about your career so far, your achievements, technical question about past experience and why you choose a certain stack.
   • Motivation, communication skills, and language proficiency.
2. Online Coding assessment:
   • 4 LeetCode Style problems in Code Signal Platform you need to get above 400 points (2 problems solved or more ) this one is proctored, which means u will be sharing your cam and mic and it should be quiet. after completion, they will check if there are no sights of cheating and then it will validated and sent to BCG.
   • Problems usually involve Strings, Arrays, Linked Lists, 2d Arrays, HashMaps ofc.
   • Problems difficulty: 1 easy, 1-2 Mediums, 1-2 Hard