SSIS/SSRS Engineer at Capgemini in Hartford, CT
Employment Terms:
Fulltime with benefits Responsibilities Min 5 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 Experience with Agile framework
Salary Range:
$100K -- $150K
Minimum Qualification
Database AdministrationEstimated Salary: $20 to $28 per hour based on qualifications.
Fulltime with benefits Responsibilities Min 5 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 Experience with Agile framework
Salary Range:
$100K -- $150K
Minimum Qualification
Database AdministrationEstimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
