About the Role

We are looking for an experienced Data Engineer / Data Management Specialist with robust hands-on expertise in Informatica, Snowflake, Informatica Data Catalog (IDC), SQL, and Data Modelling.

The ideal candidate will be responsible for building and maintaining scalable data pipelines, developing data models, managing metadata and data lineage, and supporting enterprise data governance and analytics initiatives.

Key Responsibilities

Design, develop, and maintain ETL/ELT pipelines using Informatica.
Work extensively with Snowflake for data ingestion, transformation, storage, and warehousing.
Develop conceptual, logical, and physical data models.
Use Informatica Data Catalog (IDC) for data profiling, metadata management, data discovery, and lineage analysis.
Configure metadata harvesting and connectivity across enterprise data sources.
Build data integration workflows across databases, cloud platforms, applications, and enterprise systems.
Develop optimized SQL queries, views, stored procedures, and Snowflake transformation logic.
Design scalable dimensional models,



including fact and dimension tables, star and snowflake schemas.
Support data quality, governance, lineage, classification, and metadata management initiatives.
Analyze existing data structures and recommend improvements to data models and integration architecture.
Troubleshoot ETL/data pipeline issues, performance bottlenecks, and data quality problems.
Collaborate with Data Architects, Data Analysts, Business Analysts, and application teams to understand and translate data requirements.
Prepare technical documentation for data flows, mappings, data models, and integration processes.
Follow best practices around data security, access management, performance, governance, and maintainability.

Required Skills

Informatica

Strong hands-on experience with Informatica ETL/Data Integration.
Experience developing mappings, workflows, transformations, and reusable components.
Strong understandi

📌 Data Engineer/Data Management Specialist (India)
🏢 Proso.ai
📍 India