II

AWS Data Engineering & Production Support Technology Consultant – Redshift, Informatica, AutoSys & Python

ITBrainiac Inc H-1B Information Technology Full-timeRichardson, TX
Posted Nov 2, 2026 · Expires Nov 24, 2026

Quick facts

Type
Full-time
Location
Richardson, TX
Skills
Engineering, Python, Java, SQL, AWS
Industry
Information Technology — 1359 open jobs
Visa in listing
H-1B
Apply
Free to apply — never pay anyone for a job offer or visa sponsorship

Job description

AWS Data Engineering & Production Support Technology Consultant – Redshift, Informatica, AutoSys & Python Work Locations: Hartford, CT 06103 / Raleigh, NC 27617 / Richardson, TX 75082 / Tempe, AZ 85281 Contract Duration: 12 Months Work Mode: Hybrid – 3 Days Onsite per Week (Mandatory) Experience Required: 6–8 Years Target Start Date: ASAP Candidate Submission Criteria Preferred candidates with prior experience at Capital One, Freddie Mac, or Fannie Mae. Preferred project experience: 1–4 years; candidates with more than 6 months of relevant project experience can also be considered. Preferred work authorization: L2 , and s. H1B candidates may be considered for exceptional profiles. Face-to-face interview is mandatory at any one of the specified work locations. Candidates must be willing to work onsite 3 days per week. Preferred candidate locations: Reston, VA; Raleigh, NC; Hartford, CT; Plano, TX; Richardson, TX; and Tempe, AZ. Job Description We are looking for an experienced AWS Data Engineering & Production Support Technology Consultant with strong hands-on expertise in AWS Cloud, Amazon Redshift, Informatica, AutoSys, Python, SQL, and enterprise data warehousing. The ideal candidate should have experience supporting complex ETL and data integration environments, handling L3 production support, and developing cloud-based data solutions using AWS services and modern application technologies. Key Responsibilities & Required Skills Strong hands-on experience with AWS Cloud services. Experience with Amazon Redshift and Redshift Spectrum. Hands-on experience with Informatica and AutoSys. Strong programming skills in Python. Proficiency in SQL and PL/SQL. Experience with Enterprise Data Warehousing (EDW) and Data Warehousing concepts. Strong knowledge of ETL processes and Data Integration. Experience providing L3 Application Support and Production Support. Hands-on experience with Amazon S3, Amazon RDS, AWS Lambda, Amazon ECS/ECR, Amazon EventBridge, and Amazon CloudWatch Logs. Experience with Java and Spring Boot. Knowledge of RESTful APIs and Microservices Architecture. Experience with GitLab for version control and d

Visa sponsorship record

No public sponsorship records found

We didn't find H-1B, H-1B1, E-3 or green card (PERM) filings under the name ITBrainiac Inc in the Department of Labor and USCIS data. That doesn't mean the job can't be sponsored — the company may file under a different legal name, be new to sponsorship, or sponsor a visa that isn't in these datasets (for example H-2B or J-1).

Tip: ask the recruiter early, in writing, which visa they sponsor and whether they cover the legal and filing fees.

Which visas can work for this job

Occupation: Database Architects (SOC 15-1243) — estimated from the job title.

  • Mentioned in the listing

    H-1B

  • H-1B cap-exempt employer

    Regular cap-subject employer — a new H-1B needs to win the lottery in March (unless you already hold cap-counted H-1B status).

  • TN (citizens of Canada and Mexico)

    This kind of role may fit the USMCA profession “Computer Systems Analyst” — it depends on the actual duties. No lottery, no cap; you need the matching degree or license.

  • E-3 (Australia) and H-1B1 (Chile, Singapore)

    Same degree requirement as H-1B, but no lottery and a separate quota that is rarely filled.

  • O-1 (extraordinary ability)

    For candidates with awards, publications, press, a high salary or critical roles at distinguished organizations. No cap, no lottery; the employer files a petition.

  • STEM OPT extension (F-1 students)

    Requires an E-Verify employer. We didn't find this company in the E-Verify list — ask HR.

Salary vs prevailing wage

Database Architects · Dallas-Fort Worth-Arlington, TX. Annual prevailing wages set by the Department of Labor (OFLC).

L1L2L3L4
LevelPrevailing wageH-1B lottery odds*
Level I$102,960~15%
Level II$125,362~31%
Level III$147,742~46%
Level IV$170,144~61%

The listing has no salary, so we can't place it on a wage level. Ask the employer which wage level they'd file at: Level III–IV registrations get 3–4 entries in the H-1B lottery.

* Odds are DHS projections for the FY2027 wage-weighted lottery (actual results vary by year and employer). Since the FY2027 cap season the H-1B lottery is weighted by wage level: Level I = 1 entry, II = 2, III = 3, IV = 4. The level is set by the offered wage against the prevailing wage for the occupation and worksite. Separately, a $100,000 fee for new H-1B petitions for workers outside the US was announced in 2025; as of September 2026 a federal court ruling keeps it unenforceable while appeals continue — check the current status.

Sources: U.S. Department of Labor OFLC disclosure data (H-1B/H-1B1/E-3 LCA, PERM), OFLC prevailing wage data, USCIS H-1B Employer Data Hub, E-Verify participating employers. Data loaded: LCA FY2024–FY2026, PERM, USCIS Data Hub, OFLC wages; updated 2026-10-03. Employers are matched by name, so records of companies with similar names can occasionally be mixed up. This is general information, not legal advice — talk to an immigration attorney about your case.

Get new Information Technology jobs by emailOne email a day, only when there are new jobs. Unsubscribe in one click.