What are the responsibilities and job description for the Informatica Developer (IDMC) position at STAFFWORXS?
Role: Informatica Developer
Location: Berkeley Heights, NJ or Alpharetta, GA
Duration: 6 months Contract
Rate: $55/hr on W2/ $65/Hr on 1099/C2C
Note: Need 12 years of experienced candidates
Job Summary:
We are looking for an experienced Informatica Developer to support a strategic data migration initiative. The ideal candidate will have a strong background in Informatica IDMC tool and hands-on experience in migrating data from on-premises systems (e.g., Netezza) to cloud-based data warehouses, particularly Snowflake. This role involves redesigning and optimizing existing ETL workflows for Snowflake, ensuring efficient and scalable data movement and transformation.
Key Responsibilities:
- Analyze existing Informatica PowerCenter workflows currently loading data into Netezza.
- Design, develop, and migrate ETL processes to load data into Snowflake using Informatica.
- Optimize data pipelines for performance, scalability, and maintainability in a cloud environment.
- Implement best practices for cloud data warehousing and ETL performance tuning.
- Conduct unit and integration testing, and assist with user acceptance testing (UAT).
Required Skills:
- Strong experience with Informatica IDMC (development, troubleshooting). - Must
- Experience in migrating ETL processes to Snowflake - Good to have
- Deep understanding of Snowflake architecture, data loading techniques, and performance optimization. - Good to have
- Proficiency with SQL, especially in Netezza and Snowflake environments. - Good to Have
- Experience with cloud platforms (preferably AWS/Azure/GCP) and cloud data migration tools. - Should
- Familiarity with scheduling tools (e.g., Autosys, Control-M) and version control systems (e.g., Git). - Good to have
Salary : $2 - $65
