Has anyone done data mapping using SQL? That’s gonna be my first project and I’ve never done that before. What has everyone’s experience with it been like?

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

I think maybe I misunderstood what they said. I havent started the project yet but they told me data mapping and I’ll be using a lot of SQL. I thought that meant using SQL to data map

like

So you might create data maps through a data governance tool or even simply through excel
They prob said you’d use SQL to create test cases and perform validation

like

Data Mapping is data management mostly. Just do all those concepts

like

Hm not sure I understand why you’re doing data mapping in SQL, as SQL is simply a language to query information from.
Are you being asked to use SQL-like logic to create a data model? Or use a specific tool like Snowflake or SQL Server to support governance? Or something else?
I’ve done especially the former, but requires partnership with key stakeholders plus relevant IT teams to do it, and can require multiple iterations/refinements as you do more discovery and determine test cases.

I did not get the question either. Are you just trying to look if you have all the tables, columns and data available by executing queries and verifying schema?

They might have asked to dig into SQL code and prepare source to destination data lineage.

You’re talking about metadata. Don’t think you could do that with SQL. You could analyze a log file and understand how the data is being used? And maybe visualize it? It’s difficult to do without a data lineage tool.

Related Posts

Applied for product manager role in ecomm. But instead got offered tech project manager. Company is also in the middle of acquisition. I don’t have any offer in hand and i really want an out from current employer.

Would it be wise to take the alternate role?

like

I have a partner who routinely ignores emails or responds to them several weeks later. He has to approve every single document sent to the client or the court, which means you have a physically go to his office to ask him to review something. Half of the time you go to meet with him in person, he’s either on a call or otherwise busy. I find that this basically creates more work and makes meeting deadlines extremely difficult. Is this normal?

like

I applied to a lead project specialist role with Deloitte about a month ago and my app is still pending and waiting review. I’d asked an acquaintance for a referral prior to applying also. I tried to see if LinkedIn listed the recruiter for the role but don’t see any reference. Any recommendations for touching base? Did I get lost in the shuffle? I am a certified project manager with more than a decade of experience.

Guys, can you list down your experience in working with EY, which you are missing in your previous job. Or, something good at your previous job which is missing in EY. Please comment those. It can be anything like good project, managers, WFH, benefits, flexibilities, Hi, 

I want to cancel this 200Rs Netflix membership for this month. How to change this in my card settings, I am not able to find the settings in ICICI website to cancel this. 

like

Hello all, need some advice. Am currently working for a government consulting agency, but wishing to leave due to the way the project is being managed...I am in at least 4-5 hours of meetings a day, so barely have time to prepare for demos, preparation of slides for the client, nevermind being able to write decent stories(tickets)... Usually have to rush writing requirements, steps, etc, ...
So I have been looking around.
1/2.... Remainder of story in comments below.

like

Is there a special title at your company for a Project Manager that works on product development and not an IT project manager?

An example might include launching a new product from conception through form writing, rating, filing, programming, training, and implementation, or the transfer of products from an acquisitions writing company to ours.

like

I am a Client Executive with 7 years in the industry and 5 years of HR experience prior to that. I make 60k, am I underpaid?

like

In Management/Strategy Consulting practice in big4, has anyone been on or seen someone going for an onsite opportunity in long term project like in US/UK/Europe etc?

like

Hi All,

I joined
Tech Mahindra for 5 days only and didn't find suitable timing for my project and emailed resignation mail to manager and HR. After that HR asked me to resign over portal but at the same time blocked my portal. After requesting many times they didn't unblock my portal and pretended like they want to unblock but there is some issue going on and marked my profile absconded. I have cleared fnf but they are not providing reliving letter but added pf amount also. What to do?

like
like

My manager continues to ask me to help other teams and do work on other billable projects. I’m sick of it .. and I’m going to explicitly say that no I can’t do it because my hours are taken by the existing project we are doing. Is this appropriate?

like

Hi Folks,
I am working for NetApp Client, Bangalore however My base Location is Hyderabad, and I have heard from a couple of NetApp Employees that they are planning to resume offices by May.
My questions are:
1. If UST is planning to bring employees back to office?
2. If they call will I be asked to relocate to Bangalore as my client's location is Bangalore or will I be working from Hyderabad only?

PS: My manager has left the organisation and I am the sole person from UST in my project.

like

Hi Accenture people,
I have interview in Accenture today for Program/Project Management practitioner.
Any tips about Accenture interview process ??
It will be highly appreciated.

like

Hello everyone,I recently joined Cognizant and received an auto-assignment to a project ,I have project details and project id but no contact details . How to proceed further,the employee marked in CC are all hrs. How to know about project any Idea? Cognizant

like

Dad got laid off. Drinking got worse. Attempted assault on sis and mom. Had to put up in hotel. No clue on next steps (legal and personal). Project is complete shit show and SM is not getting it. Idk man...

like
like
like

2 YOE in project management at a CRO and now 1 YOE as an analyst in life sciences at Accenture. Kind of want to switch over to L.E.K. Consulting as a consultant. How much more experience would I need? Is it worth it to make the switch? Have a Master’s in Biotech as well.

like

More Posts

Getting an opportunity from KPMG UK Audit to join biggest asset manager in UK in Internal audit (with promise to rotate if I dont like it) and also with 30% uplift in pay and obv work life balance, worth it to go?

like

Hi There,

I am confused whether should look for a change now or not. Seeing the Recession coming.
Expertise - Functional / Manual Testing with 7 Years experience.
Would like to hear suggestion or advices please.

Anyone take the WI Real Estate state exam? Any tips on what to study?

like

Can someone please refer me to KPMG?

