OneClick.ai - ETL Developer - Zoho Applications

Job Summary :

We are looking for a skilled ETL Developer to design, build, and optimize data pipelines across SaaS platforms, with a strong focus on the Zoho ecosystem. The ideal candidate will have hands-on experience in ETL processes, data warehousing, and cloud-based data architectures, along with the ability to transform raw data into meaningful business insights.

Key Responsibilities :

- Design, develop, and maintain ETL pipelines across Zoho applications and other SaaS platforms

- Implement Deluge scripts to automate workflows and data transformations within Zoho

- Configure and manage Zoho Analytics for data modeling, cleansing, dashboards, and BI reporting

- Integrate Zoho with external SaaS tools using Zoho Flow, REST APIs, and connectors like Zapier or Make

- Perform data migration, validation, and quality checks to ensure data accuracy and consistency

- Collaborate with product, finance, sales, and operations teams to deliver actionable insights

- Ensure data governance, security, and compliance across systems

- Optimize ETL processes for scalability, performance, and reliability

Required Skills :

- 2+ years of hands on experience as an ETL Developer

- Strong experience within the Zoho ecosystem (CRM, Books, Desk, Projects, Payroll)

- Expertise in Zoho Analytics (data models, KPIs, dashboards, reporting)

- Proficiency in SQL for querying, transformation, and validation

- Experience with APIs (REST, JSON, XML) and SaaS integrations

- Hands-on experience with ETL tools/frameworks such as:

- Informatica, Talend, SSIS

- AWS Glue, Airbyte, dbt

- Custom Python-based pipelines

- Solid understanding of data warehousing concepts and dimensional modeling

- Experience handling large datasets and building incremental or real-time pipelines

- Strong problem-solving and debugging skills

Preferred Skills :

- Experience with cloud platforms (AWS, Azure, or GCP)

- Familiarity with data storage & warehousing tools (AWS S3, Snowflake, BigQuery, Redshift)

- Programming experience in Python or Scala for data transformation

- Exposure to BI tools like Power BI or Tableau (beyond Zoho Analytics)

- Experience with CI/CD pipelines, Airflow, or orchestration tools

- Understanding of SaaS metrics (usage, churn, retention)

- Experience with multi-tenant data models

- Knowledge of data governance, security, and compliance best practices

Required Skill Proficiency :

- SQL 2 Years (Intermediate)

- Power BI 2 Years (Intermediate)

- Tableau 2 Years (Intermediate)

- ETL (Extract, Transform, Load) 2 Years (Intermediate)

- Data Warehousing 2 Years (Intermediate)

- Data Architecture 2 Years (Intermediate)

- AWS 2 Years (Intermediate)

- Azure 2 Years (Beginner)

- GCP 2 Years (Intermediate)

- Zoho Analytics 2 Years (Intermediate)

- API Integration 2 Years (Intermediate)

Ideal Candidate Profile :

- 25 years of experience in ETL and data engineering

- Strong understanding of data pipelines and SaaS integrations

- Ability to work with cross-functional teams and stakeholders

- Detail-oriented with a focus on data quality and reliability

- Self-driven and capable of managing end-to-end data workflows

Education :

- Bachelors degree in Computer Science, Business Administration, Information Systems, or related field

- MBA or equivalent experience is a plus

Interview Process :

- Screening & Shortlisting

- Technical Rounds

- Final Discussion/Offer

Why Join Us :

- Work on modern data platforms and SaaS ecosystems

- Opportunity to build scalable, data-driven solutions

- Exposure to cloud technologies and advanced analytics

- Collaborative and growth-oriented work environment