ETL Quality Assurance - Sacramento CA at Sacramento, Kentucky, USA |
Email: [email protected] |
From: pankaj, stellentit [email protected] Reply to: [email protected] ETL Quality Assurance Sacramento CA Phone and Skype Long Term Job Description: The BI&DW Test Engineer is expected to perform the following tasks but not limited to: 1. Develop test strategies, plans, test cases, and engineering best practices related to BI test, both manual and automated testing with a specific focus on data quality. 2. Using PowerBI, Python creates active quality monitoring for data pipelines and processes. 3. Work closely with data engineers, ETL engineers, BI developers, and business analysts to conduct solutiondesigns in terms of testability. 4. Building and automating testing frameworks around data ingestion pipelines and active monitoring. 5. Build and maintain testing frameworks for Cloud native like AWS, Azure, GCP, or Snowflake environments that are highly secure, scalable, flexible, and performant using appropriate SQL technologies. 6. Support data governance and data profiling efforts to ensure data quality and proper meta-datadocumentation for data lineage. 7. Create quality metrics to evaluate data pipelines, visualizations, and dashboards. 8. Test and validate data pipeline, ETL and batch processing. 9. Implement and execute test strategies on all supported platforms and languages to help improve the overallquality and test code coverage. 10. Design and develop integration, regression, and stress tests using industry-standard tools. 11. Collaborate with project manager and business analyst to understand requirements and translate them intotest cases. 12. Reproduce, isolate, and debug issues, providing detailed defect reports. 13. Develop and enhance the test infrastructure and continuous integration framework used across teams. Minimum Technical Qualifications Person Skill Summary Sheet and resume: 5 years of industry experience indata engineering, BI, and Quality Assurance. 5 years of experience inSQL, Python, Data Warehouse, and Data Lake. 3 years of hands-on experience testing,ETL pipeline, Reports. 3 years of sound understanding of various cloud technologies, especiallyAWS, Snowflake, Azure, and/or GCP. 4 years of experience in working with large-scale Enterprise data warehouse, data integration, datamigration, and data quality verification. Desirable Technical Qualifications 4 years of experience inState agency or Financials or Investment portfoliosor other regulated industry highly preferred. Ability to use business knowledge and expertise to build analytical data models and reports that can serve to all business users. 5 years of experience and capability using visualization software such asPowerBI,Tableau and familiarity with SAP, CRMor other Insurance and Benefits systems. Exceptional ability to multi-task while maintaining tight schedules. Excellent writing skills and documentation skills that enable analyses to be reliably reproduced Additional Information Knowledge in integrating project testing with continuous-integration process (CI/CD). Knowledge of industry-standard test automation tools and experience in developing product test harnessesand instrumenting products to gather test results. Knowledge of relational and NoSQL databases, and queries. BA/BS Degree in Computer Science or related technical discipline. CalSTRS may request a copy of thedegree. |
[email protected] View all |
Thu Nov 10 12:32:00 UTC 2022 |