Senior Informatica ETL & Snowflake Data Engineer
Kasmo Inc
Tega Cay, SC, United States
1 day ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.careerbuilder.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
4 years minimum
Working hours
Regular working hours
Job source
Tech stack
Application Programming Interfaces (APIs)
Amazon Web Services
Amazon Elastic Compute Cloud
Amazon S3
Data Analysis
User Authentication
Big Data
Cloud Computing
Cloud Database
Databases
Information Engineering
Data Integration
+30 more
Extract Transform Load (ETL)
Data Migration
Database Storage Structures
JSON
Python (Programming Language)
OAuth
Object-Oriented Software Development
Oracle (Applications)
Performance Tuning
Query Optimization
Standard Sql
JSON Web Token
PL-SQL
SQL Databases
Systems Integration
Extensible Markup Language (XML)
Parquet
Scripting
Data Ingestion
Informatica Powercenter
Snowflake
Informatica Cloud
Star Schema
Enterprise Integration
Data Management
Restful APIs
Data Pipelines
Api Management
Serverless Computing
Mulesoft
Job description
- Design, develop, and optimize scalable ETL/ELT data pipelines.
- Migrate and integrate enterprise data from Oracle to Snowflake.
- Build automated API ingestion frameworks using Python and AWS services.
- Develop high-performance Snowflake data models and optimize warehouse performance.
- Collaborate with business and technical teams to deliver reliable cloud-based data solutions., * Strong understanding of Snowflake architecture and best practices.
- Experience with Dynamic Tables, Tasks, Streams, and Snowflake Warehouses.
- Advanced SQL development and query optimization.
- Performance tuning, troubleshooting, and warehouse optimization.
- Designing scalable Snowflake data models.
Oracle
- Strong SQL and PL/SQL development experience.
- Experience migrating data from Oracle to Snowflake.
- Knowledge of Oracle performance tuning, backup, and optimization.
Python
- Develop Python scripts for cloud-based data processing.
- Build reusable, modular, and object-oriented code.
- Automate API integrations and data ingestion workflows.
- Experience with AWS Lambda for serverless processing.
API Integration
- Build ETL/ELT pipelines using REST APIs.
- Process JSON/XML payloads into structured datasets (CSV, Parquet, Database tables).
- Secure authentication using OAuth2, JWT, and API Keys.
AWS
- Hands-on experience with S3, EC2, DMS, and related AWS services.
- Build and orchestrate cloud-based data pipelines.
- Experience with serverless data integration solutions.
Data Analysis & Modeling
- Analyze large datasets using SQL and Python.
- Strong understanding of ER Models, Star Schema, and Snowflake Schema.
- Design scalable, maintainable enterprise data models.
Requirements
Database Extract Transform and Load (ETL), Informatica, Snowflake Schema, Database Extract Transform and Load (ETL), Application Programming Interface (API), Python Programming/Scripting Language, Informatica, Amazon Web Services (AWS), Cloud Computing, Data Management, * 8+ years of Data Engineering/ETL experience.
- Recent 4+ years of hands-on experience with Python, APIs, AWS, Snowflake, and Informatica Cloud Services (IICS/ICS)., * MuleSoft
- API-led integrations between Snowflake, Oracle, and AWS.
- Experience building enterprise integration workflows using MuleSoft APIs.
Must-Have Skills
- Snowflake
- Informatica IICS / ICS
- Oracle
- Python
- AWS (S3, EC2, DMS, Lambda)
- REST APIs
- SQL / PL-SQL
- ETL / ELT
- Data Modeling
- Performance Tuning
Priority: Candidates must have recent hands-on experience (4+ years) with Python, AWS, Snowflake, APIs, and Informatica IICS/ICS in their latest projects.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.careerbuilder.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