127 certified Labor Condition Applications on file with the U.S. Department of Labor, FY2021–FY2025.
Since September 2025, DOL's Project Firewall opens H-1B investigations without waiting for a complaint. These checkpoints come from Advanced Knowledge Tech, LLC's own public LCA filings (FY2023–FY2025) — the same records an investigator pulls first.
Each worksite needs its own 10-business-day LCA notice and a PAF record of that posting; a move to a new area of intended employment needs a new LCA before the worker starts there.
Withdrawn or denied LCAs are normal in isolation; a high share suggests workers were moved between filings and the paper trail needs checking.
Median offered wage is 0% above the DOL prevailing wage across 40 recent certified LCAs. Paying at the floor is lawful, but it invites the question of whether the wage level itself is right.
H-1B dependent employers must also attest to recruitment of U.S. workers and non-displacement, unless every worker on the LCA is exempt ($60k+ or master's degree).
Frequent amendments usually mean worksite or role changes; each one must be covered by a new LCA before the change takes effect.
Level I is the entry-level prevailing-wage tier and the band DOL's Project Firewall reviews first for misclassification (senior duties filed at an entry-level wage). The national share is 17%.
Public DOL disclosure data can lag actual filings by a quarter. Descriptive only — not legal advice.
Yes — Advanced Knowledge Tech, LLC is an active H-1B sponsor, with 127 certified LCAs on file (FY2021–FY2025), including 6 in FY2025. The median certified salary is $91,354 (P25 $80,122, P75 $98,904). 100% of its certified filings meet or exceed the prevailing wage.
Advanced Knowledge Tech, LLC H-1B sponsorship at a glance, from public U.S. DOL LCA disclosure data (FY2021–FY2025).
Certified LCAs are a prerequisite to H-1B petitions, not visa approvals; one LCA can cover multiple workers. Descriptive only — not legal advice.
The shaded band is the middle half of certified salaries (P25–P75); the bar spans the lowest to highest certified salary.
Levels I–IV are DOL prevailing-wage experience tiers; 22% of filings are senior-level (III–IV).
| Fiscal year | Certified | Denied | Withdrawn | Total |
|---|---|---|---|---|
| FY2021 | 55 | 0 | 21 | 76 |
| FY2022 | 31 | 0 | 33 | 64 |
| FY2023 | 24 | 0 | 10 | 34 |
| FY2024 | 11 | 0 | 11 | 22 |
| FY2025 | 6 | 0 | 0 | 6 |
Case dispositions from the U.S. DOL OFLC disclosure files. Withdrawn are LCAs that were certified and later withdrawn by the employer; they still count toward Total.
| Job title | Salary | Level | Location | Filed | Status |
|---|---|---|---|---|---|
Expert Database Architect I-200-25129-957038 | $96,500/yr | III | Menands, NY | May 09, 2025 | Certified |
ETL Developer I-200-25101-854145 | $90,400/yr | II | Town And Country, MO | Apr 11, 2025 | Certified |
Technical Project/Engagement Manager I-200-25083-796804 | $102,000/yr | III | Dunwoody, GA | Mar 24, 2025 | Certified |
Data Engineer I-200-25078-786320 | $106,000/yr | II | Frisco, TX | Mar 19, 2025 | Certified |
Data Engineer I-200-25055-717501 | $105,997/yr | II | Mckinney, TX | Feb 24, 2025 | Certified |
ETL Informatica Developer I-200-24306-446946 | $93,038/yr | II | Lansing, MI | Nov 01, 2024 | Certified |
Technical Delivery Manager / Engagement Manager I-200-24235-285316 | $101,962/yr | III | Dunwoody, GA | Aug 22, 2024 | Certified |
Senior Software Engineer I-200-24197-195164 | $117,021/yr | II | Englewood, CO | Jul 14, 2024 | Certified |
Technical Delivery Manager / Engagement Manager I-200-24185-170887 | $78,000/yr | III | Hermitage, TN | Jul 03, 2024 | Certified |
Sr. Business Analyst I-200-24172-131526 | $99,674/yr | II | Boston, MA | Jun 20, 2024 | Certified |
Technical Delivery Manager / Engagement Manager I-200-24148-038823 | $78,000/yr | III | Hermitage, TN | May 27, 2024 | Certified |
Infrastructure Engineer / Systems Administrator I-200-24115-919537 | $77,667/yr | II | Plano, TX | Apr 24, 2024 | Certified |
ETL Informatica Developer I-200-24057-746780 | $89,565/yr | II | Lancing, MI | Feb 26, 2024 | Certified |
Data Warehouse Developer III I-200-24047-724310 | $90,000/yr | II | Madison, WI | Feb 16, 2024 | Certified |
ServiceNow CMDB Consultant I-200-24039-702413 | $93,517/yr | III | Aubrey, TX | Feb 08, 2024 | Certified, withdrawn |
SAP Security Consultant I-200-24004-615134 | $105,914/yr | II | Plano, TX | Jan 04, 2024 | Certified, withdrawn |
Data Analyst I-200-24002-604508 | $108,306/yr | II | Queens, NY | Jan 02, 2024 | Certified |
Agile Lifecycle Coach¿¿¿ I-200-23313-492456 | $101,000/yr | II | Gwynn Oak, MD | Nov 09, 2023 | Certified |
Sr. ETL Developer I-200-23313-491956 | $103,272/yr | II | Garner, NC | Nov 09, 2023 | Certified, withdrawn |
ETL Developer ¿¿ I-200-23205-208917 | $101,192/yr | II | Plano, TX | Jul 24, 2023 | Certified, withdrawn |
Business Analyst/Scrum Master I-200-23173-136128 | $73,000/yr | II | Lewisville, TX | Jun 22, 2023 | Certified |
Business Analyst/Scrum Master I-200-23166-115710 | $73,000/yr | II | Lewisville, TX | Jun 15, 2023 | Certified |
Business Analyst/Scrum Master I-200-23166-115662 | $73,000/yr | II | Lewisville, TX | Jun 15, 2023 | Certified |
Business Analyst/Scrum Master I-200-23166-115105 | $73,000/yr | II | Lewisville, TX | Jun 15, 2023 | Certified |
Automation QA operation Lead I-200-23160-094300 | $96,500/yr | II | Berlin, CT | Jun 09, 2023 | Certified |
Senior Software Engineer I-200-23151-064048 | $98,904/yr | II | Flower Mound, TX | May 31, 2023 | Certified |
Software Developer Engineer In TEST I-200-23146-056132 | $75,500/yr | II | King Of Prussia, PA | May 26, 2023 | Certified |
Automation QA operation Lead I-200-23145-052910 | $96,500/yr | II | Berlin, CT | May 25, 2023 | Certified |
ETL Developer I-200-23142-040922 | $110,240/yr | II | Missouri, MO | May 22, 2023 | Certified |
ETL Informatica Developer I-200-23142-040914 | $84,614/yr | II | Pittsburgh, PA | May 22, 2023 | Certified |
SR. Java Factory Lead I-200-23135-020189 | $96,400/yr | II | Mclean, VA | May 15, 2023 | Certified |
Sr. Informatica Developer I-200-23135-020334 | $108,200/yr | II | Mckinney, TX | May 15, 2023 | Certified |
ETL Informatica Developer I-200-23135-020197 | $98,904/yr | II | Lewisville, TX | May 15, 2023 | Certified |
Informatica Developer I-200-23129-004140 | $103,200/yr | II | Thomasville, NC | May 09, 2023 | Certified |
Software Developer Engineer In TEST I-200-23129-004121 | $75,500/yr | II | King Of Prussia, PA | May 09, 2023 | Certified |
DataStage Administrator I-200-23041-766906 | $99,800/yr | III | Chicago, IL | Feb 10, 2023 | Certified |
Java Developer I-200-22348-640552 | $109,283/yr | II | Westlake, TX | Dec 14, 2022 | Certified |
Agile Lifecycle Coach I-200-22308-569411 | $97,000/yr | II | Baltimore, MD | Nov 04, 2022 | Certified |
Agile Lifecycle Coach I-200-22308-569285 | $97,000/yr | II | Baltimore, MD | Nov 04, 2022 | Withdrawn |
Product Owner I-200-22292-539405 | $106,621/yr | III | Chicago, IL | Oct 19, 2022 | Certified |
Application Administrator I-200-22270-496884 | $95,000/yr | II | Dorchester, MA | Sep 27, 2022 | Certified |
Product Engineer I-200-22259-478227 | $84,531/yr | II | Boca Raton, FL | Sep 16, 2022 | Certified |
Business Intelligence Developer I-200-22251-461176 | $84,802/yr | II | Maryland Heights, MO | Sep 08, 2022 | Certified |
Microsoft Dynamics CRM & Power Platform Consultant I-200-22245-453976 | $109,283/yr | II | Suwanee, GA | Sep 02, 2022 | Certified |
Performance Tester I-200-22221-405983 | $72,093/yr | II | Louisville, KY | Aug 09, 2022 | Certified |
ETL Developer I-200-22220-403396 | $98,904/yr | II | Mckinney, TX | Aug 08, 2022 | Certified |
ServiceNow Developer I-200-22220-402821 | $110,510/yr | II | Ellicott City, MD | Aug 08, 2022 | Certified |
ETL Developer I-200-22217-400486 | $84,802/yr | II | Maryland Heights, MO | Aug 05, 2022 | Certified |
Business Intelligence Developer I-200-22208-380485 | $84,802/yr | II | Maryland Heights, MO | Jul 27, 2022 | Certified |
Scrum Master I-200-22200-362760 | $70,000/yr | II | Louisville, KY | Jul 19, 2022 | Certified |
Scrum Master I-200-22200-362277 | $70,000/yr | II | Louisville, KY | Jul 19, 2022 | Certified, withdrawn |
ETL Developer I-200-22195-353305 | $98,904/yr | II | Plano, TX | Jul 14, 2022 | Certified |
ETL Developer I-200-22187-335449 | $112,632/yr | II | Plano, TX | Jul 06, 2022 | Certified |
Data Modeler I-200-22173-305137 | $75,026/yr | III | Broken Arrow, OK | Jun 22, 2022 | Certified |
Data Architect I-200-22168-293361 | $72,134/yr | II | Broken Arrow, OK | Jun 17, 2022 | Certified |
ETL Developer I-200-22152-232848 | $94,037/yr | II | Richardson, TX | Jun 01, 2022 | Certified |
Snowflake Developer I-200-22143-202108 | $77,584/yr | II | Morrisville, NC | May 23, 2022 | Certified |
Senior Software Engineer I-200-22137-181448 | $111,176/yr | III | Flower Mound, TX | May 17, 2022 | Certified, withdrawn |
SAP Security Consultant I-200-22131-161468 | $106,059/yr | III | Plano, TX | May 11, 2022 | Certified |
Data Engineer I-200-22126-146002 | $94,037/yr | II | Frisco, TX | May 06, 2022 | Certified |
Senior Java Developer I-200-22124-136607 | $87,485/yr | II | Alpharetta, GA | May 04, 2022 | Certified, withdrawn |
ServiceNow Architect I-200-22122-126749 | $95,555/yr | III | Austin, TX | May 02, 2022 | Certified |
Expert Database Architect I-200-22118-117856 | $91,187/yr | III | Menands, NY | Apr 28, 2022 | Certified |
Software Developer I-200-22101-058227 | $72,134/yr | II | Broken Arrow, OK | Apr 11, 2022 | Certified, withdrawn |
Lead Scrum Master I-200-22088-019154 | $80,000/yr | II | Atlanta, GA | Mar 29, 2022 | Certified |
Informatica Developer I-200-22082-002740 | $99,944/yr | II | Canton, MA | Mar 23, 2022 | Certified |
ETL Engineer I-200-22077-992376 | $78,500/yr | II | Richmond, VA | Mar 18, 2022 | Certified |
ETL Developer I-200-22076-988583 | $79,000/yr | II | Glen Allen, VA | Mar 17, 2022 | Certified, withdrawn |
Lead Scrum Master I-200-22073-976959 | $80,000/yr | II | Atlanta, GA | Mar 14, 2022 | Certified |
Test Data Engineer I-200-22046-904885 | $76,981/yr | II | San Antonio, TX | Feb 15, 2022 | Certified |
ETL Developer I-200-22045-899886 | $89,669/yr | II | Glen Allen, VA | Feb 14, 2022 | Certified, withdrawn |
ETL Engineer I-200-22027-858985 | $78,500/yr | II | Richmond, VA | Jan 27, 2022 | Certified |
Informatica Developer I-200-22025-853156 | $91,520/yr | II | Cumberland, RI | Jan 25, 2022 | Certified |
Senior Full-Stack Java Lead I-200-22013-827836 | $94,016/yr | II | Centennial, CO | Jan 13, 2022 | Certified, withdrawn |
ETL Developer I-200-21323-716224 | $77,000/yr | II | Tampa, FL | Nov 19, 2021 | Certified |
Lead Scrum Master I-200-21301-674397 | $76,000/yr | II | Atlanta, GA | Oct 28, 2021 | Certified |
ServiceNow Developer I-200-21293-657454 | $94,037/yr | II | Dallas, TX | Oct 20, 2021 | Certified |
ServiceNow Developer I-200-21291-651590 | $94,037/yr | II | Lewisville, TX | Oct 18, 2021 | Certified, withdrawn |
ETL Developer I-200-21285-639814 | $85,842/yr | II | Charlotte, NC | Oct 12, 2021 | Certified |
ETL Developer I-200-21273-616468 | $85,842/yr | II | Charlotte, NC | Sep 30, 2021 | Certified |
Senior Developer I-200-21259-588353 | $105,040/yr | III | Atlanta, GA | Sep 16, 2021 | Certified |
ETL Developer I-200-21257-583354 | $91,874/yr | II | Henrico, VA | Sep 14, 2021 | Certified |
Infrastructure Architect 3 I-200-21243-557059 | $93,000/yr | III | Philadelphia, PA | Aug 31, 2021 | Certified |
SAP Consultant I-200-21243-556988 | $101,754/yr | II | Parsippany, NJ | Aug 31, 2021 | Certified |
Scrum Master I-200-21243-556763 | $90,147/yr | III | Long Beach, CA | Aug 31, 2021 | Certified |
Scrum Master I-200-21216-502387 | $90,147/yr | III | Long Beach, CA | Aug 04, 2021 | Certified |
Test Data Engineer I-200-21203-478870 | $76,981/yr | II | San Antonio, TX | Jul 22, 2021 | Certified |
SAP Consultant I-200-21203-478441 | $101,754/yr | II | Parsippany, NJ | Jul 22, 2021 | Certified |
Test Data Engineer I-200-21197-467786 | $76,981/yr | II | San Antonio, TX | Jul 16, 2021 | Certified |
Infrastructure Architect 3 I-200-21194-458429 | $93,000/yr | III | Philadelphia, PA | Jul 13, 2021 | Certified |
Sr. Software Engineer I-200-21188-449382 | $94,016/yr | II | Englewood, CO | Jul 07, 2021 | Certified |
ETL Developer I-200-21180-433500 | $83,637/yr | II | Maryland Heights, MO | Jun 29, 2021 | Certified |
ETL Developer I-200-21159-378801 | $86,000/yr | II | Maryland Heights, MO | Jun 08, 2021 | Withdrawn |
ETL Developer I-200-21159-379158 | $86,000/yr | II | Maryland Heights, MO | Jun 08, 2021 | Certified |
SAP Basis Consultant I-200-21155-370566 | $101,100/yr | III | Mason, OH | Jun 04, 2021 | Certified |
ETL Developer I-200-21153-362970 | $93,558/yr | II | Smithfield, RI | Jun 02, 2021 | Certified |
ServiceNow Developer I-200-21130-300797 | $93,558/yr | II | Lewisville, TX | May 10, 2021 | Certified |
Red Hat System Administrator I-200-21125-289253 | $90,938/yr | III | Fort Worth, TX | May 05, 2021 | Certified |
Scrum Master - Lead I-200-21103-221003 | $74,006/yr | II | Atlanta, GA | Apr 13, 2021 | Certified |
Sr. Systems Administrator I-200-21102-216627 | $72,509/yr | II | Austin, TX | Apr 12, 2021 | Certified |
Informatica Developer I-200-21097-205894 | $93,558/yr | II | Plano, TX | Apr 07, 2021 | Certified, withdrawn |
ETL Developer I-200-21089-185701 | $93,600/yr | II | Woonsocket, RI | Mar 30, 2021 | Certified |
ServiceNow Architect I-200-21081-164819 | $110,344/yr | III | Plano, TX | Mar 22, 2021 | Certified |
ECM Java Programmer I-200-21070-140496 | $80,163/yr | II | Nashville, TN | Mar 11, 2021 | Certified |
Programmer/Analyst I-200-21068-133587 | $80,163/yr | II | Nashville, TN | Mar 09, 2021 | Certified |
ETL Developer I-200-21063-121042 | $82,784/yr | II | San Antonio, TX | Mar 04, 2021 | Certified |
ETL Developer I-200-21060-109567 | $82,784/yr | II | San Antonio, TX | Mar 01, 2021 | Certified |
Scrum Master I-200-21049-086166 | $79,000/yr | II | Atlanta, GA | Feb 18, 2021 | Certified |
Data Engineer I-200-21042-072514 | $87,984/yr | II | Richmond, VA | Feb 11, 2021 | Certified |
Scrum Master I-200-21040-066407 | $69,500/yr | II | Louisville, KY | Feb 09, 2021 | Certified |
Data Warehouse Developer II I-200-21035-055194 | $81,100/yr | II | Madison, WI | Feb 04, 2021 | Certified |
Java Full Stack Developer I-200-21035-055201 | $87,838/yr | II | Chicago, IL | Feb 04, 2021 | Certified |
Informatica Developer I-200-21032-047067 | $76,502/yr | II | Kansas City, MO | Feb 01, 2021 | Certified |
ServiceNow Developer I-200-21025-031421 | $110,344/yr | III | Plano, TX | Jan 25, 2021 | Certified |
Software Application Developer I-200-21022-028298 | $74,100/yr | III | Santa Fe, NM | Jan 22, 2021 | Certified |
Application Developer I-200-21021-025557 | $97,406/yr | II | Washington, DC | Jan 21, 2021 | Certified |
ServiceNow Consultant I-200-21011-006127 | $127,150/yr | IV | Lewisville, TX | Jan 11, 2021 | Certified, withdrawn |
Informatica Developer I-200-21004-993857 | $76,502/yr | II | Kansas City, MO | Jan 04, 2021 | Certified, withdrawn |
Technical Lead I-200-20344-946519 | $86,000/yr | II | Maryland Heights, MO | Dec 09, 2020 | Certified |
Technical Lead I-200-20322-916370 | $114,400/yr | II | Maryland Heights, MO | Nov 17, 2020 | Certified |
ServiceNow Consultant I-200-20321-914144 | $127,213/yr | II | Plano, TX | Nov 16, 2020 | Certified, withdrawn |
ServiceNow Developer I-200-20295-884616 | $127,213/yr | II | Plano, TX | Oct 21, 2020 | Certified, withdrawn |
ServiceNow Developer I-200-20295-884187 | $127,213/yr | II | Plano, TX | Oct 21, 2020 | Withdrawn |
Performance Tester I-200-20281-865351 | $78,582/yr | III | Louisville, KY | Oct 07, 2020 | Certified |
Systems Engineer/Administrator I-200-20267-841525 | $77,501/yr | III | Colorado Springs, CO | Sep 23, 2020 | Certified, withdrawn |
Business Analyst I-200-20248-806265 | $75,600/yr | II | Columbus, OH | Sep 04, 2020 | Certified, withdrawn |
Data Engineer I-200-20239-789428 | $81,806/yr | II | Tampa, FL | Aug 26, 2020 | Certified, withdrawn |
Cloud Engineer I-200-20238-786701 | $97,450/yr | II | Mclean, VA | Aug 25, 2020 | Certified, withdrawn |
Full Stack Developer I-200-20231-775127 | $94,100/yr | II | Columbia, MD | Aug 18, 2020 | Certified, withdrawn |
Web Portal Developer I-200-20196-713983 | $87,000/yr | III | Tallahassee, FL | Jul 14, 2020 | Certified, withdrawn |
Database Specialist System Engineer I-200-20192-708474 | $90,000/yr | II | Atlanta, GA | Jul 10, 2020 | Certified, withdrawn |
SQL Database Administrator I-200-20191-705932 | $86,000/yr | II | Brookfield, WI | Jul 09, 2020 | Certified, withdrawn |
Web Portal Developer I-200-20190-703187 | $87,000/yr | III | Tallahassee, FL | Jul 08, 2020 | Certified, withdrawn |
Software Developer/Administrator I-200-20183-690649 | $90,500/yr | II | Columbus, OH | Jul 01, 2020 | Certified, withdrawn |
ETL Developer I-200-20121-531614 | $91,750/yr | II | Dover, NH | Apr 30, 2020 | Certified, withdrawn |
Informatica Developer I-200-20099-471281 | $93,891/yr | II | Woodland Hills, CA | Apr 08, 2020 | Certified, withdrawn |
Senior Java Developer I-200-20073-405623 | $94,350/yr | II | Plano, TX | Mar 13, 2020 | Certified, withdrawn |
Systems Engineer/Administrator I-200-20042-314008 | $77,000/yr | III | Colorado Springs, CO | Feb 11, 2020 | Certified, withdrawn |
Senior IT Developer I-200-20030-287726 | $92,000/yr | III | Jacksonville, FL | Jan 30, 2020 | Certified, withdrawn |
Sr. Java Developer I-200-20027-277641 | $86,000/yr | II | Alpharetta, GA | Jan 27, 2020 | Certified, withdrawn |
DataStage Administrator I-200-20024-274603 | $97,100/yr | III | Chicago, IL | Jan 24, 2020 | Certified, withdrawn |
Technical Architect I-200-20023-272246 | $137,500/yr | IV | Brooklyn, NY | Jan 23, 2020 | Certified, withdrawn |
One row per LCA case (its latest version), from U.S. DOL OFLC disclosure data. Salaries are the offered wage, converted to a yearly figure. Certified LCAs are not visa approvals.
Worker positions by LCA filing purpose, summed across FY2021–FY2025 disclosure records.
Most active filing months: Feb and May — useful for timing transfer conversations.
Attestations from the employer's own LCA filings (Form ETA-9035), as disclosed by the U.S. DOL.
25 states · 69 cities
The same DOL data on this page is what every H-1B sponsor must track for each worker. ElevateStaffing.ai automates it end-to-end:
Get the private PAF / LCA gap check for your own filings — free, one business day — then let ElevateStaffing.ai keep every LCA, PAF, I-9 and I-983 deadline audit-ready.
Get my private gap check →