.NET Development, SSIS Expert

.NET Development, SSIS Expert at codersbrain · Gurugram · 4 - 6 years · ₹6L - ₹10L / yr · Bootstrapped · Posted 6 May 2023

.NET Development, SSIS Expert

at codersbrain

Posted by Aishwarya Hire

4 - 6 yrs

₹6L - ₹10L / yr

Gurugram

Skills

.NET

ASP.NET

SSIS

SQL Server Reporting Services (SSRS)

SQL Server Analysis Services (SSAS)

SQL Server Integration Services (SSIS)

SSAS

XML

OLTP

OLAP

SQL

MS SharePoint

T-SQL

Manage different versions of complicate code and distribute them to different teams in the organization utilizing TFS.
Develop an ASP.Net application to input and manage a production schedule, production statistical analysis and trend reporting.
Create routines for importing data utilizing XML, CSV and comma delimitate files.
Filter and cleanse OLTP data with complex store procedures and SSIS packages in the staging area.
Develop a dimensional database and OLAP cube using SSAS for analysis, maintenance and good customer service.
Involve in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
Extract the data from XML and load it to dimensional model.
Maintain SQL scripts, indexes, complex queries for data analysis and extraction.
Create advanced reports like dashboard and scoreboard using SharePoint and power pivot for better presentation of data.
Create cubes in SSAS reports which require complex calculations such as calculation of the premium for a particular policy.
Create SharePoint sub sites, lists, libraries, folders and apply site permissions according to the given requirement.
Work with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
Develop T-SQL functions and store procedures to support complex business requirements.
Create and configure an OLTP replication database for disaster recovery purpose.
Designed/Implemented/Maintain OLAP servers and processes to replicate production data to the server.

Manage different versions of complicate code and distribute them to different teams in the organization utilizing TFS.
Develop an ASP.Net application to input and manage a production schedule, production statistical analysis and trend reporting.
Create routines for importing data utilizing XML, CSV and comma delimitate files.
Filter and cleanse OLTP data with complex store procedures and SSIS packages in the staging area.
Develop a dimensional database and OLAP cube using SSAS for analysis, maintenance and good customer service.
Involve in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
Extract the data from XML and load it to dimensional model.
Maintain SQL scripts, indexes, complex queries for data analysis and extraction.
Create advanced reports like dashboard and scoreboard using SharePoint and power pivot for better presentation of data.
Create cubes in SSAS reports which require complex calculations such as calculation of the premium for a particular policy.
Create SharePoint sub sites, lists, libraries, folders and apply site permissions according to the given requirement.
Work with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
Develop T-SQL functions and store procedures to support complex business requirements.
Create and configure an OLTP replication database for disaster recovery purpose.
Designed/Implemented/Maintain OLAP servers and processes to replicate production data to the server.

Users love Cutshort

Read about what our users have to say about finding their next opportunity on Cutshort.

Shubham Vishwakarma

Full Stack Developer - Averlon

I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.

Companies hiring on Cutshort

About codersbrain

Founded :

2015

Type :

Services

Size :

100-1000

Stage :

Bootstrapped

About

Coders Brain is a global leader in IT services, digital and business solutions that partners with its clients to simplify, strengthen and transform their businesses. We ensure the highest levels of certainty and satisfaction through a deep-set commitment to our clients, comprehensive industry expertise and a global network of innovation and delivery centers. We achieved our success because of how successfully we integrate with our clients.

Shreya Trivedi

Connect

Company social profiles

Similar jobs (2)

MSBI Developer

Posted by Akash Bhatt

Delhi, Gurugram, Noida, Ghaziabad, Faridabad, Kolkata, Mumbai

2 - 12 yrs

₹5L - ₹22L / yr

SSIS

Microsoft SSRS

SQL server

Data Warehouse (DWH)

We are looking for an MSBI Developer to build ETL and reporting solutions on the Microsoft BI stack.

Responsibilities

Build ETL packages in SSIS
Create reports in SSRS and cubes in SSAS
Write and optimise T-SQL queries and stored procedures
Maintain the data warehouse and its data quality

Requirements

2+ years with SSIS and SQL Server
Good T-SQL and data warehousing skills
SSRS or SSAS experience

We are looking for an MSBI Developer to build ETL and reporting solutions on the Microsoft BI stack.

