Ampcus
ETL/Big Data Tester
Ampcus, Chantilly, Virginia, United States, 22021
Role:
Senior Data Test Engineer, ETL/Data Tester/Big DataLocation:
RemoteDuration:
Long termResponsibilities: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.Required Qualifications7 to 10 years of relevant work experience in testing backend application primarily involving complex SQL queriesAt least 7 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.Cloud databases (AWS /Redshift)/Relational databasesExperience testing mission 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 planning, writing, executing tests as well as preparing test strategiesExperience in using testing tools such as ALM and JIRA
Critical SkillsAbility 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 QualificationsBasic knowledge on how to use Tidal and Postman is a plus
Senior Data Test Engineer, ETL/Data Tester/Big DataLocation:
RemoteDuration:
Long termResponsibilities: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.Required Qualifications7 to 10 years of relevant work experience in testing backend application primarily involving complex SQL queriesAt least 7 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.Cloud databases (AWS /Redshift)/Relational databasesExperience testing mission 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 planning, writing, executing tests as well as preparing test strategiesExperience in using testing tools such as ALM and JIRA
Critical SkillsAbility 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 QualificationsBasic knowledge on how to use Tidal and Postman is a plus