like

Hello desi fam...Anyone know wherr/how to get an iptv box in the Chicago area?.... thanks

like

Planning on getting married in a temple in the US. Does anyone know what all paperwork (eg marriage license, certificate, registration) I should be thinking about and how to get it done?

like

Looking for Indian store recommendations in NJ where I can find some desi style footwear (women) to go along with my lehenga for a wedding. I’m in Hoboken, but able to drive into the interiors. TIA!

like

Hello everyone,

I'm looking for remote opportunity as a reactJs developer.
YEO: 3

Any help would be appreciated.

So, I have always had jobs where I earned a base salary with the ability to earn commission and bonuses. But I've been told that I'm limiting my earning potential by not taking a commission-only role but this seems risky, especially since the economy is supposed to tank

like

Thoughts on Roland Berger’s Dubai office?

like
like

My boss asked me to submit my career aspirations after bringing in someone in a new position over me. Is this a bill shit assignment? Has anyone else ever asked to do this?

like

Any recommended books to read prior to beginning a summer associate position? Transactional/ Corporate & Finance

like

Help me with my struggle!

I'm in Oklahoma, and an avid Aldi shopper. Prior to COVID, my favorite merlot was routinely stocked there - under $6 a bottle and better than many $30 bottles I've had. It was by Burlwood Cellars. Sadly, supply chain issues have apparently done a number on Aldi's wine selection and it's not carried there anymore. I've searched high and low for a comparable merlot, but to no avail. So I need alternate suggestions or better still, somewhere I can buy my old fav.

I've been job searching for nearly 4 months.... started using fishbowl 3 weeks ago... this app is far superior to anything on the market.

likesmart
like

Hi all! I’m looking for recommendations for team building activities in Charlotte. In particular, activities for a smaller team. Located close to Uptown would be an advantage.

It’s been a while since I’ve done one so wanted to see what other people are enjoying these days!

like

Current situation: company A- was hired as a specialist and proved my worth to become a category manager but ended up on the low end of the salary range because of my lack of experience. Have voice my concern about my pay several times to my director, with no action in return.
Company B - Recruiter on LinkedIn approached me regarding a position open at an out of state healthcare facility for the same thing I do now, I would be working remotely where I currently am today. Cont in comments..

like

Thinking of starting my own real estate company in MO. Does anyone know what the market out there is like?

like

What's the best way to motivate a poorly performing intern?

like

Additional Posts in Data & Analytics Consultants

What are some interesting non-tech/insurance/advertising/consulting careers where data science is applied? Thinking of epidemiology and economics

like

If you were to hang your own shingle as a consultant what BI tool would you use to deliver dashboarding to clients?

Assume that you aren’t plugging in to source systems as I primarily work in CDD.

like

Anyone have recommendations on the best app/site to learn Python? 🐍
I’m a complete beginner.

like

Anyone have any tips or material on effective storytelling to leadership? I have to present an analysis and recommendation to a VP and really need to put together a good story. Thanks!

like

I have created Algorithmic Product/System for the client to take out inventory not-in-demand for long time to save storage expense and also provide an approach to prioritize Work Orders based on Market Demand. It’s more like an Manufacturing Plan. I want to get into Product Analyst/Lead role. What approach I should take? Any books to start with? Any events to attend? Any groups to join?

like

Has anyone else begun to resent data science?

like

I was hired a few months ago by D to do data science. I am not doing data science currently, is there a way I can switch roles internally? Should I talk to my coach? Or should I just start looking for a new job. I’m starting to feel that the field is so hot rn my small stint at D won’t be a big deal to other firms.

like

Anyone know of an alternative to StackOverflow for asking tech questions? The community is super toxic and I'm looking for a place I can casually ask questions that might seem dumb without being hrangued for not providing an essay proof of the research I've already done. Or some sort of buddy system where I can ping a person of relevant experience those questions. It's better to poke someone's brain for a minute than to spin in circles reading docs/dead end articles sometimes.

like

This might be a long shot ... but I have a Statistics assignment due for tonight in a few hours

Does anyone know how to do Linear Discriminant Analysis with more than one predictor - by hand? I know how to compute in R but my professor wants it done by hand .... fml

likefunny

Any recommended courses or books on customer care/cust success analytics or marketing analytics in general?

like

I'm planning to transition to Data Science. What should be the key technologies that i need to learn and add to my resume to make this work?

Thanks for your suggestions.

like

What are the top sales & marketing metrics that tech companies track? I have an interview for a Data architect role and the data aspect is my strength but need to brush up on the business insight part

like

Have you ever failed to deliver? What was it and why?

like

Learning cloud architecture right now so apologies if these are obvious questions: Best ways to store video metadata to perform analysis on it? I'm looking at AWS and GCP. Saw that Cassandra would be good for it, but not sure what the GCP equivalent is? But also I'm a bit confused on if Cassandra is just a DB and storage would need to be elsewhere? All help is welcome! I've been spinning my wheels on Google trying to understand

like

1) Hypothetically if you were looking to sabotage a colleague, can you code an excel document to throw off their numbers or calculations, (if you send them that document and they download it for use)?

like

Any conda users in here have to install a binary and use conda forge? Need some help installing pdftotext. Throwing a weird message saying “Found conflicts!” Any and all help would be appreciated.

like

Can anyone at Ford Motor Company tell me more about the “Learning Analytics and Engagement Specialist” remote position? Very curious and would love a referral!

like

It’s been ages since I’ve taken college statistics. Can anyone recommend an online course where I can review and brush up?

like

New data offering: name.co, or namesoftware.com for the main domain? I’m leaning toward name.co, but I worry about not having the .com.

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