SUMMARY

• Skilled Professional 9 years of Software Quality Analyst experience with emphasis in ETL Testing & experience in Healthcare, Banking and Retail domain.
• Proficient in performing ETL, BI, backend manual testing.
• Expert in writing SQL scripts required for testing various ETL and Data Warehouses in Agile Scrum environment.

TECHNICAL SKILLS

ETL: DataStage, Informatica, Ab Initio, Talend, SSIS, Azure Data Factory.

Databases: Teradata, Oracle, SQL Server, MySQL, DB2, Netezza.

Big Data: Hadoop, HIVE, Cassandra, MongoDB, MarkLogic, Snowflake.

Real - Time Data Streaming: Kafka, Flume, NIFI, Kinesis.

Reports: Business Objects, Crystal Reports, Cognos, Excel.

Business Intelligence: Tableau, Power BI.

Scheduling: Control-M, Autosys, Tivoli.

Methodologies: Agile Scrum, Kanban, Waterfall

PROFESSIONAL EXPERIENCE

Sr. ETL Data Warehouse Tester

Confidential, Chicago IL

Responsibilities:

• Wrote and processed quick test scripts through the expert view by adding conditional statements, loops, and other user - defined functions.
• Generated test cases, test strategy plan, and RTM to guarantee proper coverage of requirements and business processes.
• Supported QA execution to guarantee the accuracy of data flowing through each stage of the ETL process.
• Utilized Shell scripts greatly for automation of file manipulation and data loading procedures.
• Shipped data from tables in one schema to CSV files and exported to tables from another schema utilizing SQL* Loader.
• Generated Jobs to Written several UNIX Shell Scripts for cleanup, logging, file manipulation, and transferring the files.
• Presented design direction and oversight of code development in Ab Initio, KSH, and PL/SQL.
• Examined loaded data warehouse components like ODS (Stage), EDW, and data marts tables following the jobs run.
• Test Business Objects reports for data validations and examine results with TOAD.
• Conducted additional data validation using custom SQL scripts.
• Developed automation test scripts for data creation using a Python library called Faker.
• Launched and Involved in Test Design, Test Plan, conduct audits, Test Development, and analyzing Test Results.
• Conducted UAT (User Acceptance Testing) and administered to verify the applications' requirements, look, and feel.
• Served as a Lead ETL tester for Liberty Mutual (Insurance), managing a team of three on ETL testing.

Environment: Talend v7, DataStage v11.7 v11.5 v9.1, Azure Data Factory, Oracle v19c v12c, Teradata v17 v16, AWS Snowflake, Kafka, MongoDB, Unix, Control-M, Business Objects, Power BI, Agile Kanban.

ETL QA Tester

Confidential, Des Plaines IL

Responsibilities:

• Developed the test plans, test procedures, and test scripts from the decomposed specifications and use cases utilizing the Quality Center.
• Trained new team members, mentored them to learn the business process along with data examination.
• Backed QA in reporting test cases and problem metrics to all organization levels utilizing Quality Center/ ALM.
• Generated shell scripts to automate file manipulation and data cleansing procedures.
• Examined the Transformation rules from source to target tables by running easy and complicated SQL queries on the oracle database.
• Derived data from multiple sources like flat files, web services, SQL Server and Oracle in UNIX platform.
• Served on Batch Processing ETL, PL/SQL subprograms, and performed backend testing.
• Achieved full data warehouse life cycle implementation, including analysis, design ETL processes, development, and testing.
• Authorized the data utilizing SQL queries (TOAD) extensively.
• Produced required SQL scripts for database testing and Performed DATA validation utilizing SQL queries and was also involved in backend testing.
• Developed Scripts using Python Selenium WebDriver combo for user module application.
• Used ClearCase to manage test documents and record test results and ClearQuest to log testing errors.
• Worked on SQL scripts to load data in the target tables and was involved in writing UAT Test cases.
• Programmed and executed data verification for ETL routines to ensure that they don't break on heavy loads.
• Evaluated DataStage Jobs and test cases before transferring to Client.

Environment: Informatica v10 v9, SQL Server v, Oracle v11g, Hadoop, HIVE, Cassandra, Autosys, Tableau, SAP Crystal Reports, Agile Scrum.

ETL Tester

Confidential, Houston TX

Responsibilities:

• Performed Manual testing utilizing TestDirector to generate test cases, test scripts, performing the scripts, and logging the bugs.
• Participated in testing, produced KPI's which regulate the business processes in our company.
• Involved in smoke testing when migration demands to transfer the modifications from development to QA / UAT / production environment.
• Verified PL/SQL stored Plans utilized for customers placing orders regularly.
• Generated and implemented SQL queries to do Data Integrity testing on an Oracle Database to verify and test data.
• Examined various UNIX Shell Scripts and PERL scripts for correlating to the database and for file manipulation of data.
• Utilized SQL, PL/SQL to examine backend functionality.
• Guaranteed all Main Frame and Data Warehouse improvements and defect fixes are executed with a high degree of correctness.
• Autanticated Data warehouse tables utilizing Toad.
• Performed data validation of higher than 1.3 million records utilizing SQL in IBM Data Studio from the Loans and deposits side.
• Designed and implemented Python scripts to provide robust error - handling capabilities.
• Analyzed complex test outcomes and the improvement of problem resolution and communicated growth to Management.
• Transferred and stationed the ETL code in SIT, UAT & production environments as per the control measures.
• Performed the ETL Development team and database team to guarantee testing requirements and development processes according to the functionality.

Environment: SSIS, SQL Server v R2, DB2, Netezza, IBM Cognos, Tivoli, Waterfall, ALM HP Quality Center.