Share this Job

Go Back

ETL QA analyst, Location: San Ramon ,CA. Dur:6 months ,(possible extension 18 months),Rate: Open


2017-02-21 11:58:27
Job Type: Contract

Job Description:
Role:

  • This resource will be part of BIDM (Business Intelligence Data Management) team for Data ware- house testing projects. Primary responsibilities would be, understand requirements & data mapping, define test plan, develop test cases, conduct reviews and execute test cases.
  • Resource should be primarily interacting with Dev team, BSA, Data Analyst, and Data architects for understanding project requirements, Technical design and data mapping.
  • Resource should participate in daily status meetings to provide accurate QA status with Project manager.
  • Should be able to understand data mapping and document test cases and test scripts independently and have excellent team player skills to work with cross domain team in dynamically changing environment.
  • This is not a lead or manager position. Resource should be a hands on ETL tester to execute multiple projects at a time.
Experience/Skills required:
Core skills (Must have):

  • Overall 8+ years of experience of IT experience with minimum of 4+ years of ETL/ Data Warehouse Testing.
  • Experience in writing SQL (medium to complex) statements to test ETL code based on the data mapping & requirements provided and perform extensive data analysis to identify the defects.
  • Strong Data ware house and BI concepts.
  • Experience in working testing through Informatica or related ETL tools, Oracle database, BI tools like OBIEE, etc. and has experience working with UNIX/LINUX.
  • Experience in working with large scale Enterprise Data Warehouse, Data Integration, Data Migration and upgrade projects.
  • Experience in testing data warehouses systems and have defined test approaches for data warehouse projects.
  • Experience in creating Test plan, test cases and engineering best practices related to software test engineering, both manual and automated testing.
  • Experience coordinating testing activities and optimizing test cycles working with project team.
  • Experience with utilization of appropriate test methodologies and use of test management tool like HP ALM.
  • Experience with conducting and running defect triage meeting with project teams.
  • At least 3 - 5 years?? experience of working with financial services applications.
  • Strong in STLC process, Test Strategy/Plan, Test Estimation
  • Effective Project & People Management Skills, exposure to Knowledge Management.
  • Solid time management and prioritization skills.
  • Excellent verbal and written communication skills

Key Skills: