We provide IT Staff Augmentation Services!

Data Warehouse Etl Specialist Resume

2.00/5 (Submit Your Rating)

PROFILE SUMMARY:

  • 5 years of hands - on experience developing and maintaining SQL Databases
  • 5 years of hands-on experience in data modelling and SQL development
  • 5 years of hands-on experience in ETL Process Development
  • 5 years of hands-on experience with ANSI SQL scripts for DDL, DML
  • 10 years of experience with data integration ETL tools such as Informatica, BODS (SAP)
  • 5 years of hands-on experience with Informatica Mapping, Workflow package development
  • Strong understanding of MS SQL Server, Oracle and other relational databases
  • Experience in SQL development tools, TOAD, T-SQL, SQL Developer, IBM Netezza, Teradata
  • Strong Powercenter Informatica development experience
  • Experience in UNIX script development
  • Strong SQL knowledge in DDL, DML query development as well as an understanding of database structure
  • Knowledge of data modeling principles
  • 7 years of experience in creating technical documentation and specs
  • Experience in developing and executing ETL and data conversion methods for the migration of data from multiple existing modern and legacy systems into Enterprise Data Warehouse.
  • Strong knowledge of the business process related to Financial Institutions, mutual funds, CRM, Lending, Credit Cards and Portfolio Risk Management.
  • Experience in the planning and execution of large-scale critical data conversion and migration initiatives
  • Experience performing data conversion/migration from legacy systems to Salesforce, eCOM sites.
  • Have worked on Multiple Parallel Projects with offshore-onsite mix.
  • Have worked extensively with Test Management Tools, HPQC, JIRA, Star Team.
  • Experienced in ETL Batch Job Run Planning and Executing.
  • Thorough understanding & experience on SDLC Models, Waterfall & Agile.
  • Hands on Technical skills with Project/Program Management Tools, MS-Project, MS Visio, MS Office, JIRA, Microsoft Sharepoint.
  • Strong Interpersonal, Problem solving skills
  • Self-starter, continuous leaner paying attention to details.
  • Strong experience working with Architects, Business Teams, QA, BA Teams.

SKILLS SUMMARY:

SQL Scripting: Oracle SQL Developer, MS SQL Server, IBM Netezza, Teradata

ETL Development: Informatica Power center, Data Validation Option

DETAILS OF EXPERIENCE:

Data Warehouse ETL Specialist

Confidential

Technology: Informatica Powercenter, MS SQL Server, T-SQL, Oracle, MS APS Data warehouse, Unix

Responsibilities:

  • Analyze and understand complex databases and multiple systems of data.
  • Understand and implement logical and physical data models and solutions to support reporting systems and analysis.
  • Develop data integration and ETL packages between our various databases and business systems.
  • Maintain and enhance database views used in our enterprise data warehouse and other reporting databases.
  • Troubleshoot issues with Data warehouse databases, views and query performance.
  • Operational support and troubleshooting of data integration and ETL processes.
  • Follow guidance and recommendations on data integration and best practices.
  • Collaborate with other teams and departments to ensure excellent levels of internal customer service.
  • Responsible for understanding spec. and development and maintenance of SQL Server databases, ETL processes.
  • Maintaining and supporting existing ETL applications
  • Create T-SQL scripts to implement business logic for ETL processes
  • Analyze and troubleshoot ETL processes
  • Create and maintain technical and functional design documents for projects
  • Communicate with architects, business users, managers and team members
  • Continuously learning new innovative technologies and upgrading knowledge on existing ones
  • Development and execution of data mapping packages
  • Conversion, migration and ETL procedures to effectively migrate data from legacy systems to the new target Data Warehouse
  • Develop high quality ETL code on time and on target
  • Perform ETL by developing various Informatica objects to extract and transform data; scheduling workflow sessions, jobs and executing them in workflow manager
  • Work closely with the Informatica Administrators to support the deployment of changes to higher environments
  • Work in a dynamic Agile/Scrum/Waterfall team environment
  • Applying DevOps best practices
  • Documenting work as required following development standards
  • Working with the Data warehouse architect in Identifying, documenting and validating data conversion/migration scope, risks, constraints, dependencies and assumptions
  • Scripting and executing of ETL packages to enable automation and less manual intervention
  • Ability to build modular, parameter based code to help reusability
  • Prepare pre-load and post-load SQL scripts
  • Prepare data comparison procedures to test the transformed data
  • Working with analysts and testing team to resolve any data related issues
  • Monitor service desk work queue and responds to support issues within agreed service levels
  • Works with key users and stakeholders to identify and resolve data issues
  • Conducts post implementation review of ETL, data conversion and migration exercises

