Overview
On Site
Contract - W2
Skills
Informatica PowerCenter
Data Integration
Stored Procedures
Data Processing
Slowly Changing Dimensions
Data Quality
Collaboration
Data Profiling
Reporting
Analytics
Scalability
Production Support
Version Control
Continuous Integration
Continuous Delivery
Scheduling
Workflow
Informatica
SQL
PL/SQL
PostgreSQL
Data Warehouse
ELT
OLAP
OLTP
Dimensional Modeling
Data Loading
Change Data Capture
Streaming
Performance Tuning
Cloud Computing
Amazon Web Services
Amazon Redshift
Snow Flake Schema
Microsoft Azure
Google Cloud Platform
Google Cloud
Problem Solving
Conflict Resolution
Debugging
Extract
Transform
Load
Agile
Communication
Job Details
Informatica Developer - Data Warehousing & ETL
Role is 5 days a week onsite McLean, VA - local candidates only
6+ months
About the Role
We are seeking an experienced Informatica Developer to design, build, and optimize enterprise data integration and data warehouse solutions. The ideal candidate will have strong expertise in SQL, data warehouse concepts, and data loading/comparison mechanisms to support complex ETL workflows and ensure data accuracy, consistency, and scalability across business-critical systems.
Key Responsibilities
Design, develop, and maintain ETL workflows using Informatica PowerCenter/Cloud to support enterprise data integration needs.
Implement data loading strategies for large-scale structured and semi-structured data.
Develop efficient SQL queries, stored procedures, and performance tuning for optimal data processing.
Work with data warehouse concepts (fact tables, dimension tables, star/snowflake schemas, slowly changing dimensions, partitioning, indexing).
Design and implement data comparison and reconciliation mechanisms to ensure data quality and consistency across systems.
Collaborate with data architects, analysts, and business teams to gather requirements and translate them into technical ETL solutions.
Perform data profiling, cleansing, and validation to support business reporting and analytics.
Optimize ETL pipelines for scalability, performance, and reliability.
Participate in code reviews, debugging, and production support for ETL processes.
Work with version control, CI/CD, and scheduling tools for deployment and automation of data workflows.
What You'll Bring with You
5+ years of experience as an Informatica Developer in enterprise data warehouse environments.
Strong expertise in SQL (Oracle, SQL Server, PostgreSQL, or similar), including performance tuning.
Deep understanding of data warehouse concepts (ETL/ELT, OLAP/OLTP, dimensional modeling, star/snowflake schemas).
Hands-on experience in data loading techniques (incremental loads, CDC, batch, streaming).
Strong knowledge of data comparison and reconciliation mechanisms for validating large data sets.
Experience with ETL performance optimization and error handling.
Familiarity with cloud data platforms (AWS Redshift, Snowflake, Azure Synapse, or Google Cloud Platform BigQuery) is a plus.
Strong problem-solving and debugging skills for ETL and data issues.
Ability to work in Agile teams, collaborating with business and technical stakeholders.
Excellent communication skills with the ability to explain technical solutions to non-technical users.
Role is 5 days a week onsite McLean, VA - local candidates only
6+ months
About the Role
We are seeking an experienced Informatica Developer to design, build, and optimize enterprise data integration and data warehouse solutions. The ideal candidate will have strong expertise in SQL, data warehouse concepts, and data loading/comparison mechanisms to support complex ETL workflows and ensure data accuracy, consistency, and scalability across business-critical systems.
Key Responsibilities
Design, develop, and maintain ETL workflows using Informatica PowerCenter/Cloud to support enterprise data integration needs.
Implement data loading strategies for large-scale structured and semi-structured data.
Develop efficient SQL queries, stored procedures, and performance tuning for optimal data processing.
Work with data warehouse concepts (fact tables, dimension tables, star/snowflake schemas, slowly changing dimensions, partitioning, indexing).
Design and implement data comparison and reconciliation mechanisms to ensure data quality and consistency across systems.
Collaborate with data architects, analysts, and business teams to gather requirements and translate them into technical ETL solutions.
Perform data profiling, cleansing, and validation to support business reporting and analytics.
Optimize ETL pipelines for scalability, performance, and reliability.
Participate in code reviews, debugging, and production support for ETL processes.
Work with version control, CI/CD, and scheduling tools for deployment and automation of data workflows.
What You'll Bring with You
5+ years of experience as an Informatica Developer in enterprise data warehouse environments.
Strong expertise in SQL (Oracle, SQL Server, PostgreSQL, or similar), including performance tuning.
Deep understanding of data warehouse concepts (ETL/ELT, OLAP/OLTP, dimensional modeling, star/snowflake schemas).
Hands-on experience in data loading techniques (incremental loads, CDC, batch, streaming).
Strong knowledge of data comparison and reconciliation mechanisms for validating large data sets.
Experience with ETL performance optimization and error handling.
Familiarity with cloud data platforms (AWS Redshift, Snowflake, Azure Synapse, or Google Cloud Platform BigQuery) is a plus.
Strong problem-solving and debugging skills for ETL and data issues.
Ability to work in Agile teams, collaborating with business and technical stakeholders.
Excellent communication skills with the ability to explain technical solutions to non-technical users.
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.