Tech job offerings are plagued with over reaching and unrealistic job/experience requirements. They want college grads to have 5 years of experience, list multiple extremely specific technologies they use which no one would have as a normal skill set, or require deep experience with emerging technologies.
These requirements sound like someone rattled off the software/skills of a previous employee with no concept of what was important about those skills. For example, when asking for 10 years of Oracle SQL experience what they probably really need is someone with deep SQL knowledge and experience using databases in an enterprise setting.
I always see these specific requirements on the job offer but once I get down to it I find most companies want skills, not technical knowledge in a specific brand of technology, language, etc.
How can I figure out what they really need when I'm interviewing/being screened? How can I probe without making it look like I'm unqualified, communicating that I have what they really need, just not the exact flavor of expertise on the offer?