Minimum Requirements:
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.
YearsRequired/PreferredExperience
6+RequiredExperience with Informatica Products, including at least 4 years of direct experience with Informatica Cloud Data Integration (IICS).
5+RequiredGenerating advanced SQL queries and utilizing data interrogation methods.
5+RequiredReviewing, interpreting, and translating business requirements and design specifications into data mappings and pipeline development.
4+RequiredExperience in relational database design concepts, with direct experience in Oracle RDBMS.
3+RequiredExperience with Data Warehouse architectural patterns, including modeling Facts and Dimensions.
3+RequiredExperience with static mapping and Change Data Capture (CDC) for bulk data movement.
2+RequiredPractical experience with Informatica Mass Ingestion.
2+RequiredHands-on experience using Snowflake (creating, managing, optimizing databases, time-travel, and cloud data warehousing features).
-PreferredExperience working with Snowpark, servicing Python programmers, or understanding Data Scientists' requirements against Snowflake databases.
-PreferredFamiliarity with Snowflake data sharing.
-PreferredPrior experience working within state agencies, adhering to strict security protocols and processes.
-PreferredFamiliarity with GitHub or equivalent version control workflows.