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

Sysco

CDL A Local Delivery Truck Driver - Sysco Cincinnati - Circleville (R84494) Job at Sysco

Company: US0019 Sysco Cincinnati, LLC Zip Code: 43164 Employment Type: Full Time Travel Percentage: 0 JOB SUMMARY Sysco has immediate job openings for dependable local CDL A Delivery Truck Drivers to safely and efficiently operate a tractor-trailer... 

Personnel Plus, Inc.

Farm truck driver Job at Personnel Plus, Inc.

 ...in business for over 50 years. looking for Class A & B CDL drivers to join our team. If you dont have a CDL client will train you...  ...issues and perform preventative maintenance. Safely maneuver trucks into loading or unloading positions. Communicate well with... 

Rock Harbor Church FL

Youth Ministry Director / Pastor Job at Rock Harbor Church FL

 ...Youth Ministry Director/Pastor Full-time - $45,000 to $65,000 Rock Harbor Church is seeking a passionate and dedicated Youth Ministry Director/Pastor to lead and develop our vibrant youth ministry. This role will involve creating a safe and engaging environment... 

University of Southern California (USC)

Adjunct Professor of Film and Television Production - Sound | University of Southern California (USC) Job at University of Southern California (USC)

 ...The Division of Film and Television Production of the School of Cinematic Arts is seeking professionals with high level practical experience within the film industry to teach beginning, intermediate and advanced level courses in the field of sound. The Division... 

Waste Management

Truck Driver Helper - 2206001 Job at Waste Management

 ...care, and more! Who are we? #WeAreWM I. Job Summary Driver Helper teams with Route Driver and assists in the collection of Waste...  .... Requires pushing, pulling, bending, twisting and lifting up to _ lbs. Will be exposed to a physical environment, which...