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
...Job Description Job Description We are currently seeking an Automotive Technician/Automotive Mechanic to become an integral part of our team! You will diagnose, adjust, repair, and overhaul automotive vehicles. Responsibilities: Diagnose and repair automotive...
...A hospitality management firm in Greenville, SC is seeking a dedicated Human Resource Coordinator to assist in HR processes, including administration of health and welfare plans, employee recruitment support, and maintenance of HR records. Candidates should have a High...
...Job Summary: Ventra Ionia Main Provide security detail as outlined in the post orders and establish working relationships with customers, local law enforcement and fire departments. Security personnel will always perform job duties with a constant awareness of surroundings...
...Job Description Title: Senior SAP S/4 Hana Delivery Manager Terms: Long Term Contract Location: Atlanta area Hybrid 3 days a week Must live in GA No 3rd party agencies at this time Are you looking for a career opportunity that allows you to grow...
Trillium Drivers is looking for Class A Drivers in the Lake City, MN area! Drivers will... ...to work 50+ hours/week. -The CDL Truck Driver will be driving automatic trucks; 5... ...indicating truck conditions. -Maintain driver log through ELD according to U.S. DOT (FMSCA)...