Akhila

ETL Developer at Warner Bros

Designed Informatica mappings and transformation logic; implemented performance tuning for mappings; executed extensive SQL queries for data analysis; developed unit/test plans and prepared mapping documentation; created UNIX shell scripts to automate bulk load and update processes.

ETL Developer at American Express

Collaborated with Business Analysis to collect requirements; defined Source-to-Target Mappings and Transformation rules; developed Informatica mappings, sessions, workflows and mapplets; wrote SQL/PL-SQL for data extraction and testing; implemented bulk-load interfaces using UNIX shell scripts.

Associate Analyst at Cognizant Technology Solutions

Performed end-to-end QA for ETL/Data Warehouse projects; created Test Plans and Test Cases from requirements; implemented Traceability Matrix and URS/STS verification; conducted backend testing with Oracle, SQL, Teradata, Snowflake; automated regression using Python; collaborated with BAs, Designers and Developers; produced status and strategy reports.

QA Analyst at INTACT FINANCIAL SERVICES, CANADA

Worked on IFRS17 project; developed Test Plans and Test Cases; performed system, integration, functional testing across multiple source systems; analyzed Source-to-Stage and Stage-to-Target mappings; validated ETL workflows in Informatica; authored backend SQL queries for data validation; contributed to defect tracking and test documentation.

ETL QA Analyst at KEY BANK, USA

Transformed High Level/System requirements into functional specs; wrote Python scripts to test Hadoop-extracted data; developed Python framework for regression testing; managed data migration project from Hadoop to AWS; validated source/target mappings with Teradata/BigQuery; automated data validations in Linux; tracked defects using ALM/JIRA and prepared test artifacts.

ETL QA Analyst at Canadian Western Bank, Canada

Validated AML/KYC data and SAS AML/Finscan reports; developed and executed test cases for Power BI AML risk dashboards; validated source-to-target data in MSSQL; automated regression testing using Python; documented test scripts/defects; created sample data; prepared UAT test cases and scenarios.