Amrutha Pradeep

• Requirement gathering from business stakeholders and perform data analysis to get the requirement sign-off
• Analyze and understand the ETL/Hadoop work flows developed
• Work closely with Product owner, Solution designer, BAs and Developers to develop and execute thorough test suites in all phases of the SDLC
• Leads test planning meetings for business testing and holds team accountable to following test strategy document
• Develop Test strategy, test plan/design, determines necessary resources and project timelines, execute test cases and defect management
• Develops risk mitigation & contingency plans. Effectively escalates project risks and areas requiring Leadership intervention
• Worked on spark development framework to create hive table
• Execute Hadoop commands to access and move data from production to lower environment
• Run & developed the Ab Initio/Autosys jobs to load data into dev/test environment
• Worked on batch & real stream data processing (Kafka)
• Performed end-to-end testing which involves File Ingestion, Hive table validation, Data Analysis, Data Quality and Data transform validations across each layer and Tableau Report Validation
• Worked on Source File Ingestion using Ab Initio Palm Framework
• Worked on loading multiple datasets into HDFS and processing the datasets by using Hive
• Involved in creating Hive tables, loading, analyzing and validating partitions/data using Hive Queries and analyzing the log files
• Reviewing and analyzing the source data and ETL requirements to design and execute test cases
• Verifying the accuracy and completeness of the data extracted from source systems and loaded into the target systems
• Testing the ETL processes to ensure they meet performance and data quality standards
• Debugging and troubleshooting ETL issues and working with developers to resolve them
• Designing, executing and automating regression test suites to ensure that ETL processes continue to work as expected with changes to source systems, target systems or the data
• Creating and maintaining test data and test environments
• Involved in running Sqoop jobs to transfer data to Teradata for generating BI reports
• Prepared complex SQL queries to perform BI Report data validation
• Participating in code and design reviews to provide feedback and ensure that ETL processes meet the requirements and standards
• Collaborating with the project team and stakeholders to understand the data flow and data dependencies
• Provide demos/walkthrough on Test Plan/Test Design and Test Results
• Provides key updates/test status metrics to leadership and program management on test execution and progress
• Monitoring Production Jobs and worked on Production Incidents which involves root cause analysis and providing resolution
• Played the role of Scrum master

• Handled multiple projects which involves ETL Testing, Data Migration Testing, BI Report Testing, Manual Adjustment Testing, Liquidity Report Testing, Azure database testing
• Created Test Strategies, developed Test Plans, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements and Transformation Rules
• Worked with Project managers, Business Users and QA Managers in creating Test Strategy which involves people planning, environment setup and testing scope
• Worked on multiple areas - Job Validation, File Validation, ETL Validations, Data Migration, Report Mapping Validations, Downstream Extract Validations, BI Reporting
• Execution and monitoring of Control-M jobs
• Performed backend testing on Oracle and Teradata databases by writing SQL queries
• Performed testing on LCR, ALMM, CFMR, NSFR Liquidity Reports
• Performed Tableau & OBIEEE dashboard verifications which include Report Mapping checks, Report generation, Report UI checks, Dashboard UI checks
• Worked on Azure services like Azure SQL Database, Blob Storage, Azure data factory, Azure Databricks, Azure Notebooks, Azure Storage Services
• Performed data migration testing from on-premise to Azure database and validated the ETL processes in Azure SQL database
• Direct interaction with end users and BA for requirement gathering
• Assigned, Monitored and Tracked Tasks of Team Members
• Managed and worked in phases of testing such as Acceptance, System, System Integration, Regression, Functional, Performance and Sanity
• Logged and managed defects by tracking, retesting and assigning to Developers, coordinated through defect triage calls until closure and ensured defects are raised with QA standards
• Circulating Daily Status Reports to Stakeholders
• Identified the areas where test automation is required, provided solutions to implement automation which resulted in reduction of error, regression coverage increased, man hours was reduced

• Analyze the Requirement document and understand the ETL process
• Prepared complex SQL queries as per the mapping document
• Performed File Validation, Data Analysis, Data Cleansing, Data Validation and BI Report Validation
• Debugs SQL queries prepared by ETL developers and optimize the queries in order to minimize the query running time
• Created Test Plan, Test Cases, Test Scripts, Test Execution Report and Test Closure Report
• Report bugs if mismatch is found in data or if data is not populated according to the transformation logic mentioned in the mapping
• Review and consolidation of daily offshore deliverables
• Daily reporting to the Onsite coordinator and Client
• Circulated Status Reports, Test Closure Reports and Defect Analysis Reports to stakeholders
• Worked on TOSCA Automation testing which involved -TOSCA Module Creation, Test Case Design and Development, Build Reusable Libraries and Build Regression Test Suite