We provide IT Staff Augmentation Services!

Etl /data Analyst Resume



  • 10 years of IT experience in managing software testing efforts for Automobile, Retail, Healthcare and Financial domain applications.
  • Well - versed with all stages of Software Development Life Cycle (SDLC), and QA Methodologies like Agile, Scrum Waterfall, and Iterative process.
  • Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
  • Expertise in performing Data validations on Oracle, SQL Server, Teradata, DB2, Hadoop Big data platforms like Hive, BigInsights and Hortonworks.
  • Strong understanding of Hadoop echo systems like Hadoop Distributed File System (HDFS), SQOOP, Hive Partitioning and Testing Hadoop system using Hive Queries.
  • Extensive experience in testing Cognos reports and Micro Strategy according to report and functional specification documents.
  • Prepared source to target mapping documents with complex Transformation rules for ETL loads.
  • Good in using HP ALM/Quality Center for creating scripts, tracking defects, and reporting to the client and management team.
  • Expert in writing Complex SQL quires for backend testing and written several queries on the fly for user specific requirements for trouble shooting day to day production issues to identify root cause.
  • Excellent in testing ETL jobs and applications, Business Intelligence reports, Quality Assurance and management, Risk, Compliance, Data management, internal audit programs.
  • Experience in validating the standard reports developed in Cognos for the data, layout, filters and prompts.
  • Experienced in analyzing Physical & Logical Data Model and Entity relationship diagrams.
  • Extensively involved in testing the application developed in Agile Methodology and detailed designs.
  • Expert in planning and executing Smoke, Functional, Integration, Regression, User Acceptance Testing, Compatibility Testing for Java and .net based web application, Data Warehouse Application; UNIX based applications and Client Server applications.
  • Experience testing ETL, PL/SQL, UNIX batch jobs using scheduling tools such as Autosys.
  • Experience in Hadoop ecosystems like HBASE, Scoop, Hive, Storm and Pig.
  • Validated the data Loaded from ORACLE to Hadoop Cluster using Sqoop.
  • Good understanding of dimensional modeling like Star Schema, Snow Flake Schemas.
  • Experienced in writing detailed Test Plans, Test Strategy, Test Data Management Plan and maintained Test Readiness Reviews (TRR) for large releases, application enhancements, maintenance releases and defect fixes for various applications.
  • Knowledge in creating Business Scenarios, Test Scenarios, Test Cases for System, Integration, Regression using HP Quality Center and User Acceptance Testing.
  • Maintained and updated Requirements Traceability matrix (RTM) having Business Requirements, Technical Requirements, Test Scenarios and Test Cases for test completeness and Internal Audit (IA)
  • Ability to independently develop, maintain and execute Test plans and Test scripts.
  • Managed all testing artifacts in HP Quality Center, TFS (Team Foundation Server), utilized the same for test execution and reporting.
  • Coordinated Release management for Application Maintenance Releases and Production Defects fixes.
  • Experienced in leading Software Testing projects and expert in coordinating testing effort between On Shore and off shore teams.
  • Excellent communication, coordination and interpersonal skills.


Methodologies: RUP, UML, Agile Modeling, SDLC model, Waterfall Model

Requirements tools: Rational Requisite Pro, DOORS

Data modeling and Design: ER Diagrams and MS VISIO, ERWIN

Languages: SQL, PLSQL, XML, T-SQL

Databases: Oracle, MS SQL Server 2012/2008/2005, DB2, Teradata

BigData Technologies: Hadoop and its Ecosystem

Testing Tools: HP Quality Center / ALM, QTP, TFS, JIRA

Operating Systems: Windows 95/98/2000/XP, UNIX, Linux

Defect Management Tools: Rational Clear Quest and HP Quality Center / ALM

ETL Tools: Informatica, DataStage, SSIS, Ab Initio

Reporting Tools: OBIEE, Micro Strategy, Cognos, SSRS


Confidential, MN

