Hi fishes, I am going to have a interview with TransUnion, entry level operational analyst.
The next interview will be a technical interview which includes a test on basic SQL, excel.
Could you give me any advices to prepare for the interview? I have no idea what it will be, what question will be asked.
By now, I prepare the pivot table, Vlookup, etc. for Excel, and I am trying to finish all easy level of SQL at Leetcode. What else should I prepare? Are they going to ask me the defination?

like
Posting as :
works at
You are currently posting as works at

If it's a basic SQL test then I think finishing the easy leetcode will be enough. For excel, maybe other formulas like SUMIF, XLOOKUP, and hard coding values?

like

Awesome. Thank you for sharing. I appreciate your answer :)

I think you are on the right track! I think they might ask you the definitions, but it shouldn't be a big deal. They probably want to see your ability with Excel and SQL.

like

Don't worry too much about it. Those will be just basic technical interview questions. Don't think too much. Just be confident and apply whatever you have learned. Also, try to prepare for behavioral questions. They might ask you kinds of questions out of nowhere. Good luck!

Thanks for all advice, I finished the easy level of leetcode yesterday, and I will keep practicing on Excel.

Related Posts

What’s anyone interviewed or exited to Via? Thoughts on the company ?

like

Hey fishbowls which is the better company to join ?? Trantor or Puresoftware?

like

How is BigID ( data privacy) profile in Morgan Stanley? Is it worth to change profile from capital market to data privacy? Morgan Stanley Capco BigID

Hi Fishes

I have offer with citi. But I have poor credit history/cibil score. Will citi check credit history too on background check and reject candidate?
I have another offer with TCS which will lapse by tomorrow if I don't agree.
Please share your inputs about citi's background check.

like

After asking for docs , how much days it will take in cognizant for further process ?
Please let me know

like

Hey everyone! This is my first time posting but I thought I’d try to ask, I received a request from a recruiter to interview for a new insurance company I’ve never heard of: Branch. Looked it up and it seems to be a new “Techsurance” company working with both home and auto policies. Does anyone have any information they could share about this company? Thank you!

like

Hi everyone,
I want to learn Salesforce Tableau CRM (formerly known as Einstein Analytics) and switch to a different organisation. In my current company stuck in a project where there's no learning scope, no growth and work culture is toxic. Now I'm only going through Trailhead, YouTube playlist videos and practicing hands on in my free personal org. Are these enough to crack interviews or not? I don't have real-time project experience.

like

Hi fishes,
Wanted to know what is the probation period in cognizant and what is np in tht probation. Joined cogni in sep. Please help. @cognizant

like

What are the Designation level at HSBC GSC for Hyderabad location. What is the band for Assistant Manager

Is it possible to transfer from CN India to Accenture Canada (if one gets a Canadian PR themselves)? How well is it taken by the leadership and is any kind of support provided?

likehelpful

Hi all, What is GPAD system in HSBC. Do we have to add our personal brokerage accounts in their systems? Please help HSBC India

like
like

Does SAP SDC provide any mobile phone device?

like
like

Howz Information Security engineer profile in Wells Fargo?

like

Out of Cognizant, persystent, Hughes Systique, Gspan, Which company should I join.
YOE 7+ and package is pretty similar in all companies Cognizant Persistent Systems Limited Hughes Systique Corporation Gspann

Hi All,
Can you please providw your input as to How is cognizant from learning perspective?

like

Hi Fishes,

Does anyone know about TCS Digitate? Can you share some reviews about it?

Thanks!

like

Hi fishes, what are some good work life balance and learning projects/ clients in epam anywhr for front end react profile?

like

More Posts

New to startup ecosystem. What are some resources, books, podcasts that help you along the way? Are there any communities you interact with regularly on Reddit/discord/meetup?

like

Hey TW,

Is there a HLD or LLD or both design rounds in java dev interview?

like

Hi. Anyone here works in finance in the UK? I'm moving there soon and I find salaries to be a bit low, e.g., £30K. Is this the norm?

I have a little over 1 YOE with a Bachelor's in Finance and soon a Master's. Thanks.

like

Joined this week. What can I expect from Mr V

like

Any recommendations for good improv clubs, places that teach comedy writing, or joke writing resources in general? Trying to punch myself up while we’re still WFH.

like

Can someone walk through a general day-to-day if an in-house employment lawyer? Thanks in advance!

like

Any thoughts on how to start writing a memoir or finding people to work with free? Also - how can we gain more speaker opportunities? And is it something specific and focused or can it be generally motivational?

like

Do NOT claim you are "colorblind" in the workplace. 1. DE&I knowledge is now a core leadership competency. Colorblind claims will earn you the reputation of being DEI-ignorant at best & racist at worst. 2. Colorblindness within the context of workplace diversity is an obvious lie. You do NOT want to be painted as an intellectually dishonest leader. 3. Colorblind claims signal that you lack the leadership skills & vocabulary to have key conversations. Ask questions here, in this safe space.

Post Photo
likesmart

Hi folks, i am looking for a job change i have 2.6 yoe in data engineering with tech stack - hive, hadoop, pyspark, sql, python , aws. These days i am not getting much calls. I worked for x company for 2 yrs and switched to y company in feb 2022. But recently i faced a situation. I cleared all rounds and send my docs to sunlife financial but now when i am trying to connect with them they are saying your candidature is on hold. I alao resigned from my current company. What should i do?

like

I once ate all the square chocolate pieces from my boyfriend’s packaged granola at midnight and he thought he got a defect product

funnylikesmart

I hate it when I'm shopping for dresses and I see one that's really cute, only to find out it's a romper

likefunny

