We provide IT Staff Augmentation Services!

Etl Team Lead Resume

3.00/5 (Submit Your Rating)

EXPERIENCE SUMMARY:

  • Over 9+years of experience in Software industry in the areas of Analysis, Design, Coding and Testing. Current responsibilities include understanding Client’s expectations, requirements and develop solutions
  • Extensive experience in developing strategies for Extraction, Transformation, Loading data from/to various sources into Data Warehouse and Data marts using Data Stage
  • ETL experience using IBM Web sphere Data Stage 11.3/8.7/8.1/8.0.1/7.5 Versions.
  • Extensive experience in software application development with JAVA/SQL Server Development, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
  • In - depth knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases such as Requirement gathering, Analysis/Design, Development, Testing and Implementation/Release Management.
  • Knowledge on data warehouse concepts like Star Schema, Snow Flake Schema, Dimension and Fact tables.
  • Strong knowledge of DataStage parallel and server jobs. Will be able to develop the jobs and fix the defects independently.
  • Worked closely with project management, analysts, data modelers and the existing ETL developers to understand project requirements and contribute to the project solution.
  • Experience in integration of various data sources (DB2, DB2-UDB, SQL Server and Oracle) into data staging area and target data warehouse.
  • Performed debugging, troubleshooting, monitoring and performance tuning using DataStage.
  • Excellent facilitator and communicator with both upper management and software developers in technical/non-technical terms.
  • Resolution of critical issues through logic and sound reasoning while focused on goals. Ability to work independently and manage business expectations with a delivery-focused approach to work
  • Involved in End-to-End Implementation in a project.
  • Provided technical expertise on ETL design, Data Warehousing, and Data integration Partner with Business Intelligence and Business operational teams to understand data sources and implement new requirements.
  • Client interaction to capture and understand business requirements, and defining project scope.
  • Involved in Blue Health Intelligence (BHI) and all Confidential association mandate programs.
  • Architect, Design, Integrate, Develop and implemented enterprise level data warehouse solutions using Datastage 8.x/ 11.x architecture for Enterprise level data warehouse solution.
  • Converting business requirements to project documentation and technical specifications.
  • Project Estimations for New DataStage projects and deployment of complex Datastage project.
  • Have experience in leading the team.
  • Designing an enterprise level data warehousing solution involving heterogeneous source systems.
  • Fine tuning Data Stage jobs to optimize performance. Experience in tuning database tables in production environment to achieve optimized performance benefits.
  • Involved in all the phases of project from Requirement gathering, development, Unit testing SIT, UAT, Pre Prod &Prod phases.
  • Has good experience & knowledge on Data stage advanced concepts. Worked on Both DataStage Parallel & Server editions.

TECHNICAL EXPERTISE:

Primary ETL Skills: IBM Web sphere Data Stage, DTS, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)

Operating Systems: Windows 98/NT/2000/XP, Windows Server 2003/2008, UNIX, LINUX

Reporting Tools: SSRS, Power BI, Business Objects.

Scripts: Bourne Shell scripting

Databases: IBM DB2 UDB 9.7.5, Oracle 9i/11/12 g and SQL Server 2000/2008/2012

Source Control: Synergy, SVN, Mercurial, GIT, TFS, WNCV

Domain Knowledge: Health Insurance and Retail

Testing Tools: Hp Quality Center

Documentation: Technical, Design, Test Case documentation and Materials

Configuration Management: JIRA

Other Tools: Rapid SQL 8.7.5,MoveIT DMZ,WinSCP,Toad,Oracle SQL Developer, SSMS,WinMerge,Service-Now, LTF Viewer, SQL Loader, IBM DataStudio, Autosys, Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard

EXPERIENCE DETAILS:

Confidential

ETL Team Lead

Responsibilities:

  • Perform business impact analysis due to business changes to understand any changes that will be involved for any of the interfacing systems.
  • Responsible for creating a Data warehouse for the organization as part of the migration project from IBM to Microsoft SQL Server
  • Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
  • Developing data stage jobs for various requirements.
  • Transferred data from various data sources systems including MS Excel, MS Access, and Flat Files to SQL Server using SSIS/DTS using various features like data conversion.
  • Created SSIS packages to load data from flat files, csv and excel files in to the staging tables.
  • Created T- sql objects to load the data from the staging tables to the transaction tables.
  • Programs modified for applications related as per the requirements
  • Prepared Technical Specification Document based on Functional Spec.
  • Prepared the Unit test plan.
  • Conducted meetings with Onsite team and client.

Confidential

ETL Team Lead

Environment: DataStage 8.0.1, DataStage 8.7, RHEL 6.5, Windows 2003, DB2, Rapid SQL 8.7.5,MoveIT DMZ,WinSCP

Responsibilities:

  • Developing data stage jobs for various requirements..
  • Used Data stage Enterprise Edition (PX) for Extraction, Transformation and Loading data into the target.
  • Working on Data stage director to execute and Monitor the jobs.
  • Extensively used Data Stage Designer, Director and integrity for creating and implementing jobs.
  • Used Data Stage stages namely Sequential file,Datasets,Transformer,Aggregator, Sort, Join, Lookup, filter, Change Capture,Funnel,Removeduplicates,Row Generator stages in accomplishing the ETL Coding.
  • Developed job sequencer with proper job dependencies, job control stages.
  • Developing Korn shell scripting.
  • Giving the customer deliverable on-time and support the SIT environment.
  • Excessively used Data Stage Director for monitoring Job logs to resolve issues.
  • Perform business impact analysis due to business changes to understand any changes that will be involved for any of the interfacing systems.
  • Prepared Technical Specification Document based on Functional Spec.
  • Prepared the Unit test plan.
  • Conducted meetings with Onsite team and client

Confidential

ETL Team Lead

Environment: DataStage 8.0.1, DataStage 8.7, RHEL 6.5, Windows 2003, DB2

Responsibilities:

  • Involved in extracting data as per Vendor requirements.
  • Involved in loading Data Marts.
  • Developing Sequencer jobs to define the job workflow and handle the dependencies between the jobs
  • Develop/follow approved processes for solving, reporting, and escalation of load/extraction issues.
  • Creation/Updating of Technical Specifications of the Jobs developed.
  • Would be responsible for interacting with the ETL lead to study the interface specifications from each source system and prepare the design documentation for the multiple reports to be developed that would be used by the development team to proceed with coding.
  • Would be completely responsible for supporting the application during User Acceptance Testing and will actively involves developers in fixing the issues as and when they arise.
  • Develop/follow approved processes for solving, reporting, and escalation of load/extraction issues.
  • Involved in carrying out rigorous testing in integration environment and would be signing off all the deliverables before delivering the same to the end users for User Acceptance Testing.
  • Provide development services for approved Change Requests enhancements with Data stage assessment.
  • Modified the jobs on demand of business.
  • Understanding the existing Shell script and do the needful changes as per business requirements.
  • Involved in Unit Testing and peer review for the code developed across project.
  • Setting up project wide variables and defaults for new projects.
  • Monitored log file sizes on Datastage project

Confidential

ETL Team Lead

Environment: DataStage 8.0.1, RHEL 6.5, IBM DB2 control Center, MoveIT DMZ, WinSCP and WinMerge

Responsibilities:

  • Working with code changes and enhancements.
  • Working with datastage 8x versions to modify the code changes and new developments.
  • Working on JIRA Tickets to resolve the defect fixing.
  • Based on requirement, designed Data Stage ETL jobs for extracting data from text /DB and loading into Oracle.
  • Troubleshooting the designed jobs using the Data stage Debugger.
  • Prepare Unit test cases for the modified components.
  • Prepared Statement of Work.
  • Perform business impact analysis due to business changes to understand any changes that will be involved for any of the interfacing systems.
  • Prepared Technical Specification Document based on Functional Spec.
  • Prepared the Unit test plan.
  • Conducted meetings with Onsite team and client

Confidential

Environment: DataStage 8.0.1, DataStage 8.7, RHEL 6.5, DB2

Developer

Responsibilities:

  • Prepared Statement of Work.
  • Perform business impact analysis due to business changes to understand any changes that will be involved for any of the interfacing systems.
  • Prepared Technical Specification Document based on Functional Spec.
  • Prepared the Unit test plan.
  • Conducted meetings with Onsite team and client.

Confidential

Environment: DataStage 8.0.1, DataStage 8.7, RHEL 6.5, DB2

Developer

Responsibilities:

  • My responsibilities include Analysis, Coding, and Unit testing, preparing Release notes, SMRs (Software Migration Recommendation).
  • Enhancing the existing code to suit the requirements of the client
  • Coding new programs to in corporate enhancements in the business flow.
  • Prepared Technical and Design specifications.
  • Prepared Essential Application Documents.
  • Prepared Materials and provided transition to the team.
  • Prepared Statement of Work.
  • Perform business impact analysis due to business changes to understand any changes that will be involved for any of the interfacing systems.
  • Prepared Technical Specification Document based on Functional Spec.
  • Prepared the Unit test plan.
  • Conducted meetings with Onsite team and client.

Confidential

ETL Team Lead

Environment: DataStage 8.0.1,Windows 2003, IBM DB2 UDB

Responsibilities:

  • Developing Sequencer jobs to define the job workflow and handle the dependencies between the jobs
  • Used Datastage clients for extracting source data and loading into target table.
  • Design, Build and Test sequencer jobs to run all the parallel jobs in Batch
  • Stages such as Datasets, Lookup, Remove Duplicates, Funnel, Join, Aggregator, Filter, Sort and Peek were used in Parallel jobs.
  • Involved in Developing ETL Load Tracking Strategy for loading Incremental records.
  • Involved in Preparation of UTP (Unit Test Plan) and executing them.
  • Involved in Support for System Testing, UAT
  • Involved in End-to-End Implementation of the Project
  • Migrated projects from Datastage 8.0.1 on Windows 2003 to Datastage 8.7 RHEL 6.5.
  • Prepared Statement of Work.
  • Setting up project wide variables and defaults for new projects
  • Prepared Technical Specification Document based on Functional Spec.
  • Prepared the Unit test plan.
  • Perform business impact analysis due to business changes to understand any changes that will be involved for any of the interfacing systems.

We'd love your feedback!