ETL /Data Analyst


  • Involved in Design and development of test plans based on high-level documents (BRD & FRS).
  • Involved in writing and implementing the Test plan, Test cases, Test Procedures, Test sets using Use cases and requirement specifications.
  • Analyzed customer and business needs to determine business and functional requirements.
  • Gathered and documented business requirements for system gaps that require development in credit card project.
  • Writing complex SQL queries to validate the data from multiple source systems and loading to the EDW system
  • Validated the custom reports developed in Cognos Report studio, validated the Adhoc reports in Cognos Query studio, and multi-dimensional cubes in Cognos Analysis studio.
  • Involved in writing source to target mappings with transformation rules.
  • Worked with Business Analyst and Developer to resolve the defects.
  • Validated the data with all the possible transformation rules and provided the quality data.
  • Validated the cosmetics of Cognos reports and data shown on the reports according to the report specifications.
  • Extensively involved in testing the application developed in Agile Methodology and detailed designs.
  • Analyzed the user/business requirements and functional specification documents.
  • Analyzed and optimized the use cases and created the Test cases based on them for Change Requests.
  • Validated Quality Centre test plan module to write the test cases and test lab module to execute them.
  • Executed all Test cases in different phases of testing like Smoke, Regression and System testing of the application.
  • Generated the defect reports for review by the client and the management teams.
  • Prepared UNIX Shell Scripts and these shell scripts will be scheduled in Robot for automatic execution at the specific timings.
  • Used Datastage Director to run the workflows and workflow monitor to verify their status and logs.
  • Widely experience in verify the log of ETL jobs.
  • Validated the Data warehouse(DWH) Table structure part of ETL testing
  • Execute batch processing and verify the ETL jobs status and data in database tables
  • Validated parameter driven ETL process to map source systems to target data warehouse with Datastage complete source system profiling.
  • Tested all the rules which implemented during ETL job move data from source to target Data Warehouse(DWH)
  • Developed complex SQL queries to test ETL jobs source to target Data Warehouse(DWH)
  • Involved in defining Test Scenarios for the applications and performed manual testing in HP Quality Center.
  • Created and executed different types of test cases for the Change Request and existing functionality of the application.
  • Responsible for checking of data in database by writing and executing SQL statements.
  • Reviewed the test activities through daily Agile Software development stand-up meetings.
  • Involved in meetings with Automation team for Development of Automation Scripts for Change requests to run the along with regression tests suites of business priorities on Loan Application.
  • Involved in backend testing using UNIX commands.

Environment: HP ALM, TFS, Oracle 11g, DB2, Teradata, Datastage, PL/SQL developer, Teradata SQL Assistant, Agile, WinSCP, Cognos 10, UNIX, SQL.


