LTIMindtree Data Engineer Coding Question | Masking & Splitting Explained (3–5 Yrs)

In this video, I explain a real coding question asked in LTIMindtree face-to-face interview for a Data Engineer with 3–5 years of experience. 👉 Problem covered in this video: Masking contact numbers except last 4 digits Splitting email IDs to extract first name and last name This type of question is commonly asked in LTIMindtree, Accenture, Infosys, TCS, Capgemini interviews. 🎯 Best for: Data Engineers (3–5 years) PySpark interview preparation Big Data & Spark developers 👍 If you find this helpful, LIKE, SHARE, and SUBSCRIBE for more real interview questions. Chapters / Timestamps (Very Important) 00:00 – Introduction 00:28 – LTIMindtree Interview Question Overview 02:40 – Masking Contact Number Logical solution 08:42 – Masking Contact Number Coding Solution 10:56 – Email Splitting (First & Last Name) Logical solution 13:46 – Email Splitting (First & Last Name) Codingsolution 14:40 – Interview Tips & Follow-up Questions LTIMindtree interview LTIMindtree data engineer pyspark interview questions data engineer interview questions spark sql interview masking data pyspark split function pyspark big data interview data engineering interview 3-5 years data engineer real interview questions #LTIMindtree #DataEngineer #PySpark #BigData #InterviewQuestions #SparkSQL #DataEngineering %sql -- Create Employee SQL Table CREATE OR REPLACE TABLE employee ( id INT, contact_number VARCHAR(15), mail_id VARCHAR(100), status VARCHAR(10) CHECK (status IN ('Active', 'Inactive')) ); -- Insert Sample Data (5–7 Rows) INSERT INTO employee VALUES (1, '+91 9876543210', '[email protected]', 'Active'), (2, '+1 9123456780', '[email protected]', 'Inactive'), (3, '+44 9988776655', '[email protected]', 'Active'), (4, '+91 9012345678', '[email protected]', 'Inactive'), (5, '+61 9090909090', '[email protected]', 'Active'), (6, '+1 8887776665', '[email protected]', 'Active');