Ampcus, Inc
ETL/Big Data Tester
Ampcus, Inc, Chantilly, Virginia, United States, 22021
Role:
Senior Data Test Engineer, ETL/Data Tester/Big Data
Location:
Remote
Duration:
Long term
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:7 to 10 years of relevant work experience in testing backend applications primarily involving complex SQL queries.At least 7 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.Cloud databases (AWS /Redshift)/Relational databases.Experience testing mission 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 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 and Postman is a plus.
#J-18808-Ljbffr
Senior Data Test Engineer, ETL/Data Tester/Big Data
Location:
Remote
Duration:
Long term
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:7 to 10 years of relevant work experience in testing backend applications primarily involving complex SQL queries.At least 7 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.Cloud databases (AWS /Redshift)/Relational databases.Experience testing mission 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 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 and Postman is a plus.
#J-18808-Ljbffr