Prophecy Technologies
Website:
prophecytechs.com
Job details:
Company Description
Prophecy Technologies, founded in 2014 and headquartered in Irvine, CA, delivers cutting-edge software solutions across industries such as finance, healthcare, manufacturing, and retail. We are a trusted technology partner, providing innovative and tailored products and services to help organizations achieve their strategic goals. With a skilled team of software engineers, architects, designers, and product specialists, we are dedicated to empowering businesses through advanced technology. Our mission is to enable sustainable growth and uncover new opportunities for our clients.
Role Description
We are looking for a detail-oriented ETL / Data QA Engineer with strong expertise in manual testing, SQL-based validation, and Azure data platforms.
Key Responsibilities
· Develop test plans, test cases & test scenarios for ETL/data workflows
· Perform functional, integration, system & regression testing
· Validate data using SQL queries (joins, aggregations, window functions)
· Identify, log & track defects and collaborate with dev teams
· Analyze requirements, mapping documents & data models
· Perform data validation & reconciliation across systems
· Work with Azure Data Factory (pipelines, triggers, data flows)
· Validate data across Azure SQL, Data Lake, Synapse
· Participate in Agile ceremonies (sprint planning, stand-ups, grooming)
· Perform risk analysis & prioritize test scenarios
· Support release planning & provide go/no-go recommendations
· Suggest process improvements & ensure data quality standards
Required Skills
· Strong experience in Manual ETL Testing
· Expertise in SQL for data validation & reconciliation
· Hands-on experience with Azure Data Factory (ADF)
· Knowledge of data warehousing concepts (facts, dimensions, SCD, star/snowflake schema)
· Experience validating data on Azure SQL, Data Lake, Synapse
· Strong analytical & problem-solving skills
· Experience working in Agile/Scrum environments
· Good communication & documentation skills
· High attention to detail & passion for data quality
Click on Apply to know more.