What are the responsibilities and job description for the Looking for ETL Informatica _Only locals required No Relocation Charlotte, NC (Day 1 Hybrid 3 days office in a week) position at Vrddhi Solutions LLC?
Role: ETL Informatica
Location: Charlotte, NC (Day 1 Hybrid – 3 days office in a week)
Only locals required – No Relocation
Need to Share live location at the time of submission
If the consultants are on or they need to show their passport copy during the video call.
Job Description
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:
- 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
- Handle Late Arriving Dimensions using industry best practices
- Optimize long-running ETL sessions and improve performance using partitioning and tuning techniques
- Knowledge of data warehousing concepts, ETL best practices, and dimensional data modeling (Star/Snowflake schemas).
- Experience working with cloud platforms such as AWS, Azure, or Google Cloud Platform is an added advantage.
- Familiarity with source control tools such as Git and deployment methodologies.
- 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