Sr. DB Resource (CUBE & DW)

Apply Now

Company: Damco Solutions

Location: Plainsboro, NJ 08536

Description:

Basic Skills:
  • Strong in SQL, data modeling
  • Able to create and deploy measures in Cubes, authentication & permission on CUBE level
  • Process the cube structure with refreshing the data, blank column in dimension and various options
  • Hand on experience on Tabular or Multidimension CUBE
  • Strong problem-solving and attention to detail to ensure data accuracy and performance
  • Use tools like SSIS, SSMS, SSAS and other ETL tools
  • Developing procedures / functions / views.
  • Work closely with developers.
  • Extensive Knowledge of Software Development and Testing Lifecycle (different Testing Models)
  • Adequate Test Delivery Experience to understand the criticalities of different Testing phases
  • Scrum / Agile framework knowledge is mandatory.
    • Behavioral Competency :
  • Individual contributor
  • Focus to deliver results with quality , accuracy, and technical understanding
  • Good verbal and written communication skills
  • Client interaction exposure

    • Screening Questions

    Cubes:
    • Which kinds of cube you have created so far?
    • What are the steps to create a cube?
    • Slicing and dicing in cube? (should know about how to make a cube scenario or parametrized.)
    • How to implement authentication on Cube level?
    • How to restrict a user to cell/row level in cube level?
    • How to deploy a cube? (different type of ways she/he should know)
    • How to process a cube (must knowledge about the option/properties, must be on granular level)?
    • How to process the cube structure with refreshing the data?
    • How to add a blank column in a cube? What are the steps?
    • If you add a blank column in dimension, then how to reflect it in a cube? What are the various options for that?
    • Which type of model you are using in your project (Tabular or Multidimension)?
    • Cube Processing is taking long time, what are the various way to fix it?
    • How do you change the data type format in a cube?

    Dimension/Fact/Datawarehouse/SQL Server
    • What are different types of dimensions you used in your project?
    • How many dimensions are there in your project and their usage?
    • What types of values do you store in fact tables? How many tables are there in your project and their significance?
    • What is scd and its type and how do you use it in your project?
    • How SCD will call?
    • What are synonyms in SQL Server?
    • How to first non-null values in sql?
    • How to convert/replace a value as null?
    • How to search for an alphabet in string and replace it?
    • Row _number in sql server?
    • How to concatenate multiple columns values into comma separated string?
    • How to convert columns into rows?
    • Few queries based on substring function SQL Server.
    • Can we use order by in Views in sql server?
    • If not, how can we sort data in a view?
    • If we have junk data or alpha-numeric value in a fact table column, how to handle it, so that it will not impact your cube.

    Similar Jobs