The ETL engineer will support a cloud based analytics platform based on AWS using Informatica Power center and Snowflake. In addition to the skills listed, experience with other Informatica tools such as MDM, Axon, and EDC will be preferred. Knowledge of Python will be preferred.
| Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity. |
||
| Years | Required/Preferred | Experience |
| 10 | Required | ETL experience in Informatica tools or similar technology |
| 8 | Required | Experience Working on Data Warehousing projects |
| 8 | Required | Experience working on Enterprise Scale database solutions, such as Oracle, SQL Server, Snowflake, and similar |
| 8 | Required | Experience in Agile or Scrum |
| 5 | Preferred | Experience with Informatica PowerCenter preferred |
| 5 | Preferred | Experience with Business Intelligence or Reporting tools such as Tableau, PowerBI, Crystal Reports, SSRS, or simlar. |
| 4 | Preferred | Experience creating data models, including star and snowflake schema strongly preferred. This should include both Physical and Logical Data models. |
| 4 | Preferred | Experience with cloud platforms such as AWS, Azure or similar strongly preferred |
| 3 | Preferred | Experience with Python |
| 2 | Preferred | Experience with Snowflake Cloud Database |
A) Services shall be provided during normal business hours unless otherwise coordinated through the Agency. Normal business hours are Monday through Friday from 8:00 a.m. through 5:00 p.m., excluding Texas state holidays when the agency is closed.
B) The primary work location will be 701 W 51st, Austin, Texas 78751.
Position will be 4 days remote with 1 day (Tuesdays) required to be onsite at the location listed above. Program will allow candidates who are within the state (Any location within the State of Texas).
Please do not submit candidates who are currently out of state and are planning to move to Texas. Candidates must already reside in Texas.
C) Any and all travel, per diem, parking, and/or living expenses shall be at the worker’s and/or Vendor’s expense.
D) The worker may be required to work remotely at HHSC discretion, up to 100 percent of the time.
E) The worker may be required to work outside the normal business hours on weekends, evenings and holidays, as requested. Payment for work over 40 hours will be at the hourly rate quoted and must be coordinated and pre-approved through the Agency.
Interviews will be conducted:
☐ By Phone
☐ In person
☒ Through Microsoft Teams
Submission of a candidate’s resume by multiple vendors will result in disqualification of the candidate from this opportunity.
This position is subject to availability of funding.
In submitting a resume for this solicitation, the vendor attests to their compliance with e-verify for the submitted candidate. E-verify requirements are outlined in Appendix A, Section P. Immigration, of the Standard Terms and Conditions for Information Technology Staff Augmentation Contract.
Worker must sign an Acceptable Use Agreement as a condition of employment.
Worker must sign and return an HHSC Information Technology Staff Augmentation Contractor Integrity Agreement (IT Form 4710) before a purchase order is issued.
Vendor must sign and return and HHS Information Security Cybersecurity Training Acknowledgement (HHS Form 3834) before a purchase order is issued.
Vendor must conduct a criminal history investigation of the Worker and provide the results to HHSC prior to the issuance of any purchase order. The criminal history investigation must have been conducted within six months prior to the issuance of any purchase order, including a purchase order for modifying or extending the terms of the agreement. Should the Worker not be acceptable to HHSC at any time because of the results of the criminal history investigation, then HHSC may immediately terminate its purchase order and related service agreement or request replacement of the Worker in question.
By accepting the purchaser order, the Vendor agrees to comply with the HHS Data Use Agreement.