View Our Website View All Jobs

Datawarehouse Developer

Competencies(Technical)

Expert T-SQL skills

a.       Write stored procedures that pass parameters and return values.

Writing complex queries, CTE, Sub Queries, use of Temporary Tables, Date, String Functions, stored procedures
Ability to create Stored SQL objects, validation and deploy the process

Query optimization

d.       By optimizing the queries, Query Execution Plan

e.       Adding indexes to the object

Good knowledge of Multidimensional Tabular model

Able to create cube Process
Optimize cube, use of Partition

Ability to create data warehouse, data mart end to end

data modelling (ERwin)
Create end to end ETL process (SSIS, SSAS)
Slowly changing dimension
Database security
Read execution plan and optimize

SSIS

Able to use majority of the transformation within SSIS, SSAS
Parallel processing, Debugging, Event handlers, Deployment

TFS

Understand the use and purpose of TFS
Code check in , check out
Create task and reporting

 

DBA Knowledge

r.        Backup- Restore, Creating Filegroups, Creating Link Servers

s.        Appropriate selection of database objects and data types


 

Competencies (Non-Technical):

1.       SME of IT Solution/Software

a.       Give technical presentations/solutions

b.       Engage in discovery sessions to shape complex technical solutions

                                                               i.      Document solution

                                                             ii.      Create Estimate of solution

                                                           iii.      Recourse solution

2.       Business Acumen

a.       Understand Stakeholder business, Industry + Environment

b.       Able to speak professionally/intelligently with Directors and below

3.        Leadership

a.       Welcome responsibility

b.       Take ownership

c.       Delivery purposeful, strategic and resourceful way

d.       Embrace change

e.       Cultivate passion, creativity and sense of adventure

f.        Practice self-awareness, self-management, social awareness and relationship management

 

 

Read More

Apply for this position

Required*
Apply with Indeed
Attach resume as .pdf, .doc, or .docx (limit 2MB) or Paste resume

Paste your resume here or Attach resume file

150