SSIS Developer Resume Samples

A SSIS Developer is hired to render support on projects including building, maintaining, and designing metadata models and OLAP cubes and ETL packages. The job description entails taking responsibility for data reporting, and converting customer requests into technical details. Core job tasks seen on the SSIS Developer Resume include the following – identifying operational requirements of the company, developing advanced BI applications using MS BI stack, analyzing and improving dashboards, reports, and reporting systems; assisting in designing extensions; designing and developing BI solutions using multidimensional cubes, providing training and expertise to users and other stakeholders; providing technical details for BI solution implementation; and identifying problems trends and delivering corrective actions.

Candidates for this role are expected to display on the resume – experience in delivering solutions using Microsoft BI stack – SSAS, SSIS; experience working in a data warehouse environment; strong understanding of dimensional data modeling concepts; strong exposure to OLAP systems; and working knowledge of current Microsoft.NET technologies. Candidates with a degree in computer science or the related along with a relevant certification gain eligibility for this role.

SSIS Developer Resume example

Ssis Developer Resume

Objective : Over 7+ years of IT experience focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence. Proficient in Talend open studio ETL. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools. Developed jobs in Talend open studio for various sources using different components for achieving the required transformations and loaded output data to the databases using output database components in Talend.

Skills : ETL, Informatica, Odi, Oracle.

Description :

    1. Provided environmental, civil engineering and laboratory services world-wide.The basic aim was to integrate existing TEGSIS framework with GIS functionality, deployment of re-engineered TEGSIS Soil Web application, and a standard database Web system.
    2. Interaced with the data of other external modules of TEGSIS (like TEGSIS Risk & Liability Asset Management module).
    3. Involved in requirement gathering and performed ETL Process.
    4. Created Dimension Tables and Fact Tables based on the warehouse design.
    5. Wrote Triggers and Stored Procedures using PL/SQL for Incremental updates Integrated various sources in to the Staging area in Data warehouse to Integrate and for Cleansing data.
    6. Involved in building of the Data Warehouse which includes the Design of Data mart using Star Schema Created the Source and Target Definitions in SSIS.
    7. Created Reusable Transformations to use in Multiple Mappings Developed and updated documentation of processes and system.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelor In Information Technology


Ssis Developer III Resume

Objective : Over 6+ years of IT experience focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence. Proficient in Talend open studio ETL. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools. Drawing on Experience in all aspects of analytics/data warehousing solutions (Database issues, Data modeling, Data mapping, ETL Development, metadata management, data migration and reporting solutions) Strong understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data warehousing using Windows.

Skills : Bachelors of Technology in Computer Science, MS Word.

Description :

    1. Developed ETL Processes for support of the 340B Pharmaceutical management product with SSIS, SQL Stored procedures, and C # scripting.
    2. Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
    3. Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDX Scripting.
    4. Experienced in creating complex SSIS packages using proper control and data flow elements with error handling.
    5. Provided a wide range of value-added services, including implementation and training, operational management services, health care data analysis, transaction processing, employer health centers and third party administrator services for employer-based health plans.
    6. Designed and developed SSIS packages to move data from various sources into destination flat files and databases.
    7. Troubleshoot previous SSIS packages to solve issues
      Performance tuning existing scripts and processes
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelor In Information Technology


Ssis Developer II Resume

Summary : Over 6+ Years of experience in Data Design and Development In Microsoft SQL Server T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS. In-depth knowledge of T-SQL (DDL and DML), SSIS and SSRS. Experienced in developing complex stored procedures to generate Ad hoc reports using SSRS Have prepared the reports for everyday as well as periodically in various file formats such as XML, HTML, PDF and Excel Ability to transform the data from the staging database and transform the data using Data Flow Tasks and worked extensively with on ETL process using SSIS Packages Expert knowledge of Software Development Lifecycle (SDLC) and gathering business requirement documents Worked closely with business and QA team to test SSIS packages and SSRS reports.

