Collaborate with the application developers in data modeling and E-R design of the systems. Create materialized views and normal views as per the business requirements. Create and modify database objects like tables, views, procedures, functions, triggers, packages, using Oracle tools like TOAD and SQL Navigator. Develop SQL and PL/SQL scripts to transfer tables across the schemas and databases. Update procedures, functions, triggers and packages based on the change request from users. Create SSIS package to load data from XML Files and SQL Server. Develop Unit Test Plans for SSIS packages for checking the functionality of each component. Generate Sub-Reports, Cross-tab, Conditional, drill down reports, drill through reports and parameterized reports using SSRS. Will work in Manchester, CT and/or various client sites throughout the U.S. Must be willing to travel and/or relocate.