ETL Engineer – Finance Applications Snowflake + Oracle Fusion +AWS (Bengaluru)

ETL Engineer – Finance Applications Snowflake + Oracle Fusion +AWS (Bengaluru)

19 Nov
|
Helios Systems Asia
|
Bengaluru

19 Nov

Helios Systems Asia

Bengaluru

Summary

We are seeking an experienced ETL Engineer to design, build, and maintain scalable data pipelines supporting critical finance operations, including invoicing, payments, collections, and customer risk workflows. Working across Snowflake, Oracle ERP, and containerized cloud environments (AWS/Amazon EKS), you will develop high-performance SQL and Python solutions to deliver reliable, reconciled, and application-ready datasets. The ideal candidate has 8+ years of data engineering experience, deep expertise in data modeling and quality controls, and a strong track record of collaborating across engineering and finance teams to ensure pipeline reliability and audit readiness.

ETL Engineer – Finance Applications

Snowflake + Oracle Fusion +AWS

Responsibilities

● Design, develop, and maintain ETL/ELT pipelines that deliver finance application data from Snowflake and selected Oracle ERP objects.

● Write complex and performant SQL for data extraction, transformation, reconciliation, aggregation, and application-ready datasets.

● Build and maintain Snowflake tables, views, transformations, and data models supporting customer risk, payments, invoices, product usage, cases, and collections workflows.

● Develop Python utilities for ingestion, transformation, validation, automation, and operational support.

● Create source-to-target mappings and document data definitions, keys, dependencies, lineage, ownership, and refresh schedules.

● Implement full-load, incremental-load, backfill, retry, and late-arriving-data processing strategies.

● Build data-quality checks for completeness, accuracy, duplicates, referential integrity, row counts, reconciliation, and freshness.





● Integrate with application services through well-defined data contracts and reliable data-access patterns.

● Deploy and operate containerized ETL workloads on Amazon EKS using Docker, Kubernetes, CI/CD pipelines, scheduling, and setting configuration.

● Implement pipeline monitoring, logging, alerting, failure recovery, audit reporting, and operational runbooks.

● Use code-generation and AI-assisted development tools such as GitHub Copilot, Claude, Gemini, and other LLM-based tools while maintaining SQL, Python, and pipeline quality.

● Troubleshoot data discrepancies and pipeline failures, perform root cause analysis, and support production incidents.

● Collaborate with backend engineering, Oracle ERP, Snowflake, cloud platform, security, QA, finance systems, and business teams.

Basic Skills

● 8+ years of experience in building and supporting production ETL, ELT, or data-integration pipelines.

● Advanced SQL skills, including complex joins, window functions, common table expressions, incremental processing, and performance tuning.

● Hands-on proficiency with Snowflake, including schemas, tables, views, roles, warehouses, loading, query optimization, and access controls.

● Strong Python skills for data ingestion, transformation, validation,



automation, and operational tooling.

● Experience working with Oracle ERP, Oracle Fusion Cloud, or comparable enterprise source systems.

● Experience with data modeling, source-to-target mapping, data lineage, data-quality frameworks, and pipeline documentation.

● Understanding of REST APIs, service accounts, application data consumption, and backend integration requirements.

● Experience with Docker, Kubernetes, AWS, Amazon EKS, and CI/CD pipelines.

● Excellent troubleshooting, analytical, communication, and collaboration skills.

● Experience working in Agile environments using tools such as Jira and Confluence.

Preferred Qualifications

● Experience with Oracle Accounts Receivable data, including customer accounts, invoices, payment schedules, receipts, applications, collectors, and transaction types.

● Experience with Snowflake ODS, curated, or certified data layers.

● Experience with workflow orchestration tools such as Temporal, Airflow, Dagster, or comparable platforms.

● Experience with AWS services such as S3, IAM, ECR, Secrets Manager, queues, and private networking.

● Experience creating audit extracts, data-load reports, operational dashboards, or evidence for finance controls and SOX-sensitive processes.

● Experience with Datadog or comparable monitoring and observability platforms.

● Working experience with code-generation tools such as GitHub Copilot, Claude, Gemini, and other AI and LLM-based development tools.

● Experience supporting risk, credit, collections, billing, revenue, or other finance data domains

📌 ETL Engineer – Finance Applications Snowflake + Oracle Fusion +AWS (Bengaluru)
🏢 Helios Systems Asia
📍 Bengaluru

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: etl engineer – finance applications snowflake + oracle fusion +aws (bengaluru) / bengaluru

Subscribe to this job alert:

Get the latest job offers by email for: etl engineer – finance applications snowflake + oracle fusion +aws (bengaluru) / bengaluru