Snowflake Engineer Job at Openkyber, Atlanta, GA

WVlGWlVJbExiamNYUHliYm45b1BEMklTY3c9PQ==
  • Openkyber
  • Atlanta, GA

Job Description

Data Engineer (Informatica / Snowflake) Employment Type: Contract (12+ months) Location: Texas (Telework) MUST RESIDE IN TEXAS

We are seeking a Data Engineer with strong hands-on experience with Informatica Cloud (IICS), Oracle, and Snowflake to support the development of enterprise data integration and data pipeline solutions. This role will focus on building and maintaining data ingestion pipelines from Oracle transactional databases into Snowflake, developing ETL/ELT workflows, supporting data warehouse modeling, and implementing bulk data movement and Change Data Capture (CDC) processes.

Qualifications/Requirements

  • 4+ years of hands-on experience with Informatica Cloud Data Integration (IICS)
  • 5+ years of experience developing advanced SQL queries and performing data interrogation
  • Experience translating business requirements and design specifications into data mappings and data pipeline solutions
  • Experience with relational database design and Oracle RDBMS
  • Experience with Snowflake, including database creation, management, optimization, and Snowflake SQL
  • 2+ years of experience with Informatica Mass Ingestion
  • 3+ years of experience with static mapping and Change Data Capture (CDC) for bulk data movement
  • 3+ years of experience with data warehouse architecture and dimensional modeling, including Facts and Dimensions
  • Experience developing ETL/ELT mappings and workflows using Informatica Cloud
  • Experience working with Oracle as a data source and Snowflake as a target platform
  • Experience with data pipeline development, troubleshooting, and production deployments
  • Familiarity with GitHub or equivalent version control systems
  • Ability to create technical documentation, data-flow diagrams, and ERDs
  • Experience working with state agencies and applicable security protocols and processes
  • Experience with Snowpark and Python is preferred
  • Experience with Snowflake Data Sharing is preferred
  • Experience developing RESTful API-based data integrations is preferred
  • Knowledge of Informatica Pushdown Optimization is preferred
  • Experience supporting Data Scientist or analytical workloads within Snowflake is preferred

Responsibilities

  • Develop and maintain data integration pipelines using Informatica Cloud Data Integration
  • Build mass ingestion pipelines to move data from Oracle transactional databases into Snowflake
  • Develop source-to-target mappings, ETL/ELT workflows, and data integration processes
  • Implement one-time data loads and Change Data Capture processes for bulk data movement
  • Design and develop Snowflake databases and data warehouse structures
  • Develop dimensional data models to support reporting, analytics, and performance requirements
  • Support API-based data ingestion and Snowflake Data Sharing initiatives
  • Analyze business and technical requirements and translate them into effective data solutions
  • Troubleshoot data pipeline issues and assist with performance optimization
  • Review development work, provide technical feedback, and support delivery deadlines
  • Promote code and data integration solutions through development and production environments
  • Create and maintain technical documentation, data-flow diagrams, and ERDs
  • Work collaboratively with technical teams and stakeholders to support ongoing data integration initiatives

OpenKyber is proud to be a Certified Women's Business Enterprise, an Equal Opportunity Employer, and values diversity. All employment decisions are made on the basis of qualifications, merit, and business need.

For applications and inquiries, contact:hirings@openkyber.com

Job Tags

Contract work, Remote work

Similar Jobs

SimIS Inc.

Microsoft 365 & Power Platform Developer/Administrator (N2701) Job at SimIS Inc.

 ...test, deploy, document, administer, troubleshoot, and improve SharePoint and Power Platform solutions in direct collaboration with operational users. SimIS seeks a Microsoft 365 & Power Platform Developer/Administrator to provide hands-on Microsoft 365, SharePoint, and... 

Never Ending Travels

Remote Travel Coordinator-part time Job at Never Ending Travels

 ...passionate people to help us guide customers to achieve their travel package goals. A successful candidate will understand the needs...  ...As needed, assisting with distributing information to and coordinating internal and/ or team needs Updating daily activity, reporting... 

Bright Vision Technologies

Golang Developer Job at Bright Vision Technologies

 ...Golang Developer - Remote Bright Vision Technologies is a technology consulting and software development company delivering cloud, AI, data, and enterprise solutions across the United States. This is a fantastic opportunity to join an established and well-respected... 

Drw

Trader Job at Drw

 ...how we do it. DRW is a place of high expectations, integrity, innovation and a willingness to challenge consensus. As a Junior Trader , you will have an opportunity to combine the disciplines of risk management, research and technology to operate trading... 

On The Border - Rapid City

Host/Hostess Job at On The Border - Rapid City

 ...Description We count on our Host / Hostess / Greeter for a number of duties. The Host / Hostess / Greeter is responsible for cheerfully greeting the guests, escorting them to their table, providing them with a menu, and answering any preliminary questions. Restaurant...