threeS Data, a cutting-edge technology startup based in Coimbatore, India, specializes in Data Architecture, Management, Governance, Analytics, Intelligence, Business Intelligence, Automation, and Machine Learning. Founded in 2024, we focus on delivering simple, smart, and significant solutions that meet our clients' desired outcomes. Our engagements are partnerships, dedicated to understanding the complexities of day-to-day operations and offering practical, honest approaches to deliver exceptional results.

Role Description

Apache Airflow

Key Responsibilities:

ETL Design and Development:

Apache Airflow

orchestration and monitoring capabilities.

· Translate business requirements into robust data transformation pipelines across cloud-data platforms.

· Develop reusable ETL components to support a configuration-driven architecture.

Data Integration and Transformation:

· Integrate data from multiple sources: Redshift, flat files, APIs, Excel, and relational databases.

· Implement transformation logic such as cleansing, standardization, enrichment, and de-duplication.

· Manage incremental and full loads, along with SCD handling strategies.

SQL and Database Development:

· Write performant SQL queries for data staging and transformation within Redshift and Snowflake.

· Utilize joins, window functions, and aggregations effectively.

· Ensure indexing and query tuning for high-performance workloads.

Performance Tuning:

· Optimize data pipelines and orchestrations for large-scale data volumes.

· Tune SQL queries and monitor execution plans.

· Implement best practices in distributed data processing and cloud-native optimizations.

Error Handling and Logging:

· Implement robust error handling and logging in Airflow DAGs.

· Enable retry logic, alerting mechanisms, and failure notifications.

Testing and Quality Assurance:

· Conduct unit and integration testing of ETL jobs.

· Validate data outputs against business rules and source systems.

· Support QA during UAT cycles and help resolve data defects.

Deployment and Scheduling:

· Deploy pipelines using Git-based CI/CD practices.

· Schedule and monitor DAGs using Apache Airflow and integrated tools.

· Troubleshoot failures and ensure data pipeline reliability.

Documentation and Maintenance:

· Document data flows, DAG configurations, transformation logic, and operational procedures.

· Maintain change logs and update job dependency charts.

Collaboration and Communication:

· Work closely with data architects, analysts, and BI teams to define and fulfill data needs.

· Participate in stand-ups, sprint planning, and post-deployment reviews.

Compliance and Best Practices:

· Ensure ETL processes adhere to data security, governance, and privacy regulations (HIPAA, GDPR, etc.).

· Follow naming conventions, version control standards, and deployment protocols.

Qualifications

o 6+ years of hands-on experience in ETL development.

Apache Airflow

o Strong understanding of data warehousing concepts and cloud-based data ecosystems.

o Familiarity with handling flat files, APIs, and external sources

o Experience with job orchestration, error handling, and scalable transformation patterns.

o Ability to work independently and meet deadlines.

Preferred Skills:

Snowflake

healthcare

Azure Data Factory

§ Knowledge of Git, Azure DevOps, or other version control and CI/CD platforms.

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.