ETL Developer

Job Description About Us Zycus, recognized by leading analyst firms in procurement technology, empowers teams to unlock deep value through its comprehensive Source-to-Pay (S2P) solutions. At the heart of our S2P solution is the Merlin Agentic Platform, which orchestrates intelligent AI agents to deliver simplified, efficient, and compliant processes. The Merlin Intake Agent Offers Business Users Unparalleled Ease Of Use, Increasing Adoption Rates And Significantly Reducing Non-compliant Spending. For Procurement Teams, The Merlin Autonomous Negotiation Agent Handles Tail Spend Autonomously, Securing Additional Savings; The Merlin Contract Agent Helps Draft Compliant Contracts And Reduces Risks By Actively Monitoring Them; And The Merlin AP Agent Further Enhances Efficiency By Automating Invoice Processing With Exceptional Speed And Accuracy.We Are An Equal Opportunity Employer Zycus is committed to providing equal opportunities in employment and creating an inclusive work environment. We do not discriminate against applicants on the basis of race, color, religion, gender, sexual orientation, national origin, age, disability, or any other legally protected characteristic. All hiring decisions will be based solely on qualifications, skills, and experience relevant to the job requirements. Job Description We are seeking a skilled and motivated ETL Developer to join our dynamic data team. In this role, you will be responsible for the end-to-end design, development, and maintenance of robust and scalable data pipelines. You will be a key player in transforming raw data into actionable insights that drive our business decisions. If you are passionate about data architecture and have a strong command of Talend, RDBMS, and Java, we encourage you to apply. Key Responsibilities - Design and build efficient, reusable, and reliable end-to-end ETL pipelines using Talend. - Write and optimize complex SQL queries to extract and manipulate data from various Relational Database Management Systems (RDBMS) like Oracle, SQL Server, or PostgreSQL. - Develop and integrate custom Java code within Talend jobs to handle complex data transformations and business logic. - Collaborate with data architects, analysts, and business stakeholders to gather requirements and define data integration specifications. - Take ownership of the entire ETL process, from data source analysis and ingestion to loading into data warehouses or data marts. - Implement data quality checks, validation, and error-handling procedures to ensure data accuracy and integrity. - Troubleshoot production issues, identify bottlenecks, and optimize ETL jobs for performance. - Create and maintain comprehensive technical documentation for all developed data pipelines. Five Reasons Why You Should Join Zycus - Cloud Product Company: We are a Cloud SaaS Company, and our products are created by using the latest technologies like ML and AI. Our UI is in Angular JS, and we are developing our mobile apps using React. - A Market Leader: Zycus is recognized by Gartner (world's leading market research analyst) as a Leader in Procurement Software Suites. - Move between Roles: We believe that change leads to growth and therefore we allow our employees to shift careers and move to different roles and functions within the organization - Get a Global Exposure: You get to work and deal with our global customers. - Create an Impact: Zycus gives you the environment to create an impact on the product and transform your ideas into reality. Even our junior engineers get the opportunity to work on different product features. About Zycus Zycus, recognized by leading analyst firms in procurement technology, empowers teams to unlock deep value through its comprehensive Source-to-Pay (S2P) solutions. At the heart of our S2P solution is the Merlin Agentic Platform, which orchestrates intelligent AI agents to deliver simplified, efficient, and compliant processes. The Merlin Intake Agent offers business users unparalleled ease of use, increasing adoption rates and significantly reducing non-compliant spending. For procurement teams, the Merlin Autonomous Negotiation Agent handles tail spend autonomously, securing additional savings; the Merlin Contract Agent helps draft compliant contracts and reduces risks by actively monitoring them; and the Merlin AP Agent further enhances efficiency by automating invoice processing with exceptional speed and accuracy. Job Requirement Experience & Qualifications - Experience- 3 to 5 yrs - Proven professional experience as an ETL Developer or in a similar role. - Expert proficiency in Talend Studio for designing, developing, and deploying ETL jobs. - Strong hands-on experience with RDBMS (e.g., Oracle, MS SQL Server, PostgreSQL, MySQL) and advanced SQL scripting. - Solid programming skills in Java, especially for creating custom routines and components in Talend. - Excellent understanding of data warehousing concepts, dimensional modeling, and ETL best practices. - Bachelor's degree in Computer Science, Engineering, Information Technology, or a related field. Preferred Qualifications - Experience with scripting languages like Python for automation and data manipulation. - Familiarity with cloud platforms (AWS, Azure, or GCP) and their native data services (e.g., S3, Redshift, Azure Data Factory, BigQuery). - Knowledge of or keen interest in Generative AI (GenAI) and its applications in data engineering. - Experience with Big Data technologies like Hadoop or Spark. - Familiarity with version control systems like Git.