Informatica Developer

We are a Prime Vendor with the State of Texas.
This is Carrie Van Loon, a Senior Recruiter at PMC. I live in Austin, this job is in Austin and requires you to live in the area.
Solicitation Reference Number:
Working Title: Informatica Data Engineer
Title/Level: Developer/Programmer Analyst 3
Category: Applications/Software Development
Full Time
$74.00/hour C2C, please ask for W2 rates if you prefer
DESCRIPTION OF SERVICES Railroad Commission of Texas requires the services of 1 Developer/Programmer Analyst 3 , hereafter referred to as Candidate(s), who meets the general qualifications of Developer/Programmer Analyst 3, Applications/Software Development and the specifications outlined in this document for the Railroad Commission of Texas . All work products resulting from the project shall be considered "works made for hire" and are the property of the Railroad Commission of Texas and may include pre-selection requirements that potential Vendors (and their Candidates) submit to and satisfy criminal background checks as authorized by Texas law. Railroad Commission of Texas will pay no fees for interviews or discussions, which occur during the process of selecting a Candidate(s).


DESCRIPTION OF SERVICES Railroad Commission of Texas requires the services of One (1) Informatica Data Engineer, hereafter referred to as Candidate(s), who meets the general qualifications of Applications/Software Development, Developer/Programmer Analyst, Level - 3, and the specifications outlined in this document for the Railroad Commission of Texas .
All work products resulting from the project shall be considered "works made for hire" and are the property of the Railroad Commission of Texas and may include pre-selection requirements that potential Vendors (and their Candidates) submit to and satisfy criminal background checks as authorized by Texas law. Railroad Commission of Texas will pay no fees for interviews or discussions, which occur during the process of selecting a Candidate(s).
Job Description Performs advanced (senior-level) Data Pipeline development work with Informatica Cloud (IICS) including data integration, source to target data modeling, Extract-Transaction-Load development, consuming Oracle data connections, RESTful API application-based data connections, targeting Snowflake data connections, designing Snowflake target data lake databases, data warehouse modeling with ELT. This candidate will be using Informatica Cloud to build mass ingestion pipelines or other EL from an Oracle transaction database(s) to our Snowflake Data Lake. Additional duties may include working within Snowflake to create other API based data ingestion routines and/or setting up Data Sharing of these accumulated data. Dimensional modeling of data may be required in our Data Warehouse to accomplish other objectives like data reporting and improved performance data handling.
Development of ETL/ELT data mappings and workflows for data pipeline development with Informatica Cloud Data Integration. Practical experience using and building Informatica Mass Ingestion Pipelines. Demonstrated experience with Oracle Database as a Data Connector source. Expert with Snowflake as a Target database platform. Experience with the Snowflake platform and ecosystem. Knowledge of Snowflake data sharing and Snowpark is a plus. Knowledge of the advantages as well as previous experience working with Informatica push-down optimization Experience with Snowflake database creation, optimization, and architectural advantages. Practical experience with Snowflake SQL. Determines database requirements by analyzing business operations, applications, and programming; reviewing business objectives; and evaluating current systems. Obtains data model requirements, develops, and implements data models for new projects, and maintains existing data models and data architectures. Creates graphics and other flow diagrams (including ERD) to show complex database design and database modeling more simply. Performs related work as assigned. Practical experience with one time data loads as well as Change Data Capture (CDC) for bulk data movement. Creation of technical documentation for process and interface documentation is a key element of this role, as the Team is working on release two of a multiple release effort. Ability to review the work of others, troubleshoot, and provide feedback and guidance to meet tight deliverable deadlines is required. Ability to promote code from development environments to production. Familiarity with GitHub or equivalent version control systems. Experience working with state agencies as well as security protocols and processes. TERMS OF SERVICE Services are expected to start 4/15/2024 and are expected to be completed by 8/31/2024 . Total estimated hours per Candidate shall not exceed 750 hours. This service may be amended, renewed, and/or extended providing both parties agree to do so in writing.
III. WORK HOURS AND LOCATION Services shall be provided during normal business hours unless otherwise coordinated through the Railroad Commission of Texas . Normal business hours are Monday through Friday from 8:00 AM to 5:00 PM , excluding State holidays when the agency is closed.
The primary work location(s) will be at Work from Home . Any and all travel, per diem, parking, and/or living expenses shall be at the Candidate's and/or Vendor's expense. Railroad Commission of Texas will provide pre-approved, written authorization for travel for any services to be performed away from the primary work location(s). Pre-approved travel expenses are limited to the rates and comply with the rules prescribed by the State of Texas for travel by its classified employees, including any requirement for original receipts.
The Candidate(s) 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 Railroad Commission of Texas .
OTHER SPECIAL REQUIREMENTS The candidate or vendor should provide a desktop or laptop device for the candidate to connect work with RRC via GoToMyPC (or similar) and must have a device capable of handling this connection, including a headset as needed. Alternately, the RRC may provide a desktop or laptop device for connection to the RRC network in certain situations. The laptop must be returned to the RRC Help Desk upon candidate resignation or termination or the end of the purchase order/contract.
Shipping information: Railroad Commission of Texas
1701 North Congress Avenue
Austin, Texas ********
Attn: ITS Help Desk
ADDITIONAL TERMS AND CONDITIONS The term of the Purchase Order is April 15, 2024 through August 31, 2024, with the option for 3 one-year renewals at the RRC's sole discretion depending on satisfactory performance and availability of funding. The Purchase Order term may not be extended except by POCN. Renewal Periods: 1st Renewal September 1, 2024 through August 31, 2025 2nd Renewal September 1, 2025 through August 31, 2026 3rd Renewal - September 1, 2026 through August 31, 2027 CANDIDATE SKILLS AND QUALIFICATIONS 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
8
Required
Generating advanced SQL queries and using other data interrogation methods..
8
Required
Experience with Informatica Products with at least 4 years direct experience with Informatica Cloud Data Integration
8
Required
Reviewing, interpreting, and translation business requirements and design specifications into data mappings, and data pipeline development using all major data integration patterns.
8
Required
Experience in relational database design concepts which including direct experience in Oracle RDBMS.
8
Required
Experience with Data Warehouse architectural patterns including modeling Facts and Dimensions.
8
Required
Experience with static mapping and Change Data Capture (CDC) for bulk data movement.
8
Required
Experience with Informatica Mass Ingestion
8
Required
Experience using Snowflake (creating, managing, optimizing databases as well as time-travel and other technical advantages of cloud data warehousing).
1
Preferred
Any experience working with Snowpark, servicing the needs of Python programmers, or understanding Data Scientists requirements against Snowflake databases will make the candidate more successful
III. TERMS OF SERVICE Services are expected to start 04/15/2024 and are expected to complete by 08/31/2024 . Total estimated hours per Candidate shall not exceed 750 hours. This service may be amended, renewed, and/or extended providing both parties agree to do so in writing.
WORK HOURS AND LOCATION Services shall be provided during normal business hours unless otherwise coordinated through the Railroad Commission of Texas . Normal business hours are Monday through Friday from 8:00 AM to 5:00 PM , excluding State holidays when the agency is closed. The primary work location(s) will be at WFH . Any and all travel, per diem, parking, and/or living expenses shall be at the Candidate's and/or Vendor's expense. Railroad Commission of Texas will provide pre-approved, written authorization for travel for any services to be performed away from the primary work location(s). Pre-approved travel expenses are limited to the rates and comply with the rules prescribed by the State of Texas for travel by its classified employees, including any requirement for original receipts. The Candidate(s) 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 Railroad Commission of Texas .

Report this job Dice Id: ******** Position Id: 8225571