Skills : ETL Tools/Software. ETL Developers obviously need a tool to develop on, SQL. SQL, or Structured Query Language, is the lifeblood of ETL as it is the most popular database language.

Description :

    1. Documented major changes to the SQL Servers.
    2. Setup Test, Dev, Staging and Production Environments.
    3. Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
    4. Performed Unit testing related to those packages and other updated data loads
    5. Employed error handling techniques and promoting parallelism.
    6. Created of SQL Agent jobs to schedule package runs.
    7. Communicated with various team members related to status updates, sprints, reviews, etc.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelors

Ssis Developer I Resume

Objective : Over 7+ years of professional experience in Software Design, Development, Integration, Implementation of Data Warehousing & Business Intelligence Applications in Tableau Desktop, Tableau Server, OBIEE, Microsoft BI (SSAS, SSIS, SSRS), Power BI, ETL Design & Development, BI/DW. Worked extensively in SQL Server 2008, 2012 & 2014.

Skills : ETL Tools/Software. ETL Developers obviously need a tool to develop on, SQL. SQL, or Structured Query Language, is the lifeblood of ETL as it is the most popular database language.

Description :

    1. Created tables, running ETL jobs, writing dynamic scripts to generate stored procedure, creating tables etc., Creating packages in the solution explorer (In EXTRACT, TRANSFORM AND LOAD) and writing SQL query in data flow task, creating variable, error handling process and writing functions.
    2. Created project parameters for different regions.
    3. Described environments names from which data is coming.
    4. Deployed the packages in the solution explorer to catalog which is in management studio.
    5. Tested the table in DW to load data to catch many errors like data type violation, NULL constraint violation, foreign key violation and duplicate data.
    6. Generated reports to maintain zero percent error's in all the data warehouse tables.
    7. Developed SSIS Packages for migrating data from Staging Area of SQL Server 2008 to SQL Server 2012.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Assistant Ssis Developer Resume

Objective : Over 3+ years of professional experience in Software Design, Development, Integration, Implementation of Data Warehousing & Business Intelligence Applications in Microsoft BI (SSAS, SSIS, SSRS), Power BI, ETL Design & Development, BI/DW. Worked extensively in SQL Server 2012 & 2014. Experience with SQL server and in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, data dictionaries and integrity.

Skills : Organization, Creativity, Debugging, Problem Solving.

Description :

  • Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase).
  • Created packages in SSIS with error handling.
  • Worked on domain like mortgage.
  • Worked with different methods of logging in SSIS.
  • Experienced in creating complex SSIS packages using proper control and data flow elements.
  • Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.
  • Helped the client design, build, stabilize and deploy a Microsoft Business Intelligence solution for a large 12 million record flat file using SQL Server, SSIS, SSAS, SSRS.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Associate Ssis Developer Resume

Objective : Over 7 years of IT Professional experience in Development, Client Analysis, Database Design, and Presentation using SQL Server Experience in various industries includes Financial Services, Insurance, Retail, Mortgage, pharmaceutical and Banking. Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.

Skills : Organization, Creativity, Debugging, Problem Solving.

Description :

    1. Analyzed the requirements and selected the dimensions based on the analysis requirements.
    2. Designed Tables, Constraints, Views, and Indexes, and created the Cubes for Business Intelligence.
    3. Involved in writing Test Plans for SQL Stored Procedures and User Defined Functions.
    4. Created Views to facilitate easy User Interface Implementation and Triggers on them to facilitate consistent data entry into the database.
    5. Developed the ETL Process to load the data from the mainframe production databases to the Oracle database models.
    6. Involved in High-Level Documentation for SQL Server Database Design, Periodic Data Refresh, and Database Upgrades.
    7. Finally set standard, guidelines, and best practices based on the documentation.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelors In Information Technology

Assistant Ssis Developer I Resume

Summary : Over 8 years of experience as a MS SQL Server Developer working on large-scale enterprise and performance critical applications. Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server Experienced with VB6, VB.NET 1.1, 3.0 & 3.5 and ADO.

