Quick overview
Job description
Senior Informatica ETL Developer with strong Data Warehouse experience
Hybrid role, 3 days in a week onsite
Job Locations: Alpharetta, GA; Charlotte, NC; Chicago, IL; Conshohocken, PA; Dallas, TX; Denver, CO; Fargo, ND; Garden City, NY; Houston, TX; Lenexa, KS; Lubbock, TX; Morristown, NJ; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS.
Notes:
We are preferring ETL - Source to target mapping, incremental push (or incremental load), informatica PowerCenter.
We are not looking for snowflake Technology; we are looking for data modelling concept snowflake/star schema.
Snowflake data experience is ok but not mandatory.
Job Summary:
We are looking for a Senior Informatica ETL Developer with strong experience in Data Warehousing concepts and ETL development. The candidate should have hands-on expertise in designing, developing, and optimizing ETL pipelines using Informatica PowerCenter / Informatica Intelligent Cloud Services, along with deep understanding of data models, CDC, SCD, and performance tuning.
Key Responsibilities/ Experience Required:
•Design and develop ETL pipelines to load data into Data Warehouse
•Work with multiple source systems (RDBMS, flat files, APIs) and integrate data into staging and DWH layers
•Build and maintain Fact and Dimension tables based on business requirements
•Implement Slowly Changing Dimensions (SCD Type 1, 2, 3) in ETL processes
•Handle Late Arriving Dimensions using industry best practices
•Implement Change Data Capture (CDC) mechanisms, including scenarios without timestamp columns
•Optimize long-running ETL sessions and improve performance using partitioning and tuning techniques
•Debug and optimize complex SQL queries and ETL workflows
•Work with clustered and non-clustered indexes, and understand row store vs column store
•Collaborate with business and analytics teams for data validation and reporting needs
Similar jobs
- SN

Need Sr. NET DeveloperRecently posted
SnapCode Inc · New York, NY · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLC#.NET+1TechnologySalary not listed - RS
Sr AI Full Stack Engineer/ ArchitectRecently posted
R Systems, Inc. · United States · Hybrid · Posted 17 Nov 2026 🇺🇸
FastAPILLMPython+6TechnologySalary not listed - LI

Senior Kofax DeveloperRecently posted
LiveMindz · Charlotte, NC · On-site · Posted 17 Nov 2026 🇺🇸
Stakeholder ManagementOracleSQL+7TechnologySalary not listed - CY
Java Developer – OpenAPI, OAuth 2.0, JSON & JSFRecently posted
CYBRTY INC · Albany, NY · On-site · Posted 17 Nov 2026 🇺🇸
OraclePL/SQLSQL+5Technology$60/hr - B&

Senior PowerBuilder DeveloperRecently posted
Bits & Bytes Technology Solutions · Albany, NY · Hybrid · Posted 17 Nov 2026 🇺🇸
PL/SQLSQLTechnologySalary not listed - AG

Python Developer - CloudRecently posted
ASCII Group LLC · Austin, TX · On-site · Posted 17 Nov 2026 🇺🇸
AWSGoogle CloudPython+2TechnologySalary not listed - CS
Forward Deployed Engineer (Java Full Stack Developer)Recently posted
Compest Solutions Inc · Minneapolis, MN · On-site · Posted 17 Nov 2026 🇺🇸
Stakeholder ManagementMicroservicesGit+14TechnologySalary not listed - PD
Senior Python Developer Machine LearningRecently posted
Purple Drive Technologies LLC · Addison, TX · Hybrid · Posted 17 Nov 2026 🇺🇸
ScrumDeep LearningPython+3TechnologySalary not listed - CE
Full Stack Data Engineer (NORTHCOM) with Security ClearanceRecently posted
CELESTAR CORPORATION · Colorado Springs, CO · On-site · Posted 17 Nov 2026 🇺🇸
DatabricksGraphQLUnity+4Technology$140k - $143.5k/yr - BA

Full Stack Software Engineer with Security ClearanceRecently posted
Booz Allen Hamilton · Tinton Falls, NJ · On-site · Posted 17 Nov 2026 🇺🇸
JavaPythonAgile+2Technology$69.4k - $158k/yr - TS

Full Stack Software Engineer with Security ClearanceRecently posted
The Swift Group · Herndon, VA · On-site · Posted 17 Nov 2026 🇺🇸
DockerNext.jsSQL+19Technology$5k/mo - ES
Embedded C++ DeveloperRecently posted
ENIN SYSTEMS INC · San Diego, CA · Hybrid · Posted 16 Nov 2026 🇺🇸
SVNGitEmbedded Systems+8TechnologySalary not listed
