Data Engineer

Responsibilities

• Manage data in staging tables, ensuring accuracy, completeness, and integrity
• Perform data cleaning, validation, duplicate removal, and restricted picklist handling
• Build and optimize ETL logic to map staging fields into Salesforce objects
• Use Salesforce Bulk API (v1/v2) for large-scale batch loads with error handling
• Implement parallel and incremental loading strategies to improve performance
• Develop automated workflows using SSIS or ADF to move data from staging to Salesforce
• Implement retry logic, rerouting, and run tables to track load attempts
• Monitor pipelines and proactively fix failures
• Tune SQL queries, transformations, and data flow tasks for scalability
• Work with Salesforce Developers and QA teams to deliver reliable data pipelines
• Document pipeline design, error patterns, and reusable frameworks

Requirements

• Strong SQL skills including query tuning, stored procedures, and performance optimization
• Strong analytical skills
• Good communication skills

Preferred Qualifications

• Hands-on experience with ETL tools such as SSIS, Airflow, or ADF
• Experience with Salesforce data loading, objects, Bulk API v1/v2, and schema mapping
• Proficiency in Python or Java for transformations and automation
• Knowledge of parallel processing, incremental loads, and error handling frameworks
• Familiarity with version control (Git) and CI/CD tools (Jenkins)

About the Company

Algotale is an IT services and consulting firm established in 2020 that specializes in data-centric solutions, including data analytics, artificial intelligence, machine learning, and cloud solutions.