CV Library
Senior Data Test Engineer, ETL/Data Tester
CV Library, Chantilly, Virginia, United States, 22021
Position:
Senior Data Test Engineer, ETL/Data TesterDuration:
Full timeLocation:
Chantilly, VAResponsibilities:
Active involvement in the software engineering lifecycle that includes design, development, testing, and implementation of 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, assemble, 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.Execute and perform detailed analysis of test data scripts.Define and track quality assurance metrics such as defects, defect counts, test results, and test status.Document all problems and assist 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 field with at least 9 years of experience in software engineering and testing backend applications primarily involving complex SQL queries.Required Qualifications:
10 to 15 years of relevant work experience in testing backend applications 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.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.Qualifications:
Basic knowledge on how to use Tidal and Postman is a plus.Only candidates from the local area will be taken into consideration.
#J-18808-Ljbffr
Senior Data Test Engineer, ETL/Data TesterDuration:
Full timeLocation:
Chantilly, VAResponsibilities:
Active involvement in the software engineering lifecycle that includes design, development, testing, and implementation of 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, assemble, 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.Execute and perform detailed analysis of test data scripts.Define and track quality assurance metrics such as defects, defect counts, test results, and test status.Document all problems and assist 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 field with at least 9 years of experience in software engineering and testing backend applications primarily involving complex SQL queries.Required Qualifications:
10 to 15 years of relevant work experience in testing backend applications 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.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.Qualifications:
Basic knowledge on how to use Tidal and Postman is a plus.Only candidates from the local area will be taken into consideration.
#J-18808-Ljbffr