About Us

ETL Advisors is a US based consulting firm specializing in custom development solutions for the Talend suite of products. Our highly specialized team consists of expert Talend developers with more than 15 years of experience building custom Data Integration, Big Data, MDM, ESB & Data Quality solutions for the following industries:

• Healthcare
• Financial
• Retail
• Entertainment
• Copyright
• Legal
• Sales
• Pharmaceutical
• Government

and much more….

Our core expertise lies in:

Talend Data Integration:

• 15+ years direct development experience in Talend Studio and Qlik Talend Cloud (plus legacy Open Studio estates)
• Certified Talend developers
• Extensive experience developing and deploying custom Talend solutions for a variety of industries
• Complex dynamic schema implementations
• Reusable job design for increased modularity
• Custom java development within Talend framework
• Webservice integration (SOAP, REST, OAuth 2.0)
• Webscraping within Talend Framework
• Talend Administration Center (legacy) and Talend Management Console operations
• Migration of Talend Open Studio projects to supported platforms
• Best Practices and Training

Talend MDM:

• MDM Schema Design
• Trigger / Event development
• Data integration in and out of MDM server
• Complex data quality rules
• End-of-life migration off Talend MDM Server (EOL December 31, 2024)

Talend ESB:

• RESTFul API development and deployment
• Custom messaging routes
• Implementation and management of Talend Runtime application
• Modernization of Camel routes to standalone Apache Camel / Spring Boot

Big Data & Cloud Data Platforms:

• Talend Spark job design, executed on Databricks, Amazon EMR, or Kubernetes
• Snowflake, Redshift, BigQuery, and Databricks loading and ELT pushdown
• Lakehouse file formats: Parquet, Apache Iceberg, Delta Lake
• Dynamic schema loading of flat data at scale
• Migration of legacy MapReduce, Pig, and Sqoop-era Talend jobs to Spark or ELT
• Custom MongoDB integration

Modern Data Stack:

• Warehouse modeling and transformation with dbt
• Ingestion with Fivetran, Airbyte, and custom Talend pipelines
• Orchestration with Airflow, Dagster, and Talend Management Console
• Change data capture and streaming (log-based CDC, Debezium-style pipelines, Kafka)
• Practical use of LLM tooling for job documentation and migration analysis

Talend Data Quality:

• Talend Data Quality portal installation and management
• Implementation of custom data validation process
• Development of complex data cleansing processes
• Complex de-duplication of data

Java:

• Custom Java Routines for data cleansing
• Integration with third party libraries
• Custom Talend component development

Redshift:

• 10+ years direct development experience in large scale AWS Redshift datawarehouses
• Implementation of data integration pipelines processing petabytes of data per day into Redshift leveraging Talend

MySQL & PostgreSQL:

• 15+ years direct development experience in enterprise grade MySQL and PostgreSQL database development
• Architecture and Maintenance of large scale systems (100M records+)
• Complex Datawarehouse architecture
• Store Procedures, Cursors and Event Driven Automation

Certifications

• Talend Data Integration Certified Developers
• Oracle Certified MySQL Developers
• Certified Scrum Product Owners