Subject Matter Expert – ETL Developer

Smiligence

  • Chennai, Tamil Nadu
  • Rs. 16,00,000 per year
  • Permanent
  • Full-time
  • 1 month ago
Job Title: Subject Matter Expert ETL DeveloperMode: Hybrid (3 Days Office + 2 Days Remote)Job Type: Full-Time / ContractLocation:
  • Washermenpet, Chennai
  • Chinna Chokkikulam, Madurai
Shift Time: 1:00 PM to 10:00 PM ISTExperience Required: 5 to 9 YearsJoining: Immediate Joiners Preferred (Max 15 Days)Payroll Company: SmiligenceBudget: Based on ExperienceHolidays: As per US CalendarContact:
  • helpdesk@smiligence.in
  • 7603823025
Job OverviewSmiligence is hiring a Senior ETL Developer with strong hands-on experience in Talend, PostgreSQL, AWS, and Linux. The ideal candidate will take complete ownership of data engineering projects, mentor team members, and drive best practices in ETL development and cloud data workflows.Key ResponsibilitiesCore Functional Responsibilities
  • Lead the design and development of scalable ETL workflows.
  • Take ownership of project execution from requirement gathering to delivery.
  • Conduct technical interviews and mentor junior developers.
  • Create and test proof-of-concepts for data integration solutions.
  • Assist in proposal preparation and client requirement analysis.
Technical Responsibilities
  • Build ETL pipelines using Talend and PostgreSQL.
  • Integrate structured and unstructured data from multiple sources.
  • Develop scripts using Python or Shell in a Linux environment.
  • Work with AWS services: S3, Glue, RDS, Redshift.
  • Implement data versioning using tools like Quilt, Git.
  • Schedule jobs via Apache Airflow, Cron, Jenkins.
  • Troubleshoot and optimize data pipelines for performance and reliability.
  • Promote coding best practices and participate in peer reviews.
Technical Skill RequirementsETL & Integration Tools
  • Must Have: Talend (Open Studio / DI / Big Data)
  • Good to Have: SSIS, SSRS, SAS
  • Bonus: Apache NiFi, Informatica
Databases
  • Required: PostgreSQL (3+ years)
  • Bonus: Oracle, SQL Server, MySQL
Cloud Platforms
  • Required: AWS (S3, Glue, RDS, Redshift)
  • Bonus: Azure Data Factory, GCP
  • Certifications: AWS / Azure (Good to Have)
Operating Systems & Scripting
  • Required: Linux, Shell scripting
  • Preferred: Python scripting
Data Versioning & Source Control
  • Required: Quilt, Git (GitHub/Bitbucket)
  • Bonus: DVC, LakeFS, Git LFS
Scheduling & Automation
  • Tools: Apache Airflow, Cron, Jenkins, Talend Job Server
Other Tools (Bonus)
  • REST APIs, JSON/XML, Spark, Hive, Hadoop
Visualization (Nice to Have)
  • Power BI / Tableau
Soft Skills
  • Strong verbal and written communication.
  • Proven leadership and mentoring experience.
  • Independent project execution skills.
  • Quick learning ability and willingness to teach.
  • Flexible to work in a hybrid setup from Chennai or Madurai.

Expertia AI Technologies