MSBI Data Developer

MS BI Data Developer

Role ID

MS BI Data Developer

No of resources

1 position

Years of Experience

6-8

Work Hours

2:30 PM – 11:30 AM IST  

Technology

Mandatory

·         Should have minimum 6 years of experience in the field of IT and Database mainly on SQL Server.

·         Understanding of database design (DDL, DML), transactions, CTEs or temp tables, bulk inserts, link servers, indexes, keys, joins, cursors, query optimization, write sql queries, stored procedures, views, data import etc.

·         Data centric applications background, sql programming, ETL programming

·         TSQL, Data Warehousing, Python, Perl, UNIX Shell scripting, TWS, Bitbucket, TFS, JIRA, Git, SSRS, SSIS, SnowFlake, AWS

·         Excellent communication skills

Job Description

·         Build ETL data pipelines to consume data and manage existing data warehouses.

·         Develop custom database objects, stored procedures, functions using SQL.

·         Implement data enrichment using different sources of data.

·         Analyze datasets to resolve discrepancies and ambiguities. Improve data quality and build out frameworks for reporting.

·         Data Migration from On-Prem databases to SnowFlake DWH.

·         Collaborate with business stakeholders to transform functional requirements into technical implementations

·         Good communication, presentation, and Problem-Solving skills.

·         Flexibility to work in UK/US hrs.

Soft Skills

Soft Skills

·         Good analytical skills

·         Good Interpersonal skills, written & verbal communication skills

Yogesh BN

8951854028

Yogesh.bn@capco.com