Post Job Free

Resume

Sign in

ETL Tester

Location:
Irving, TX
Posted:
January 26, 2021

Contact this candidate

Resume:

Arpitha Reddy

214-***-**** adjpzy@r.postjobfree.com

ETL tester/Lead

Software Development Data Analysis & Design Test Strategies & Plans

Solutions-focused and analytical Quality Assurance professional with a wealth of experience in system requirements, data analysis, coding, testing, installation, and administration. Skilled in problem identification, developing test specifications, test strategies, test plans, and defect management. Demonstrated ability to manage cross-functional teams on multiple projects with varying degrees of complexity. Creative and collaborative thinker who effectively leverages company resources and cross-functional teams while partnering with external stakeholders. Relationship builder who successfully articulates complex technological solutions. Invests in an empowered and aligned culture to drive results.

Technical Skills & Capabilities

SQL PL/SQL Informatica REST API Shell Scripting Agile, Waterfall Methodologies Quality Center JIRA Windows MAC IOS Android UNIX MS-DOS Oracle Teradata Microsoft SQL MS-Access IIS Apache XML TOAD Oracle SQL Developer PLSQL Developer SQL Loader Oracle Enterprise Manager HTML Power BI Tableau Crystal Reports SSRS Reports Azure DevOps ArcGIS (ESRI)

Key Accomplishments

Led the testing Rhythm for Civics a responsive cloud-based e-commerce platform that allows citizens and business to manage their government interactions on any device.

Managed the offshore and onsite QA team and coordinating with development teams in the respective projects.

Generate new ad hoc and other report scripts using Crystal and SSRS reports.

Consistently lead projects that exceed expectations in meeting project deadlines and reaching goals on time.

Implemented an auto-scheduler to overcome the manual application and database backups resulting in saving manpower and financial capital.

Demonstrated ability to work under high pressure, prioritizing tasks to deal with multiple projects simultaneously.

Oversaw system testing in collaboration with multiple teams to meet deadlines and performance metrics in receiving data and finished testing on time.

Professional Experience

Infor Global Solutions Rancho Cordova, CA 2006-May 2020

Lead QA Analyst

Led the core team to manage QA efforts with multiple Infor Public Sector ETL product lines.

Review Business Requirement and Design Documents to create and execute test scripts based on ETL mapping artifacts.

Created test guidelines and scripts, managed release testing, and quality of the products including the migration and configuration tool, dashboard, and Crystal Reports and SSRS report testing.

Ensured the business rule validation across the different integration layers.

Using Informatica (ETL tool) all the kinds of data are moved from Source to staging and from staging to Data Warehouse tables and exceptions are getting captured correctly for records with deviation.

Developed and Executed the Test cases & Scripts for Functional, System, Regression, Integration, Performance and UAT.

Supervised interviewing and screening, planning, assigning, and directing work, and addressing complaints.

Performed imports and exports, maintained user updates, and ensured database backups performed regularly.

Built data table configurations and maintained security options, and assigns passwords for database access.

Installed database software upgrades and patches as required to set up test environments.

Created detailed test plans, specifications, and documentation reviews, scheduled technical /application test training, and determined the scope of testing requirements.

Conducted testing to certify software defect fixes and new functionality following documented guidelines, test plans, and procedures; executed functional, application, regression, and performance tests for software releases.

Created clear and precise defect reports as required for identified software defects and functional defects based on testing results.

Developed test data, wrote test standards and procedures with responsibility for automation of test plans, test scenarios, and test scripts within Rational product (Automated testing tool).

Analyzed test results, offered recommendations, and documented results from tests and communicates the results to the QA Manager.

DST Output El Dorado Hills, CA 2006

Software Quality Assurance Analyst

Prepared, developed, maintained, and executed a wide range of more complex quality tests with full competency to ensure software meets or exceeds specified standards and end-user requirements.

Conducted detailed risk assessments and drafts, revised more complex test plans and scripts to make potential malfunctions occur.

Documented discrepancies and collaborated with technical associates on the resolution of those discrepancies.

Built, tested, and released software applications and documentation, participated in project reviews throughout the project life-cycle, and in the establishment of testing standards and methodologies for the project.

MCI Sacramento, CA 2005-2006

Oracle Database Analyst

Delivered data and system analysis to restore contractual application solution services, including web-based applications, point of sale devices, and other legacy systems.

Operated on projects with a vast scope and technical complexity and resolved a wide variety of problems ranging from routine/simple to highly complex requiring judgment and discretion to select the appropriate method or technique and interpret applicable operating policies and practices.

Applied PL/SQL, SQL, SQL*Plus/TOAD, Oracle 8i/9i, Unix shell scripting, XML, Sun Solaris, UNIX, and Remedy Ticketing Software for tasks in support of problem resolution.

California Independent System Operator 1998-2005

Sr. Systems/Data Analyst

Oversaw Oracle 9i/8i/7.3 database analysis, design, implementation, maintenance, and administration on Solaris/UNIX systems.

Performed imports and exports; add and remove users to and from the database; ensures that database backups are performed regularly.

Established data table configurations, maintained security options, and assigns passwords for database access. Installed database software upgrades and patches as required.

Delivered technical support to production systems to ensure they are running error-free and projected space requirements for the implementation of new schemes.

Developed and customized billing and settlement applications utilizing PL/SQL, ORACLE 7.3,8i, 9i, MSSQL, MS Access databases, Oracle Alerts and File utilities, and TOAD.

Analyzed and determined information needs and elements, data relationships and attributes, proposed manipulation, data flow, and storage requirements, and data output and reporting capabilities.

Assisted the Information System Service staff with establishing database connections between users, customers, and other contractors.

Endorsed business analysts with queries and ODBC connections and provided technical advice to database users.

Identified measures or indicators of system performance and the actions needed to improve or correct performance relative to the goals of the system.

Collaborated with the business unit department to develop requirement specifications and evaluated the feasibility of the scheme and defined implementation schedules.

Engaged with the development team to ensure that the requirements are understood clearly and hosted discussion sessions to resolve any questions/clarifications raised by the development team.

Documented and reviewed technical specifications for new schemes and enhancements and involved in the development of test strategies.

Coordinated with various departments including systems, networks, developers, and business units in setting up test environments.

Education

Post Graduate Diploma Computer Applications

Master of Science in Commerce Osmania University, Hyderabad India

Bachelor of Science in Commerce Osmania University, Hyderabad India

ORACLE DBA Training (Architecture & Administration, Backup & Recovery, Performance Tuning)



Contact this candidate