Data Analyst - Microsoft SQL Server Integration Services

Best InfoSystems Ltd.
  • Chennai
  • Confidential
  • 5-10 years
  • 30 Nov 2015

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

This individual will be required to work as a Data Analyst using SQL Server. The individual will be required to write extraction queries to support extraction of data from Oracle / SQL databases, should be well versed with ETL using Microsoft SQL Server Integration Services (SSIS) .The person would also be required to work extensively for manipulating data to the required need. Core activities are enumerated below -
Data Analysis
Data Extraction from Databases
Data Cleansing and Consolidation
Data Loading into databases or datamarts
Writing scheduling scripts on servers
Individual Contributor
Customer Interaction

Skill Sets:

Expertise in creation and debugging of complex SSIS packages
Core Expertise in Microsoft SQL Server 2005/2008 especially T-SQL, DTS packages
Core Expertise in SQL Loader.
Core Expertise in PL/SQL Programming
Experience on writing UNIX and Windows Shell scripts
Experience on Oracle database is highly desirable
Experience in BI/DW projects will be a huge advantage
Experience in writing fuzzy logic scripts in SSIS
In depth SQL Server Database Administration experience and Oracle
Experience in managing multiple MS SQL RDBMS on large systems
Strong self sufficiency and initiative working on database projects
Experience in monitoring and tuning database to provide high availability service
Expertise in programming languages like SQL, PL/SQL
Practical experience in managing the internal and external MS SQL database security

Competencies/Skill sets for this job

SQL Server Data Analysis Debugging SSIS PL/SQL BI/DW

Job Posted By

About Organisation

Best InfoSystems Ltd.