ETL / Big Data Tester

Company: Ampcus Inc
Location: Chantilly
Posted on: February 20, 2021

Job Description:

Ampcus Inc. is a Global leader in end-to-end IT Business Solutions and Services with latest technologies. We are listed among the top 50 fastest growing companies in USA. We work closely with our clients for Talent acquisition. Job description:Responsible for executing formal test plans to ensure the delivery of a big data testing initiative. Responsibilities:

• Develop test data scripts based on ETL mapping artifacts and other technical documentation.
• Execution and detailed analysis of test data scripts
• Defines and tracks quality assurance metrics such as defects, defect counts, test results and test status.
• Documents all problems and assists in their resolution. Required Qualifications

• 5 to 10 years of relevant work experience in testing backend application primarily involving complex SQL queries
• At least 5 years' experience in:
  • Testing "Big Data" and Enterprise Data warehouse
  • Writing and Executing complex queries in SQL
  • Experience in analyzing ETL mapping documents
  • Writing and Executing ETL scripts and Stored Procedures
  • Development of SQL scripts based on ETL mapping and database documents to validate data inputs and compare data outputs
  • Using tools such as Informatica (PowerCenter)
  • Integration testing - Services, ETL, Database (SQL/Oracle) - covering DML Validations, Batch Monitoring etc.
  • Cloud databases (AWS /Redshift)/Relational databases
  • Experience testing mission critical Financial Applications
  • Advanced level of expertise in Database testing with excellent PL /SQL skills
  • Ability to create and execute test plans, strategies and test cases for applications that use ETL components
  • Experience planning, writing, executing tests as well as preparing test strategies
  • Experience in using testing tools such as ALM and JIRA Critical Skills
    • Ability to work on multiple assignments simultaneously and produce high quality products
    • Very good communication skills
    • Strong problem solving and analytical skills demonstrated by the ability to assimilate new information, understand complex topics and arrive at sound analysis and judgment
    • Should be a good team player
    • Experience testing Waterfall / Agile Development Projects
    • Keeps abreast of current technology trends
    • Familiar with application development best practices
    • Well-versed in the use of Microsoft Office Tools
    • Big Data Preferred Qualifications
      • Basic knowledge on how to use Tidal is a plus Regards,Sufiyan ShaikhLead - Talent AcquisitionAmpcus Inc. - provided by Dice

Keywords: Ampcus Inc, Chantilly , ETL / Big Data Tester, IT / Software / Systems , Chantilly, Virginia