Software Developer - Data Analytics - Ssrs/ Ssis

Disha HR Services Pvt. Ltd
  • Mumbai
  • Confidential
  • 7-11 years
  • 31 Aug 2015

  • Project/ Program Management IT

  • IT/ Technology - Software/ Services
Job Description

Principal Responsibilities

Data steward will be responsible for data quality / cleansing, de-duplication and harmonization of data across the various source systems.

Automate end to end data validation and data loading solutions using SSIS ETL packages.

Develop & Implement and manage data strategies that optimize the data quality to improve standardization.

Maintain and create the data governance standards, rule books and metadata to support current master and transactional data.

Manage process activities to support conversion of data from multiple source system to consolidated system.

Identify the patterns and frequency of the data in the dataset and prepare the reports.

Manage the data quality audits/rules and generate the reports.

Convert business rules into technical rules for data quality analysis.

Report data quality/integrity issues to the business users , identify root causes and provide solutions

Create, define and maintain the documentation representing data validation processes and data elements across multiple systems.

Writing SQL code (stored procedures, triggers, database scripts) to implement business logic and database maintenance.

Develop queries and stored procedures for data extraction, using SQL queries and one or more relational databases such as SQL Server/Oracle/MS Access.


Work Experience (Years, setting, etc.)

Experience with SQL Server 2005/2008, Oracle 10g/11g, MS Access 2010

At least 4+ to 8 years of Experience in writing complex SQL queries, designing, developing, debugging and deploying SQL Server stored procedures.

At least 4+ years of solid experience on MSBI tools.

At least 3+ years of demonstrated experience in working with data quality, data validation and data governance initiatives.

At least 3+ years of experience in providing data analysis, identifying data related issues and business needs and providing practical and workable solutions.

Understanding of how data is used within business processes and its impact on desired business process outcomes.


Bachelors degree in Computer Science, MIS, Mathematics or other related degree

Fluent in English both spoken and written

Major Skills (Technical & soft skills)

Ability to design complex SQL Queries

Strong understanding of data flow and governance

Strong Analytical skills

Superior interpersonal skills. Ability to talk with individuals and groups about their needs and ask the right questions to surface essential information

Ability to communicate effectively in a multicultural, multinational environment

Demonstrates a strong customer orientation

Demonstrates cross-functional expertise and the ability to thrive in a highly complex environment

Superior problem solving ability

Ability to work independently and with a team

Proficiency in Excel

Job Posted By

About Organisation

Disha HR Services Pvt. Ltd