What are the responsibilities and job description for the ETL Developer position at Cloud and Things?
Our goal is to solve problems and deliver results for our clients. At Cloud and Things, you can be a part of transforming the public sector’s IT environment. Our team is on the forefront of helping to solve the government's most complex IT challenges. If you are seeking a role that offers the opportunity to work on rewarding projects, consider a career with Cloud and Things.
We are seeking an ETL Developer to support our client on a high-impact project within the Health and Human Services domain. The selected candidate will play a key role in designing, developing, and maintaining data integration solutions using Informatica and PL/SQL. This role involves working with large-scale OLTP and OLAP systems, optimizing performance, and ensuring data accuracy and integrity. The ETL Developer will serve as a technical liaison across teams, monitor daily processes, troubleshoot issues, and contribute to the continuous improvement of data operations and architecture.
Duties
AI-Assisted Resume Evaluation Notice
Cloud and Things – Talent Management
Notice to Candidates
Cloud and Things utilizes artificial intelligence (AI) tools to assist our recruiting team in evaluating candidate applications for streamlining; consistency, efficiency, and thoroughness. All hiring decisions are ultimately made by our human recruiting professionals.
How AI Is Used
Our AI tools assist by:
Your Data and Privacy
Cloud And Things Data Handling
By submitting your application, you acknowledge this notice and consent to AI-assisted evaluation as part of our recruitment process. You may opt out only by choosing not to submit your resume for consideration.
- This is an exempt position. Salary commensurate with experience*
We are seeking an ETL Developer to support our client on a high-impact project within the Health and Human Services domain. The selected candidate will play a key role in designing, developing, and maintaining data integration solutions using Informatica and PL/SQL. This role involves working with large-scale OLTP and OLAP systems, optimizing performance, and ensuring data accuracy and integrity. The ETL Developer will serve as a technical liaison across teams, monitor daily processes, troubleshoot issues, and contribute to the continuous improvement of data operations and architecture.
Duties
- Perform analysis, design, development and implementation, including data analysis, data access, data structures, data transformation, data reporting solutions and user documentation.
- Act as the primary ETL technical liaison working with technical infrastructure teams to resolve problems and implement solutions to technical issues impacting application performance.
- Manage and administers ETL solutions for medium to large scale OLTP and OLAP projects.
- Monitor daily ETL jobs and processes that identify load and performance issues and determine the resolution and revise the incorrect operational processes.
- Communicate and coordinate with members of the development team to work across multiple projects.
- Explore, actively support and work on new technology initiatives that may be of interest to the organization.
- Actively participate in troubleshooting any technical issues that the program may have.
- Other duties as assigned
- 7 years of experience working on complex projects with 2 or more years in a leadership role as a Developer
- 7 years of experience in analysis, design, development, testing and implementation of data integration solutions using PL/SQL & relational databases.
- 5 years of hands-on experience in implementing and maintaining data integration processes using Informatica suite of products such as Informatica PowerCenter and/or Informatica Data Quality.
- 7 years of hands-on experience using ETL tools like Informatica PowerCenter to migrate data from various sources and targets including databases, flat files, and XML files, UNIX shell scripts.
- 7 years of experience developing complex SQL, PLSQL objects with Oracle 11g or higher such as stored procedures, triggers, packages, materialized view and using Oracle supplied utilities including: SQL Loader, external tables, and Oracle built in packages to migrate data.
- 5 years of experience with Data Quality processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match and merge functionality using tools such as Informatica Data Quality.
- 7 years of experience in implementing concepts such as Slowly Changing Dimension (SCD Type) and Change Data Capture (CDC) functionality in both an OLTP (Relational Modeling) and OLAP (Dimensional Modeling) environments.
- 7 years of experience writing complex UNIX scripts to validate and ftp files, and for scheduling / automating ETL processes.
- 7 years of experience in performance tuning SQL scripts, complex PL/SQL objects such as procedures, functions, triggers, packages, tables, views and indexes.
- Experience with implementing ETL solutions for medium to large scale OLTP and OLAP projects.
- Experience in writing technical specifications including ETL source to target mapping documents, ETL design documents, implementation documents.
- Experience with Health & Human services applications.
AI-Assisted Resume Evaluation Notice
Cloud and Things – Talent Management
Notice to Candidates
Cloud and Things utilizes artificial intelligence (AI) tools to assist our recruiting team in evaluating candidate applications for streamlining; consistency, efficiency, and thoroughness. All hiring decisions are ultimately made by our human recruiting professionals.
How AI Is Used
Our AI tools assist by:
- Analyzing resumes against job requirements
- Supporting our recruiters in candidate data evaluation
- Ensuring consistent review standards across all applications
Your Data and Privacy
Cloud And Things Data Handling
- Your information is processed securely and used exclusively for recruitment purposes
- Cloud and Things may store your resume in our Applicant Tracking System (ATS) indefinitely for future job matching opportunities
- You may opt out of long-term ATS storage by emailing your name and your request to opt out of storing your resume in the ATS to: security@cloudandthings.com
- All personal information is handled confidentially in accordance with our privacy policy
- AI processing data is retained for a maximum of 90 days, after which it is deleted
- All data sent to AI tools is encrypted in transit and at rest
- AI tools comply with applicable privacy laws including GDPR and CCPA
- Personal data is anonymized or minimized wherever possible during AI processing
By submitting your application, you acknowledge this notice and consent to AI-assisted evaluation as part of our recruitment process. You may opt out only by choosing not to submit your resume for consideration.
