Position: ETL Tester
Location: Plano, TX (Hybrid 3 Days/Week Onsite)
Duration: Permanent Role
Visa: USC or GC can apply for this role
Job Responsibilities:
Candidate should have 10+ Years of experience
- ETL Testing: Design, develop, and execute test cases for ETL processes to validate data extraction, transformation, and loading. Ensure data accuracy, completeness, and consistency throughout the ETL pipeline.
- Big Data Testing: Test and validate Big Data solutions, including Hadoop and related technologies, to ensure data processing, storage, and retrieval meet performance and quality standards. Identify and resolve issues related to data ingestion, transformation, and analysis.
- SQL Testing: Develop and execute SQL queries to validate data against expected results. Perform data verification, data integrity checks, and reporting to ensure data accuracy and consistency.
- Test Planning: Collaborate with stakeholders to understand data requirements and create comprehensive test plans and test cases. Ensure test plans cover all critical data scenarios and edge cases.
- Issue Identification: Identify, document, and track defects and discrepancies. Work with development teams to troubleshoot and resolve issues related to ETL processes, Big Data systems, and SQL queries.
- Performance Testing: Conduct performance testing of ETL processes and Big Data solutions to assess system scalability and responsiveness. Recommend optimizations and improvements based on test results.
- Automation: Develop and maintain automated test scripts for ETL and SQL processes where applicable. Utilize testing tools and frameworks to streamline the testing process and improve efficiency.
- Documentation: Maintain detailed documentation of test plans, test cases, test results, and defect reports. Ensure that documentation is clear, accurate, and accessible to relevant team members.
- Continuous Improvement: Stay updated with the latest trends and best practices in ETL, Big Data, and SQL testing. Propose and implement enhancements to testing processes and methodologies.