Data Warehouse Etl Specialist Resume
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.