ETL Developer

About TAO :

TAO's mission is to help and empower our partners to digitalize with the latest technologies and AI. We build reliable, scalable data and engineering solutions that turn complex data into business value.

Role Summary :

We are looking for an experienced ETL Developer with strong hands-on expertise in FME, Python, SQL and AWS to design, build and maintain data integration pipelines. You will work with cross-functional teams to move, transform and validate data across systems, and deploy solutions in containerized, cloud-based environments.

Key Responsibilities :

- Design, develop and maintain ETL workflows and data pipelines using FME (Workbench / Server / Flow).

- Write clean, efficient Python scripts for data transformation, automation and custom FME functionality.

- Develop and optimize complex SQL queries, stored procedures and data models for extraction and loading.

- Integrate data from multiple sources such as databases, APIs, flat files and cloud storage.

- Deploy, schedule and monitor ETL jobs on AWS (e.g., S3, EC2, Lambda, RDS, Glue, CloudWatch).

- Containerize applications and data workflows using Docker for consistent, portable deployments.

- Perform data validation, quality checks and error handling to ensure accuracy and reliability.

- Troubleshoot pipeline failures, tune performance and resolve production issues.

- Document data flows, mappings and technical designs.

- Collaborate with business analysts, developers and stakeholders to understand requirements and deliver on time.

Mandatory Skills :

- Python - scripting, data processing, automation

- ETL / FME - hands-on experience building and managing FME workspaces

- AWS - working knowledge of core cloud services for data and deployment

- Docker - building and running containerized applications

- SQL - strong querying, joins, optimization and database fundamentals

Good to Have :

- Experience with FME Server / FME Flow automation and scheduling

- Knowledge of PostgreSQL, Oracle or SQL Server

- Familiarity with spatial/geospatial data formats

- CI/CD pipelines and Git-based version control

- Experience with REST APIs and JSON/XML data handling

- Exposure to data warehousing concepts

Qualifications :

- Bachelor's degree in Computer Science, Information Technology or a related field.

- 4+ years of relevant experience in ETL / data integration.

- Strong analytical, problem-solving and communication skills.

- Ability to work independently in a remote setup and collaborate effectively with distributed teams.

Work Mode :

- Remote role.

- Candidates based in Hyderabad are expected to work from the office in a hybrid model.

Skills

Data Engineering, Python, ETL, SQL, AWS, FME, Data Warehousing, Data Integration