Data Warehouse Analyst

Confidential

Technology: IBM Netezza, SAP Powerbuilder, UNIX

Responsibilities:

  • To read and interpret the technical specification in the SAP Powerbuilder.
  • To participate in spec. review and technical design meetings.
  • To develop SQL scripts based on the Specifications transforming input file data into Data Mart Tables.
  • To develop Test SQL scripts to compare target tables with Test Tables.
  • To investigate and analyze defects and troubleshoot.
  • To identify test data requirements and develop Test Dictionary scripts.
  • Review Test cases and provide sign off.
  • Prepare Deployment package for migrating the ETL code to Production.

QA Lead

Confidential

Technology: Teradata, Informatica Power Center, Oracle(Unix)/SQL Developer, QTP, SAS, JIRA

Responsibilities:

  • To evolve Test Strategy considering that the platforms are new to the organization.
  • To plan & design Test Environment.
  • To identify QA elements to be taken care of in the Agile Kanban method of Project Execution.
  • To plan for data inputs in source systems in Java, SAP & SharePoint Platforms using QTP Automation.
  • To estimate the resource need and arrange recruiting & onboarding.
  • To train & mentor testers, review performance on continual basis.
  • Prepare & Review Test cases for Dimension & Fact Tables of DW.
  • Develop Test Cases for user stories & write SQL Scripts.
  • To guide Testers at offshore in Test Execution.
  • To plan for Informatica WF Batch Running in Test Tiers.
  • To coordinate and support UAT.
  • To get Sign off for QA Artifacts.
  • To Admin JIRA for the project & generate daily & weekly Status reports.
  • Test Strategy developed for Relational Model Data Warehouse using Agile Method.
  • Innovative Test Environment & Test Data Management Process evolved.
  • Developed Framework for SQL Script Development.
  • Developed & Reviewed SQL Scripts for 100 User Stories.

Test Lead

Confidential

Technology: Informatica Power Center, .net, MS-SQL2008, Sybase, SharePoint, XML, Saleforce.com, HP QC, JIRA, HPIM

Responsibilities:

  • To identify the elements in Test Environments & publish periodic notification on status of the Environment.
  • Monitor, control and Gate Keep Test Data configuration in all Test Tiers.
  • To Identify/Prepare Test Data in source systems, CDS, SharePoint, Mainframe.
  • Develop SQL Scripts for Data Mapping Rules.
  • Plan & implement deployment of SW packages to higher levels of Test Tiers & arrange for Validation.
  • To guide Testers at offshore in Test Execution.
  • To plan for Informatica ETL Batch Running in Test Tiers.
  • To coordinate and support UAT.
  • To get Sign off for QA Artifacts.
  • To Admin ALM for the project & generate daily & weekly Status reports.
  • Developed & Implemented Templates for monitoring Status of Test Tiers.
  • Guided, motivated offshore team & efficiency improved by 50%.
  • Framework for Database Testing introduced.

Sr. QA Consultant

Confidential

Technology: IBM Curam (SOA), Java, Oracle database, QTP, HP QC, Ab Initio

Responsibilities:

  • To review Strategize testing different Services in the system.
  • To work with the dev team and develop Build Plan & Smoke Testing Process.
  • To writes SQL Scripts to validate data in Target system (Curam).
  • Unit Testing of Services in the SOA.
  • To strategize Test Data Management
  • To provide requirements for Test Environment and ensure the Environment is Validated.
  • To schedule and monitor Test Execution for Integration, System & UAT Phases.
  • Prepared Data Driven Test cases for the complicated Monthly Benefits calculations.
  • Successfully evolved & implemented quick and easy approach to carry out Integration Testing.
  • Prepared Framework for Automating Monthly Benefits Testing in QTP .

QA Lead

Confidential

Technology: Java, SAP, PeopleSoft, Oracle, ETL tool - BODS, COGNOS Reports, Quality Center & QTP Java, xml & flat file interfaces, Oracle SQL Developer, SharePoint, Sub Version

