Data Warehouse Developer

Overview

Remote
On Site
Hybrid
BASED ON EXPERIENCE
Contract - W2
Contract - Independent

Skills

Data Management
Data Processing
Flat File
Data Architecture
Regulatory Compliance
Collaboration
Root Cause Analysis
Documentation
Informatica PowerCenter
Migration
Extract
Transform
Load
Workflow
Relational Databases
Data Warehouse
Data Modeling
SQL
Database
PL/SQL
Snow Flake Schema
Data Integration
Communication
Informatica
Cloud Computing
Amazon Web Services
Microsoft Azure
Google Cloud Platform
Google Cloud
Hospitality
Retail
FOCUS
Professional Services
Genetics
Law

Job Details

Title: Data Warehouse Developer
Location: 100% Remote
Duration: 6+ months
Compensation: $60-$70/hr.
Work Requirements: , Holders or Authorized to Work in the U.S.

Job Overview:
We re looking for an experienced Data Warehouse Developer to design, develop, and support enterprise-grade data solutions. This role will focus on converting on-premise Informatica workflows to the Informatica Intelligent Data Management Cloud (IDMC/IICS) platform, building modern data pipelines, and integrating data from a variety of systems into centralized repositories. The ideal candidate brings a deep understanding of Informatica, strong ETL expertise, and cloud data platform experience.

Key Responsibilities:

  • Design, develop, and maintain data warehouse structures and ETL pipelines for large-scale data processing.
  • Migrate existing on-premise Informatica PowerCenter workflows to IDMC (IICS) cloud platform.
  • Build end-to-end data pipelines pulling from cloud systems, on-premise applications, databases, and flat files.
  • Ensure solutions follow data architecture standards, best practices, and compliance requirements.
  • Collaborate with business users, data architects, and engineering teams to define requirements and deliver reliable data solutions.
  • Perform root cause analysis, troubleshoot issues, and optimize performance of ETL processes.
  • Maintain documentation for data processes, mappings, and architecture.

Required Qualifications:
  • 7+ years of experience in Informatica PowerCenter and ETL development.
  • Proven experience migrating ETL workflows from on-premise environments to IDMC or IICS.
  • Strong knowledge of relational databases, data warehousing concepts, and data modeling.
  • Proficient in SQL and working with major database platforms (e.g., Oracle, SQL Server, Snowflake).
  • Experience with data integration across cloud and on-premise systems.
  • Excellent communication skills and ability to work in a collaborative, fast-paced environment.

Preferred Qualifications:
  • Hands-on experience with Informatica IDMC or IICS in a production environment.
  • Familiarity with cloud platforms such as AWS, Azure, or Google Cloud Platform.
  • Experience working with enterprise data standards in a large organization.
  • Exposure to hospitality, retail, or similar domains (optional).


Our benefits package includes:
  • Comprehensive medical benefits
  • Competitive pay
  • 401(k) Retirement plan
  • and much more!

About INSPYR Solutions

Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at inspyrsolutions.com.

INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.

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.

About INSPYR Solutions