SUMMARY

• Over 4 plus years of IT experience as SQA Engineer in ETL testing broadly developing test strategies for ETL loads, performing regression, end to end validations in various environments from test to UAT and providing production support.
• Reviewing Mapping documents to design test plan, test cases as per business requirements, functional specifications and coordinating with product owner and business for acceptance criteria.
• Experience in creating Test Plans, Test Cases, Test execution and generating Test Scripts.
• Preparation and execution of Test Cases and Scripts using Rally and Jira for defect tracking based on various QA stories.
• Worked in Agile environment with scrum team and followed best agile practices.
• Ability to manage time effectively and work to meet client deadlines.
• Ability to integrate testing tools to efficiently test system functionality and report bugs detected during testing.
• Hands on experience in Snowflake cloud d Confidential warehouse environment performing analysis using Snow - SQL.
• Tested various Data Visualization Dashboards in Tableau/Power BI
• Excellent verbal and written communication skills.

TECHNICAL SKILLS

Reporting Tools: Informatica 9.6 Tableau

Defect Reporting Tools: Jira, Rally Programming Languages SQL, Python

Databases: Oracle 12c, MSSQL Server 2012, PostgreSQL, Snowflake Cloud Data - Warehouse

Operating Systems: UNIX, Windows

Others: Airflow, AWS S3, Snowflake, Snow-SQL, Beyond Compare, Visual Studio Code, Toad, GitHub, Slack

PROFESSIONAL EXPERIENCE

ETL Test Consultant

Confidential, Overland Park, KS

Responsibilities:

• Developed, designed, reviewed, and executed Test Cases based on the Business Rules and Mapping Documents.
• Responsible for Testing of ETL processes, Data cleanliness, Datal completeness testing, Data transformation, Data validation.
• Created test case scenarios, executed test cases, and maintained defects in internal bug tracking systems.
• Involved in functional study of the application and Prepared test d Confidential for testing.
• Performed validation from XSD to XML and d Confidential base to XML validation.
• Involved in validating stored procedures.
• Involved in identifying the test scenarios and writing detailed test cases.
• Involved in testing where most of the Transformations are used.
• Interactions with BA & Dev Teams to resolve the issues.
• Involving in sending the test report during execution.
• Defect analyzing and reporting in rally.
• Reporting daily testing status.
• Status reporting, project tracking, documentation, and reporting.
• Worked in the D Confidential Analytics & Engineering team to generate product category & attribute insights using clickstream d Confidential .
• Participated in design and creation of analytics schema and tables.
• Wrote SQL queries to process clickstream d Confidential and populate daily analytics tables in Snowflake d Confidential warehouse.
• Integrated the queries with the Airflow ETL pipeline
• Built dashboards using Tableau to highlight important trends/insights around product categories and attributes.

Environment: Oracle SQL developer, SSIS, SharePoint, Web Services, Rally, XML, Oracle 12, Snowflake, AWS S3, Web Services, Airflow, Snowflake D Confidential warehouse, Snow-ScQL, Tableau

Software Test Consultant

Confidential

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Source to Target Detailed mapping document & Transformation rules document).
• Analyzing business requirement needs and functional requirements to ensure creation and execution of appropriate Test Plans and Test Cases.
• Worked closely with project team leader to coordinate and implement testing methodologies.
• Maintained ETL scripts that acquire d Confidential from various source systems to load information into the Staging Area, the D Confidential Warehouse and D Confidential Marts.
• Frequently Created and maintained SQL Scripts to perform Back-end testing on the SQL server for d Confidential integration and d Confidential analysis.
• Wrote SQL Statements to extract D Confidential from Tables to verify the output D of the reports.
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios & reports.
• Created and executed extensive SQL Queries with complex multi-table joins and nested queries to meet organizational d need.
• Involved in reviewing complex SQL queries and stored procedures and spotting issues before/during code migration.
• Responsible for different D mapping activities from Source systems to Target.
• Performed application testing by Unit Testing, Smoke & Integration Testing, and UAT .
• Performed d Confidential validation- using MS SQL Server 2012
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Logged defects in JIRA for multiple user stories and assigned tasks to respective ETL developers.
• Participated in daily standup's, sprint planning and retrospectives/review meetings.

Environment: Informatica 9.6.1, MS SQL Server 2012, SharePoint, Web Services, JIRA

Data Encoder

Confidential

Responsibilities:

• Evaluated and followed up on news leads and news tips to develop story ideas.
• Performed research and checked all facts to maintain high standard of journalistic integrity.
• Responsible for GUI interface content loading and back-end resource validation in dynamic environment.
• Edited and sourced images and videos using adobe Photoshop and AVID.
• Managed content distribution to online channels and social media platforms.
• Used content management system to analyze user engagement and website tra ic metrics.
• Delegated and tracked each sta member's assignments and deadlines.
• Worked with graphic artists, post-production team members and other specialists to produce captivating and successful content.