Role: Senior Data Test Engineer, ETL/Data Tester– Only GC/USC/H4 EAD

Location: Alpharetta, GA (Remote Until Covid) 

Duration: 12+ Months 

Key Skills : Hadoop, ETL, SQL, Oracle, AWS, HP ALM, Jira 

Description: 

• 7 to 10 years of relevant work experience in testing backend application 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 
  • 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 

Additional Information