Genius Road

Data Engineer #3351

Genius Road  •  Texas (Remote)  •  3 hours ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

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

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

Genius Road, LLC 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.
Genius Road

About Genius Road

2025 Inc. Magazine’s Best Workplaces!

Genius Road, LLC, is a boutique technical, telecom and executive recruiting firm with a difference.

We’re not resume aggregators, but corporate matchmakers – connecting you with candidates who fit your requirements, your culture and your environment. For permanent positions, we bring you new hires with staying power, culling through our extensive network to identify the perfect all-around fit.

If you have a temporary need for additional technical or telecom expertise, we’ll find the right mix of people who can jump right in and start producing.

Just as important, we make the process easier. Instead of inundating your inbox with random resumes, we create individual profiles of our recommended talent that give you a comprehensive view of the top candidates. So, you’ll see, in a glance, not only what these individuals can do, but who they are as human beings and how they’ll fit in your organization.

Combine all this with a proven track record, an unshakable professionalism and a fierce commitment to customer service, and it’s easy to see what sets us apart.

We call it a smarter approach to recruiting. Our customers say it’s “Pure Genius“

Industry
HR & Recruiting
Company Size
11-50 employees
Headquarters
Dallas, Texas
Year Founded
2010
Social Media