Responsibilities:

  • Architect Test Solution for the Data Warehouse.
  • Develop Test Plan, Test Strategy for the Warehouse development involving all stakeholders.
  • Identify Test Environment Requirements & prepare business cases for acquisition.
  • Work with DBA Team in laying out the layers of Test Tiers & sharing arrangement between Development & UAT Teams.
  • Maintain configurations of Test Tiers for each system elements.
  • Gate keep configuration changes to Test Tiers & keep the project teams notified.
  • Ensure coordination of Test Tier updates for downstream development teams periodically.
  • Develop and review SQL scripts for Data Mapping Spec.
  • Publish daily status report on Test Tiers indicating Data Version & Code Version.
  • Plan for code merge across Test Tiers to ensure Production Environment is simulated for Testing.
  • Monitor & Track Environment Issues in HPIM. Escalate critical issues to ensure minimum downtime.
  • Plan ETL Batch running for different Test Tiers in line with Test Execution Plan.
  • Set up Test Data Input in source systems, PeopleSoft, Java based portal QTP Automation.
  • Implement Test Process & methodology for Data Warehouse. Review of Business Requirements, Creation of Test Plans, Test cases & Test SQL Scripts and getting Sign off. Manage Test data creation & review. Manage Defect Tracking and Defect Triages.
  • Make Periodic Project Status update presentation to Governance Team using MS Visio, MS Powerpoint.
  • Manage System Testing, End-To-End Testing, Regression Testing, Conversions Testing. Manage 5 team testers from offshore.
  • Conduct Defect Triages; Participate in Production warranty issue management team. Provide detailed investigation report on issues with a view to prioritize, fix and re test.
  • Developed Test Tiers Tracking Dashboard.
  • Developed & executed SQL Scripts for about 1100 Test Cases covering 55 Dimension & Fact Tables.
  • Managed successful rollout of initial release & the subsequent 5 major releases.
  • Developed Process for Periodic Refreshment of Test Tiers.
  • Developed Test Tiers Version Control Mechanism in Sub Version.

QA Lead Consultant

Confidential

Technology: .net, Unix DB2, Mainframe(COBOL), JCL, COGNOS, IBI Webfocus, Abinito (ETL Tool)Quality Center, QTP, Lotus Notes, Toad, Loadrunner

Responsibilities:

  • Lead QA for multiple projects with onsite-offshore teams.
  • Plan for HW & SW System Requirements for Test Environment catering to the needs of all the ongoing projects.
  • Maintain Test Tiers allocation for projects based on the individual release schedule.
  • Plan for code merge for Test Tiers shared by multiple projects having staggered release schedule.
  • Maintain versions for SW elements of Test Tiers & release status report.
  • Develop specific test cases for covering data range in GDS, Airline Travel Booking System.
  • Implement Model Test Database to generate Test Data. Develop and review Test cases & Test scripts. Conduct Team review of Business Requirements and provided sign off. Manage Test execution & defect tracking.
  • Implement Functional Testing, End to End System Interface Testing, Testing for Data conversions, Automated Regression Testing using QTP.
  • Coordinate about 50 Team members from different locations across the globe.
  • Train and develop SQL skills in Testers. Review SQL Scripts for test cases.
  • Use Quality Center for Test cases, Defects.
  • Analyze issues found in software enhancements, provide data and suggested solutions to development team to fix the issue, participate in defect triages.
  • Discuss Requirements and UAT Plan with Business SMEs & Business Analysts. Work with System Analyst to set up Test Data. Interact with Developers to resolve defects. Interact with PM to provide status reports.
  • Developed Lotus Notes Utility for Tracking & Reporting Environment Availability.
  • Developed Test Data Dictionary & Test Data maintenance process.
  • Developed Process for Test Data Loading & Production Data Refresh for Projects.

Lead, QA

Confidential

Technology: Java/XML, Websphere, Data Repository in Unix DB2, CICS, JCL, Inhouse ETL tool MS SQL server 7.0, Quality Center, QTP, MS Project, Toad Java based web applications, SharePoint, Oracle Database application

Responsibilities:

  • Manage QA for projects under Auto Enrollment program.
  • Review Projects’ Test Artifacts & conduct project audits.
  • Work with Infrastructure team in managing Test Environment.
  • Allocate Test Tiers & Test Data for projects.
  • Prepare QTP Automation scripts for golden test cases to add to Regression suite.
  • Work with Release Management Team & plan for Pre Prod Staging Validation & Rollout.
  • Resource maintenance, development & deployment.
  • Develop SQL Scripts for Database Validation.
  • Evolve & implement TCOE processes.
  • Set Processes & Norms for Quality Center, plan for customizing.
  • Coordinate Trouble shooting, cross functional teams, Production rollouts.
  • Mentor & train QA resources. Manage new recruitments.

We'd love your feedback!