|
Search Jobvertise Jobs
|
Jobvertise
|
US_East | Tool Specialist - DATA INTEGRATION _L3 Location: US-IL-Chicago Email this job to a friend
Report this Job
Description: Role: (T) Data Integration Location: Hartford, CT JOB DESCRIPTION: Common Developer Expert Onshore"""Min 6 years - experience of working on SSRS/SSIS is required.Strong SQL Skills and SSRS and SSIS skills expected
- Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix and Sub Reports.
- Should be comfortable understanding and importing XMLs into RDL files to develop SSRS reports
- Analyzed data models, data relationships, and dependencies for greatest optimization
- Design and develop stored procedures, queries and views necessary to support SSRS reports
- Perform functional and unit testing
- Experience Excellent knowledge in creating, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL
- Optimize the database by creating various clustered, non-clustered indexes and index views. Using aggregate strategies to aggregate data, sorting and joining tables.
- Extensively using joins and sub-queries for complex queries which were involving multiple tables from different databases. Analyzing data and re-mapping fields based on business requirements. Create/Modify SSIS packages/ C# code to export and import data from CSV files, Text files and Excel spreadsheet.
- Prior experience of PLSQL is expected
- Assist with solving technical problems when they arise. Ensure the implementation of agreed architecture and infrastructure
Phone #: | | Email address: | | Location (City and State): | | Relocate: | | Availability to start: | | Visa type and expiration: | | Hiring Status: C2C/W2/10NA | | Skype ID: | | Open for CTH (y/n): | | Timeslots for Skype interview | |
RICEFW Technologies Inc
|