Draw ETL processing Flow diagram to implement on such scenarios.
Perform Data Cleansing in a transformation level of data before dumping in warehouse.
Writing ETL procedures by using SSIS and MSSQL tools provided by Microsoft.
Generate dummy data for testing where the requirement is new.
Conducts ETL Unit and development tests. Monitors results and takes corrective action when necessary.
Managing ETL Jobs on Data Warehouse servers
Write BI reports Scripts for warehouse.
Write ad-hoc queries for user ad-hoc reports generation.
Design and develop transactional database reports on SSRS and MSSQL.
Deploy ad-hoc queries in respective tables and generate a default report with existing mechanism.
Develop database functions, scripts, stored procedures and triggers.
Creating or repairing indexing where required.
Create activity jobs for integration process.
Resolve daily bugs and errors on data or procedure
Provide training, troubleshoot and upgrade the system as the need arises.
To adhere to the organizational norms while working on different projects.

Monitoring & Verifying ETL Jobs and data
Coordinate with ETL team to deploy all ETL procedures for all new projects and maintain effective awareness of all production activities.
Provide support to all large data volumes and assist in data processing.
Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
Prepare functional or technical documentation for data warehouses.
Identify data issues and agree best course of action with the client.
Resolve any conflicts and manage infrastructure and implementation of new business systems.
Work closely with client and technical support teams.
Data collection, data staging, data movement monitoring, data quality and archiving strategies.

Translate requirements from the business and analyst into technical code by using SSIS & MSSQL
Data Integration from SharePoint and other sources for Reporting prospective by using SQL Integration Services in SQL SERVER platform.
Report designing by using SSRS in MSSQL platform.
Identify and rectify errors in a timely manner.
Developing, managing and testing back-up and recovery plans.
Link Server integration from different databases.
Assist in design and development of database systems.
Provide database solutions based on technical documents and business requirements.
Deployment of systems and reports in MS Environment as well as SharePoint reporting.
Prepare documentations regarding database design, configuration and change management tasks.