Apply Now

ETL Developer

Albany, NY, US • Posted 9 hours ago • Updated 9 hours ago

Full Time

On-site

Depends on Experience

Fitment

Dice Job Match Score™

🎯 Assessing qualifications...

Job Details

Skills

Summary

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. 

*This is an exempt position. Salary commensurate with experience*

Overview:
Location: Hybrid – Brooklyn, NY
Salary: $105,000 – $115,000

We are seeking an ETL Developer who will support our NYC client with the design and implementation of complex data pipelines to extract, transform, and load data into enterprise data warehouses and data lakes, primarily using Oracle Exadata, SQL/PL/SQL, and Informatica IICS. The ideal candidate for this role will have strong Oracle database experience and proven ability in performance tuning and data modeling.
Duties:

Develop complex data pipelines to bring data into the Data Lake/Warehouse per business requirements.
Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
Design the architecture to perform data management activities i.e., data extraction, transformation, and load (ETL) to enterprise data warehouse.
Implement the data management solutions using SQL, SQL procedures, data management tools like Informatica IICS on Oracle exadata database.
Design the overall architecture to Extract, Transform and Load (ETL) data into data warehouse or data mart and data lake.
Develop data models and ER diagrams for existing and new databases.
Maintain and improve already existing processes.

Mandatory Qualifications:

Associates degree or combination of experience and education.
5+ years of experience as an ETL Developer
Proficient in SQL and ETL processes, ETL and DB performance tuning.
Experience with Oracle database full life cycle development including data modeling, database architecture, SQL and PL/SQL development, unit testing and support.
Expertise in PL/SQL Programming including: Data Types, Cursors, Exception Handling Collections, Merge statements, Analytics Functions, Views, Materialized Views, Table Functions, Stored procedures, Functions and Packages, database triggers, mutating, Dynamic SQLs, External Tables, Performance Tuning, Object Programming, built in functions, joins, aggregate functions, Collections.
Working experience with ETL tool (Preferred - Informatica - IICS)
Passionate about complex data structures and problem solving.
High attention to detail.
Ability to pick up new data tools and concepts quickly.

Desirable Qualifications:

Any Experience in public safety systems

Cloud and Things complies with all applicable federal, state, and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other category protected by applicable federal, state, or local laws.

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

Important: AI serves as a support tool only. As noted above, all candidate selection and hiring decisions are made by experienced human recruiters. Your unedited resume will be processed by our AI tools as part of this evaluation.

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 Tool Data Processing:

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

Your Participation
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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 91116955
Position Id: 9263
Posted 9 hours ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Remote

•

18d ago

Title: ETL Engineer / Informatica Developer Location: Remote Pay Rate: $57/hr on W2 Terms of Employment W2 Contract, Six Months (Likely Extension(s)) This position is 100% remote. Candidates must be based in Eastern or Central Time Zone. Overview & Responsibilities Work with a leading healthcare solutions firm to design, develop, and maintain critical data exchange programs. As an ETL Engineer, you will join a lean, highly productive team responsible for managing data flows across 40 different

Easy Apply

Contract

Depends on Experience

ETL DEVELOPER

Remote

•

Yesterday

The Consultant shall work with client staff from the Data Analytics & First New York units within client Division of the Chief Information Officer (the Division). The Consultant shall assist the Division with the build-out of the current CLIENT environment for both infrastructure and tools as they relate to data analytics and the necessary supporting technologies, such as data warehousing, business intelligence, statistical analysis, and data exchanges with external agencies/entities. Tasks incl

Easy Apply

Contract

Depends on Experience

ETL Developer

Remote

•

3d ago

Position Details: Job Title: ETL Developer Job Type: Full-time Location: Hybrid/Remote, DC DynanetCorporation Overview: Dynanet started with a focus on IT infrastructure and operations, helping organizations enhance their networks and overcome the limitations of 1990s technology. From strengthening communication channels to introducing innovative ways to collaborate and share information, Dynanet played a crucial role in shaping the early stages of digital transformation. The companys efforts h

Full-time

Depends on Experience

ETL Developer / Data Warehouse Architect

No location provided

•

Today

SystemDomain, a leading provider of information technology consulting Services firm based in Chicago is looking for IT Professionals. Our high-performance consultants offer technological expertise, strategic insights, and knowledge of their industry experience. Established in 1999, we partner with our customers to build stronger innovative business solutions and to solve their most important and complex business challenges. For more information about SystemDomain, please visit Job Title: ETL Dev

Easy Apply

Full-time, Part-time, Contract, Third Party

Search all similar jobs

ETL Developer

Dice Job Match Score™

Job Details

Skills

Summary

Similar Jobs