| Job description |
Informatica IICS Responsibilities:
- Lead ETL development using Informatica Cloud (IICS), IDMC and PowerCenter.
- Design and implement data integration workflows and processes.
- Utilize IICS components like Application Integration, Data Catalog, Service Connectors, and Process Objects.
- Perform root cause analysis and resolve complex data issues.
- Collaborate with business and technical stakeholders to gather requirements and translate them into technical solutions.
- Migration of legacy Oracle systems to Snowflake in IICS/IDMC
Snowflake Responsibilities:
- Lead the design, development, deployment of Snowflake data warehousing solutions.
- Develop Snowflake data models, stored procedures, views, and ingestion pipelines.
- Optimize Snowflake performance and ensure data security and compliance3.
- Working on Snowflake queries & fixing Snowfalke issues.
General Leadership & Technical Duties:
- Manage small to medium-sized teams and mentor junior developers.
- Drive CI/CD processes and end-to-end development lifecycle.
- Coordinate Defect Traige, UAT sessions and production support activities
- Ensure documentation of implementations and testing procedures
- Customer Handling & Discussions
Required Skills & Experience:
-
Experience: 7–15+ years in ETL and data warehousing, with strong hands-on experience in IICS and Snowflake.
-
Technical Skills: SQL, PL/SQL, Shell Scripting (Unix/Linux), Python.
-
Tools & Platforms: Informatica (IICS, PowerCenter), Snowflake, CI/CD tools,Cloud platforms (AWS, Azure, GCP) 3.
-
Soft Skills: Strong analytical, problem-solving, and communication skills. Ability to work in cross-functional teams and manage stakeholder expectations
|