Skills : MS Office, Debugging, Problem Solving.

Description :

    1. Designed and developed SSIS packages, stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.
    2. Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server integration services (SSIS) Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence container and Conditional split, Data conversion, Derived column and Multi casting.
    3. Scheduled the jobs to streamline and automate cumbersome repeated tasks using SSIS.
    4. Involved in all phases of System Development Life Cycle (SDLC) Developed, executed and maintained SQL queries/scripts and to validate completeness, integrity and accuracy of data.
    5. Responsibilities: Designed standards for database tables, columns, procedures and views.
    6. Created junked and conformed dimension in Data Warehouse environment.
    7. Created degenerative dimension within OLAP environment.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelors

Associate Ssis Developer I Resume

Summary : Having 7+ years of experience in working on Business Intelligence and Data Warehousing applications using the Microsoft Technologies such as SQL Server SSRS ,SSIS and Tableau. Technical hands-on experience using Tableau 8.1/8.0. Experience in developing Custom Reports and different types of reports like Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

Skills : Problem solving skills, MS Office.

Description :

    1. Gathered user requirements and analyzed and designed software solution and database.
    2. Updated functional specification and technical design documents and also created new design documents Helped in the design of the Architecture of the Data Warehouse and helped in performance tuning of the data base.
    3. Designed the Entity Relationship(ER) models and logical data (LDM), physical data (PDM) models based upon the design documents.
    4. Extensively worked on full Software Development Life Cycle (SDLC) of the project from Database Design and Modeling to implementation and maintenance.
    5. Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
    6. Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, and Excel to SQL Server using Business Intelligence Development Studio.
    7. Data transferred between various servers using BCP and Data Transformations in SQL Server Integration Services.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelors

Ssis Developer/Analyst Resume

Headline : A Data Warehouse/Business Intelligence Developer with 8 years of strong expertise in OLTP, OLAP databases, ETL, Data Integration, Business Intelligence Analysisand Reporting with hard-core experience in Health Care, Property & Causality Insurance and Banking Sectors. Highly Experienced in Requirements gathering, Analysis, Design, Development and testing in SDLC using SQL Server [] and Business Intelligence products like SSRS, SSAS, SSIS.

Skills : MS Office, MS Word, Problem Solving.

Description :

    1. Involved in collecting Business Requirements to develop and implement SSIS packages on an enterprise level for all the ETL needs.
    2. Developed and Maintained Enterprise level Erwin Model for Development and Production Environments.
    3. Responsible for testing and maintaining all EDI processes and relationships in the environment.
    4. Added and modified base EDI schemas, creating maps between the EDI document and internal/external messaging.
    5. Used SSIS for RAD ETL development using SSIS packages to Import data from different format of source files originating from SXC.
    6. Designed and Implemented Scrubbing logic to maintain Data Quality.
    7. Involved in planning, defining and designing data and provided documentations.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors In Computer Science

Ssis Developer Resume

Summary : Around 8+ years of experience as a MS SQL Server Developer in various industries such as IT, Finance, Insurance. Proficient in MS SQL Server Business Intelligence using MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), and MS SQL Server Analysis Services(SSAS). Expert in migration of databases from older versions of SQL Server (2005) to SQL Server As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.

Skills :

  • MS Office, MS Word, Problem Solving.

Description :

    1. Organized business requirements into conceptual, logical and physical (OLAP) data warehouse model.
    2. Involved with all phases of Data Warehouse development including prototyping, data modeling, analysis, design, development, testing and documentation.
    3. Created ER Diagram database design and demonstrated business process modeling and requirements definition into it.
    4. Implemented OLAP cube and connecting using Excel PowerPivot.
    5. Created ETL(SSIS) process to transfer data from OLTP Files to data warehouse, scheduled and monitored jobs.
    6. Involved in Reporting Services (SSRS) forms authentication configuration /Single Sign On(SSO) and Analysis Services cross-domain authentication using HTTP access.
    7. Designed, Implemented and maintained Database Schema, ER diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
B. Tech In Electronics