19 Nov
|
White whale software solutions private
|
Bengaluru
19 Nov
White whale software solutions private
Bengaluru
Job Title: Python & SQL Data Engineer
Experience: 8+ Years
Job Summary
We are seeking an experienced Python & SQL Data Engineer to develop, maintain, and optimize scalable ETL/ELT pipelines supporting finance applications.
The candidate should have solid expertise in Python programming, advanced SQL, Snowflake, data transformation, data modelling, and data-quality frameworks.
Key Responsibilities
- Design, develop, and maintain production ETL/ELT pipelines.
- Write complex and optimized SQL queries for data extraction, transformation, aggregation, and reconciliation.
- Develop Python utilities for data ingestion, transformation, validation, automation, and operational support.
- Build application-ready datasets supporting invoices, payments, collections, customer risk, and finance workflows.
- Work with Snowflake and Oracle ERP data sources.
- Implement full-load, incremental-load, backfill, retry, and late-arriving-data strategies.
- Build data-quality checks for completeness, accuracy, duplicates, referential integrity, and freshness.
- Create source-to-target mappings and maintain data definitions and lineage.
- Troubleshoot pipeline failures and perform root cause analysis.
- Collaborate with backend engineering, finance, QA, and data platform teams.
Required Skills
- 8+ years of experience in ETL/ELT and data engineering.
- Strong Python programming skills.
- Advanced SQL knowledge, including:
- Complex joins.
- Window functions.
- Common Table Expressions (CTEs).
- Incremental processing.
- Query optimization and performance tuning.
- Hands-on experience with Snowflake.
- Experience working with Oracle ERP, Oracle Fusion, or similar enterprise systems.
- Knowledge of data modelling and data-quality frameworks.
- Experience with data reconciliation and pipeline documentation.
- Understanding of REST APIs and backend integration.
- Strong analytical and troubleshooting skills.
Preferred Skills
- Oracle Accounts Receivable (AR) data experience.
- AWS cloud experience.
- Docker, Kubernetes, and Amazon EKS.
- Workflow orchestration tools such as Airflow, Dagster, or Temporal.
- Datadog or similar monitoring tools.
- Familiarity with GitHub Copilot, Claude, Gemini, and other AI-assisted development tools.
- Experience in finance domains such as billing, payments, credit, collections, and revenue.
How to Apply Interested candidates with relevant Python, SQL, and data engineering experience can apply through the link below:
https://forms.gle/YUzQjXQQ8YCu2kid9
Pay: ₹2,500,000.00 - ₹3,500,000.00 per year
Work Location: In person
📌 Python & SQL Data Engineer (Bengaluru)
🏢 White whale software solutions private
📍 Bengaluru