ETL Developer Job at Donato Technologies, Inc, Texas

RmdHQ2lmdlRyZkh0bmVQT2IrMm1EeEljbFE9PQ==
  • Donato Technologies, Inc
  • Texas

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:

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

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

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

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

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

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

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

o 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).

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

o Linux/Unix experience.

II. 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

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 resumes@donatotech.net

Job Tags

Similar Jobs

Domino's Franchise

Pizza Chef / Line Cook Job at Domino's Franchise

 ...responsibilities include but not limited to: -Answering phones. -Helping carryout, curbside, and pick up window customers. -Making pizzas in a busy and timed environment. -Wowing our customers. -Leading by example. Qualifications Job Requirements... 

Newport Associates

(Remote) Travell Specialist Job at Newport Associates

 ...to learn new skills, work from home, and turn your passion for travel into a meaningful career? Were looking for motivated, detail-oriented...  ..., a love for helping others, and an interest in exploring the world. As a Travel Scheduler, youll help clients create... 

MyCHN

Medical Social Worker (Full-Time) Job at MyCHN

 ...Job Summary: Primary function of the Medical Social Worker (MSW) is to provide coordinated care in the home to patients of all age groups...  ...conditions Ability to work flexible schedule and ability to travel locally Transportation: Reliable transportation and valid... 

SHANGHAI JIN HE YUAN YUAN CONSULTATION PTY LTD

Arabic Actor for TikTok Video Job at SHANGHAI JIN HE YUAN YUAN CONSULTATION PTY LTD

We are seeking a talented and charismatic Arabic actor to collaborate with us on creating engaging TikTok videos, with a primary focus on product presentation. As an actor, you will play a crucial role in helping us promote our products and connect with our Arabic-speaking...

Marimn Health

PHARMACY MANAGER Job at Marimn Health

 ...the state of Idaho. A minimum of a Bachelor of Science degree in Pharmacy is required, with a Doctor of Pharmacy (PharmD) preferred....  ...up to 30 lbs.~Pulling up to 20 lbs.RESPONSIBILITIES: ~Manages all aspects of Marimn Health pharmacy.~Develops and maintains...