Job Description

Job Description

Donato Technologies, established in 2012, excels as a comprehensive IT service provider renowned for delivering an exceptional staffing experience and prioritizing the needs of both clients and employees. We specialize in staffing, consulting, software development, and training, catering to small and medium-sized enterprises. While our core strength lies in Information Technology, we also deeply understand and address the unique business requirements of our clients, leveraging IT to effectively meet those needs. Our commitment is to provide high-quality, customized solutions using the optimal combination of technologies.

Title: ETL Developer

Location: Texas - Hybrid - One day onsite

If you are interested, please submit an updated resume (make sure the asking skills are added to the most recent projects - Refer to the Skill matrix). You need to fill all the forms/pages of the attachments ie. RTR, skill matrix - number of years with each asking technology, and three references (refer to the forms), two of them must be supervisor level references, and provide Full name, email and phone number of the references. Please provide the forms in word format only.

Client requires the services of 1 Systems Analyst 3 , hereafter referred to as Candidate(s), who meets the general qualifications of Systems Analyst 3, Applications/Software Development and the specifications outlined in this document for the Client .

All work products resulting from the project shall be considered "works made for hire" and are the property of the Client and may include pre-selection requirements that potential Vendors (and their Candidates) submit to and satisfy criminal background checks as authorized by Texas law. Client will pay no fees for interviews or discussions, which occur during the process of selecting a Candidate(s).

(CLIENT) requires the services of one (1) Informatica administrator/data engineer, hereafter referred to as Worker, who meets the general qualification of Systems Analyst 3, Emerging Technologies and the specifications outlined in this document for Health and Human Services Commission (CLIENT) Information Technology.

All work products resulting from the project shall be considered "works made for hire" and are the property of the CLIENT. CLIENT may include pre-selection requirements that potential Vendors (and their Workers) submit to and satisfy criminal background checks as authorized by the Texas law. CLIENT will pay no fees for interviews or discussions, which occur during the process of selecting a Worker(s).

CLIENT IT is continuing to develop an CLIENT data integration hub with a goal to accomplish the following:

Implementation and configuration of the infrastructure for the data integration hub

Design, Development, And Implementation (DD&I) Of The Data Integration Hub Using An Agile Methodology For All Standard SDLC Phases That Includes, But Is Not Limited To:

Validation of performance metric requirements

Creation of Epics/User Stories/Tasks

Automation of data acquisition from a variety of data sources

Development of complex SQL scripts

Testing integration, load and stress

Deployment / publication internally and externally

Operations support and enhancement of the data integration hub

This Development Effort Will Utilize An Agile Methodology Based Upon The Approach Currently In Use At CLIENT For The Texas Integrated Eligibility Redesign System (TIERS). As a Member Of The Agile Development Team, The Worker Responsibilities May Include:

• ETL Administration with a focus on data warehousing and business intelligence solutions.
• Experience with Informatica IICS Administration, including installation, upgrades, and maintenance of the Informatica IICS environment.
• Knowledge of Power Exchange Change Data Capture (CDC) on both PowerCenter and IICS.
• Experience with a cloud background and knowledge of Continuous Integration and Continuous Deployment (CI/CD) tools such as GitHub and Jenkins.
• Ability to think innovatively and automate various administrative tasks in the admin space using Python and shell scripting skills.
• Excellent analytical skills to triage and resolve production issues and outages.
• Proven expertise in designing, developing, and deploying ETL pipelines using industry-standard tools like Informatica and IICS.
• Familiarity with a wide range of data sources: relational databases (e.g., Oracle, SQL Server, MySQL, Snowflake), flat files, and cloud platforms (e.g., AWS S3, Azure Blob).
• Experience in data quality, validation, and data migration projects.
• Linux/Unix experience.
  
  

Minimum Requirements:

II. CANDIDATE SKILLS AND QUALIFICATIONS

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

ETL Administrator with a focus on data warehousing and business intelligence solutions.

8

Required

Experience with Informatica IICS Administration, including installation, upgrades, and maintenance of the Informatica IICS environment.

8

Required

Knowledge of Power Exchange Change Data Capture (CDC) on both PowerCenter and IICS.

8

Required

Experience with a cloud background and knowledge of Continuous Integration and Continuous Deployment (CI/CD) tools such as GitHub and Jenkins.

8

Required

Ability to think innovatively and automate various administrative tasks in the admin space using Python and shell scripting skills.

8

Required

Excellent analytical skills to triage and resolve production issues and outages.

8

Required

Proven expertise in designing, developing, and deploying ETL pipelines using industry-standard tools like Informatica and IICS.

8

Required

Familiarity with a wide range of data sources: relational databases (e.g., Oracle, SQL Server, MySQL, Snowflake), flat files, and cloud platforms (e.g., AWS S3, Azure Blob).

8

Required

Experience in data quality, validation, and data migration projects.

8

Required

Linux/Unix experience.

8

Required

Technical writing and diagraming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, and PowerPoint) and MS Project.

8

Required

Experience on an agile sprint team

8

Required

Experience with JIRA software

8

Required

Experience working with multiple teams concurrently, being able to prioritize and complete work on time with high quality

8

Required

Knowledge of relational databases and data warehousing, including platforms like Oracle, Snowflake, SQL Server, and MySQL.

8

Required

Proficiency in SQL, Python and Bash.

8

Required

Familiarity with cloud ecosystems like AWS, Azure, or GCP and their respective data services.

8

Required

Data Quality & Modeling: Knowledge of data quality frameworks and data modeling techniques.

6

Preferred

Proven ability to write well designed, testable, efficient code by using best software development practices

4

Preferred

Understanding of security principles and how they apply to healthcare data

4

Preferred

Experience with state of the art software components for a performance metrics data visualization or business intelligence environment

4

Preferred

Excellent oral and written communication skills.

4

Preferred

Effectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required.

4

Preferred

Bachelor's degree in Computer Science, Information Systems, or Business or equivalent experience.

3

Preferred

Prior experience in the Healthcare Industry

2

Preferred

Prior experience with an CLIENT agency

2

Preferred

Prior experience working with PII or PHI data

2

Preferred

Prior experience with Azure

Please share your resumes at [email protected]

Job Tags

Full time,

Similar Jobs