View Our Website View All Jobs

Sr. Data Warehouse Developer

Why Join Exsilio? 

Exsilio team members enjoy the benefits of a fast-paced dynamic work environment, while maintaining healthy work-life balance . Were energetic bunch of techies who love enabling tomorrows enterprises . 
Exsilio's success is grounded in the perfect balance of size and ability, we have the capacity to expertly handle many large enterprise accounts. Our teams carry with them an arsenal of diverse, expert knowledge and fierce dedication to the success of our customers . We're committed to the idea of getting in the trenches with our customers and understanding their business to achieve the best results.

Working at Exsilio isnt only about working on projects, we always look for opportunities to stay active in the industry whether it be participating in design competitions and hackathons or showcasing your talents in videos, podcasts or blog form . This position works scheduled hours from our office located in Ahmedabad, Gujarat .

Youre a rockstar, let us give you a stage!!

As a Sr. Technical Consultant at Exsilio, you will have an opportunity to develop, test and implement mission critical enterprise solutions. This employee will perform custom application development using advanced components of the Microsoft technology stack , including web services, enterprise portals and mobile applications.
Developers at Exsilio provide professional consulting services on major enterprise initiatives utilizing Microsoft technologies and modern delivery methods.

Job requirements: -
Expert T-SQL skills

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
By optimizing the queries, Query Execution Plan 
Adding indexes to the object Good knowledge of Multidimensional Tabular model
Able to create cube Process g. Optimize cube, use of Partition Ability to create data warehouse, data mart end to end h. data modelling (ERwin) 
Create end to end ETL process (SSIS, SSAS) 
Slowly changing dimension 

Database security

Read execution plan and optimize SSIS, SSAS
Able to use majority of the transformation within SSIS,SSAS
Parallel processing, Debugging, Event handlers, Deployment TFS 
Understand the use and purpose of TFS p. Code check in , check out 
Create task and reporting 

DBA Knowledge

Backup- Restore, Creating Filegroups, Creating Link Servers 
Appropriate selection of database objects and data types 

Interpersonal Skills:
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