Job Description
About the Role
n

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

nThe 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.
n

nKey Responsibilities
n

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



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

n

nRequired Skills
n

nInformatica
n

n
- n
- Robust hands-on experience with Informatica ETL

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