Role: Senior Informatica ETL Developer

[Naveen Kotennavar]

Hi Team,

We have an exciting opportunity for a Senior Informatica ETL Developer with one of our direct clients for a long-term hybrid engagement across multiple locations.

Position Details:

Role: Senior Informatica ETL Developer

Work Model: Hybrid (3 Days Onsite per Week)

Experience Required: 14+ Years

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

Note: Local Candidates Only

Mandatory Skills:

• Informatica IICS (Informatica Intelligent Cloud Services)
• Snowflake Data Warehouse
• Star Schema Data Modeling
• Fact & Dimension Table Design
• Microsoft Azure Cloud
• ETL Development & Data Integration

Required Skills:

• Strong experience with Informatica PowerCenter and/or IICS
• ETL Development and Source-to-Target Mapping
• CDC (Change Data Capture) and Incremental Load Implementation
• Strong Data Warehousing Concepts
• Snowflake / Star Schema Data Modeling
• Fact & Dimension Table Design
• SCD Type 1, Type 2, and Type 3 Implementation
• Experience handling Late Arriving Dimensions
• SQL Query Optimization and Performance Tuning
• Snowflake Data Experience
• Azure Cloud Experience
• Property & Casualty (P&C) Insurance Domain Experience

Key Responsibilities:

• Design, develop, and support ETL solutions using Informatica PowerCenter/IICS.
• Build scalable and high-performance data integration solutions.
• Develop and maintain Snowflake-based data warehouse solutions.
• Design and implement Star Schema models, Fact and Dimension tables.
• Implement CDC processes, SCD logic, and incremental data loads.
• Optimize ETL workflows and SQL queries for performance and scalability.
• Collaborate with business and technical teams to gather requirements and deliver robust data solutions.
• Support Azure-based cloud data initiatives and integrations.

If you have suitable consultants available, please share their updated resumes along with the following details:

• Full Name
• Current Location
• Work Authorization/Visa Status
• Contact Number
• Email Address

Looking forward to your prompt response.

Thanks & Regards,
Naveen SK
US IT Recruiter
X-Axis Solutions Inc.
(434) 287-8302
nav...@xaxis.solutions