We provide IT Staff Augmentation Services!

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.

We'd love your feedback!