Senior Informatica ETL Developer

Requirements

• 12+ Years Mandatory
• Local candidates only - must currently reside within reasonable commuting distance of a listed location.
• Relocation candidates will NOT be considered.
• Visa: USC, GC, GC EAD, H1B, H4 EAD, L2 EAD.
• Strong hands-on experience with Informatica PowerCenter
• ETL development and Data Warehousing concepts
• Source-to-target mapping and incremental data loads
• Data modeling, Star Schema, and Snowflake Schema
• Fact and Dimension tables
• SCD Types 1, 2, and 3; Late Arriving Dimensions
• Change Data Capture (CDC), including scenarios without timestamp columns
• ETL performance tuning, partitioning, and complex SQL optimization
• Clustered/Non-clustered Indexes and Row Store vs. Column Store concepts
• Snowflake technology experience is not mandatory. We are looking for candidates with strong Data Warehousing and Snowflake Schema knowledge, not Snowflake platform expertise.

Schedule

• Hybrid – 3 Days Onsite per Week

How to apply

• Send your updated resume along with your current location, visa status, and total years of experience.

Location

• 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