PROFESSIONAL SUMMARY:

• Over 7+ years of IT experience, working as ETL tester on various Data Warehouse Environments in multiple domains.
• Experience in full software Development Life Cycle (SDLC) and Quality Assurance Life Cycle (QALC) analysis, design, development, testing, implementation and maintenance in data warehousing environment.
• Expertise in understanding Business Requirements, Functional Requirements, decomposing into HLD's and ETL Specifications into Test Cases for positive and negative test conditions.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
• Delivered Test Data Management Strategy,TDMprocesses, Gap Analysis, Data Sub Setting Strategy, Detailed Test Data.
• Experience in Data Analysis, Data Validation, Data modeling, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in gathering functional requirements from users and designing data model for ETL development.
• Experience in writing and development of test cases, test scripts and test procedures.
• Identifying and tracking performance issues and defects during testing.
• Extensive experience in performing different types of testing including White Box, Black Box, System, Functional, Integration, Regression, Smoke, GUI, Database and User Acceptance Testing (UAT) and Unified Functional Testing (UFT).
• Experienced with coordinating cross - functional teams, project management and presenting technical ideas to diverse groups & proven ability to implement technology-based solutions for business problems.
• Experience in Data Profiling, Data Extraction, Data Integration, Data Testing and Data Cleansing.
• Excellent communication skills, team player and hard working.
• Have academic exposure to software development life cycle like Feasibility, Design, Coding, Testing, Implementation and Maintenance.
• Strong technical knowledge of UNIX shell scripts as part of the Hadoop andETLprocess, automate the process of loading, pulling thedata
• Designed and implemented distributed data processing pipelines using Spark, Hive, Sqoop, Python, and other tools and languages prevalent in the Hadoop ecosystem.
• Application Data warehousing experience in Financial, Banking, Healthcare and Insurance.
• Experienced in running SQL queries using Toad (Oracle), Teradata SQL Assistant and SQL server.
• Experience in Performance Tuning of SQL and stored procedures.
• Passionate worker to contribute individually and as part of a team.
• Ability to learn modern technologies quickly with good analytical and problem-solving skills.

TECHNICAL SKILLS:

Testing Tools: ETL Tools

Reporting Tools: Selenium, QTP, Quality Center, TestDirector

Informatica, Datastage: Business Object, Cognos, Ab Initio

Defect/Test Management Tools: Quality Center, Jira, ALM

Languages: Java, SQL

Databases: Oracle 9i/10g, IBM DB2, MS SQL Server, MS Access

WebServer/AppServer: Tomcat, IIS, Weblogic, WebSphere

Operating Systems: UNIX, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Knoxville, TN

ETL Tester

Responsibilities:

• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs.
• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Performed automation testing for the Back Office using Quick Test Pro and coordinate with the dev team for immediate hot fixes.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Tracked the defects using HP ALM tool and generated defect summary reports.
• Performed Manual Functional Testing and Automated Testing using Selenium, of the application against new builds.
• Testing ETL data feeds from various data sources to ware house
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Tested a number of complex ETL Ab Initio graphs, for initial/ history and daily/weekly/monthly incremental data loads.
• Hands on experience in working with Eco systems like Cassandra, Spark, PostgresHbase and Hive.
• Created temporary tables for validations after understanding the transformation logic.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Tested complex mappings using mapplets and reusable transformations.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Involved in testing data reports. Written several SQL queries for validating the front-end data with backend.
• Conducted back to back meetings with developers and discussed about all open issues.
• Conducted test case reviews to ensure scenarios accurately capture business functionality.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Written several SQL statements to confirm successful data transfers between source and target.
• Executed SQL queries to perform backend database testing and verify/modify user data
• Utilized new technologies/tools/frameworks centered around Hadoop and other elements in the Big Data space.
• Hands on experience in working with Eco systems like Cassandra, Spark,PostgresHbase and Hive
• Hands on experience in working with Eco systems like Pig and Map Reduce
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports.

  Environment: Informatica Power Center, Ab Initio, Selenium, SOAP, Oracle 8i, SQL Server, SQL, PL/SQL, SQL*Plus, TOAD, Shell Scripting, Windows, Hadoop, hue, Spark, Postgres, Cassandra,ETL, Hive and Hbase.

  Confidential, Wooster, OH

  ETL Tester

  Responsibilities:

  • Gathering the requirements and preparing the test case generation.
  • Provided review comments on Test Scenarios and Test Cases based on Functional Requirement Specifications.
  • Worked on Data validation, Data merging, Data cleansing and Data aggregation activities.
  • Executed the ETL jobs sessions and workflows.
  • Involved on ETL Functional testing. Involved in testing Reports. Requirements gathering and freezing of those requirements.
  • Involved in ETL process testing using Abinitio ETL tool.
  • Involved in ETL testing, BI Micro strategy Dashboards and reports testing.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Abinitio graphs.
  • Preparation of Requirement Traceability Matrix, Test Metrics and Deployment manual.
  • Analyzed, designed and developed shell and hive scripts for validation ofBigDataanalytics platform- Benchmark of ADP Analytics.
  • Performed integration testing of Hadoop into traditionalETL, extraction, transformation, and loading of massive structured and unstructured data.
  • Performed Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.
  • Performed system testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance.
  • Worked with Data profiling, Data Validation and Data Integrity and Data Cleansing and ETL processes using Informatica.
  • Validated the Business Objects Reports against Data warehouse.
  • Verifying the Business Objects Report functionality and Layout specifications based on report requirement document.
  • Validated the Summary and detail reports with drill down options.
  • Closely worked with Clients during User Acceptance Testing to validate their findings, and report defects for resolution.
  • Perform User Acceptance Testing with UAT test scenarios.
  • Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.
  • Track Sheet Maintenance and map the use case to requirement.
  • Build deployment activities and participate in design (spec) reviews with the Core team.
  • Evaluate and suggest improvements to the software development process.
  • Monitor Testing Activities within the team and report regular progress to the Test Manager.

  Environment: Informatics Power Center 8.1/7.1, Custom programming using Perl, Teradata V2R6, Oracle 10g, MS SQL Server 2005/2000, UNIX Shell Scripting, PL/SQL, Rational Clear Quest, Windows 2000, HP-UX, Bigdata.

  Confidential - Temecula, CA

  QA/ETL Tester

  Responsibilities:

  • Prepared data mapping document for various data feeds for ETL to write and develop the data extraction routines.
  • Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems.
  • Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application.
  • Coordinated between offshore and onsite team and managed multiple OLAP and ETL projects for various testing needs.
  • Extensively used Informatica for extraction, transformation and loading process.
  • Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
  • Wrote store procedures, functions, database triggers and UNIX shell scripts to support and Automate the ETL process.
  • Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
  • Monitoring ETL jobs in Informatica which involved analyzing the issues and providing corrective actions
  • Performed MS SQL Server T-SQL Queries, creating Tables, and Views by following Teradata Best Practices.
  • UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
  • Tested Micro Strategy reports and written test cases using HP Quality Center.
  • Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
  • Defects were tracked and prioritized using Quality Center and analyzed the variation between expected result and actual result.
  • Designing and creating new reports, freeform SQL reports in Micro Strategy.
  • Designed and prepared scripts to monitor uptime/downtime of different system components.

  Environment: Informatica, XML, XSLT, PERL, Micro Strategy, SQL Server, QTP, Quality Center, DTS, T-SQL, SQL, TOAD, Oracle, PL/SQL, IBM DB2, MS Access/Excel/Visio, UNIX Shell Scripting

  Confidential, Des Plaines, IL

  QA Tester

  Responsibilities

  • Analyzed user requirements, scenarios, and business rules and attended periodic meeting for changes in the application.
  • Createtest plans, test cases, test procedures, and test scripts based on enhancing requirements and specifications.
  • Created test cases, defects in MS excel and exported in Test Director after approval.
  • Analyzed and managed test cases using Test Director.
  • Prepared and maintained reports and documentation.
  • Responsiblefor Smoke testing, Regression testing, Integration testing and System testing.
  • Involved in Manual Testing to check the basic functionality of the modules under test.
  • Prepared test plans and test cases to test application functionality.
  • Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
  • Prepared Requirement traceability matrix (RTM) for the application.
  • Performed browser compatibility testing on different versions and data validations for all reports.
  • Created manual test cases for Functional, GUI and Database testing of the application using Test Director.
  • Performed integration, function, system, usability, compatibility, load, stress and performance testing.
  • Involved in database testing by writing and executing SQL queries to ensure that data entered has been uploaded correctly into the database.

  Environment: Java, Test Director, WinRunner, HTML, Java Script, Oracle, Windows XP.