Urgent Requirement || ETL Tester || Boston, MA(Hybrid) Local Only || 6+Months at Boston, Massachusetts, USA |
Email: [email protected] |
From: Suraj Prashar, Pivotal [email protected] Reply to: [email protected] Hi, Hope you are doing great!! Please find the requirement below, If you find yourself comfortable with the requirement please reply back with your updated resume and I will get back to you or I would really appreciate if you can give me a call back at my contact number (703) 570-8775 * (Ext. 232). Job Title: ETL Tester Location: Boston, MA(Hybrid) Local Only Duration: 6+ Months Interview: Video Visa Type: NO H1/CPT/OPT Local or Nearby Only Job Description CHIA is seeking a skilled Database/ETL Test Engineer to work alongside our other talented test engineers and developers within CHIAs Data Operations and Technology (DOT) group. The testers duties will include performing key testing functions in the data product release process. In this role, the candidate will collaborate with colleagues in DOT to design and create manual and automated tests to validate data sources, extraction of data, the application of transformation logic, and loading data into target tables in an Azure cloud database. Responsibilities Create and execute test cases based on test strategy and test plans as defined by business requirement documents and ETL design documents. Test ETL processes and Data Warehouse components Execute backend data-driven tests Create strategies and test cases for data applications Provide guidance to other team members as needed Identify issues pertaining to data submissions or ETL transactions during the creation of data warehouses. Be able to discuss these issues with DBAs, assist with remediation strategies, and help devise timelines for correction Define and track quality assurance metrics such as defects, defect counts, test results and test status. Document all problems using CHIAs bug tracking tool and assist in their resolution. Test for continuity and integrity of data loaded from migrated ETL jobs and target DB System Qualifications The ideal candidate will have: A Bachelor's degree in computer science, information technology, or related field. Seasoned SQL programmer with experience querying LARGE volumes (terabytes) of health data, preferably medical claims, dental claims, pharmacy claims and eligibility data. Experience working with large scale Database Systems like SQL Server, PostGresSQL, Snowflake, etc., and ETL tools like Talend Data Fabric and IBM DataStage. Experience with Agile Software Development & Testing methods for deployment in cloud environments, preferably MS Azure. Five or more years of relevant experience testing backend applications, focusing on complex SQL queries. Experience analyzing ETL mapping documents to design test plans for validating ETL code. Ability to create SQL scripts based on ETL mapping documents. Ability to create and execute strategies and test cases for applications that use ETL components. Expertise in Database testing with excellent SQL skills. Data warehouse testing experience. Hands on experience in relational databases and database architecture. Hands on experience interpreting and understanding data model and ER diagrams. Familiarity with data visualization and business intelligence tools such as Tableau and Power BI will be an advantage but is not required. Keywords: business intelligence database microsoft Massachusetts Urgent Requirement || ETL Tester || Boston, MA(Hybrid) Local Only || 6+Months [email protected] |
[email protected] View all |
Sat Jul 20 00:30:00 UTC 2024 |