Etl/datawarehouse Tester Resume
4.00/5 (Submit Your Rating)
OBJECTIVE
- Proactive, self - motivated, and goal-oriented individual seeking to obtain entry-level position that utilizes my combined academic and practical specific experience.
- Offering organizational skills, leadership strength, and the ability to work well with others to reach and exceed corporate goals.
TECHNICAL SKILLS
- HTML4/5
- CSS2/3
- DHTML
- JavaScript
- XHTML
- XML and SQL
- Oracle
- Unix/Linux
- IBM Datastage
- Jira
- Azure
- Tableau
- Fitness
- Informatica
- Hadoop
- Teradata
- IBM Web sphere
- Agile
- Waterfall
- HP QC/ALM
- UC4.Servicenow
- Remedy force
PROFESSIONAL EXPERIENCE
Confidential
ETL/Datawarehouse Tester
Responsibilities:
- Coordinate with Offshore leads and Dev Leads to analyze and provide solutions
- Write test data scripts, based on ETL mapping artifacts
- Execute data scripts and detailed analysis on the scripts
- Create strategies and test cases for applications that use ETL components
- Data mining and detailed data analysis on data warehousing systems
- Execute formal test plans to ensure the delivery of data related projects
- Provide input and support big data testing initiative
- Define and track quality assurance metrics such as defects, defect counts, test results and test status
- Document all problems and assists in their resolution
- Create SQL scripts based ETL mapping documents
- Create and execute strategies and test cases for applications that use ETL components·
- Participate in the Requirement Understand meetings with Client, Business Analysts, Business Users and Developers.
- Preparation of Daily & Weekly Status Reports, Testing Key Metrics & Test Summary Report.
- Identifying the exact root cause by working with Dev & Data Architect for the resolution.
- Responsible for Testing the Data flow between Source, intermediate and Target systems
Confidential
Software and ETL Testing
Responsibilities:
- Excellent DW/BI ETL QA skills.
- Requirement analysis and understanding of DWBI technical specification documents.
- Analyze and understand the ETL workflows developed.
- Validation of data transformations and perform End-to-End data validation for ETL & BI systems.
- Experience with unit testing tools such as Fitness.
- Good understanding experience with Test Driven development warehousing and BI testing with strong data analysis, SQL & data analytical skills.
- Very good understanding in ETL workflows and BI dashboards.
- Perform data analytical testing for the BI systems.
- Technologies: Netezza, Oracle, Informatica, UNIX
- Strong database SQL skills with good understanding of UNIX Support the development of machine learning Models that analyze data sourced from various lines of business to detect patterns/anomalies in the data to predict future behavior.
- Validate the data flow from its original source to the final output which includes the Models’ scored results.
- Create and execute use cases for verifying data transmission depend upon the data source and the methodology defined for -
- Batch processing - includes creating data for model ingestion, triggering Autosys jobs, verifying exception handling and the final model output
- API validation - includes creating data for model ingestion, validating JSON request/responses using an API validator triggered by eclipse and Postman for manual testing, verifying exception handling and the final model output
- Strong communication skills
Confidential, Auburn Hills, MI
Software Quality Support Analyst
Responsibilities:
- Maintains and supports systems, workstations, mobile devices, printers, and peripherals.
- Design and execute test strategies, text plans, test cases, test scripts, traceability matrix
- Track details and use methodical processes to maintain an effective testing strategy
- Manage defect and test case progress reporting and communicate with stakeholders
- Share status of testing progress and forecast timeframes to complete tasks
- Focuses on solution-oriented approach and identifies complete regression testing needs involving multiple parts of a product and system.
- Manages the validation test phase including executing scripts, logging and tracking problems found, and regression testing any changes made to the system.
- Able to design and manage automated test approach for tests and ensure that manual tests are automated using suitable tools and framework for the product.
- Reviews and approves and executes the Integration Test Plan and Procedures
- Validates the completion of Integrated Testing. Consults with development engineers in resolution of problems and suggest functional solutions.
- Develops, executes and analyzes the output from scripts that capture application and platform quality metrics.
Confidential, Orlando, FL
DataStage Developer
Responsibilities:
- Coding and testing complex (data from multiple sources such as SQL databases) IBM DataStage jobs.
- Determine the appropriate code for ETL applications based on information gathered including data sources, data targets, data definitions, data relationships, and business rules.
- Provide technical expertise on ETL design, Data modeling, Data Warehousing, and Data integration.
- Develop DataStage Parallel Extender jobs using different stages like Aggregator, Join, Merge, Lookup, Source dataset, External Filter, Row generator, Column Generator, Change Capture, Copy, Funnel, Short, Peek stages etc.
