View Our Website View All Jobs

Datawarehouse Developer


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


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


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

Apply with Indeed
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file