April 25, 2014 at 3:58 am
Just seen this advert for a SQL Developer, and was interested to know what the general opinion on what they are asking for was, does anybody know all this and be half decent at any of it at the same time?
Required Skills
Expert Level SQL Server Inc., database design, T-SQL, stored procedures (up to SQL Server ver 2012) Microsoft SQL BI Tools (SSRS, SSIS)
Dimension Modelling - Kimball Methodologies
Required Skills
Intermediate+ Level Microsoft SQL
BI Tools - SSAS MS Sql server performance tuning, optimization
Microsoft.NET/w C# as primary programming language (up to framework ver 4.5)
ASP.NET, MVC and WebAPI
Web technologies (HTML, CSS, JavaScript, jQuery)
SOAP and REST Web Services using WCF TDD/BDD + Agile, Scrum & Kanban
Microsoft WebForms and WPF
Required Skills
Basic+ Level Oracle/PL/SQL
Desirable Skills
SQLLite
MS Access
Data Visualisation Tools
Splunk, Tableaux, Qlikview Informatica UM, RulePoint, PowerCenter
Job Schedulers - Autosys, Control -M
April 25, 2014 at 4:02 am
Looks more like a wishlist than requirements to me.
😎
April 25, 2014 at 4:07 am
Well, for some reason 'Required Skills' is listed 3 times, so they obviously want all those. I just don't see how anyone can be good at all those things to a decent standard. If I see a job desc, and I don't have everything on it, even if its one thing, I don't apply. Is this the wrong approach?
April 25, 2014 at 4:14 am
Are these all for the same job? (why is Required Skills listed 3 times?)
The first and second one explicit mention Microsoft SQL Server, but the third one asks for Oracle...
If your good at TSQL, you can also write basic PL/SQL. You can google for the differences when you need it.
The first one says SSIS and SSRS for BI tools, while the second also drags SSAS into the picture.
ASP.NET, MVC and WebAPI
Web technologies (HTML, CSS, JavaScript, jQuery)
SOAP and REST Web Services using WCF TDD/BDD
Microsoft WebForms and WPF
--> those are not necesary for a SQL/BI developer. Unless they plan to create custom web visualizations.
These requirements seem geared towards a BI developer, not just a SQL developer. Especially Kimball and all of the different data visualization tools in the desired skillset indicates this. By the way, which company uses all of those visualization tools at the same time? You either have QlickView or you have Tableau, otherwise you are just throwing money away and confusing end users. It looks like they took a look at the Gartner BI Magic Quadrant and just picked the highest vendors to include in their list.
I have been working with BI for over 5 years now, and I haven't used most of these tools yet.
It seems this was created by a very inexperienced recruiter.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 25, 2014 at 4:19 am
Yes, believe it or not it is for the same job. I don't know why 'required skills' are listed 3 times, I copy and pasted it straight from the description.
April 25, 2014 at 4:23 am
Another job I wouldn't qualify for. The T-SQL and basic Pl-SQL are fine, however I don't meet any of the front end coding requirements.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 25, 2014 at 8:34 am
We should have a purple squirrel emoticon. 😉
April 25, 2014 at 11:17 am
FWIW I just landed a job like that where I lacked all the front-end skills. They asked for the usual SQL stuff plus ASP.NET, C# and other front-end stuff. I had plenty of the former but not much of the latter. I got hired anyway and spent the first few weeks learning ASP.NET as I worked on an enhancement for one of their websites!
Now I'm on my way to being a journeyman ASP.NET dev as well.
The Moral: Apply anyway, emphasize your strengths. If you get an interview, play to your strengths but be candid about your weaknesses.
April 25, 2014 at 11:19 am
gbritton1 (4/25/2014)
FWIW I just landed a job like that where I lacked all the front-end skills. They asked for the usual SQL stuff plus ASP.NET, C# and other front-end stuff. I had plenty of the former but not much of the latter. I got hired anyway and spent the first few weeks learning ASP.NET as I worked on an enhancement for one of their websites!Now I'm on my way to being a journeyman ASP.NET dev as well.
The Moral: Apply anyway, emphasize your strengths. If you get an interview, play to your strengths but be candid about your weaknesses.
I agree with that. I was candid about my weak areas in my last interview and got the job over a more "qualified" candidate.
April 25, 2014 at 11:47 am
When you say 'candid'...? Not sure how that is.
April 25, 2014 at 11:51 am
Duran (4/25/2014)
When you say 'candid'...? Not sure how that is.
For example, when I was asked if I knew C#, I said I did not. Because it's true. I was also candid that I do not know XML, just broad conceptual strokes. I will have to pick up both as I go. But I also demonstrated my genuine enthusiasm for the platform and my desire and ability to learn. I guess that made a big difference to them. Or maybe they were looking for someone "mold-able".
In any case, I don't lie in interviews. I refuse to say "Yes, I know that" when I don't. You always get caught.
April 25, 2014 at 11:54 am
They are likely looking for more than one person and wanted to save time and effort on the job spec, so threw it all in there...
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);April 25, 2014 at 2:10 pm
SQL is delicious (4/25/2014)
Duran (4/25/2014)
When you say 'candid'...? Not sure how that is.In any case, I don't lie in interviews. I refuse to say "Yes, I know that" when I don't. You always get caught.
Same here, some people can do it, but I just feel uncomfortable and would not get over the on-the-job humiliation when I'm asked to do anything.
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply