Data Warehousing Architect

Skills Required

- Extensive knowledge in T-SQL programming

- Expertise in ETL Development experience using SSIS packages.

- Expertise in SSRS Report Development Experience.

- .Net for writing script tasks in SSIS packages

- Building Cubes using SSAS

- MSSQL database administration

- MYSQL database administration

- Data Visualization Skills

- Expert in implementing Data warehousing concepts

Job Responsibilities

- Provision MSSQL & MySQL instances, both in clustered and non-clustered configurations

- Ensure performance tuning, security, and availability of databases

- Prepare documentations and specifications

- Handle common database procedures, such as upgrade, backup, recovery, migration, etc.

- Profile server resource usage, optimize and tweak as necessary

- Collaborate with other team members and stakeholders

- Participate in the analysis, design, development of SQL Server DB programs, SSIS, SSRS tools

- Ability to decompose / translate business requirement to technical design and be able to design database objects which are scalable and flexible for change

- Sound knowledge & Expertise of Database development including developing Stored Procedures, functions etc.

- Design layout of SSRS reports and determine the best way to present data to end users

- Good understanding of data-modeling concepts

- Develop SSRS reports and dashboards using Microsoft Reporting Services utilizing SQL Server 2012 and above

- Strong SSIS skills and experience in dealing with heterogenous data sources. Good knowledge in .net for performing script tasks in SSIS packages

- Extensive knowledge working in SSAS Tabular models and needful reporting experience in SSAS

- Fast adoption of new tools and techniques

- Work on cross-functional solutions, from requirements gathering, solution architecture, development and implementation

- Design and deliver software as part of cross-functional teams

- Ability to write shared and reusable code

- Implement and enhance sophisticated real-time enterprise data integrations

- Design and implement data management solutions that support scalable, highly performing systems

- Work within a modern DBMS environment to ensure [24]7s applications and support staff have reliable and accurate data supplied to them at all times

- Lead technical communications with other teams, both internal and external

- Develop and maintain application documentation

- Should possess strong non-technical skills including, but not limited to, problem-solving, work prioritization, communication, self-direction, and time management.

- Contact Center / BPO Domain knowledge

- Understanding of Database Query Performance tuning & optimization

- Good communication skills, able to work independently on ETL tasks, including data-analysis and documentation.

- Should be knowledgeable about loading various DIMs/FACTs load using SSIS packages.

- Should have worked with different sources like files, web services, and database systems.

Karthik
Manager - Senior Level and Leadership hiring