ETL QA/Data Analyst

  • Reviewed business requirements (BRD), application requirements (SRS), Use Cases, System Module Specification, System Interface Specification, System architecture diagram.
  • Worded as Lead QA Analyst, Business Tester and onsite/offshore coordinator.
  • Collaborated with various teams including developers, database administrators and middleware; led fast-track product releases with onshore and offshore team members.
  • Writing complex SQL/PL-SQL queries based on the Mapping rules document to validate the data into the Hadoop Big Insights Data Warehouse from different Source Systems.
  • Performed integration testing for Extraction, transformation, and loading of massive structured and unstructured data into Hive from multiple Flat files, relational databases like Oracle and DB2.
  • Prepared Hadoop Queries (H-QL) to test data correctness in the Hive and verified partitions created in the Hadoop based on the date field.
  • Validated data in the target flat files using Hadoop distributed file system (HDFS) commands.
  • Validated data duplicates between data warehouse and HDFS and whether there is any real business benefit in duplicating the data.
  • Performed Hadoop Eco system behavior validation by changing some parameters in Hadoop profile file.
  • Also reviewed data flow diagram, data model to better understand cube/dimension presentation.
  • Prepared test data/mock data for identified scenarios, submitted remedy ticket/ work order # to coordinate with DBA’s to migrate production data into System Integration Testing environment.
  • Created quality assurance readiness review document and reviewed with stakeholders and project management teams before test execution.
  • Created test cases for Smoke testing, System testing, Functional testing, Regression testing and User Acceptance Testing.
  • Written complex SQL’s to validate the data without violating the transformation rules.
  • Have leaded offshore team to develop Test Plan and Test Script.
  • Created System test scenarios and User acceptance test scenarios to test all mortgage application releases.
  • Extensively worked with EDI to create test files, analyzed all EDI test files with 5010 implementation guides and gap analysis of EDI transactions
  • Stored and managed test cases in HP Quality Center for multiple releases, baseline and used for Regression testing and System testing.
  • Validated various Micro Strategy reports for data quality and lay outs.
  • Verified the application outputs like reports on the different browsers like Safari, IE, Chrome and Firefox.
  • Performed data validation for the Micro Strategy reports.
  • Validated the drilldown reports, drill up reports, dashboards, ad-hoc reports developed in Micro Strategy according to the report requirements.
  • Reviewed the test activities through daily Agile Software development stand-up meetings.
  • Validated the used requirement module for requirements and defects modules for entering the defects.
  • Tested the customer service application supporting cookies for the different browsers.
  • Tested the customer service application functionality and modules, roles and responsibilities.
  • Created Regression test sets in Quality Center Test Lab module and executed the same for Regression testing.
  • ETL - Data extraction process, transformation and loading from PeopleSoft GL.
  • Used Datastage Director to schedule and execute the workflows, to identify the status and to verify the session and workflow logs.
  • Validated PL/SQL Packages, Procedures, and Functions by writing PL/SQL functions and Anonymous blocks.
  • Tracked, logged, and drove defects to resolution, enhancements using Rational Clear Quest and taken care that the defect life cycle was followed.
  • Validated reports generated by reporting tool.
  • Verified test results (viewing the log files using VI editor, querying the database using the SQL) documenting the defects.
  • Involved in testing the UI screens, reports which was used by the internal business team.
  • Validated PL/SQL, UNIX, ETL batch jobs scheduled using Autosys.
  • Created test status reports throughout the testing life cycle using quality center, reports and graphs, test case execution data and communicated to stake holder project management team.
  • Validated Customer facing and Ad hoc reports developed in Oracle OBIEE.
  • Trained business users in various occasions about application enhancement quality assurance tools such as rational clear quest, quality center and QA industry best practices.
  • Logged and drove defects to resolution using rational clear quest for multiple releases.

Environment: HP Quality Center 10, IBM Datastage, Hadoop, Hive, Sqoop, Map Reduce, Agile, OBIEE Reports, Oracle 11g, Toad, Autosys, MS Office, Teradata, Rational Clear Quest, SQL, PL/SQL, UNIX, Putty.


ETL / Data Analyst

  • Reviewed requirements document such as BRD, DMS and design document and other artifacts to better understand the process, its underlying data.
  • Actively reviewed business requirement to identify ambiguous and unclear requirements, worked with clarify those items.
  • Created detailed test cases independently to test web application created using java for internal and external purpose.
  • Used CAST to convert the datatypes in Teradata.
  • Involved in testing the functionality of Ab Initio ETL graphs based on data mapping requirements and Entity relationship diagrams.
  • Conducted Smoke testing, Regression testing, System testing, and End to end testing and User Acceptance Testing.
  • Knowledge on the phases of agile methodology and scrum Methodology
  • Responsible in testing Initial and daily loads of ETL Ab Initio graphs.
  • Written SQL queries to validate Ab Initio graphs and transformations.
  • Debugged and scheduled Ab Initio ETL Jobs/Mappings and monitored error logs.
  • Validated Autosys batch schedule jobs which schedule PL/SQL, ETL jobs.
  • Performed cross browser testing for this web application with Safari, Opera, Chrome, Firefox, Internet Explorer and Mobile browsers (different versions).
  • Validated various Micro Strategy reports which are of tabular format, Cross tab format, ad hoc reports.
  • Involved in validating various Datastage workflows, mappings and tasks
  • Coordinated with business analyst and business users to conduct user acceptance testing.
  • Customized critical test cases for business user execution during the UAT.
  • Created test case result document for all the testing.
  • Validated XML files as part of system testing and compared the data with database.
  • Identified defects in system testing, end to end testing, regression testing logged these defects using Rational Clear Quest with proper severity and priority and performed defect life cycle.
  • Worked with automation team to develop automation regression testing framework and automation regression testing QTP scripts.
  • Performed database testing using SQL queries with joins, unions, arithmetic and aggregate functions.
  • Created test status reports, summary reports and communicated accurate progress to stakeholders.
  • Worked on Parts and vehicle claims during the project.

