Ascendion
Website:
ascendion.com
Job details:
About the Role"
Data Engineer (ETL/ELT Focus) - PL/SQL Specialist
Location: India (Mumbai preferred; remote/hybrid options for top talent)
Experience Level: 6+ years
Employment Type: Full-time
Urgent Hiring: Immediate joiners preferred
"Job Title"
Data Engineer (ETL/ELT Focus) - PL/SQL Specialist
"Responsibilities"
We are urgently hiring two Data Engineers with strong PL/SQL expertise to build and optimize scalable ETL/ELT pipelines for high-volume data processing. You will design, develop, and maintain data workflows handling subscription data and analytics, ensuring data integrity, performance, and real-time processing. This role demands hands-on experience in transforming complex datasets into actionable insights for business growth.
Key Responsibilities
- Develop and maintain robust ETL/ELT pipelines using PL/SQL, Oracle, and modern tools like Apache Airflow, dbt, or Talend to ingest, transform, and load large-scale data from multiple sources.
- Optimize PL/SQL stored procedures, functions, and packages for subscription management systems, including billing, churn prediction, and customer lifecycle analytics.
- Collaborate with data scientists and analysts to automate data pipelines, implement data quality checks, and ensure scalability for petabyte-scale environments.
- Design and deploy data models (e.g., star schemas) in data warehouses like Snowflake, Redshift, or Oracle, with a focus on ELT paradigms for agile transformations.
- Troubleshoot performance issues, monitor pipeline health, and implement CI/CD practices for data engineering workflows.
- Integrate APIs and streaming data (e.g., Kafka) into ETL processes for real-time subscription updates.
"Required Skills"
Must-Have Qualifications
- Bachelor's/Master's in Computer Science, Engineering, or related field.
- 6+ years of hands-on experience as a Data Engineer, with compulsory expertise in ETL/ELT development (demonstrate 3+ projects).
- Advanced proficiency in PL/SQL (stored procedures, triggers, packages) and Oracle Database; experience migrating to cloud data platforms.
- Strong SQL skills and experience with Python/Scala for scripting ETL jobs.
- Familiarity with data orchestration tools (Airflow, Luigi) and cloud services (AWS/GCP/Azure).
- Based in India; immediate availability a plus.
"Desirable Skills"
Preferred Skills (Strong Advantage)
- 2+ years in subscription management systems (e.g., Zuora, Chargebee) or SaaS billing data pipelines.
- Experience with big data tools like Spark, Hadoop, or Databricks.
- Knowledge of data governance, lineage tools (e.g., Collibra), and containerization (Docker/Kubernetes).
"Education Qualification"
Bachelor's/Master's in Computer Science, Engineering, or related field.
Click on Apply to know more.