Senior Data Test Engineer, ETL/Data Tester Job at Ampcus Incorporated, Chantilly, Loudoun County, VA

N2Ixdk05NC9hMmJYNTVESmJQYXhRMTRmRUE9PQ==
  • Ampcus Incorporated
  • Chantilly, Loudoun County, VA

Job Description

Position: Senior Data Test Engineer, ETL/Data Tester

Duration: Full time

Location Chantilly, VA

Responsibilities:

Active involvement in the software engineering lifecyle that includes design, development, test and implement data-centric applications and provide application support.

Write computer programs to store, locate, retrieve documents, data and information.

Design, develop, and maintain Data/ETL validation scripts to enable data-driven insights

Identify and implement enhancements to existing ETL processes

Work with clients to design, build, assembly and configure applications including the technical data architecture components as per technical and business specifications

Collaborate with data scientists, data architects, and other stakeholders to ensure successful data engineering projects

Lead “Big Data” migration or consolidation projects for various clients

Review and 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.

Write/edit and test macros, scripts, parsers, and small programs to process, load or analyze data, and perform configuration management before entering into a production baseline

Provide technical support and troubleshooting for data engineering projects

Ensure data quality and accuracy

Stay up-to-date with the latest data engineering and ETL development techniques and technologies

Monitor data usage to ensure compliance with applicable data privacy regulations

Create and maintain technical/development documentation

Requirements

Education and Experience:

Bachelor’s degree in computer science, IT or related with at least 9 years of experience in software engineering and testing backend applications primarily involving complex SQL queries.

Required Qualifications

10 to 1 5 years of relevant work experience in testing backend application primarily involving complex SQL queries

At least 10 years’ experience in:

Testing “Big Data ” and Enterprise Data warehouse

Writing and Executing complex queries in SQL

Experience in analyzing ETL mapping (STTM) 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.

Knowledge of PostgreSQL

Cloud databases (AWS /Redshift/Snowflake)/Relational databases

Experience in working with critical Financial Applications

Advanced level of expertise in Database testing (data cleansing, transforming, mapping, data validation) with excellent PL /SQL skills

Ability to create and execute test plans, strategies and test cases for applications that use ETL components

Experience with large-scale (terabytes) database development, large-scale file manipulation, data modeling, data

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 and Postman is a plus

Only candidates from the local area will be taken into consideration

Job Tags

Permanent employment, Full time, Work experience placement, Local area,

Similar Jobs

Mohawk Valley Health System

Physical Therapist - VNA Home Care - Occasional - Days Job at Mohawk Valley Health System

 ...therapists, speech and language therapists and audiologists) to provide prevention and wellness services including screening and health promotion. The PT participates in operational aspects of the department: performance improvement activities, CQI activities, formulating... 

Anew Recruiting

Trust Officer Job at Anew Recruiting

 ...Job Description Job Description Sr. Trust Officer Los Gatos, CA (Hybrid) Description Our client is an established and expanding wealth management firm with over $18B in assets, is seeking a Trust Officer, who will be responsible for fiduciary and client relationship... 

Novant Health

RN-Registered Nurse, 8th General Renal Job at Novant Health

 ...Diverse & Women Managers to Work by Diversity MBA Magazine Top ratings in patient safety...  ...needed. e Qualifications Graduate of an accredited school of nursing required...  ...State/Compact required. One-year relevant experience, preferred. Responsibilities It is... 

Druid Hills Golf Club

Catering Supervisor Job at Druid Hills Golf Club

 ...all the other member life cycle events in between? Then this might be the job for you. Druid Hills Golf Club is looking for a Catering Supervisor to assist the Director of Events with the planning, coordination and execution of private and member events. This role... 

Hermes Networks Inc.

Job title: Computer/IT Software Developer Job at Hermes Networks Inc.

Job title: Computer/IT Software DeveloperHermes Networks Inc.Job code: CSK2020Job Location: Plainsboro, NJ & other client locationsDuties and ResponsibilitiesInvolve in all aspects of SDLC including analysis, design, develop, implement, & maintain applications...