ETL tester Job at Diverse Lynx, Phoenix, AZ

VXZ0aVVFUzBGZ00yNS9PdGhKdlA4ZGZ5NkE9PQ==
  • 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

Get It - Hospitality

Travel Agent - Remote | WFH Job at Get It - Hospitality

 ...individual to join our growing team as a Remote Travel Agent. This is a fantastic opportunity for...  ...or in a related role is a plus, it's not required. We're looking for someone eager to learn! Knowledge of domestic and international travel destinations is helpful.... 

JPMorganChase

Senior Lead Software Engineer - Data Platform Job at JPMorganChase

 ...and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management. We offer... 

Frontier Airlines, Inc.

Flight Attendant - Denver, CO ONLY Job at Frontier Airlines, Inc.

 ...What Will You Be Doing? The Frontier Airlines Flight Attendant (FA) is essential to maintaining the well-being, safety, security and comfort of our passengers onboard our aircraft. The Flight Attendant performs a variety of services in order to maint Flight Attendant,... 

Udacity

Tutor (External Contractor) - Bilingual English & Russian Job at Udacity

 ...is an added plus~2+ years of working experience related to the above skillsets~Experience teaching technical concepts and public speaking~Experience organizing technical talks, or webinars~Positive character, trusted by the students, creating emotional ties in... 

City of Hallandale Beach, FL

Beach Safety Lifeguard (Relief) Job at City of Hallandale Beach, FL

 ...patronizing the City's beaches. Work includes rigorous physical training and conditioning, and ensuring patron adherence to established laws, rules and ordinances governing the public use of City beaches. Work requires considerable communication, interaction and contact...