Full Time

Tech Lead

Posted 2 months ago by 24/7 Customer Private Ltd
Bengaluru
Application ends: December 16, 2021
Apply Now

Job Description

Looking for a senior database developer with 6-8 years of experience in Microsoft SQL Server Database, SSIS, SSRS, SSAS, Python, Tableau as primary skill. The.Net skill is needed for writing script tasks in SSIS. experience in NOSQL DB will be an added advantage for the profile

Summary of essential job functions

Work collaboratively to do database design and development (involving extensive DB programming, .Net programming needed in SSIS, ETL (SSIS), Reports (SSRS), SSAS) to deliver projects collectively working with projects team.

Job Responsibilities

Participate in the analysis, design, development of SQL Server DB programs, SSIS, SSRS, SSAS 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.
Good understanding of data-modeling concepts
Strong SSIS skills and experience in dealing with heterogenous data sources. Good knowledge in .net for performing script tasks in SSIS packages
Good knowledge in Python for processing complex files, writing program and needful integration with SSIS.
Experience designing/implementingOLAPcubes usingSSAS
Experience inOLAPCubeand MDX query development
Fast adoption of new tools and techniques
Experience in developing dashboards using Tableau
Design layout of SSRS reports and determine the best way to present data to end users
Develop SSRS reports and dashboards using Microsoft Reporting Services utilizing SQL Server 2012 and above
Leveraging cubes in excel / SSRS tools for reports / dashboards.
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]7’s 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.

RoleSoftware Developer
Industry TypeBPO, Call Centre, ITeS
Functional AreaIT Software – DBA, Datawarehousing
Employment TypeFull Time, Permanent
Role CategoryProgramming & Design
Education
UG :Any Graduate
PG :Any Postgraduate
Doctorate :Doctorate Not Required
Key Skills
MDXReporting ServicesSSASCubeSSRSMS SQL ServerOLAPTableauSSISETL