ETL tester Job at Diverse Lynx, Phoenix, AZ

OVpxVXErK2Y0QzJFQjE3U2dEZGlXN2RTRnc9PQ==
  • Diverse Lynx
  • Phoenix, AZ

Job Description

Role- ETL testerLocation-Maricopa, AZ Role Description: Develop detailed test plans, strategies, and cases to ensure comprehensive coverage of ETL processes Collaborate with developers, data architects, and business analysts to understand requirements and define test objectives Conduct end-to-end testing of ETL processes, ensuring the accurate extraction, transformation, and loading of data Validate data accuracy by comparing the source data to the target warehouse, performing data integrity checks Write and execute complex SQL queries to validate data transformations, aggregations, and mappings Identify discrepancies and raise issues for resolution, documenting all anomalies. Log, track and manage ETL-related defects using appropriate defect tracking tools Conduct performance and load testing of ETL processes to ensure scalability and robustness under heavy data volumes. Essential Skills: 10+ years of professional experience is required. Proficient experience as ETL Tester Excellent understanding and hands on experience on a) Oracleb) PL/SQL,c) Informatica Excellent written and verbal communication skills with clear, concise technical writing style Hands-on experience with writing and executing complex SQL queries for data validation Experience in testing data migration and integration projects Proficient in identifying and reporting ETL defects, including root cause analysis. Knowledge of database concepts like normalization, indexing and performance tuning. Strong analytical and problem-solving skills Think strategically and big and should always be a vocal leader Experience with report validations Skills: Experience with Cloud based ETL tools (Azure, AWS, GCP) Familiarity with modern data architecture patterns like data lakes, data mesh, or data fabric Knowledge of ETL/ELT frameworks and data integration best practices Knowledge of visualization tools (PowerBI, Tableau) for reporting quality metrics Exposure to Data Governance6) Experience working in Agile/Scrum environments Experience with a. IICS,b. Datawarehouse ArchitectureDiverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company. Diverse Lynx

Job Tags

Similar Jobs

CGT Staffing

Ui/ux designer Job at CGT Staffing

 ...seeking a talented and innovative Product Designer II to join our team and contribute to the...  ...enhancing the overall user experience (UX), ensuring that design strategies align with...  ...This position offers flexibility with remote work options and involves working with cutting... 

StandardAero

A&P Mechanic - Learjet Job at StandardAero

 ...customer satisfaction, StandardAero Houston is dedicated to keeping business aviation flying safely and efficiently. As an A&P Mechanic working on our Lear Team, you will be responsible for using your sound judgment and technical aptitude to make decisions regarding... 

Gpac

Funeral Director Job at Gpac

A well-established, family-owned Funeral Home is seeking a Funeral Director to join their growing team! This is the perfect opportunity for someone who is looking to take the next step in their career and continue to expand their knowledge in all aspects of the position... 

Wyndy LLC

Seeking school pick-up/drop-off in Johnson City, TN Job at Wyndy LLC

Seeking school pick-up/drop-off services in Johnson City, TN. Duties include timely transportation to and from school. Must have reliable transportation and clean driving record. Ability to follow directions and prioritize safety is essential.Qualifications A love... 

Aldi

Store Manager Trainee Job at Aldi

 ...Job Description As a Store Manager Trainee, youll train on all aspects of successfully running a store in preparation for running for your own store. Youll be involved in supervising day-to-day store activities, ensuring overall store performance, identifying staffing...