This query will retrieve the specified columns from the public.jobs table, filtered for cases with a status of 'Certified', ordered by the most recent received_date, and limited to

case_number
case_status
visa_class
job_title
soc_title
full_time_position
employer_name
employer_city
employer_state
wage_rate_of_pay_from
wage_rate_of_pay_to
wage_unit_of_pay
I-200-23267-376415CertifiedH-1BSenior Associate JC60 -Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX90854nullYear
I-200-23267-376443CertifiedH-1BManager JC50 - Software DevelopersSoftware DevelopersYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX125000nullYear
I-200-23268-376509CertifiedH-1BMedical Laboratory Technologist Medical and Clinical Laboratory TechnologistsYGUAM HEALTHCARE DEVELOPMENT, INC.DEDEDOGU2222Hour
I-200-23267-376405CertifiedH-1BManager JC50 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX93517nullYear
I-200-23267-376377CertifiedH-1BManager JC50 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX85405nullYear
I-200-23267-376359CertifiedH-1BSR. ORACLE EBS ANALYSTSoftware DevelopersYThe Sherwin-Williams CompanyClevelandOH111101125000Year
I-200-23267-376394CertifiedH-1BManager JC50 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX103730nullYear
I-200-23268-376534CertifiedH-1BIT PROJECT MANAGERInformation Technology Project ManagersYPERSISTENT SYSTEMS, INC.SANTA CLARACA78354115584Year
I-200-23267-376347CertifiedH-1BSOFTWARE DEVELOPERSoftware DevelopersYERP Initiatives Group Inc.FULSHEARTX77000nullYear
I-200-23268-376487CertifiedH-1BArchitectural Designer/DrafterArchitectural and Civil DraftersYMarcus Gleysteen Architects, LLCBostonMA4560085000Year
I-200-23267-376307CertifiedH-1BESL TeacherMiddle School Teachers, Except Special and Career/Technical EducationYMilwaukee Board of School DirectorsMilwaukeeWI49836104762Year
I-200-23267-376419CertifiedH-1BSenior Associate JC60 -Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX81266nullYear
I-200-23267-376381CertifiedH-1BSr Mgr JC45-Software Quality Assurance Analysts and TestersSoftware Quality Assurance Analysts and TestersYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX135720nullYear
I-200-23267-376370CertifiedH-1BManager JC50 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX93517nullYear
I-200-23267-376413CertifiedH-1BAssociate Director JC40 - Management AnalystsManagement AnalystsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX154315nullYear
I-200-23267-376282CertifiedH-1BDEVOPS ENGINEERComputer ProgrammersYORIGIN HUBS INCMORRISVILLENC87800nullYear
I-200-23267-376433CertifiedH-1BRegional Coaching DirectorCoaches and ScoutsYMaestro Soccer, LLCWestfieldNJ26nullHour
I-200-23267-376399CertifiedH-1BManager JC50 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX98259nullYear
I-200-23267-376372CertifiedH-1BPhysicistHealthcare Practitioners and Technical Workers, All OtherYPrecess Medical Derivativesshort hillsNJ7000080000Year
I-200-23267-376438CertifiedH-1BManager JC50 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX93517nullYear
I-200-23267-376444CertifiedH-1BManager JC50 - Software DevelopersSoftware DevelopersYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX125000nullYear
I-200-23268-376498CertifiedH-1BSOFTWARE ENGINEER IIISoftware DevelopersYACCIDENT FUND INSURANCE CO. OF AMERICALANSINGMI104062115000Year
I-200-23268-376517CertifiedH-1BApplication Integration SpecialistSoftware DevelopersYIdexcel IncHerndonVA120000nullYear
I-200-23268-376518CertifiedH-1BMechanical Engineer Mechanical EngineersYSunyes Corporation TamuningGU24nullHour
I-200-23267-376325CertifiedH-1BSENIOR SOFTWARE DEVELOPERSoftware DevelopersYPRIMITIVE PARTNERS LLCMIAMIFL65686nullYear
I-200-23267-376317CertifiedH-1BSports NutritionistDietitians and NutritionistsYLamar UniversityBeaumont TX50637nullYear
I-200-23267-376468CertifiedH-1BCreative Operations ManagerMarketing ManagersYAlltech IncNicholasvilleKY85000nullYear
I-200-23267-376400CertifiedH-1BAssociate II JC65 - Automotive EngineersAutomotive EngineersYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX82576nullYear
I-200-23267-376464CertifiedH-1BBUSINESS OPERATIONS MANAGERBusiness Operations Specialists, All OtherYKJS FOOD ENTERPRISES LLCATLANTAGA9000090001Year
I-200-23267-376364CertifiedH-1BSYSTEMS ANALYSTComputer Systems AnalystsYCOMPUNNEL SOFTWARE GROUP, INCPLAINSBORONJ7250083500Year
I-200-23267-376299CertifiedH-1BPostdoctoral Research FellosMedical Scientists, Except EpidemiologistsYChildren's Hospital Los AngelesLos AngelesCA64480nullYear
I-200-23267-376398CertifiedH-1BManager JC50 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX109158nullYear
I-200-23267-376396CertifiedH-1BManager JC50 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX109158nullYear
I-200-23267-376328CertifiedH-1BSoftware DeveloperSoftware DevelopersYSiaraa Technologies, Inc.PrincetonNJ150000nullYear
I-200-23267-376378CertifiedH-1BManager JC50 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX103730nullYear
I-200-23267-376324CertifiedH-1BAssociate Professor Clinical Title SeriesGeneral Internal Medicine PhysiciansYUniversity of KentuckyLexingtonKY450000nullYear
I-200-23267-376434CertifiedH-1BManager JC50 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX104520nullYear
I-200-23268-376522CertifiedH-1BCivil EngineerCivil EngineersYSmithbridge Guam, Inc.YigoGU46946nullYear
I-200-23267-376312CertifiedH-1BSenior Consultant - Airport Terminal PlannerUrban and Regional PlannersYLandrum & Brown, Inc.Blue AshOH100000nullYear
I-200-23267-376442CertifiedH-1BSenior Manager JC45 - Software DevelopersSoftware DevelopersYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX142002nullYear
I-200-23267-376367CertifiedH-1BManager JC50 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX93517nullYear
I-200-23267-376395CertifiedH-1BLEAD SALESFORCE DEVELOPERSoftware DevelopersYThe Sherwin-Williams CompanyClevelandOH131518134017Year
I-200-23268-376489CertifiedH-1BSoftware EngineerSoftware DevelopersYQUEST GLOBAL SERVICES- N.A., INC.WINDSORCT88420102689Year
I-200-23268-376547CertifiedH-1BSoftware DeveloperSoftware DevelopersYBell Systems, IncLargoFL80100nullYear
I-200-23267-376388CertifiedH-1BSenior Manager JC45 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX127774nullYear
I-200-23267-376420CertifiedH-1BSenior Associate JC60 -Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX70075nullYear
I-200-23267-376429CertifiedH-1BMgr. JC50 - Software Quality Assurance Analysts and TestersSoftware Quality Assurance Analysts and TestersYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX79726nullYear
I-200-23267-376369CertifiedH-1BSoftware DeveloperSoftware DevelopersYStrategic Resources International IncParlinNJ9008590086Year
I-200-23267-376310CertifiedH-1BESL TeacherElementary School Teachers, Except Special EducationYMilwaukee Board of School DirectorsMilwaukeeWI49836104762Year
I-200-23267-376423CertifiedH-1BSenior Associate JC60 -Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX68120nullYear
I-203-23267-376449CertifiedE-3 AustralianManager JC50 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX130000nullYear
I-200-23267-376428CertifiedH-1BMgr. JC50 - Software Quality Assurance Analysts and TestersSoftware Quality Assurance Analysts and TestersYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX79726nullYear
I-200-23267-376452CertifiedH-1BManager JC50 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX110448nullYear
I-200-23268-376537CertifiedH-1BTesterSoftware Quality Assurance Analysts and TestersYHexaware Technologies, Inc.IselinNJ99549nullYear
I-200-23267-376437CertifiedH-1BManager JC50 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX103730nullYear
I-200-23268-376536CertifiedH-1BSoftware DeveloperComputer Occupations, All OtherYRegal IT Services, IncKatyTX80000nullYear
I-203-23267-376294CertifiedE-3 AustralianSenior Regional Manager – Engineering (Americas)Aerospace EngineersYQantas Airways LimitedLos AngelesCA220000nullYear
I-200-23267-376439CertifiedH-1BSenior Associate JC60 -Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX76357nullYear
I-200-23268-376519CertifiedH-1BConfiguration Specialist Software DevelopersYCOEUS Holdings, LLCDevonPA140000nullYear
I-200-23267-376362CertifiedH-1BHospitalistHospitalistsYATLANTICARE REGIONAL MEDICAL CENTERATLANTIC CITYNJ280000nullYear
I-200-23267-376424CertifiedH-1BSenior Associate JC60 -Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX78187nullYear
I-200-23267-376411CertifiedH-1BSA JC60 - Network and Computer Systems AdministratorsNetwork and Computer Systems AdministratorsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX75421nullYear
I-200-23268-376533CertifiedH-1BSoftware DeveloperComputer Occupations, All OtherYTech IT Solutions, Inc.HoustonTX80000nullYear
I-200-23267-376414CertifiedH-1BSoftware Engineer IIISoftware DevelopersYTruist BankCharlotteNC119025nullYear
I-200-23267-376352CertifiedH-1BResearch Assistant ProfessorStatisticiansYUniversity of New MexicoAlbuquerqueNM94554115000Year
I-200-23267-376306CertifiedH-1BSolution Architect 3Software DevelopersYCAPGEMINI AMERICA INCCHICAGOIL142000nullYear
I-200-23267-376408CertifiedH-1BSA JC60 - Network and Computer Systems AdministratorsNetwork and Computer Systems AdministratorsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX75421nullYear
I-200-23267-376373CertifiedH-1BSenior Associate JC60 -Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX78478nullYear
I-200-23267-376387CertifiedH-1BSenior Manager JC45 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX127774nullYear
I-200-23267-376365CertifiedH-1BSr. Software EngineerSoftware DevelopersYVantageERP LLCHoustonTX100000nullYear
I-200-23267-376401CertifiedH-1BAssociate II JC65 - Automotive EngineersAutomotive EngineersYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX82576nullYear
I-200-23268-376550CertifiedH-1BComputer ProgrammerComputer ProgrammersYHexaware Technologies, Inc.IselinNJ8141186403Year
I-200-23268-376544CertifiedH-1BSoftware DeveloperComputer Occupations, All OtherYPRIME BUSINESS TECHNOLOGIES INCHOUSTONTX80000nullYear
I-200-23267-376446CertifiedH-1BManager JC50 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX97469nullYear
I-200-23267-376435CertifiedH-1BAD JC40 - Network and Computer Systems AdministratorsNetwork and Computer Systems AdministratorsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX110677nullYear
I-200-23267-376426CertifiedH-1BSenior Associate JC60 -Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX78187nullYear
I-200-23268-376529CertifiedH-1BStaff EngineerSoftware DevelopersYKloudFuse Inc.CupertinoCA184662225000Year
I-200-23267-376393CertifiedH-1BManager JC50 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX103730nullYear
I-200-23268-376480CertifiedH-1BNetwork EngineerInformation Security EngineersYWISE GEN INCFARMINGTON HILLSMI32nullHour
I-200-23267-376308CertifiedH-1BESL TeacherKindergarten Teachers, Except Special EducationYMilwaukee Board of School DirectorsMilwaukeeWI49836104762Year
I-200-23267-376451CertifiedH-1BManager JC50 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX210704nullYear
I-200-23267-376412CertifiedH-1BData Scientist IIData ScientistsYTruist BankCharlotteGA112000nullYear
I-200-23267-376404CertifiedH-1BManager JC50 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX93517nullYear
I-200-23267-376276CertifiedH-1BSenior Member Technical StaffSoftware Quality Assurance Analysts and TestersYSalesforce, Inc.San FranciscoCA163929nullYear
I-200-23267-376466CertifiedH-1BHR MANAGERHuman Resources ManagersY351323 COFFEE CAFE LLCLOGANVILLEGA8116281163Year
I-200-23267-376389CertifiedH-1BSenior Associate JC60 -Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX75254nullYear
I-200-23267-376303CertifiedH-1BPostdoctoral Research FellowMedical Scientists, Except EpidemiologistsYChildren's Hospital Los AngelesLos AngelesCA64480nullYear
I-200-23267-376418CertifiedH-1BSenior Associate JC60 -Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX63960nullYear
I-200-23267-376311CertifiedH-1BProject Manager 3Information Technology Project ManagersYCAPGEMINI AMERICA INCCHICAGOIL148184nullYear
I-200-23267-376440CertifiedH-1BMedical Research SpecialistMedical and Clinical Laboratory TechnologistsYAdministrators of the Tulane Educational FundNew OrleansLA53681nullYear
I-200-23267-376376CertifiedH-1BSenior Manager JC45 - Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX100006nullYear
I-200-23267-376356CertifiedH-1BLead DevOps EngineerSoftware DevelopersYFresenius USA Marketing, Inc., a Fresenius Medical Care N.A. companyWalthamMA145002nullYear
I-200-23268-376515CertifiedH-1BSoftware DeveloperComputer Occupations, All OtherYTech IT Solutions, Inc.HoustonTX80000nullYear
I-200-23267-376275CertifiedH-1BDEVOPS ENGINEERComputer ProgrammersYORIGIN HUBS INCMORRISVILLENC87800nullYear
I-200-23267-376278CertifiedH-1BAssistant ProfessorChemistry Teachers, PostsecondaryYUniversity of Georgia; OGEAthensGA105000nullYear
I-200-23267-376391CertifiedH-1BSenior Associate JC60 -Computer Systems Engineers/ArchitectsComputer Systems Engineers/ArchitectsYCOGNIZANT TECHNOLOGY SOLUTIONS US CORPCOLLEGE STATIONTX75254nullYear
I-200-23267-376460CertifiedH-1BSOFTWARE ENGINEERWeb DevelopersYPRIMITIVE PARTNERS LLCMIAMIFL71448nullYear
I-200-23267-376392CertifiedH-1BProject ManagerInformation Technology Project ManagersYSunsoft Services IncJersey CityNJ7847878500Year
I-200-23267-376309CertifiedH-1BTest Consultant 3Software Quality Assurance Analysts and TestersYCAPGEMINI AMERICA INCCHICAGOIL116858nullYear
I-200-23267-376304CertifiedH-1BData Analyst 2Data Warehousing SpecialistsYCAPGEMINI AMERICA INCCHICAGOIL122000nullYear