Responsibilities

Build ETL packages in SSIS
Create reports in SSRS and cubes in SSAS
Write and optimise T-SQL queries and stored procedures
Maintain the data warehouse and its data quality

Requirements

2+ years with SSIS and SQL Server
Good T-SQL and data warehousing skills
SSRS or SSAS experience

Business Intelligence Analyst II

Posted by Naveen Dominic

Bengaluru (Bangalore)

5 - 15 yrs

Best in industry

PowerBI

SQL

SQL Server Reporting Services (SSRS)

SQL Server Analysis Services (SSAS)

Business Intelligence Analyst - 2

Planview is the world leader in enterprise software planning for enterprise-wide deployment strategies, processes and resources. More than 4000 customers, among the world's largest and most respected companies, have successfully implemented Planview software to optimize their enterprise portfolio management, project, portfolio and resource management, business intelligence and expense tracking processes. We have had stable, organic growth for years and now need reinforcement.

Job Summary:

The Planview BI Team is seeking an experienced Business Intelligence Analyst – 2 to support, troubleshoot, optimize, and enhance business intelligence and reporting solutions built on Planview products.

This role focuses on advanced BI support across Power BI, Microsoft Fabric, SQL Server, SSAS, SSRS, OData, Dataflows, Data Pipelines, Data warehousing, and Data models. The BI Analyst – 2 will handle complex technical issues, perform advanced root-cause analysis and performance tuning, and work closely with customers and internal teams to deliver scalable BI solutions.

Key Responsibilities:

· Troubleshoot and resolve complex issues involving data accuracy, refresh failures, report behavior, connectivity, security, and performance across Power BI, SSRS, SSAS, SQL Server, OData, and Data warehousing layers.

· Perform advanced T-SQL development and performance tuning, including execution plans, indexing, query optimization, stored procedures, views, and complex queries.

· Support, develop, maintain, and optimize Power BI semantic models, DAX measures, Power Query, datasets, workspaces, gateways, refreshes, and Row-Level Security.

· Support and troubleshoot SSAS Tabular and Multidimensional models, including processing, calculations, relationships, security, and performance.

· Develop and troubleshoot advanced SSRS/paginated reports, including parameters, subreports, drill-through, expressions, pagination, subscriptions, and export formats.

· Support Microsoft Fabric solutions including Data Pipelines, Dataflows Gen2, Lakehouse/Warehouse, semantic models, and Power BI integration.

· Troubleshoot ETL/ELT processes, data pipelines, Dataflows, refresh failures, and data transformation issues across BI environments.

· Analyze and troubleshoot OData feeds, including filtering, pagination, refresh, connectivity, and large-volume data scenarios.

· Support Planview Automart, Datamart, and data warehouse implementations and ensure data consistency across source, warehouse, semantic, and reporting layers.

· Perform end-to-end root-cause analysis and performance optimization across the BI technology stack.

· Collaborate with customers, Product, Engineering, Hosting, and Support teams on complex technical issues and escalations.

· Provide technical guidance and mentoring to BI Analyst – 1 team members and contribute to BI best practices and documentation.

Required Skills & Qualifications:

· 5+ years of professional experience in Business Intelligence Development, BI Support, Data Analytics, or a related field.

· Strong hands-on experience with Power BI, DAX, Power Query, and enterprise data modeling.

· Advanced knowledge of SQL Server and T-SQL, including query optimization and performance tuning.

· Strong experience with SSRS and enterprise reporting.

· Experience with SSAS Tabular and/or Multidimensional models.

· Experience with Microsoft Fabric, particularly Data Pipelines, Dataflows, Lakehouse/Warehouse, and Power BI.

· Experience working with OData and enterprise data integration.

· Strong understanding of Data Warehousing, Datamarts, Automart, ETL/ELT, and data modeling.

· Experience troubleshooting Power BI Service, gateways, refreshes, security, and semantic models.

· Strong analytical, troubleshooting, and root-cause analysis skills.

· Proven ability to work directly with customers and communicate technical concepts to both technical and non-technical stakeholders.

· Experience with tools such as DAX Studio, Tabular Editor, Performance Analyzer, Query Store, or SQL Profiler is an advantage.

Relevant Microsoft certifications such as PL-300, DP-600, or DP-203 are an added advantage.