Environment: HP Quality Center 10, Teradata, Toad, SQL, PL/SQL, Autosys, Windows XP, SQL Server 2008, Micro Strategy, Datastage, Rational Clear Quest, Microsoft SharePoint, Unix Scripts, Unix, Agile


ETL / Data Analyst

  • Reviewed Business, Systems, Design and Technical specification and identified gaps and ambiguous points, coordinated with respective team to fix the gaps.
  • Defined testing activities for three major releases with concurrent monthly maintenance releases.
  • Created Test data analysis from the Functional, System and Design specification.
  • Interacted with Business Users, BA, Dev teams to understand the business process and technical flows and created detailed End-to-End test cases based on the processes and business flows.
  • Created test plan, test cases, test scripts and test steps for every release and stored in Microsoft- TFS
  • Created Requirements Traceability Matrix (RTM) for test coverage analysis and test completeness
  • Reviewed Use cases test critical areas of application.
  • Created test cases for Smoke testing, System testing and Regression testing.
  • Created Risk Assessment matrix document based on defects identified and risks associated in system/production environment.
  • Incorporated Integration within System Test plans, which adequately exercise functioning of the system and its various components.
  • Validated various DataStage jobs according to Business Requirements and Functional Specifications.
  • Created manual Test cases and utilized QTP to automate test scripts for Regression Testing.
  • Integrated the Automation test scripts in Quality Center and created baselines.
  • Wrote queries on Oracle and DB2 database for data validation, tested the Java web interface application with the legacy Mainframe programs.
  • Extensively developed SQL Queries using Rapid SQL to test the business process of financial accounting modules to PeopleSoft.
  • Coordinated the Testing efforts during Integration, System and User Acceptance Testing phases.
  • Manage defects through Rational Clear Quest Defect Tracking. Assign defect priority, analyze follow up and retest defects over builds.

Environment: Microsoft-TFS, DataStage, Oracle 9i, Toad, SQL, PL/SQL, DB2, CDW, PeopleSoft (GL, AP and AR), Autosys, Windows XP, QTP, SQL Server2005, Crystal Reports, Rational Clear Quest, Rational Clear Case, MS Office, VISIO and Project


Quality Analyst

  • Prepared detailed test cases by understanding the business logic and user requirements for manual testing.
  • Involved in creating the Test plans with QA lead, Creating and executing manual tests to validate the workflows for End-to-End scenarios
  • Extensively performed Manual Testing process to ensure the quality of the software.
  • Followed agile methodology and attended Scrum meetings
  • Performed End-to-End System testing and Regression testing for various workflow
  • Analyzed the Business requirements and developed the RTM (Requirements Tractability Matrix) for the project.
  • Interacting with the team and resolving the issues
  • Involved in mentoring the team for various workflows
  • Involved in STLC and responsible for preparing system test cases for UAT system
  • Extensive Experience in writing and executing SQL queries for verification and validation of data for backend testing on various databases like Oracle, MYSQL.
  • Experience in performing Integration Testing, System Testing, Automation Testing, Smoke Testing, Data driven Testing, Black box Testing, White Box testing, End-to-End Testing, UAT User Acceptance Testing and Database Testing for Cross function application using Web Services.
  • Good scripting experience in VB Script and QTP framework using HP/Mercury Quick Test Professional, developing function libraries in VB script for QTP, shared repository, Descriptive programming data validation from QTP / VB Script
  • Involved in Black box, White box, functional testing, integration testing, load testing, regression and System testing
  • Generated Automated Script using Virtual User Generator (VUGEN)
  • Extensively used Run time settings, advance setting option and results setting to emulate Vusers. Maintained a log on the performance of the system
  • Performed Load and performance testing under off and peak load conditions using Load Runner
  • Helped team lead in Generating graphs and reports for analysis
  • Defects were tracked, reviewed, analyzed and compared using Quality Center

Environment: HP QC, Clear Quest, HTML, XML, Oracle, Windows 7 Professional, SQL, UNIX, JAVA, JQuery, Java Script, VB Script, VB.Net, PHP, PERL, MySQL, Manual/Automation Test management tools, Microsoft office.

Hire Now