IICS + Snowflake Developer

8+ years of overall development experience, with at least 5+ years specifically in IICS and Snowflakes.

•            Implement scalable and efficient data storage solutions using Snowflake.
•              Strong experience with Informatica IICS, including tasks, mappings, and workflows.
•              Develop and manage IICS integrations to connect Snowflake with other enterprise systems.
•              Create and optimize Snowflake SQL queries, stored procedures, and user-defined functions (UDFs).
•              Proficiency in Informatica IICS for building and managing data pipelines.
•              Familiarity with cloud platforms (AWS, Azure, or GCP) and services like S3.
•              Manage IICS tasks, schedules, and job monitoring.
•              Ensure data quality and integrity throughout the integration process.
•              Knowledge in migrating on-premise Oracle PLSQL and Informatica PowerCenter workflows to IICS.
•              Proficiency in using IICS advanced transformations such as Aggregator, Lookup, Joiner, and Expression transformations.
•              Ensure data integrity, consistency, and security throughout the data pipeline.
•              Build ETL/ELT processes to ingest, transform, and load data from various sources into Snowflake.
•              Optimize data pipelines for performance, scalability, and reliability.
•              Proven track record of data migration and optimization within Snowflake
•              Integrate Snowflake with various data sources and third-party tools.
•              Familiarity with BI tools integration
•              Ensure data security and compliance with industry standards.
•              Collaborate with cross-functional teams to meet data-driven business objectives.
•              Proficient in SQL and familiar with ETL processes
•              Write complex SQL queries to perform data transformations and aggregations.
•              Experience with data modeling and cloud computing environments
•              Hands-on experience with Snowflake features like Time Travel and Zero-Copy Cloning
•              Understanding of data compliance and security best practices
•              Ability to work independently, prioritize tasks, and meet deadlines in a fast-paced environment.