Data Warehouse Tester Resume
3.00/5 (Submit Your Rating)
Vienna, Virginia
SUMMARY
- Cross - industry experience in Government, Financial, Health.
- Extensive data validation experience in CDC, SCD Types, and Data sync, Data Warehouse, Data mart, Incremental load, historical load.
- Extensive hands-on experience in each phase of Waterfall, Agile and Iterative Methodology.
- In-depth noledge and experience in time management, risk management and integration management.
- Highly organized in creating/maintaining test plan, test strategy, testing standards, testing framework (manual/automation), business requirements, process improvements, preparing and reporting test metrics, effort estimation and implementing quality assurance practices to reduce defects and improve teh software product quality.
- Extensive experience in establishing successful partnership wif business users, understanding objectives, defining/clarifying business rules and functional requirements, coordinating, driving, conducting effort to ensure full testing coverage of all application functionality.
- Good interpersonal, analytic and communication skills who can inspire and motivate team members. Excellent team player who listens, thrives on collaborating wif diversely talented team members, and integrates their divergent thoughts, opinions, and perspectives into meaningful action.
TECHNICAL SKILLS:
Technology: ETL Automation
DVO: Bigdata, Hadoop, Impala
Databases: Oracle, SQLServer, Teradata, DB2, Vertica, Postgres.
ETL Tools: Informatica PowerCenter
BI Tools: Tableau, BO, Microstrategy, SSRS, OBIEE
Test Management Tool: ALM, Jira, Rally, TFS, CQ, CLM
Tools: XmlSpy, SecureFx, SecureCRT, Sharepoint, Visio, Control-M.
PROFESSIONAL EXPERIENCE:
Confidential, Vienna,Virginia.
Data Warehouse Tester
Responsibilities:
- Writing complex sql queries to validate source and target data.
- Writing stored procedure to aggregate source data for multiple dates, environment to automate teh validation processes.
- Data warehouse migration testing from SQL Server to Teradata to Hadoop.
- Validate source to target data using Informatica DVO.
- PDM, source to target data validation using Java, TestNG framework.
- Write complex SQL query in Teradata environment to create sqlview to automate data testing.
- Comparing Hadoop data file using Impala, beeline, text file, DVO against Teradata.
- Write complex SQL query to validate data quality checkpoint.
- Analyze data model, data mapping, and transformation documents.
- Create test data for different test scenarios.
Confidential, Washington DC
ETL Tester
Responsibilities:
- Automate data validation test cases using DVO.
- Write complex queries to validated xml data loaded into Postgresql database.
- Write test cases, Tasks and defects in CLM.
- Run informatica workflow using control m.
- Analyze data model, source to target mapping specs, technical design document.
- Performed data analysis, troubleshoot, find root cause of bad data.
- Create xml test data using xsd schema and validate teh data against teh database.
- Validating BO reports.
Confidential, Washington DC
ETL Test Lead
Responsibilities:
- Validate Informatica upgrade, MSSQL Server migration testing using DVO.
- Validate source to target data.
- Validate CDC data.
- Record count, duplicate key, null values, data types, junk data, data size, Mandatory field, primary key, surrogate key generation, Derived Field check.
- Analyze data model, source to target mapping specs, technical design document.
- Performed data analysis, troubleshoot, find root cause of bad data.
- Validate fact, dimension tables, SCD types, Historical load, and incremental load.
- Test reports created in SSRS, and Microstrategy.
- Writing test data, test cases, test scenarios, test plan.
- Write complex sql queries to validate data.
- Automate Contingency environment’s data validation testing.
- Ability to analyze root cause of a problem and demonstrate good sense when handing teh problem over to development.
Confidential, NY
ETL Test Lead
Responsibilities:
- ETL tool migration from Pentaho to Informatica validation.
- Writing complex SQL queries using joins to create sql views.
- Review, analyze FDR, DD documents, developed strategies, test plans, and executed teh test cases.
- Work closely wif business users to gather requirements, define project specifications, develop implementation and test plans for teh projects & enhancements.
- Documented business workflows textually as well as in UML diagrams for teh stakeholder review.
Confidential
ETL/BI Tester
Responsibilities:
- Automate data validation for CSV, TXT files.
- Involved in Business analysis and requirements gathering.
- Implemented a full-manual and automated testing framework, Testing standard, testing guidelines, test plans for Database migration, Data warehouse/ETL, BI Testing.
- Creation of new data warehouse that maintained over 3,000 data tables.
- Extensively used Informatica to load data from Flat Files to Vertica, Vertica to Flat Files, Oracle to Vertica and Vertica to Vertica.
- Written Test Cases for ETL to compare Source and Target data, Ensured that teh mappings are correct and conducted data validation testing.
- Validating teh load process of ETL to make sure teh target tables are populated according teh data mapping provided that satisfies teh transformation rules.
- Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
- Written UNIX shell scripts for file transfers, error log creations and log file cleanup process.
- Preparing test deliverables and updated teh same to senior staff for review.