Associate Senior Software Engineer - Python/Snowflake

Role Overview :

We are seeking a seasoned Engineer to design, build, and optimize our data ecosystem. You will be responsible for migrating and managing complex data pipelines transitioning from legacy Oracle environments to Snowflake, using Python as your primary engine for automation and transformation. The ideal candidate is a strategic thinker who ensures data integrity at scale while staying ahead of the curve with emerging AI/ML integration.

Key Responsibilities :

- Legacy Integration : Maintain and optimize existing Oracle databases while leading strategic data migration efforts to the cloud.

- Automation : Utilize Python to automate repetitive data tasks, build custom API integrations, and manage workflow orchestration.

- Performance Tuning : Conduct advanced SQL optimization and performance tuning within Snowflake and Oracle to ensure low-latency data availability.

- Collaboration : Work closely with Data Science and Analytics teams to provide clean, structured, and performant datasets for business intelligence.

- AI Readiness : Explore and implement AI-driven data processing, such as LLM-based data cleaning or predictive pipeline monitoring.

Technical Requirements (Must-Have) :

- Python : Expert-level proficiency for data manipulation (Pandas, PySpark) and scripting.

- Snowflake : Proven experience with Snowflake architecture (Snowpipe, Tasks, Streams, and Zero-copy cloning).

- Oracle : Strong background in Oracle RDBMS, PL/SQL development, and performance tuning.

- SQL : Mastery of complex SQL queries and window functions.

- Data Modeling : Deep understanding of Star/Snowflake schemas.

Preferred Skills (Nice-to-Have) :

- AI/ML Integration : Familiarity with integrating AI models into data workflows or using Snowflakes AI features (Cortex, Document AI).

- Orchestration : Experience with Airflow, Dagster, or Prefect.

- CI/CD : Knowledge of Git and automated deployment pipelines for data (dbt experience is a plus).

- Understanding of Pre-paid card domain or any Payment domain.

- We are seeking candidates with 5-9 years of experience only.

(ref:hirist.tech)