Informatica Cloud Developer (remote)

Vitaver & Associates • Austin, TX

1d • Remote

About The Position

Our client is filling this contract position exclusively through approved staffing partners, so this opportunity is not available by applying directly with the client. If you're interested, we'd be happy to represent you throughout the hiring process. This is a temporary project estimated to last 12+ months with possible extensions. The primary work location will be remote (Work from Home).

Requirements

• Experience with generating advanced SQL queries and using other data interrogation methods (5+ years)
• Experience with Informatica Products (6+ years)
• Experience with Informatica Cloud Data Integration. (4+ years)
• Experience in reviewing, interpreting, and translation business requirements and design specifications into data mappings, and data pipeline development using all major data integration patterns. (5+ years)
• Experience in relational database design concepts which include direct experience in Oracle RDBMS. (4+ years)
• Experience with Data Warehouse architectural patterns including modeling Facts and Dimensions. (3+ years)
• Experience with static mapping and Change Data Capture (CDC) for bulk data movement. (3+ years)
• Experience with Informatica Mass Ingestion. (2+ years)
• Experience using Snowflake (creating, managing, optimizing databases as well as time-travel and other technical advantages of cloud data warehousing). (2+ years)

Nice To Haves

• Experience working with Snowpark, servicing the needs of Python programmers, or understanding Data Scientists' requirements against Snowflake databases (1+ year)

Responsibilities

• Design, develop, and deploy robust data pipelines using Informatica Cloud Data Integration (IICS) and Informatica Mass Ingestion to support enterprise-scale data movement and transformation
• Translate complex business requirements and design specifications into detailed data mappings, utilizing static mapping and Change Data Capture (CDC) for efficient bulk data processing
• Create, manage, and optimize Snowflake cloud data warehouse environments, leveraging advanced features such as Time Travel to maximize data availability and recovery
• Write advanced SQL queries and perform complex data interrogation, applying strong relational database design principles within Oracle RDBMS environments
• Implement Data Warehouse architectural patterns, including the design and modeling of Fact and Dimension tables, to ensure scalable and performant analytical data structures
• Collaborate with data scientists and Python developers to provision and optimize Snowflake databases, utilizing Snowpark to support advanced analytics and machine learning workloads
• Apply all major data integration patterns and best practices across the Informatica product suite to ensure reliable, high-volume data synchronization and system interoperability

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed