Hiring for Data Warehousing Architect in Delhi/NCR, Mumbai for Exp. 14 - 20 yrs at Engage IT Manpowe (Chennai Job)
Reply to:(Not Shown) (Please mention ChennaiClassic.com when contacting)
Job Description: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 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.