1 - 3 years
We are looking for SSIS Developer to join our team.
Responsibilities and Duties
Should be Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).
Use SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
Involve in creating multiple parameterized stored procedures which were used by the reports to get the data.
Work on formatting SSRS reports using the Global variables and expressions.
Create parameterized reports, Drill down and Drill through reports using SSRS.
Use ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
Involve in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
Prepare the complete data mapping for all the migrated jobs using SSIS.
Create databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures
BI Tools MS SQL Business Intelligence, Business Objects.
Programming Languages C#, Asp.Net and XML.
Operating Systems Win 2000/NT/2003/2008 server.
RDBMS MS SQL SERVER 2008/2005/2000, MS Access.
Database Tools SQL Query Analyzer, SQL Enterprise Manager, Management.
Studio, SQL Server 2005, Query Editor, Reporting Server,
ETL Tools Data Transformation Services (DTS), MS SQL Server Integration
Migration of Databases from Sybase, MySQL, SQL Server 2005 to SQL Server 2008.
sqlserver, ssis, dts, sybase, etl, c#, Asp.Net, Business Intelligence, datamapping, sql
Required Experience and Qualifications
Experience: 3 to 4 Years
Family health insurance with Master health checkup to employee.
Flexible working hours and leave policies.
Job Type: Full-time
Salary: ?300,000.00 to ?600,000.00 /year
work: 3 years (Required)
SSIS: 2 years (Required)
Gachibowli, Hyderabad, Telangana (Required)