Senior Informatica ETL & Snowflake Data Engineer

HRize LLC is seeking a Senior Informatica ETL & Snowflake Data Engineer. The role involves designing and optimizing data workflows using Snowflake and Informatica, along with leveraging AWS services for data management and analysis.

Responsibilities:

• Understanding of Snowflake architecture
• Experience in Dynamic Tables, Tasks, Streams
• Advanced proficiency in writing SQL queries for Snowflake
• Experience in performance tuning and troubleshooting on Snowflake
• Experience in creating and optimizing Snowflake data warehouses
• Strong experience with Oracle databases, including SQL and PL/SQL
• Experience with migrating data from Oracle to Snowflake
• Familiarity with Oracle’s performance optimization and backup strategies
• Ability to create Python scripts to work with AWS services for data workflows
• Solid understanding of core data structures (lists, dictionaries, sets) and object-oriented programming principles
• Writing clean, modular, reusable code
• Build scripts to automate API pulls
• Familiarity with AWS Lambda, Functions for serverless API integrations
• Pull data from APIs into data pipelines (ETL/ELT)
• Transform API responses (JSON/XML) into structured formats (CSV, Parquet, database tables)
• Handle API keys, OAuth2, JWT tokens securely
• Hands-on experience with AWS cloud infrastructure (e.g., S3, EC2, DMS)
• Knowledge of data pipeline orchestration using AWS services
• Ability to analyze and derive insights from large datasets using SQL and Python
• Strong problem-solving skills, with experience in identifying trends and patterns
• Strong understanding of data modeling concepts (ER, star/snowflake schemas)
• Experience in building scalable, maintainable data models in Snowflake
• Experience in building ETL workflows with Informatica/IICS and integrating them with Snowflake
• Experience with API-based integrations using MuleSoft

Requirements:

• Understanding of Snowflake architecture
• Experience in Dynamic Tables, Tasks, Streams
• Advanced proficiency in writing SQL queries for Snowflake
• Experience in performance tuning and troubleshooting on Snowflake
• Experience in creating and optimizing Snowflake data warehouses
• Strong experience with Oracle databases, including SQL and PL/SQL
• Experience with migrating data from Oracle to Snowflake
• Familiarity with Oracle's performance optimization and backup strategies
• Ability to create Python scripts to work with AWS services for data workflows
• Solid understanding of core data structures (lists, dictionaries, sets) and object-oriented programming principles
• Writing clean, modular, reusable code
• Build scripts to automate API pulls
• Familiarity with AWS Lambda, Functions for serverless API integrations
• Pull data from APIs into data pipelines (ETL/ELT)
• Transform API responses (JSON/XML) into structured formats (CSV, Parquet, database tables)
• Handle API keys, OAuth2, JWT tokens securely
• Hands-on experience with AWS cloud infrastructure (e.g., S3, EC2, DMS)
• Knowledge of data pipeline orchestration using AWS services
• Ability to analyze and derive insights from large datasets using SQL and Python
• Strong problem-solving skills, with experience in identifying trends and patterns
• Strong understanding of data modeling concepts (ER, star/snowflake schemas)
• Experience in building scalable, maintainable data models in Snowflake
• Experience in building ETL workflows with Informatica/IICS and integrating them with Snowflake
• Experience with API-based integrations using MuleSoft