Ampcus
Senior Data Test Engineer, ETL/Data Tester
Ampcus, Chantilly, Virginia, United States, 22021
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 insightsIdentify and implement enhancements to existing ETL processesWork with clients to design, build, assembly and configure applications including the technical data architecture components as per technical and business specificationsCollaborate with data scientists, data architects, and other stakeholders to ensure successful data engineering projectsLead "Big Data" migration or consolidation projects for various clientsReview and develop test data scripts based on ETL mapping artifacts and other technical documentation.Execution and detailed analysis of test data scriptsDefines 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 baselineProvide technical support and troubleshooting for data engineering projectsEnsure data quality and accuracyStay up-to-date with the latest data engineering and ETL development techniques and technologiesMonitor data usage to ensure compliance with applicable data privacy regulationsCreate 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 Qualifications10 to 1 5 years of relevant work experience in testing backend application primarily involving complex SQL queriesAt least 10 years' experience in:Testing "Big Data " and Enterprise Data warehouseWriting and Executing complex queries in SQLExperience in analyzing ETL mapping (STTM) documentsWriting and Executing ETL scripts and Stored ProceduresDevelopment of SQL scripts based on ETL mapping and database documents to validate data inputs and compare data outputsUsing tools such as Informatica (PowerCenter)Integration testing - Services, ETL, Database (SQL/Oracle ) - covering DML Validations, Batch Monitoring etc.Knowledge of PostgreSQLCloud databases (AWS /Redshift/Snowflake)/Relational databases
Experience in working with critical Financial ApplicationsAdvanced level of expertise in Database testing (data cleansing, transforming, mapping, data validation) with excellent PL /SQL skillsAbility to create and execute test plans, strategies and test cases for applications that use ETL componentsExperience 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 productsVery good communication skillsStrong problem solving and analytical skills demonstrated by the ability to assimilate new information, understand complex topics and arrive at sound analysis and judgmentShould be a good team playerExperience testing Waterfall / Agile Development ProjectsKeeps abreast of current technology trendsFamiliar with application development best practicesWell-versed in the use of Microsoft Office ToolsBig 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
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 insightsIdentify and implement enhancements to existing ETL processesWork with clients to design, build, assembly and configure applications including the technical data architecture components as per technical and business specificationsCollaborate with data scientists, data architects, and other stakeholders to ensure successful data engineering projectsLead "Big Data" migration or consolidation projects for various clientsReview and develop test data scripts based on ETL mapping artifacts and other technical documentation.Execution and detailed analysis of test data scriptsDefines 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 baselineProvide technical support and troubleshooting for data engineering projectsEnsure data quality and accuracyStay up-to-date with the latest data engineering and ETL development techniques and technologiesMonitor data usage to ensure compliance with applicable data privacy regulationsCreate 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 Qualifications10 to 1 5 years of relevant work experience in testing backend application primarily involving complex SQL queriesAt least 10 years' experience in:Testing "Big Data " and Enterprise Data warehouseWriting and Executing complex queries in SQLExperience in analyzing ETL mapping (STTM) documentsWriting and Executing ETL scripts and Stored ProceduresDevelopment of SQL scripts based on ETL mapping and database documents to validate data inputs and compare data outputsUsing tools such as Informatica (PowerCenter)Integration testing - Services, ETL, Database (SQL/Oracle ) - covering DML Validations, Batch Monitoring etc.Knowledge of PostgreSQLCloud databases (AWS /Redshift/Snowflake)/Relational databases
Experience in working with critical Financial ApplicationsAdvanced level of expertise in Database testing (data cleansing, transforming, mapping, data validation) with excellent PL /SQL skillsAbility to create and execute test plans, strategies and test cases for applications that use ETL componentsExperience 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 productsVery good communication skillsStrong problem solving and analytical skills demonstrated by the ability to assimilate new information, understand complex topics and arrive at sound analysis and judgmentShould be a good team playerExperience testing Waterfall / Agile Development ProjectsKeeps abreast of current technology trendsFamiliar with application development best practicesWell-versed in the use of Microsoft Office ToolsBig 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