About the Role We are seeking an experienced and driven Data Engineer with deep expertise in Informatica PowerCenter / IICS and Snowflake to join our growing data engineering team. You will be responsible for designing, building, and optimizing data pipelines, integration workflows, and cloud data solutions that power critical business insights across the organization. Key Responsibilities Data Integration & ETL Development ⢠Design, develop, and maintain ETL/ELT pipelines using Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS). ⢠Build robust data ingestion workflows from on-premise and cloud-based source systems (ERP, CRM, flat files, APIs, databases). ⢠Implement incremental and full-load strategies, CDC (Change Data Capture), and data replication patterns. ⢠Debug, tune, and optimize existing Informatica mappings, sessions, and workflows for performance and reliability. Snowflake Data Warehousing ⢠Architect and develop scalable data models in Snowflake including staging, dimensional, and analytics layers.



⢠Write advanced SQL for complex transformations, stored procedures, energetic tables, tasks, and streams in Snowflake. ⢠Leverage Snowflake-native features: Time Travel, Data Sharing, Zero-Copy Cloning, Clustering, and Materialized Views. ⢠Monitor and optimize query performance using Snowflake's Query Profile, result caching, and virtual warehouse sizing. ⢠Manage Snowflake environments (Dev, UAT, Prod) including role-based access control (RBAC) and data security policies. Data Modeling & Architecture ⢠Design conceptual, logical, and physical data models following Kimball, Inmon, or Data Vault methodologies. ⢠Collaborate with data architects to define standards for schema design, naming conventions, and documentation. ⢠Build and maintain metadata, data lineage, and cataloging assets using Informatica Axon or similar tools. Collaboration & Delivery ⢠Work closely with business analysts, data scientists, and BI teams to un

📌 Data Engineer (Bengaluru)
🏢 Royal Cyber
📍 Bengaluru