We are looking dynamic candidates with very good communication skills.
• 0-6 years in SSIS Development Experience
• Bachelor's degree or equivalent
• Should be open to relocate anywhere in the United States.
Desired but not mandatory
• Expert in TSQL (DML, DDL), creating and maintaining Views, Stored Procedure, Trigger, Cursor, Functions and Joins in RDBMS.
• Developed complex T-SQL code for the application.
• Created Views to enforce security and data customization.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot in T-SQL.
• Created effective Functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Created Index on huge data sets for optimization.
• Experience in Data Extraction, Transforming and Loading (ETL) using SQL DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Created SSIS packages to import data from Excel, Flat File to SQL Server.
• Experience in Data Conversion and Data Migration using SSIS and DTS services.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Flat File, Text format data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
• Designing executive reports using in-house tool and generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Identified the database tables for defining the queries for the Reports.
• Key role in data analysis, relation modeling and data migration, query tuning /Optimization.
• Involved in data warehouse design/development.
• Knowledge of Data Warehouse design, Star and Snowflake Schema to develop OLAP CUBE using SSAS.
• Translating business requirements into technical designs to map and load data from source systems to warehouses.
Even if you are not qualified, send me your resume. I will sure look into it.