SUMMARY:

• An experienced ETL Tester who has successfully ensured that accurate, up - to-date, relevant data is transferred to the target Database.
• 6+ years strong experience ETL testing
• Domain experience includes Telecom, Financial/Mortgage, Video streaming, Educational, Healthcare sectors
• Have strong SDLC experience and Agile, Kanban methodologies
• Strong experience with ETL systems, and having expertise with tools Informatica and Data stage.
• Strong experience in testing Data Warehouse (ETL) and Business Intelligence (BI) applications.
• Strong experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading
• Designing good ETL test cases (mapping scenarios, validate data count between source and target, etc.)
• Validating the data sources
• Performing the various kinds of ETL testing (ETL regression testing, data quality testing, data completeness testing, etc.)
• SQL experience and knowledge
• Excellent communication, inter-personal, team skills
• Have experience performing ETL/Data warehouse and database testing.
• Did many stages of testing such as Regression testing, Integration Testing, System Testing and User Acceptance testing, etc.
• Back-end testing using SQL, PL SQL, Unix
• Well versed in testing Methodologies, Web testing, and software Deployment/Release processes.
• Strong SQL skills including the use of unions, Multi-table joins and outer joins.
• Good exposure with databases like Oracle, SQL Server, PostgreSQL
• Cloud experience (Salesforce administration, Salesforce QA, etc.)
• Knowledge of Data Warehouse star schema design and usage
• Big Data/Hadoop knowledge: HDFS, MapReduce, Name Nodes, Data Nodes, etc.
• Have found a number of defects: missing data from the Target database, truncation of data, data type mis-match, etc.
• Extensive test case creation, verification, edge cases and regular updating of test cases
• Have been praised (by team members and leads) in each project, for my contributions to the project and quality of my work.
• Healthcare volunteer experience with VA Medical System, Long-term care facilities
• Data import, export, sharing, cleansing

TECHNICAL SKILLS:

OS (Operating System): Windows, iOS, Android, macOS, tvOS, etc.

ETL tools: Informatica, SSIS

Test Management Tools: JIRA, Rally, HP ALM, Quality Center, etc.

Platforms/Tools/Architecture: Informatica, Oracle, SSIS, Mobile, Web, Salesforce/SFDC, MVC architecture, Unix, Set-top-box (STB), Electronic Health Records (EHR), etc.

Languages: SQL, APEX, VB script, some Java, etc.

Software Methodologies: Agile, Kanban, Waterfall, etc.

Browsers: Chrome, Mozilla Firefox, Safari, Edge, etc.

Additional technologies: Microsoft Office (Outlook, Project, Excel, Word, Access, PowerPoint), etc.

Web Technologies: CSS, HTML, XML, JavaScript

RDBMS: PostgreSQL, SQL Server, Oracle

PROFESSIONAL EXPERIENCE:

Confidential, Birmingham, AL

ETL Tester

Responsibilities:

• Created and executed test cases based on test plans
• Got requirements from the business team and used this in my work
• Developed SQL scripts and ran them in SQL Server
• Used SQL Server Integration Services (SSIS) to update internal tables
• Did production validation. Validated data in our production systems and compared it against source data. This protected the data from faulty logic, failed loads, etc.
• Verified that the data was transforming correctly according to business requirements
• Conducted source and target data compares from ETL runs
• Did Data cleansing
• Was praised for my contributions, quality of work

Environment: Informatica, SQL Server, SSIS, Print Spooling and Processing systems such as Columbus, CA Rally

Confidential, San Jose, CA

ETL Tester

Responsibilities:

• Created test cases based on the requirements
• Developed SQL Queries to retrieve or create test data from different Oracle Test databases.
• Involving in Functional testing, End to End testing and Regression Testing.
• Preparing and supporting the QA and UAT test environments
• Checked if the data was transforming correctly
• Did testing of Informatica ETL jobs that developers created
• Tested if the Informatica mappings that were created for loading data to the data warehouse
• Created ETL summary reports
• Developed SQL database scripts (both simple and complex) to perform verification of SQL objects or non-relational quires and various data migrations.
• Worked closely with Developers, Business Analysts, Project Manager
• Was praised for my contributions, quality of work

Environment: Informatica, JIRA, Teradata, etc.

Confidential, Harrisonburg, VA

ETL Tester

Responsibilities:

• Created test data required for testing
• Created and executed SQL Queries to verify the dataflow from the backend
• Validating the data against staging tables and target warehouse.
• Find report defects and subsequently validating the fix, repeating the process until done
• Performing input validations, user interface validations,
• Created Business Intelligence reports
• Documented test artifacts such as test cases, etc. in JIRA
• Was praised for my contributions, quality of the work

Environment: Oracle 9i/10g, Tableau, Teradata SQL Assistant, Teradata V2R6, TOAD for Oracle, etc.