Testimonials
Services
About me
- Poornachandra Kongara is an amazing mentor, prompt, detailed, knowledgeable, and genuinely caring, especially for students heading abroad.
Frequently asked questions
How to study in the USA from India?
The standard path to study in the USA for international students — and for Indian applicants specifically — follows six steps: shortlist universities and intakes, take the required tests (TOEFL or IELTS for English, plus the GRE if your program asks for it), apply with transcripts, an SOP, and LORs, receive the I-20 from your university once admitted, show proof of funds and pay the SEVIS fee, and finally apply for the F-1 visa and attend the consulate interview. Start 12–18 months before your intended intake so you have room for retakes, applications, and visa appointment delays. Talking to someone who has recently made the same move, even in a quick 1:1 consultation, helps you avoid expensive shortlisting and budgeting mistakes.
How to study in the USA for free?
Completely free study in the USA is rare for international students, but you can get close by stacking options: target universities that give merit scholarships or tuition waivers to international applicants, apply for funded research or teaching assistantships (common in many MS and PhD programs), look at external and home-country scholarships, and choose lower-cost public universities in affordable states. On-campus work — usually capped at 20 hours a week while classes are in session — can cover living expenses. Realistically, plan for partial funding rather than a full ride, and build a semester-by-semester budget before you accept an admit.
How can I study in the USA with a scholarship?
Scholarships to study in the USA with a scholarship award come from three main places: the universities themselves (merit awards, departmental assistantships, and need-based aid at a few top schools), external foundations, and government or home-country programs. Check each university's funding page before applying, email departments directly about assistantship openings, and apply early — many awards consider you automatically with your admission application, while others need separate essays. A strong GPA, good test scores, and a clear SOP with evidence of leadership or research meaningfully improve your chances.
What is MS study in the USA?
An MS (Master of Science) is a 1.5–2 year postgraduate degree in a technical or scientific field — computer science, data analytics, engineering, or management information systems. It's the most popular route for international students aiming at US tech careers because STEM-designated MS programs qualify for extended work authorization after graduation: 12 months of OPT plus a 24-month STEM extension. Admissions typically weigh your undergraduate GPA, English test scores, and sometimes the GRE, and most programs end with a capstone or thesis rather than a mandatory dissertation.
What is a study visa in the USA?
A study visa is a US visa that permits a foreign national to enter the country for education. The F-1 visa is the main one for full-time academic study at an accredited institution; the J-1 covers exchange programs and the M-1 covers vocational study. For an F-1, you need admission to a SEVP-certified school, the I-20 form issued by that school, proof you can fund your studies, and a successful visa interview where you demonstrate genuine study intent. F-1 students can work on campus and apply for OPT after completing their program.
What is work study in the USA?
For international students, "work study" usually means earning money while studying on an F-1 visa. The primary option is on-campus employment — up to 20 hours per week during the semester and full-time during breaks — in roles like library staff, dining, residence hall support, or student organization supervision (for example, the kind of RSO supervisor role Poornachandra holds at Northeastern). After your first academic year, off-campus options open up through CPT for program-related internships and OPT. One clarification worth knowing: "Federal Work-Study" is a US government aid program reserved mainly for domestic students, so international students rely on the on-campus route.
How to prepare for a data engineer interview?
Structure your prep in four layers. First, SQL — joins, window functions, aggregations, and query optimization appear in nearly every loop. Second, Python — pandas for data tasks plus basic data-structures problems. Third, fundamentals — data modeling, ETL/ELT design, warehousing concepts, and tools like Spark, Airflow, and a cloud platform such as AWS. Fourth, your own projects — be ready to explain architecture choices and trade-offs, not just list technologies. Add a few timed mock interviews, because explaining your thinking out loud is a separate skill from solving quietly.
What are the most common data engineer interview questions and answers?
Most interviews recycle the same themes: SQL scenarios (find the second-highest salary per department, deduplicate records), Python coding on strings and collections, data modeling questions (star vs. snowflake schema, when to denormalize), pipeline design ("how would you handle late-arriving or duplicate data?"), Spark or cloud-tool questions for senior roles, and behavioral questions about failures and collaboration. The strongest answers follow a pattern: clarify the problem, state assumptions, walk through your approach, then name the trade-offs. Practicing structured answers out loud beats memorizing solutions.
What is the data engineer interview process like?
At most US companies it runs three to five rounds over two to six weeks: a recruiter screen, one or two technical screens (live SQL and Python, sometimes a take-home), a virtual onsite loop covering data modeling, pipeline or system design, and your past projects, and a final behavioral or hiring-manager round. Entry-level candidates are tested mainly on SQL, Python, and fundamentals, while experienced candidates go deeper into architecture, batch vs. streaming trade-offs, and scale. Asking your recruiter which stage you're in and what to expect next is completely normal.
Why do you want to be a data engineer?
Interviewers ask this to check whether you understand what the job actually involves, so anchor your answer in the work, not the title. A reliable structure: open with a genuine trigger (a course or project where you built a pipeline or turned messy data into something usable), explain what pulls you toward the craft — building dependable systems that others rely on, sitting between software engineering and analytics — and close by connecting it to the company's data scale, stack, or products. Skip generic lines like "I love data"; specificity is what separates a memorable answer from a forgettable one.
What is the data engineer salary in the US?
It varies widely by level, city, and industry, but as a broad guide: entry-level data engineers in the US typically land in the $80,000–$110,000 range, mid-level engineers commonly earn around $110,000–$150,000, and senior or staff engineers in hubs like the Bay Area, Seattle, or New York often cross $160,000–$200,000+ once bonuses and stock are included. Always compare offers on total compensation rather than base salary alone, and weigh them against local living costs — mapping salary against monthly expenses city by city is exactly the kind of exercise a salary and expense calculation session is built for.
How to write a data analyst resume?
Lead with impact, not responsibilities. Use a tight structure: a two-to-three line summary naming your target role and core tools, a skills section with SQL, Excel, Python, and your BI tools, and experience bullets in the "action + tool + measurable result" format — for example, "built a Power BI dashboard that cut manual reporting time by 30%." Keep it to one page if you have under five years of experience, mirror the keywords from each job description you apply to, and cut anything you couldn't confidently discuss in an interview. Recruiters skim for under a minute, so your strongest achievements must sit in the top third.
How to make a data analyst resume with no experience?
Replace job experience with evidence. Build two or three portfolio projects on public datasets, ideally one end-to-end: pull the data with SQL or an API, clean and analyze it with Python or Excel, then publish a dashboard or short write-up. Add academic projects, internships, hackathons, and any job where you touched data, even without an "analyst" title. Start from a clean, ATS-friendly data analyst resume template rather than a heavily designed one, list a certification like Google Data Analytics to show initiative, and write each bullet around the decision or outcome your analysis supported.
What should a data analyst resume look like?
Clean, one page (unless you're senior), and skimmable in 30 seconds: reverse-chronological format, a short professional summary at the top, a grouped skills section (databases, languages, visualization tools), and experience bullets that contain numbers — percentages, hours saved, records processed. Use a standard font, simple headers, and no photos, graphics, or multi-column layouts that break ATS parsing. Browsing a few data analyst resume examples online helps you calibrate formatting and language, but always tailor the final version to the specific posting instead of sending one generic file.
What data analyst resume skills should I include?
Mirror the job descriptions you're targeting, but the core data analyst resume skills for US roles are: SQL (non-negotiable), Excel including pivot tables and lookups, one visualization tool — Power BI or Tableau — and Python or R for analysis. Layer in statistics basics like A/B testing, data cleaning, and stakeholder communication. Hard skills get you past the ATS, but hiring managers screen for the applied layer — so demonstrate skills like translating business questions into metrics through your project bullets rather than only listing them in a skills row.