Senior ETL Test Engineer (Automation & Data Quality)

Be an expert in writing and executing test cases, managing and analyzing large sets of data, creating automation scripts, and communicating relevant insights to the team Love to collaborate with other data professionals, engineers, and business operation experts to understand and address reporting needs Experience with both traditional and big data streaming Create and maintain complex SQL queries such as; type 2 triggers, various joins, aggregations, groupings, and more Execute ETL jobs using orchestration tools (airflow/scheduler/SQL agent) Have a working knowledge and testing experience of ETL Be proactive with leadership abilities with a strong can do attitude Possesses heavy experience with automation testing for ETL Highly detailed oriented Strong willingness & comfort in taking on and challenging development approaches Conduct and facilitate UAT Previously worked in Agile and Scrum What You Will Need: Solid understanding of test Automation architecture, framework, and Automation script creation using programming language Python, Bash Scripts, etc. and Orchestration tools like Apache Airflow, Luigi Strong knowledge of creating SQL queries for source to target database validation and Data warehouse testing Hands-on experience interpreting and understanding data models and ER diagrams Experienced in traditional SQL DB (MySQL, Postgres, SQL server) and cloud-native data warehouses Snowflake or Redshift Experienced in ETL tools Informatica, ab initio, Talend, and reporting tools - Tableau and PowerBI Create and execute strategies and test cases for applications that use ETL components CI/CD implementation through Jenkins/GitLab/Maven Experienced with HP ALM, Jira, rally any agile test management tools Implement the orchestration of business flows on given problem statements for the automation of complex scenarios Review technical requirements with data warehouse and business intelligence terminology to produce test strategies, test scenarios, and test cases for the data warehouse team Create the test plan for the software release, defining resources, and test suites required for each test cycle, dependencies, risks, and the overall strategy for testing complex systems and applications Experienced in using frontend (UI) to generate test scenarios and validate data in the backend CLOUD ANALYTICS TECHNOLOGIES is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. CLOUD ANALYTICS TECHNOLOGIES will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters.

Nor will CLOUD ANALYTICS TECHNOLOGIES require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract Equal Opportunity Employer CLOUD ANALYTICS TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. CLOUD ANALYTICS TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters.

Nor will CLOUD ANALYTICS TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract Some of our Business Ventures - Knowledge Analytics Do restrictive necessities, your capability for advanced analytics or your business model need custom-made applications and infrastructure configurations? opt for our hosted managed services to urge comprehensive analytics solutions supported industry-leading Cloud Analytics Technologies, LLC code - delivered by the Cloud Analytics Technologies, LLC consultants UN agency understand these solutions best. Through a mix of with-it technology and dedicated service and support, Cloud Analytics Technologies, LLC hosted managed services will facilitate you: Reduce your capital prices. Skip large, direct hardware purchases - and revel in prices that are a lot for a foreseeable future over time.

Our superior analytics and business intelligence solutions drive bottom-line results, while not acquisition the prices related to developing in-house system. Boost your employee's savings. Scale back your dependence on already overtaxed internal staffing resources by looking forward to Cloud Analytics Technologies, LLC for professional capability coming up with and support.

Additionally, free your employees to target proactive business enhancements. #J-18808-Ljbffr