ETL Tester

Position: Certified ETL Tester Quality Assurance Analyst/Tester`Location: Brooklyn, NYDuration: 2 YearsHours: 35 hours Per WeekJob Description:Responsibilities:Perform functional, regression, performance, and automation testing of applicationsParticipates in project-level planning and reviews and approvals sessions, which includes business requirements and Application Software Requirements/Design review meetings.Analyze and understand ETL structural mapping and technical specification documents.Create test cases to perform Sanity, Functional, Regression, Database and ETL Testing.Analyze and report on complex data; both source and target systems to identify potential gaps in mapping documentation.Design tests for DW/ETL source data extraction, business transformation logic and target table loading.Identify, analyze and document problems with functionality, output files, or tables. Monitor defect resolution efforts and track progress.Write complex SQL queries and develop solution diagrams to demonstrate new capabilities.Foster partnerships with ETL, Data Warehouse, Data Modeling, Product Owner, and Business Partner teams.Implement an efficient and scalable Selenium Webdriver framework and with designing multiple types of automation frameworks including data-driven, modular, and database.Identify and write efficient test automation scripts using Selenium Webdriver.Must be proficient in Java programming concepts (variable, loop, procedure, function, data types and collections, exceptions, and debugging your code). This task is coding scripts and not using simple recording of the UISuccessfully automate smoke tests and regression test suitesReview peer scripts before they are checked into the test automation libraryCross-train and mentor other team members on the automation framework and scripts development.Identify Performance thresholds using client side & server side metrics and build load modelsProvide gap analysis and recommendations for the resolution of issues Mandatory Skills/Experience:Minimum 6 years of experience writing and maintaining automated test scripts using the Selenium toolset to test data quality and system functionality.Minimum 3 years of experience in performance engineering (this includes performance testing and deep dive performance analysis experience.Minimum 3 years of experience in backend testing including ETL processes that extract data from homogeneous or heterogeneous sources.Solid understanding of ETL source to target data mappings and transformation rules.Good understanding of data warehousing concepts and data analysis.Experience in writing SQL (medium to complex) statements to test data mapping & requirements, and perform extensive data analysis to identify the defectExperience using Microsoft Team Foundation Server to track and test project assetsCapability of translating and presenting technical concepts into practical business terms for leaders in both small and large group settingsExperience with MavenSolid understanding of object-oriented language including data structures, collections framework and multithreading.Experience in building and managing continuous integration using tools such as Jenkins, Bamboo, etc.Experience in various testing methodologies, including Agile, Iterative, and Waterfall.Extensive experience in boundary testing, decision table testing, and state transitions testing.Ability to work on multiple work streams or projects simultaneously.Experience using test tools including Selenium, Load Runner, JMeter, Microsoft Team Foundation Server, HP products, SOAP UI, and Visual Studio to manage testing assets.Experience conducting performance testing for browser-based systems on PCs and mobile devices.Capability of translating and presenting technical concepts into practical business termsISTQB or Certified Software Tester (CSTE) certification.Business domain experience in the education or municipal government sectors.