Professional Summary:

• 8+ years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications
• Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Involved in all phases of SDLC, STLC, agile, water fall & V - Modal process with timely delivery against aggressive deadlines.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in integration of Informatica Data Quality (IDQ) with Informatica Power Center
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experienced with ETL tools like Informatica, SSIS, and Ab Initio and Data stage.
• Experience in Data Warehouse and Web based applications with manual testing and using automated testing tools.
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming
• Good knowledge in Azure Virtual test environment during implementation of cloud infrastructure
• Experience in Testing complex Business rules by creating mapping and various transformations.
• Knowledge of BM mainframe COBOL, Querying DB2, and programming
• Experience in testing XML files and validating the data loaded to staging tables.
• Stress Testing. Regression testing, End-to-end Testing, & User Acceptance testing (UAT) and also has good knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Experience in testing and writing SQL and PL/SQL statements.
• Experience working on Mainframe with CICS.
• Hands on experience on ETL Micro Strategy tools in ETL process development, testing and in maintaining ETL codes.
• Good experience in Micro strategy, Cognos Reports and Business Objects testing.
• Experience in Financial, Banking, Brokerage, and Securities industries.
• In depth knowledge of Agile and Waterfall development methodologies.
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.
• Extensively worked on Dimensional modelling, Data cleansing and Data Staging of operational sources using ETL processes.

TECHNICAL SKILLS:

ETL Tools: Informatica, Data Stage, Ab Initio, SSIS.

Languages: SQL, PL/SQL, Unix Shell Script, PERL, Visual Basic, COBOL, XML

RDBMS: Oracle, SQL Server, Teradata, Sybase, DB2

GUI/RDBMS Query Tools: SQL* Plus, Oracle SQL Developer, SQL Server Management studio, Teradata SQL Assistant 13.0, TOAD, Win SQL

Tools: MS-Office suite (Word excel, Project and outlook)

BI Tools: Business Objects XIR2/XIR3, Cognos, OBIEE, Micro strategy, SSRS and Hyperion

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Sr. ETL Tester

Responsibilities:

• Responsible for Gathering test requirements and scoping out the test plan.
• Written complex SQL queries.
• Designed and tested UNIX shell scripts as part of the ETL testing process to automate the process of loading, pulling the data for testing ETL loads.
• Designed Data Quality using IDQ and developed several Informatica mappings.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading using Informatica.
• Automating Devops for creating VMs in the cloud (Azure).
• Reported bugs and tracked defects using HP ALM.
• Worked on developing functionalities using Agile Scrum methodology.
• Designed and reviewed the new report standards in order to ensure optimized performance under the new reporting service SSRS.
• Validated various SSRS reports and Power BI Dashboards
• Prepare Test Plans, Test Strategies and Test cases and write complex automation test scripts based on requirement document, design documents and mapping documents.
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Involved in daily Scrum meetings (Agile Methodology). Also involved in Iteration/Sprint planning meeting to plan the stories that needs to be developed and tested in the upcoming sprint based on the priority and estimated effort.
• Documented the steps for simple and complex business rules validation using DQE tool.
• Practical understanding of the Data modeling Dimensional Relational concepts like Star - Schema Modeling, Snowflake Schema Modeling.
• Good Understanding of the EDI (Electronic data interchange), Implementation and Knowledge of HIPAA code sets.
• Coding enhancements and unit level testing of the COBOL- DB2 components.
• Responsible for implementing page object model (POM) using Selenium Web Driver, Maven, TestNGcuc and Java.
• As an ETL/BI Tester responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project.
• Tested ETL process to push the transactional data from the normalized data structure into the data marts.
• Worked on Autosys, UNIX, Hadoop, Hive, Impala and shell scripting for big data testing. Leading the team for the same.
• Used Teradata SQL to save queries to a file so they can be run automatically from the same file in the future.
• Used SQL Queries to verify and validate Data populated in Front-End is consistent with that of Backend, used Insert, Update, Aggregate and Join queries.
• Lead one or more simultaneous Transactional & Data Warehouse projects utilizing Informatica, Oracle and UNIX technology stack.
• Tested Mainframe Online CICS applications.
• Performed user acceptance testing (UAT), and integration testing.
• Performed Regression test using automated testing tool QTP, Fitness and Selenium.
• Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
• Performed data analysis and data profiling using SQL and Ab Initio on various sources systems including Oracle and Teradata.
• Provided the results for the Data quality validation using DQE tool to the Business on a monthly basis.
• Extensively used TOAD and SQL developer for Database Testing and written several PL/SQL
• Queried databases using SQL queries in TOAD and SQL Server Management Studio to validate the data loaded into target tables.
• Create team specific agile process flow in JIRA to move tasks from one activity to another.
• Created new connections in query surge for flat files, databases.
• Written different kinds of SQL queries like creation, updates, inserts, deletion, joins etc, to perform Backend testing of the application for validating the data that comes from Frontend.
• Used Informatica Data Quality (IDQ) for data quality, integration and profiling.
• Involved in massive data profiling using IDQ prior to data staging.
• Migrated applications from internal data center to AWS.
• Analyzing EDI transaction Claims, Remittance, Claims Status, Member Eligibility, Functional acknowledgement, and Claim acknowledgement.
• Performed database validation according to the business logic by comparing the source to the target in Spreadsheet.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Created Short-cut joins and contexts to make the universe loops free.
• Proposing remediation in SDLC documentation for the controls that are found to be not met.
• Managed and executed the test process, using Agile Methodology.
• Involved in Implementing Agile (Scrum) methodologies for the complex project modules.
• Involved in testing data mapping and conversion in a server-based data warehouse.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Responsible for leading and coordinating with offshore team.

Environment: Informatica, IDQ, SQL, Agile, Power BI, EDI, SDLC, CICS Mainframe Testing, HP ALM, Teradata, SSRS, Joins, SQL Server, XML Files, XSD, XML, Selenium, Flat Files.

Confidential, Providence, RI

ETL SQL TESTER

Responsibilities:

• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Worked with Data Completeness, Data Transformation, Data Quality, Integration, UAT testing and Regression testing for ETL and BI group
• Write SQL queries to validate that actual test results match with expected results
• Prepared the guides for UAT & Production readiness for entire Informatica ETL testing efforts.
• Used Clear Quest for defect tracking and reporting, updating the bug status and discussed with developers to resolve the bugs.
• Azure migrations for certain Data ETL applications.
• Tested HIPAA 4010 and 5010 standards for 837P EDI X12 transactions related to providers, payers, subscribers and other related entities.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica packages.
• Worked with clients to demonstrate agile techniques for software development.
• Written complex joins to validate query performance on large database volumes and worked with business users for acceptable performance criteria for each query.
• Participated in SDLC & STLC process.
• Responsible for leading team and co-coordinating with offshore team.
• Implemented HP's leading edge Business Process Testing module for driving test Automation.
• Wrote SQL scripts in TOAD for Oracle and Teradata SQL Assistant for Teradata.
• Checking the status of ETL jobs in UNIX and tailing the log files while the loading is under processing.
• Worked on Agile Methodology, participated in daily/weekly team meetings, guided two groups of seven developers in Informatica Power Center/Data Quality (IDQ) and proposed ETL strategies based on requirements.
• Worked on CI/CD pipeline to deploy applications in the cloud.
• Performed thorough data profiling to understand the quality of source data and to find data issues using IDQ.
• Performed Back end testing by writing SQL statements like Join, Inner Joins, and Outer joins and Self Joins used TOAD and SQL Developer.
• As a member of the Agile SCRUM team participated in SDLC practices.
• Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
• Performed Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse
• Involved in massive data profiling using IDQ prior to data staging.
• Involved in implementation of Test Automation Framework build using Selenium WebDriver, protractor to handle Angular.
• Involved system testing on EDI transaction for both inbound and out bound
• Involved in Informatica test cases for source and target Database validation.
• Involved in conducting the Functional, Regression and Integration testing.
• Thoroughly tested application along with bug reporting, bug tracking till bug closure
• Prepared documentation for all the testing methodologies used to validate the Data Warehouse.
• Worked with others in SDLC/STLC process.
• Written different kinds of SQL queries like creation, updates, inserts, deletion, joins etc, to perform Backend testing of the application for validating the data that comes from Frontend.
• Worked with Informatica system variable, passing variables between packages.
• Created the Microsoft Visio diagram which represents the workflow and execution process of all the process
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment.
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Extensively involved with backend testing by writing complex SQL queries.
• Worked closely with the development teams to replicate end user issues.

Environment: Informatica, IDQ, Azure, SSRS, SQL Database, Agile, EDI, DB2, Teradata, ALM Quality Center, SDLC, XML Files, XSD.

Confidential

ETL QA/ Manual Tester

Responsibilities:

• Involved in Relational Data modelling and Dimensional Modelling Techniques to design ER data models and Star Schema designs for testing the data flow between source and target
• 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.
• Maintained and executed ANT build files for running automated test cases along with Continuous Integration tools like Jenkins
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Performed Functional Testing and Back-end Testing using the database comparable results Manually
• Interacted with the users to ensure meaningful development of the scripts and simulated real time business scenarios.
• Created temporary tables for validations after understanding the transformation logic.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Performed extensive data validations against Data Warehouse
• 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.
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports

Environment: Informatica, Agile, Oracle, SQL, SQL Server, Jenkin, XML, XSD, VSAM Files, MVS, Flat Files

Confidential

Jr. Manual Tester

Responsibilities:

• Prepared and Scheduled for Backup and Recovery. Maintenance of backup and recovery plans for system and user databases
• Created roles, and set permissions to ensure that company’s security policies are enforced and in effect.
• Involved in Manual and Automated testing using QTP and Quality Center.
• Created test case scenarios, executed test cases and maintained defects in Remedy
• Tested reports and ETL mappings from Source to Target
• Tested Informatica mappings. Performed data validations against Data Warehouse
• Understood business requirements, and helped re-design the development plan, and designed the data warehouse
• Involved in job scheduling using MS SQL server Agent.
• Involved in Extensive Manual Testing using Quality Center.
• Responsible for extensive data validations on Data warehouse and reports.
• Responsible for testing Business Objects universe and universe enhancements.
• Prepare and set up environment for Disaster recovery.
• Optimized, partitioned cubes to speed up report latency and performance optimizations.
• Assisted in Troubleshooting of Report deployment on multiple servers.

Environment: Informatica, Microsoft SQL Server, Enterprise Manager, Database Transformation Services (DTS), VB Script, Business Objects, SQL Profiler, MS Access, XML, XSLT, XSD