Senior Software Developer/Tester(#SSDT-0150) Ampcus Inc.

Ampcus Inc

Chantilly (VA)

Hybrid

USD 90,000 - 130,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Ampcus, Inc. is seeking a Senior Software Developer/Tester to lead testing and quality assurance for ETL/Data Warehouse and BI applications.

The role emphasizes ETL validation, data quality, and continuous improvement within an agile environment. The candidate will review requirements, develop test plans, write complex SQL queries, and collaborate with cross-functional teams to ensure reliable data flows from source to target systems.

Qualifications

  • Bachelor’s degree in Computer Science, Information Systems or related field and 5 years of experience in software testing or ETL development.
  • Alternative: Master’s degree with 3 years of related experience; experience must include ETL testing and development.

Responsibilities

  • Requirement analysis, test strategy development, test case creation and test execution for ETL/BI applications.
  • Design, implement and maintain ETL validation scripts for data quality checks.
  • Perform system integration testing of ETL processes and reconcile data between source and target systems.

Skills

ETL testing
SQL

Education

Bachelor’s degree in Computer Science/Information Systems or related field
Master’s degree or 3 years experience in lieu of bachelor’s

Tools

JIRA
HP ALM
AWS Redshift
Oracle
PL/SQL
PostgreSQL

Job description

Senior Software Developer/Tester(#SSDT-0150)
Job Description :

Requirement analysis, test strategy development, test case creation, test script development, test execution, defect tracking and reporting for Extract, Transform and Load (ETL)/ Data Warehouse and Business Intelligence (BI) applications. Contribute to the continuous improvement of the function within the Scaled Agile Framework. Analyze Source Systems, Staging area, Fact and Dimension tables of the multi-dimensional model of the target Data Warehouse. Review requirements and specifications and define test conditions. Analyze and review ETL mappings to understand the technical implementation of business rules. Create Test Plan and Testing Strategies for testing ETL/Data Warehouse Applications. Design, develop, and maintain Data/ Extraction, Transform and Load (ETL) validation scripts to enable data-driven insights. Identify and implement enhancements to existing ETL processes. Develop detailed Test Cases and Test Scenarios to support quality deliverables. Review and develop test data scripts based on ETL mapping artifacts and other technical documentation. Perform System Integration testing of ETL process to validate the data flow from source system to target system and reconcile data between source and target systems. Write complex SQL queries for querying data against different databases for data verification process. Test complex ETL mappings, mapplets and reusable transformations for daily data loads. Perform regression testing to ensure that the existing functionality is not broken due to new deployments/code changes. Analyze test results and conduct root cause analysis of identified defects to replicate and resolve. Ensure all testing activities are conducted throughout the life cycle, and that the results from these activities are verified, and improving the overall quality and reliability. Stay up to date with the latest data engineering and ETL development techniques and technologies. Use of AWS Redshift, Oracle, SQL, PL/SQL, PostgreSQL, JIRA, HP ALM, and related tools.

Requirements:

Bachelor’s degree or equivalent in Computer Science, Information Systems or a related field and 5 years of experience as Software Engineer or Software Tester or Test Lead or any job title involving testing and development of ETL Database applications. Will accept a Master’s degree and 3 years of experience in lieu of bachelor’s degree and 5 years of experience. Experience must include testing and development of ETL Database applications.

Work location:

AMPCUS, Inc., 14900 Conference Center Drive, Suite 500, Chantilly, VA 20151.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identify, national origin, age, protected veterans, or individuals with disabilities.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior ETL Developer & QA Lead - Data Warehouse
Senior ETL Developer & QA Lead - Data Warehouse

Ampcus Inc • Chantilly (VA)

Hybrid
USD 90,000 - 130,000
ETL developer
ETL developer

Ampcus Inc • Orlando (FL)

On-site
USD 110,000 - 140,000
Senior Data Warehouse & ETL Tester (USC/GC/EAD)
Senior Data Warehouse & ETL Tester (USC/GC/EAD)

Usmsystems • Reston (VA)

On-site
USD 82,656
ETL developer
ETL developer

Ampcus, Inc • Orlando (FL)

On-site
USD 110,000 - 160,000
Data Warehouse/ETL Tester - USC/GC or GCEAD no sponcership
Data Warehouse/ETL Tester - USC/GC or GCEAD no sponcership

USM • Reston (VA)

On-site
USD 82,656
Consultant/Senior Consultant - QA
Consultant/Senior Consultant - QA

EvonSys • Pittsburgh

On-site
USD 80,000 - 100,000
Data Intelligence Engineer: ETL, SQL & Analytics
Data Intelligence Engineer: ETL, SQL & Analytics

Ampcus Inc • Columbia (MD)

On-site
USD 85,000 - 120,000
Operations - Analyst, Software QA/Test Sr
Operations - Analyst, Software QA/Test Sr

Ampcus, Inc • Reston (VA)

Hybrid
USD 70,000 - 90,000
Locals or Nearby Only Urgent Need ETL Informatica Tester
Locals or Nearby Only Urgent Need ETL Informatica Tester

USM • Cincinnati (OH)

On-site
USD 80,000 - 100,000
Engineer, Software Sr
Engineer, Software Sr

Ampcus Inc • Reston (VA)

Hybrid
USD 120,000 - 160,000