We provide IT Staff Augmentation Services!

Etl And Sql Server Developer Resume

SUMMARY:

  • 6.8+ years of experience in Data Warehousing encompassing Development, Testing and maintenance of ETL’s on SQL Server, Oracle and SSIS.
  • A project executor with exposure to handling projects and ensuring delivery of projects within the time & cost parameters; executed key projects involving Data warehousing using Sql Server, Oracle, SSIS for Business Intelligence.
  • Strong experience in Extraction, Transformation, Loading (ETL) data from various heterogeneous source systems like SQL Server, Oracle 11g/10g, DB2, Flat files, XML, Excel into Data Warehouses and Data Marts using SSIS
  • Experience in creating and using Stored Procedures, Functions, Triggers, Views and Synonyms in SQL Server and Oracle.
  • Good understanding of SQL Server Import/Export utility
  • Skilled in Window Batch scripting and also write basic Unix Shell Scripts to automate the jobs.
  • Experience in scheduling of ETL jobs using SQL Server Agent and have some idea on Control M tool.
  • Also experienced on various tools for check in/check out code like SVN, Tortoise.
  • Extensive experience in performing complex analysis and resolving complex issues.
  • Rich working experience with very large Data warehouse.

TECHNICAL SKILLS:

ETL Tools: SSIS 2008/2012/2013 , Basics of (Datastage, Informatica)

Data bases: Sql server 2008/2012, Oracle 9i/10g/11g

Languages: SQL, PL/SQL, Window Scripting, UNIX shell scripting basics

Operating Systems: UNIX, Windows 2003/XP/2007/2010

DB Tools: SQL Server, SQL plus, Toad

Other Tools: SVN Tortoise, Autosys, Control - M, Remedy, Putty, Harvest 7

PROFESSIONAL EXPERIENCE:

Confidential

Technology: ETL and .net 4.5

Software/Tools : SSIS 2013, SQL Server 2012

ETL and SQL Server Developer

Responsibilities:

  • Involved in gathering requirements from IT/Business client.
  • Responsible for design approach and developing ETL packages in SSIS.
  • Write multiple stored procedures to handle various functionalities.
  • Designing of Data model and table creation in SQL Server.
  • Handled data validations and business validations individually.
  • Involved in Writing Multiple configurations to deploy the same code in multiple environments.
  • Also involved in creating Manifest files, which helps in deploying the code easily.
  • Also wrote Reconciliation process and customized email task in SQL script component.
  • Perform Unit testing and SIT for all the SSIS packages and stored procedures created.
  • Responsible for creating and maintaining all documents for all phases like Requirement, Design and development, SIT/ UAT, Production migration, Deployment and Handover.

Confidential

Technology: ETL/Reporting

Software/Tools : SSIS 2012, SQL Server 2012, Business Objects

Onsite Technical Lead & Developer

Responsibilities:

  • Design ETL packages in SSIS.
  • Responsible for gathering all ETL requirements.
  • Develop various SSIS individual packages based on the Client requirements.
  • Involved in enhancement of various existing packages for better performance and add new functionality.
  • Created various jobs in AutoSys Scheduler tool to schedule the SSIS Jobs.
  • Responsible for creating and maintaining all documents for all phases like Requirement/ Design and development/ system Integration/ User Acceptance testing, Production Deployment and for Handover.
  • Also used Attunity drivers to connect with Oracle to improve the performance.
  • Perform Unit testing and System Integration testing for all the SSIS packages created.
  • Coordination with Business, IT for new requirements.
  • Discuss existing issues in application with Business/IT and resolve the same as per timelines

Confidential

Technology: ETL/Reporting

Software/Tools : SSIS 2012, SQL Server 2012, Qlikview 11 and Track IT

Onsite Technical Lead

Responsibilities:

  • Involved in migration of servers from Therakos domain to Confidential domain.
  • Testing of Entire application after migration
  • Coordination with Business, IT and offshore team
  • Discuss existing issues in application with Business/IT and resolve the same as per timelines
  • Coordinating with source and downstream systems for getting/provision data feeds as per schedule
  • Documentation of entire application i.e. Therakos Understanding document, Data dictionaries and Business Rules for all source system.
  • Resolve all service requests from users regarding data issues in SSIS and Qlikview
  • Handled small enhancement in Qlikview individually
  • Worked on enhancements in SSIS whenever requested from Business.
  • Handled various recurring data issues by modifying existing SSIS packages.
  • Monitoring data loads and validate the data.

Confidential

Technology: ETL

Software/Tools : Data stage 8.5, SSIS, Oracle, UNIX, Control-M, .Net 4.5, SQL Server 2012 and Remedy

Onsite Technical Lead

Responsibilities:

  • Coordination with Confidential Business, Confidential IT and offshore team
  • Keep application up & running
  • Coordinating with different infrastructure teams to keep the servers in better performance
  • Discuss existing issues in application with Business/IT and resolve the same as per timelines
  • Coordinating with source and downstream systems for getting/provision data feeds as per schedule
  • Resolve all service requests from users
  • Prepare status reports for IT & Business
  • Work on enhancements whenever requested from Business and IT.
  • Generating sales data and distribute reports as per the schedule.
  • Monitoring Jobs Inbound and Outbound processes.
  • Dedicated 40 hours for every month to improve the process.
  • Monitoring data loads and validate the data.
  • Also act as Onsite lead in gathering requirements from business till sign off /deployments for small projects/enhancements undergone in these applications.

Confidential

Technology: ETL

Software/Tools : SSIS 2010, SQL Server 2008, Window Batch Scripting

ETL Developer and Lead

Responsibilities:

  • Responsible for gathering all ETL requirements
  • Leading the project form offshore location and responsible for dealing with onsite coordinator and client in regular status calls
  • Also handle team and assign tasks on daily basis.
  • Write batch Scripts to make the process automated in loading and archiving the source files.
  • Design ETL Jobs in SSIS.
  • Delivered the Project using standard ICE Methodology for all documentation.
  • Responsible for creating and maintaining all documents for all phases like Requirement/ Design and development/ system Integration/ User Acceptance testing, Production Deployment and for Handover.

Confidential

Technology: ETL

Software/Tools : SSIS, SQL Server 2008, UNIX.

ETL Developer

Responsibilities:

  • Active and major contribution in requirements gathering, analysis and overall solution design for ETL and Reports.
  • Design, development & implementation of ETL transformations, mappings, jobs scheduling using SSIS
  • Lead the team for ETL Development.
  • Perform Unit and integration testing.
  • Perform SIT testing and deployment in (DEV, QA and PROD) Environments.
  • Daily status and requirement calls with Client.
  • Document preparation as per IGM standards

Confidential

Technology: ETL

Software/Tools : Data stage, PL/SQL, Window Batch Scripting, Cognos

ETL Developer

Responsibilities:

  • Responsible for gathering all requirements for ETL
  • Leading the project form offshore location and responsible for dealing with onsite coordinator and client for regular status.
  • Write batch Scripts to make the process automated in loading and archiving the source files.
  • Design, development & implementation of ETL transformations, mappings, jobs.
  • Delivered the Project using standard ICE Methodology for all documentation.
  • Responsible for creating and maintaining all documents for all phases like Requirement/ Design and development/ system Integration/ User Acceptance testing, Production Deployment and for Handover

Confidential

Technology: BI, Data modeling

Software/Tools: Data stage, Cognos, Oracle and UNIX.

Tester and developer

Responsibilities:

  • Requirement understanding, test case preparation & execution.
  • Also helped team in creating and understanding data stage jobs.
  • Writing SQL Queries and test whether the data shown on the reports matching.
  • Responsible for all test management delivery.
  • Coordinate with onsite team for gathering Details

Hire Now