[Remote] ETL Developer (Informatica / Snowflake / Azure Data Factory)
Tential SolutionsRole Overview
Tential Solutions is hiring a mid-level [Remote] ETL Developer (Informatica / Snowflake / Azure Data Factory). This is a contract remote role, with the team based in Remote. Full responsibilities, required qualifications, and the apply link are listed in the description below.
Resume Keywords to Include
Make sure these keywords appear in your resume to improve ATS scoring
Sign up free to auto-tailor your resume with all these keywords and get a higher ATS score
Job Description
Note: The job is a remote job and is open to candidates in USA. Tential Solutions is seeking an experienced ETL Developer to design, develop, and support enterprise data integration solutions. In this client-facing role, you will focus on building and maintaining robust data warehouse pipelines using the Informatica suite, Snowflake, and Azure Data Factory.
Responsibilities
- Build and maintain ETL solutions using Informatica IDMC, PowerCenter, and IICS
- Design and implement dimensional models, including FACT/DIM table design and Star/Snowflake schemas
- Design ETL mappings, workflows, and end-to-end scheduling logic using enterprise tools like Control-M
- Build and support data pipelines using Snowflake and Azure Data Factory (ADF)
- Write and tune complex SQL and PL/SQL for high-performance transformations and validations
- Implement Change Data Capture (CDC) solutions and provide production support for scheduled batch jobs
- Partner with data architects and stakeholders to ensure pipelines meet performance SLAs and support downstream analytics
Skills
- Bachelor's Degree
- Must be a US Citizen or Green Card Holder (No sponsorship available)
- Ability to travel within the U.S. based on client needs
- 4+ years of dedicated ETL development and maintenance for data warehousing
- Hands-on mastery of Informatica IDMC, PowerCenter, and/or IICS
- Strong proficiency in SQL/PL/SQL performance tuning and solid experience with UNIX and Oracle tools
- Deep understanding of ETL mapping design, workflow logic, and incremental load strategies
- Proven track record in production support, job monitoring, and issue resolution in batch environments
- Strong knowledge of data loading patterns and performance considerations in Snowflake
- Experience building pipelines and orchestration within Azure Data Factory
- Familiarity with log-based or incremental patterns for Change Data Capture
Company Overview
- We put people first. We’re your trusted partner - empowering you with top talent and solutions to stay competitive in today’s dynamic market. It was founded in 2003, and is headquartered in Annapolis, Maryland, USA, with a workforce of 501-1000 employees. Its website is https://www.tential.com.
Frequently Asked Questions
How do I apply for the [Remote] ETL Developer (Informatica / Snowflake / Azure Data Factory) position at Tential Solutions?
Use the Apply button above to submit your application directly to Tential Solutions. Most applications take less than 5 minutes if your resume and contact details are ready, and you'll be routed to the employer's official application system to finish.
Is the [Remote] ETL Developer (Informatica / Snowflake / Azure Data Factory) role at Tential Solutions remote?
Yes. This is a remote role. The team is based in Remote, but the position itself does not require relocating to that office.
What does a [Remote] ETL Developer (Informatica / Snowflake / Azure Data Factory) at Tential Solutions earn?
Tential Solutions has not disclosed a salary range in this posting. Many employers share specifics later in the interview process; you can also ask during a recruiter screen if compensation transparency is important to you.
When was the [Remote] ETL Developer (Informatica / Snowflake / Azure Data Factory) role at Tential Solutions posted?
This role was posted on April 4, 2026 (65 days ago). It's still listed as actively hiring; we re-confirm openings against the source system multiple times per day and remove closed roles.
AI-powered job search
Get every job scored to your resume
Upload your resume and get jobs ranked, your resume tailored, and employee contacts found automatically.
Get Started FreeNo credit card to start