Recent 4+ years of hands-on experience with Python, APIs, AWS, Snowflake, and Informatica Cloud Services (IICS/ICS).
Key Responsibilities
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.
Required Technical Skills
Snowflake
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.
ETL Tools (Required)
Informatica Intelligent Cloud Services (IICS/ICS)
Design and develop ETL workflows integrating Oracle, Snowflake, and AWS.
Nice to Have
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.
Numbers & Facts
Location
Fort Mill, SC (Remote)
Skills
AWS Lambdaunmatched
Amazon Elastic Compute Cloud (EC2)unmatched
Amazon Simple Storage Service (S3)unmatched
Amazon Web Services (AWS)unmatched
Analysis Skillsunmatched
Application Programming Interface (API)unmatched
Authenticationunmatched
Best Practicesunmatched
Cloud Computingunmatched
Data Managementunmatched
Data Migrationunmatched
Data Modelingunmatched
Data Processingunmatched
Data Setsunmatched
Database Extract Transform and Load (ETL)unmatched
Database Technologyunmatched
Enterprise Data Integrationunmatched
Entity Relational (ER) Modelingunmatched
Identify Issuesunmatched
Informaticaunmatched
JSONunmatched
OAuthunmatched
Object Oriented (OO)unmatched
Oracleunmatched
Oracle PL-SQLunmatched
Performance Modelingunmatched
Performance Tuning/Optimizationunmatched
Python Programming/Scripting Languageunmatched
Query Optimizationunmatched
REST (Representational State Transfer)unmatched
SQL (Structured Query Language)unmatched
Scalable System Developmentunmatched
Scripting (Scripting Languages)unmatched
Snowflake Schemaunmatched
Star Schemaunmatched
Technical Deliveryunmatched
Warehousingunmatched
Wheel/Front-End Loaderunmatched
XML (EXtensible Markup Language)unmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.