Mastering ETL Testing with Chris Thompson and Mike Calabrese

TestGuild Automation Podcast

#Automationframeworks #Performancetesting #Qtp #Selenium #Testautomation #Uft #Joe Colantonio #Soapui #Programming #Tech #Software Development #Podcasting Education #Test

46:43

Think you know ChatGPT's custom GPTs? 🤔 Probably not. Last week, we tackled the basics and what's new with OpenAI's refreshed GPTs. For this AI Working Wednesdays episode, we're getting into some advanced techniques to hep you win back time. ↳ using the crazy powerful o3 model to your GPT's advantage ↳ context stacking ↳ custom actions to connect to third party sites Yeah.... don't sleep on this one shorties. Ep 563: ChatGPT's New Custom GPT's: Advanced techniques to win back time Newsletter: Sign up for our free daily newsletter More on this Episode: Episode Page Join the discussion: Thoughts on this? Join the convo and connect with other AI leaders on LinkedIn. Upcoming Episodes: Check out the upcoming Everyday AI Livestream lineup Website: YourEverydayAI.com Email The Show: info@youreverydayai.com Connect with Jordan on LinkedIn Topics Covered in This Episode: Custom GPTs: Advanced Techniques Overview OpenAI's Context Stacking Strategy O3 Model's Thinking Capabilities Building Efficient Custom GPTs Custom Actions and API Integration Zapier Integration for Dynamic Data ChatGPT's Context Window Management Creating Evergreen Podcast Content Timestamps: 00:00 Custom GPTs: Evolution and Insights 03:23 "Mastering GPT Context Stacking" 09:31 "Context Stacking in Chat GPT" 11:20 GPT Context Switching Advantage 15:33 Customizable GPT Usage Explained 19:51 Evergreen Episode Update Strategy 21:44 Optimizing AI for Continued Learning 23:48 "O-Series Models: Advanced AI Capabilities" 28:41 Building GPTs for Episode Research 30:03 GPT Model Customization and Sharing 33:18 Securing API Keys in GPTs 36:55 Zapier Enhances GPT Email Capabilities 42:12 "Use Chrome Extensions for Tokens" 43:48 "AI at Work Wednesdays Survey" Keywords: OpenAI's custom GPTs, advanced techniques, save time, context stacking, o three model, ChatGPT updates, logic and reasoning, plan ahead capabilities, agentic tools, custom actions, third party data, API, building GPTs, leveraging AI, context window, transformer model, generative AI, organization usage, fine tuning performance, productivity enhancement, AI agents, AI tools integration, custom configuration, everyday applications, tech strategies, new rendition, midweek break, AI experts, smarter AI usage, AI-powered planning, AI transformations. Ep 563: ChatGPT's New Custom GPT's: Advanced techniques to win back time Send Everyday AI and Jordan a text message. (We can't reply back unless you leave contact info) Ready for ROI on GenAI? Go to youreverydayai.com/partner…

about a year ago 32:38

MP3•Episode home

Today, we're diving deep into the complexities of ETL testing with our esteemed guests, Chris Thompson and Mike Calabrese from RTTS.

With over two decades of combined experience in data QA and automated testing, Chris and Mike will guide us through the intricacies of an actual data warehouse project plan.

They uncover the challenges in data mappings, explore different transformation types, and discuss the critical role of a comprehensive mapping document.

Chris and Mike also highlight the importance of rigorous data testing to prevent costly errors and ensure accurate decision-making.

Join us as we explore the critical aspects of ETL testing and data project planning and gain invaluable insights from two industry veterans who have seen it all. This is a must-listen episode for anyone involved in data testing and looking to optimize their data transformation processes.

I also recommend you check out our upcoming Webinar with RTTS on AI in ETL Testing. Register now!

150 episodes

Mastering ETL Testing with Chris Thompson and Mike Calabrese

TestGuild Automation Podcast

66 subscribers

published about a year ago

MP3•Episode home

Today, we're diving deep into the complexities of ETL testing with our esteemed guests, Chris Thompson and Mike Calabrese from RTTS.

With over two decades of combined experience in data QA and automated testing, Chris and Mike will guide us through the intricacies of an actual data warehouse project plan.

They uncover the challenges in data mappings, explore different transformation types, and discuss the critical role of a comprehensive mapping document.

Chris and Mike also highlight the importance of rigorous data testing to prevent costly errors and ensure accurate decision-making.

I also recommend you check out our upcoming Webinar with RTTS on AI in ETL Testing. Register now!

150 episodes

#Automationframeworks #Performancetesting #Qtp #Selenium #Testautomation #Uft #Joe Colantonio #Soapui #Programming #Tech #Software Development #Podcasting Education #Test

All episodes

1
Exploring Playwright and MCP with Debbie O'Brien 32:18

3 days ago32:18

32:18

In this episode, host Joe Colantonio sits down with Debbie O'Brien, Principal Technical Program Manager at Microsoft and a leading advocate for Playwright end-to-end testing. Debbie shares her fascinating journey from web design in the late '90s to building and nurturing the Playwright community at Microsoft. Together, they tackle the latest and greatest in test automation, with a special focus on Playwright's Model Context Protocol (MCP) server and how you can unlock its powerful AI-driven browser automation capabilities. From real-world advice on overcoming resistance to testing in teams to the exciting possibilities MCP brings for generating and scaling tests with natural language and AI, this conversation is packed with both practical tips and future-looking insights. Debbie also addresses common fears around AI replacing jobs, highlighting the need for testers and developers to embrace these tools and stay ahead of the curve. Whether you're an automation engineer, front-end developer, or simply curious about where testing is headed, this episode is full of actionable wisdom and inspiration. Tune in and get ready to supercharge your automation skills!…

1
Solving Challenges in Software Testing with Kristijan Plaushku 29:41

10 days ago29:41

29:41

On this episode of the TestGuild Automation Podcast, host Joe Colantonio welcomes Kristijan Plaushku, founder of QA Robots, for a fascinating deep dive into the evolving world of testing and automation. Grab the free Testing Toolkit now: https://testguild.me/toolkit Broadcasting from Italy, Kristijan shares his journey from starting in quality assurance at AS Watson to building his own company, dedicated to reshaping how businesses approach QA, automation, and DevOps integration, with a specific focus on the unique challenges and opportunities within the Italian tech landscape. Together, they explore what it means to apply first-principles thinking in QA, the ongoing struggles with test environment management, and why bridging the gap between QA and DevOps can have such a significant impact on software delivery. Kristijan also shares the growing influence of AI in automation, his passion for the Robot Framework, and the innovative tools he’s creating to help teams work smarter, not harder. Whether you’re an automation pro or just beginning to dip your toes in the world of testing, this episode is packed with practical insights, industry trends, and actionable advice for building better, more efficient quality processes. Don’t miss Kristijan’s take on building a QA culture from the ground up and why human-centric thinking still matters in an AI-driven world.…

1
WireMock with Tom Akehurst 39:16

17 days ago39:16

39:16

In this episode, we sit down with Tom Akehurst, the creator of WireMock, the popular open-source API mocking tool now powering simulation at scale in modern development pipelines. We unpack the real-world benefits of API mocking, when to simulate vs. integrate, and how WireMock Cloud is helping teams manage drift, complexity, and change. If you're exploring API testing, mocking tools, or wondering how OpenAPI, AI, and MCP (Model Context Protocols) fit into the picture—this one’s for you.…

1
Mastering Medical Device Testing with Priyank Soni 32:44

24 days ago32:44

32:44

In today’s show, we’re diving deep into the highly specialized world of software testing for medical devices. Our guest, Priyank Soni, brings over 20 years of experience and a wealth of knowledge from the front lines of medical innovation, think cardiac mapping, lab automation, and infusion pumps. Not only is Priyank a recognized authority in embedded systems, AI, and machine learning, but he’s also a master at transforming manual QA processes into scalable, cloud-based automated frameworks. Join host Joe Colantonio as he and Priyank unravel the unique challenges of testing in a heavily regulated, high-risk environment where safety, compliance, and innovation must work hand-in-hand. You’ll gain practical insights into navigating stringent standards like ISO 13485, managing risk in legacy systems, and balancing Agile development with rigorous verification requirements. Plus, Priyank shares the real impact of AI and automation in medical device testing—and what the future might hold for testers in this rapidly evolving field. Whether you’re a seasoned QA pro or just curious about what it takes to deliver safe, compliant software in healthcare, you won’t want to miss this episode! Take the first step towards transforming your and our community's future. Check out our done-for-you services awareness and lead generation demand packages, and let's explore the awesome possibilities together now https://testguild.com/mediakit…

1
What is Reverse Mutation Testing with Leonardo Lanni 38:53

5 weeks ago38:53

38:53

In this session, host Joe Colantonio sits down with Leonardo Lanni, a globally recognized quality engineer and founder of QA Roots, to explore a cool testing technique: mutation testing and reverse mutation testing. See if your apps are visual perfect with App Percy: https://testguild.me/apppercy Leonardo breaks down the concepts behind mutation testing, which is an innovative approach to verifying the effectiveness of your tests by intentionally introducing code changes—and introduces the idea of reverse mutation testing, a new technique for ensuring your tests themselves are up to the task. They also discuss real-world QA challenges, practical tooling, and the future of automated testing in an AI-driven world. Whether you’re a seasoned engineer or just getting started in QA, this conversation is packed with actionable insights and fresh ways to look at your automation strategy. Listen up!…

1
The Importance of Trust in Software Testing and AI with Damian Synadinos 27:00

6 weeks ago27:00

27:00

On this episode of the TestGuild Automation Podcast, host Joe Colantonio sits down with Damian Synadinos, a multifaceted expert with over thirty years of experience in software testing, public speaking, improv, and more. 👉 Try Percy now and ship with confidence: https://testguild.me/percyvisual Together, they dive deep into the concept of trust in software testing, how it's formed, the dangers of misplaced trust, and why trust is more crucial than ever in today's rapidly evolving world of AI and software testing. Damien shares how his interest in trust grew out of observing its impact not just in tech but in daily life. He highlights the importance of healthy skepticism, effective communication, and critical thinking for testers and organizations at large. The conversation also explores the challenges of navigating deepfakes, the nuance of risk-based decision-making, and the role of curiosity and questioning in creating better testers. Whether you're a tester, developer, or just curious about AI's growing influence, this episode offers actionable insights on trust, risk analysis, prompt engineering, and how to communicate skepticism professionally within your organization. If you've ever wondered what it means to "trust but verify" in a digital age, you won't miss this conversation!…

1
Building a Career in QA with Judy Mosley 28:09

7 weeks ago28:09

28:09

In today’s episode, host Joe Colantonio sits down with Judy Mosley, a QA engineer at TextUs with over nine years of experience in the tech industry. Judy shares her unconventional journey from being a stay-at-home mom to becoming a respected figure in the QA world. She discusses how a development bootcamp sparked her passion for testing and her value in breaking things (and occasionally frustrating developers!). Judy discusses the importance of mentorship, continuous learning, and building community connections, especially as an introvert. They also explore the power of writing and sharing knowledge. Judy’s blog posts have even landed in major industry newsletters. The conversation touches on overcoming imposter syndrome, embracing career changes, and leveraging both manual and automation skills to keep growing in the field. Plus, they weigh in on the impact of AI on software testing careers, finding balance between personal growth and demanding schedules, and practical tips for anyone looking to level up their automation testing game. Whether you’re new to QA or looking to reinvigorate your journey, this episode is packed with honest insights, encouragement, and actionable advice from someone who truly understands what it means to keep learning and adapting in their software testing career.…

1
European Accessibility Act: What Software Testers Need to Know (Actionable Guide) with Laveena Ramchandani 51:30

8 weeks ago51:30

51:30

Today’s episode is a little different. I’m sharing a recording from one of our monthly live Automation Guild member trainings, and trust me, it’s a session every software tester should hear. Get instant access to Automation Guild: https://testguild.me/youtubeGuild ** Use code youtube30 to get 30% off. We’ll discuss an essential topic for anyone involved in software development: accessibility and the upcoming European Accessibility Act. Listen in as accessibility advocate and testing expert Laveena Ramchandani unpacks what’s coming with the new legislation and why building inclusive digital products can’t wait for the law to catch up. Discover: How to think more accessibly – Spot potential barriers and adopt an inclusive mindset. How to test for accessibility – Use keyboard navigation, browser extensions, automated tests, and assistive tech. How to help teams create accessible content – Apply the social model of accessibility, annotate designs, and follow WCAG guidelines. Whether you develop, design, test, or lead software teams, especially if you serve European customers, this episode will get you up to speed on the what, why, and how of making your products accessible to all, and help you get ahead of compliance before June 2025 arrives.…

1
Testing AI's Promises with Michael Bolton 45:51

9 weeks ago45:51

45:51

In today's episode, I continue my conversation with legendary software testing expert Michael Bolton as we explore the world of artificial intelligence and its impact on testing. Checkout this weeks sponsor: https://testguild.me/ailowcode I know I tend to have really pro AI testing experts, and I wanted to give another point of view to balance things out. I can't think of anyone more perfect to do that than Michael So, is AI truly the revolution it's marketed to be? Listen to hear how Michael cuts through the hype to reveal what these tools really are: probabilistic text generators that often seduce us with their confident-sounding outputs. You'll discover when AI can be genuinely helpful in testing and when it's likely to lead us astray. Michael shares fascinating examples of AI inconsistencies and explains why the overconfidence these systems project can be dangerously misleading. Whether you're concerned about AI replacing testers or looking to incorporate these tools into your workflow responsibly, this episode provides the critical thinking framework you need. Stay tuned for part two of my conversation with Michael Bolton, where we separate AI fact from fiction in the world of software testing.…

1
The Secret Life of Automation with Michael Bolton 1:00:46

10 weeks ago1:00:46

1:00:46

In today's episode, host Joe Colantonio is joined by renowned software testing expert Michael Bolton, who returns to the show after an eight-year hiatus. Join Michael and me at Breakpoint online event: https://testguild.me/breakpoint In part 1 of a two-part series, Michael dives deep into software testing, reflecting on what's changed (and what hasn't!) since their last chat, the impact of emerging technologies like machine learning and AI, and what it really means to "do" software testing in 2025. Michael explores the true essence of testing beyond the buzzwords, challenging the industry's love affair with automation and redefining its role as a tool to augment, rather than replace, human insight. Michael shares insights from his latest travels, collaborative projects, and the exciting new class he's co-developed with James Bach, focusing on smarter, tool-empowered testing practices. Prepare for a candid, thoughtful discussion full of practical advice, personal anecdotes, and a few laughs along the way. This will include live demos, tool recommendations, and real-life stories highlighting the "secret life" of automation many teams overlook. Also, make sure not to miss our next episode next week, in which Michael takes a deeper dive into AI's role in testing. You don't want to miss it - listen up.…

1
AI’s Impact on Testing Careers with Jason Arbon 42:08

11 weeks ago42:08

42:08

In this episode, special guest Jason Arbon will be present for a truly eye-opening conversation about the rapidly evolving world of AI-driven software testing. Jason introduces us to the concept of MCP, a powerful AI workflow engine that’s changing how testers interact with tools and offers a behind-the-scenes look at the origins of Testers.AI is a platform that automates comprehensive software testing using AI personas tailored for everything from usability to security. In this candid discussion, Jason explores why the testing community initially hesitated to embrace AI solutions, how the landscape is shifting, and the surprising “happy dance” moment when AI outpaced traditional test teams in speed and coverage. The conversation doesn’t shy away from the difficult questions: What does this mean for human testers? How reliable are AI-generated results? And what skills will testers need in the new era where AI handles the bulk of basic testing? Whether you’re intrigued, skeptical, or just curious about how AI is reshaping quality assurance, this episode is a must-listen.…

1
How To Optimize your Automation CI/CD Pipelines (and Save Money) with Gaurav Mittal 27:02

13 weeks ago27:02

27:02

Welcome to the TestGuild Automation Podcast! In this episode, host Joe Colantonio sits down with Gaurav Mittal, a cybersecurity, data science, and IT expert with over two decades of experience. Gaurav, recognized for his thought leadership in AI and automation with multiple industry awards, shares his insights on making How To Optimize your Automation CI/CD Pipelines in DevOps more cost-effective. Whether you're a test automation engineer or security professional or work with AI/ML, you'll want to hear Gaurav's take on implementing DevOps pipelines that reduce licensing costs and enhance flexibility without sacrificing your team's productivity. Learn about his experiences with GitHub Actions, Jenkins, and the innovative ways he's optimized CI/CD pipelines to save resources and automate extensive testing processes, all while incorporating strong security measures. Join us as we delve into the innovative strategies and practical advice that can help transform your DevOps practices.…

1
Meet JASON HUGGINS, The Genius Behind Selenium! 29:57

14 weeks ago29:57

29:57

Welcome to another episode of the TestGuild Automation Podcast! This time, we're diving into the archives by honoring SeleniumConf in Valencia, Spain, with a special rerelease of an interview recorded back in 2017. Join your host, Joe Colantonio, as he sits down with Jason Huggins, the legendary creator of Selenium. Recorded live during the hustle and bustle of SeleniumConf that year, Joe takes us back to the origins of Selenium with this remarkable founder's journey. Jason dives deep into the story behind Selenium's creation, the challenges faced during its early days, and the evolution of automation in tech. Whether you're an automation veteran or new to testing, this episode is a treasure trove of insights and inspiration you won't want to miss!…

1
Proactive Observability in Testing with Anam Hira 21:42

15 weeks ago21:42

21:42

In today's episode, we're diving into proactive observability and testing with our special guest, Anam Hira, cofounder of Reveal.ai. Anam, who also has experience working at Uber AI, shares an intriguing journey where he developed "Dragon Crawl," an innovative project aimed at tackling challenges Uber faced with its end-to-end testing across multiple cities. We explore how Dragon Crawl utilized LLMs to enhance testing reliability, making tests less flaky across varied UIs. Anam's journey didn't stop there. He co-founded Reveal, a platform that takes testing and observability to a new level by connecting end-to-end tests with telemetry data. This modern approach, termed proactive observability, allows for detecting bugs before they hit production, saving companies significant time and cost. Join us as we explore the principles of proactive observability, how Reveal leverages telemetry for seamless integration, and its impact on testing efficiency. Whether you're a startup or an enterprise, if you're keen to ship faster without sacrificing quality, this is an episode you won't want to miss! 👉 Start building accessible apps with BrowserStack: https://testguild.me/accessiblity…

1
Testing ML Pipeline Best Practices to Scale with LakshmiThejaswi Narasannagari 27:45

16 weeks ago27:45