Data Warehouse Test Lead Resume
Dallas, TX
SUMMARY
- 7.5 years of industry experience in Data Warehousing. As an ETL - Informatica Developer and a Sr Data Warehouse Analyst/QA.
- Domain Expertise: Insurance(Auto and Property), Retail, Healthcare and Telecom
- Well versed in all the Phases of SDLC (Waterfall, Agile Scrum) and Software Testing Life Cycle (STLC).
- Expert in developing Informatica objects/jobs with more than 5 years of experience developing Informatica mappings, workflows and other objects.
- 5+ years’ work experience as an Informatica Developer and consultant
- 5+ years’ experience as a QA analyst working in an Agile setup.
- Experience in gathering business requirements and related rules as well as defining, training, testing, implementing and supporting functional requirements.
- Expertise in Unix shell scripting. Written scripts to run BTEQs and Informatica jobs through schedulers like Maestro, ESP, Control M, Autosys etc.
- 2 + years of experience with Automation tools like QTP and Selenium executing functional test cases through QC.
- Good working knowledge of Hadoop querying using Hive (HiveQL) and overall good knowledge of Big Data Concepts.
- Proficient working with IBM Rational ClearQuest, RequisitePro and HP Quality Center change management, defect tracking and use case management tools
- Involved in writing complex test plans and test cases and possess expertise in GUI testing, Performance Testing, Regression Testing, functional Testing, Stress and Load testing, configuration Testing, Integration Testing, System Testing, Documentation Testing and Regression Testing, User Acceptance, White box, Black box testing, Manual Testing and Automated Testing.
- Solid 6.5 years’ Experience in writing SQL queries, stored procedures, functions, packages, database triggers, exception handlers, cursors, PL/SQL records & tables and objects types.
- Well versed in writing complex queries in ORACLE PLSQL, SQL SERVER, TERADATA BTEQ
- Good working knowledge of MicroStrategy Reporting tool and Datastage.
- Basic knowledge of Mainframe system and JCLs.
- Certified DOTNET and OPEN SYSTEMS professional.(Infosys Certified)
TECHNICAL SKILLS
Automation Tool: QuickTestPro and Selenium
Defect Tracking Tool: Quality Center
Scripting Languages: VBScript, Unix Shell Scripting
Operating Systems: UNIX, Windows 95/98/2000/NT/XP
Database: Teradata, MS SQL Server, Oracle, Netezza, PostgreSQL
Languages: HTML, SQL, C, Shell Programming, .NET, HiveQL, Python
ETL/DW Tools: Informatica 9.X, Datastage, SSIS
BI Reporting Tools: Cognos, MicroStrategy, tibco Spotfire
PROFESSIONAL EXPERIENCE
Confidential, Dallas, Tx
Data Warehouse Test Lead
RESPONSIBILITIES:
- Analyze and document the various Business applications that are integrated in the Data Warehouse environment.
- Analyze and implement changes required in BTEQ scripts, informatica mappings, Oracle PL/SQL procedures etc.
- Create Informatica Mappings using S2T mapping documents.
- Create test cases for Data integration, Migration and other data flow processes.
- Prepare the test environment for the various applications involved- Billing, Finance, Accounts, Sales Tracking etc.
- Perform Data validation and integrity checks to see that data is loaded as per requirements and mapping logic.
- Perform functional testing of the Call center sales tracking application using Selenium automation framework.
- Support UAT and Post Production maintenance activities.
Confidential, Dallas, Tx
Data Analyst
RESPONSIBILITIES:
- Analyzing and Validating Cerner Data against the data loaded into the new EDW system.
- Analyzing and validating the data loaded into the EDW- Netezza system through the redesigned datastage jobs.
- Support UAT and Post implementation activities.
Confidential, Dallas, Tx
Data Warehouse Test Lead
RESPONSIBILITIES:
- Analyze and document the various Business applications that are integrated in the Data Warehouse environment.
- Analyze and suggest optimization changes for Informatica Mappings.
- Create Informatica Mappings using S2T mapping documents.
- Create test cases for Data integration, Migration and other data flow processes.
- Write wrapper unix scripts to run the ETL jobs.
- Perform Data validation and integrity checks to see that data is loaded as per requirements and mapping logic.
- Performed functional testing of the Call center sales tracking application using Selenium automation framework.
- Support UAT and Post Production maintenance activities.
- Used TFS- Team Foundation Server to log Defects, Track requirements/Update requirements and Manage the overall process of the project.
- Generate reports using brio sql and cognos and verify it against the data warehouse.
- Validate the loads by executing dry runs on the test environment and ascertain their availability for the production release.
- Execute ETL flows to load source data through sqlldr utility, perform multiload and fastload to pull data into the teradata database and execute bteq scripts to apply business logic.
- Coordinate with various teams to understand the data and testing strategy
- Coordinate with the DBAs to setup Test environment and validate the flows by regular dry runs.
- Create Test strategy and implementation for ad hoc changes and new business change requests. Perform unit test, integration test and system test to validate the change.
- Review regression test scripts for conversion perspective.
Confidential, Columbus OH
Data Warehouse - Test Analyst- Lead
RESPONSIBILITIES:
- Mapping development, debugging, job scheduling and integration.
- Developed Informatica mapping and tuned them for better performance.
- Prepared Unit Test Plans and System Test Plans for the transformation logic.
- Performed data validation and integrity checks to see that data is loaded as per requirements and mapping logic.
- Preparing and analyzing Teradata BTEQ test scripts to compare data in Databases for Parallel Load of data in test environments.
- Creating Manual regression test scripts for Functional testing of the Policy Center application. Used Selenium, QTP and an In-house automation tool called RAFT to automate the regression test scripts for the Guidewire Policy Center application.
- Involved in the Master Test Strategy, Test plan and Test strategy preparation.
- Lead a team of four testers to test the various phases of development.
- Writing complex SQL queries to access data in Teradata data marts for testing. The SQLs are then converted into Teradata BTEQs to automate through the BTEQ utility in Unix
- Writing Unix scripts to have the BTEQ utility run the SQL BTEQs.
- Reviewing of test cases and the test strategy that has been incorporated. Updating the requirements and Testcases in RequisitePro
- For Downstream applications, used TFS to log defects and Track and Manage requirements.
- Analyzing the data structure and providing ideas to better the model.
- Analyzing the mappings already in use and suggesting value additions.
- Preparing the Master test strategy document.
- Preparing the Test Plan for Iteration testing.
- Executing ETL jobs on Mainframes and work flows on Informatica.
- Preparing status reports and arranging Daily status calls with Offshore and the various stake holders.
- Involved in the Downstreams and Upstreams to discuss on the defects and Action items.
- Creating Unix shell scripts to run BTEQs and Informatica Workflows through Schedulers like Maestro and ESP
- Involved in formal meeting to review Test cases, Test plan and Test Strategy.
- Conducting regression testing on the applications under test
- Validating metrics by pulling reports using Microstrategy reporting tool
- Preparing the Test environment using Schedulers like Maestro, Control M and ESP and making code changes in the Informatica objects to point to the new QA environment.
- Conducting defect triage meetings and tracking defects till closure. Submitting defects to Rational ClearQuest and also updating and tracking them in HP Quality Center.
Confidential
Data Warehouse - Test Analyst
RESPONSIBILITIES:
- Integration and Data Migration Testing of the property and sales Data Mart
- Preparing and analyzing test Cases for Functional, Data Migration and Integration Testing.
- Reviewing of test cases and test strategy incorporated.
- Analyzing the data structure and providing ideas to better the model.
- Analyzing the mappings used for ETL.
- Involved in creating in-house automation tools for data validation using VBScript.
- Writing complex SQL queries to pull data from heterogeneous data sources and validating it with the data in the Datamarts against the Business Specification or the Source2Target mapping documents.
- Test data preparation by analyzing the business requirement.
- Scheduling Defect triage meetings to discuss on and decide the resolutions for the defects raised during integration and System testing phases.
- Used Datastage as an ETL tool to pull data from different sources and load the staging tables for QA validations.
- Involved in all phases of testing. Integration, System and UAT(as a support)
Confidential
ETL Developer / Module Leader
Responsibilities:
- Mapping development, debugging, job scheduling and integration.
- Writing complex SQL queries to pull data from oracle and teradata databases and validate it against the business specifications
- Was a part of QA and UAT Testing support.
- Developed mapping and tuned them for better performance.
- Prepared Unit Test Plans and System Test Plans for the transformation logic.
- Performed data validation and integrity checks to see that data is loaded as per requirements and mapping logic.
- Worked on BEx Analyzer tool for pulling reports on the business warehouse system
- Transforming informatica mapping to netezza SQL scripts to load into a netezza database
- Prepared Test cases based on the S2T mappings and business specification documents.
- Involved in Test Plan and Test Strategy review meetings.
Confidential
ETL Developer
Responsibilities:
- Prepared ETL Specification documents and Source to Confidential mapping documents by analyzing the Informatica jobs.
- Created and executed BTEQ scripts using Source to Confidential mapping documents.
- Prepared Unit Test Plans and System Test Plans for the transformation logic.
- Performed data validation and integrity checks to see that data is loaded as per requirements and mapping logic.
- Written SQL queries for backend testing to validate the data stored in the databases and performed database integrity checks using SQL
- Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
- Developed Pl/sql Procedures to generate test data.
- Defect tracking and verification till closure
- Good experience working with scheduling Maestro and ESP tool.