Logo
KetteQ

Senior Technical Consultant

KetteQ, New York, New York, United States

Save Job

Responsibilities

ETL Development & Optimization: Design, develop, and optimize ETL workflows using Talend to extract, transform, and load data from various sources. Database & SQL Performance Optimization: Write and optimize complex SQL queries, stored procedures, and functions for high-performance data retrieval. Data Integration & Automation: Integrate data from various sources, including APIs, flat files, cloud platforms, and relational databases. Scalability & Infrastructure: Design scalable ETL solutions that support growing business needs. Implement Change Data Capture (CDC), Slowly Changing Dimensions (SCD), and data warehousing best practices. Collaboration: Work with cross-functional teams to design and implement efficient data models. Be a go-to person when it comes to ETL best practices, SQL optimization, and data engineering. Requirments

4-10 years of experience in ETL development using Talend (or similar tools like Informatica, Pentaho, DataStage, Apache NiFi, SSIS). Strong expertise in SQL, PostgreSQL, and PL/SQL for writing, debugging, and optimizing queries. Hands-on experience with performance tuning, indexing, and query optimization in large-scale databases. Experience handling big data transformations, data quality management, and error handling. Deep understanding of ETL best practices, data warehousing principles, and data integration techniques. Strong experience with API integration and cloud data storage solutions. Excellent problem-solving skills and ability to work independently in a remote environment. Good-to-Have Skills

Experience with cloud-based ETL tools (AWS Glue, Google Dataflow, Azure Data Factory). Familiarity with orchestration tools like Apache Airflow, Control-M, or Talend Job Scheduler. Knowledge of supply chain or supply planning datasets is a plus. Experience working in a startup environment with agile methodologies.

#J-18808-Ljbffr