Guys anybody from Verizon have received the hike percentage for performing rating. I think this year also they won't adjust the package with market standards. ? Can anyone throw some light on this. For last 2 yrs i am receiving performing and also manager haven't initiated the mts 3 promotion. Please share a way to get a hike than getting only 10 percent

Offered a referral from someone at Deloitte but haven't heard back in 10 days since sending the job posting as they asked. I sent a follow-up email that has been read but still no reply.

Would anyone be willing to offer a referral for a Human Capital/Digital transformation position? I am worried the position will be filled as it has been posted for a month! Any leads would be appreciated and as always I am willing to sit down and chat with anyone!

like

Hi Everyone! Happy Friday! I’m new to Fishbowl. I’m an experienced EA with a diverse background seeking a new role with competitive compensation and benefits. I’m located in South Florida but I’m open to remote, on-site, or a hybrid position. Feel free to reach out and connect!

like

Has anyone ever successful negotiated there salary with the federal government. I have tried twice and both times was cited a HR policy saying my specific circumstance did not allow negotiation. Just wondering if it’s even possible

like

Looking for regulatory and statistical reporting roles within Pune.

How long before joining ADP Initiates onboarding process . My HR mentioned they will call one week before joining and share all details.

When and how do you push back on people senior to you? Fifth year dealing with supersenior associate (11th year) who completely lacks good judgment & common sense. One of those super smart but impractical types. As just one example, he recently called me to tell me to call someone who’s on vacation and ask them to send a calendar invite. I offered to send myself but apparently that wouldn’t work (presumably because it would be efficient & make sense.) At what point (and how) do I Just Say No?

like

FAANG PMTs salaries?
Looking to hear about PMT/ Sr. PMT / Principal PMT Salaries

like

Does anyone own an LV Capucines? My heart has been set on that for a while now but I see it’s prices keep going up, up, up! The one thing I love about the bag is the structured look and no over the top logo print. Does anyone have it and if yes, is it worth the investment? Also are there other LV bags that do not have the visible LV prints?

like

Additional Posts in Career Advice for Students

Any Walmart ASM(Assistant Store Manager) here? Current or ex? Want to move forward but feels stuck in retail.

Taking the NY bar for the first time. Is it fine to take it from the work laptop because personal laptop seems to be giving up in life! Please guide any pros or cons. Thanks !

like

Any thoughts on how to start writing a memoir or finding people to work with free? Also - how can we gain more speaker opportunities? And is it something specific and focused or can it be generally motivational?

like

Looking to get into the Finance, Consulting, or Business Analytics field as an entry level (graduating in December 2022) and would really appreciate if people could refer me!

Post Photo
like

Hey guys! I’ve been getting emails from Cisco every week to fill out a form to ask if I am still interested for security solutions spring internship. I’ve clicked Yes each time but I never get contacted for anything further. Should I be holding out hope for Cisco or should I move on? @cisco

like

🥱🥱 you can’t never trust nobody

Post Photo
like

Hi all, my name is Alex and I just joined the bowl :)
Im graduating in may with a BS in Industrial Engineering. Ive also held a Data Analyst Internship for 1 year with a small construction company. Anyone have advice where this combination of education and experience would make me most competitive in terms of roles/companies?

like

3L with mostly A’s and B’s. I am having the worst luck trying to find work for after school and my experience working with lawyers has left me completely dejected. I cannot get an interview to save my life. I was so excited to get an externship summer after 2L with a small business and IP firm only to get yelled at on the phone a few times for not doing an assignment correctly. Mind you, I was working FOR FREE as it was a school connected externship. That made me never want to work in the law.

like

Hi, where or what types of companies should sophomores & juniors apply for next summer (2022) to recruit for IB the following summer (2023)? This summer BBs wrapped up SA IB recruitment, EBs even earlier, and a fair amount of my friends missed out big time.

Also, if a sophomore or junior doesn’t get a finance-related summer internship (I.e tech) and aims for an IB SA or FT position, is it harder to break in?

Appreciate any advice and insight, thank you.

like

I received an offer for a mid-large size consulting firm at $80k with a $10k signing bonus to be an associate consultant. Is this industry norm- high? Low? I have no clue as it is my first offer and unsure whether to accept it or negotiate

like

I am a graduating senior with a CS degree about to start my job in IT (low code, mostly using data tools) at a biotech company. My goal is to be a solutions architect within the next few years. Besides sol. architect cert and other AWS certifications, what can I do to put myself on the path to becoming a Solutions Architect ASAP?

like

Looking for remote entry level business analyst positions! If you or anyone you know is hiring, please let me know.

Since I can’t really post anywhere else rn lol, I’d love some feed back on this offer I received. It my first one for a pr account coordinator in nyc: 45k, pto 17 days (but doesn’t start until next year) and thats pretty much it. I have 1 yoe + master’s and I plan to negotiate but working out how much

like

Trying to get a second job does anyone know how this works. It says part time but the schedules looks full time some help please. Thanks

Post Photo
like

Hello! I’m wondering if anybody has any advice in getting into HR? I graduated in 2020 with a degree in psychology and had a temporary internship in HR which didn’t teach me much. I have experience in customer service, sales, counseling etc. Any advice on roles and/or fields that would kickstart a career in HR? Thanks!

like

Hi. I’m an incoming masters in business analytics student at MIT and am looking for summer 2022 internships as an analyst in a tech company. I have worked as an engineering analyst for about a year. Any suggestions on how to prepare for interviews are welcome and maybe we could also do a coffee chat.Thank you

like

What’s the culture like at FTI Consulting?

like
like

Anybody know what the average salary, and low end salary is for Investment Analyst at Cambridge Associates

I️ am pursuing a Product Management Internship in Big Tech for next summer. I️ am comfortable reaching out to people to network and know who to reach out to. However, I️ have not found the convos to be all that helpful. Any advice on how to make these convos useful?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal