Data Engineer (ETL & Boomi)

5+ Years Experience About Project Tree At Project Tree, we bridge the gap between complex business challenges and elegant technical solutions. As a premier IT service provider in Gujarat, we specialize in building scalable, future-ready applications. We are looking for a highly technical Data Engineer to architect robust data pipelines and seamless system integrations for our global enterprise clients. Role Overview As a Data Engineer at Project Tree, you will be the architect of our data flow. You will design, develop, and maintain high-performance ETL processes and leverage Dell Boomi to integrate disparate systems. Your goal is to ensure that data is accurate, accessible, and synchronized across our entire ecosystem, supporting real-time analytics and business intelligence. Key Responsibilities ETL Architecture: Design and implement complex ETL/ELT workflows to move data from various sources (SQL, NoSQL, APIs) into centralized data warehouses or lakes. Boomi Integration: Act as the subject matter expert for Dell Boomi (AtomSphere); develop, deploy, and manage integration processes using Boomi connectors, maps, and profiles. Data Modeling: Design and optimize relational and non-relational data models (PostgreSQL, SQL Server, Snowflake) to ensure high-speed query performance. System Synchronization: Build real-time and batch-based integrations to ensure data consistency between ERP, CRM, and custom-built backend services. Quality & Governance: Implement rigorous data validation, cleansing, and error handling protocols to maintain 99.9% data integrity. Pipeline Optimization: Identify and resolve bottlenecks in data processing; implement caching and indexing strategies to reduce latency. Key Responsibilities ETL Architecture: Design and implement complex ETL/ELT workflows to move data from various sources (SQL, NoSQL, APIs) into centralized data warehouses or lakes. Boomi Integration: Act as the subject matter expert for Dell Boomi (AtomSphere); develop, deploy, and manage integration processes using Boomi connectors, maps, and profiles. Data Modeling: Design and optimize relational and non-relational data models (PostgreSQL, SQL Server, Snowflake) to ensure high-speed query performance. System Synchronization: Build real-time and batch-based integrations to ensure data consistency between ERP, CRM, and custom-built backend services. Quality & Governance: Implement rigorous data validation, cleansing, and error handling protocols to maintain 99.9% data integrity. Pipeline Optimization: Identify and resolve bottlenecks in data processing; implement caching and indexing strategies to reduce latency KPIs & Success Metrics Data Accuracy Rate: Ensuring zero-to-minimal discrepancies between source and target systems. Pipeline Uptime: Maintaining high availability for critical data integration streams. Processing Latency: Reducing the time taken for data to move from ingestion to availability. Integration Success Rate: Percentage of successful Boomi executions without manual intervention. Technical Skills & Qualifications Education: Bachelor s degree in computer science, Data Science, IT, or related field. Expertise: 5+ years of experience in Data Engineering with a heavy focus on ETL methodologies. Boomi Mastery: Proven experience with Dell Boomi (Certification is a strong plus). Knowledge of Atoms, Molecules, and Boomi API Management. Data Tooling: Advanced SQL proficiency; experience with Python or Java for data scripting. Cloud & Warehousing: Experience with cloud data platforms (AWS Redshift, Azure Synapse, or Snowflake). Testing: Strong skills in unit and integration testing for data pipelines. Soft Skills AI-Augmented Efficiency: A forward-thinking mindset with the ability to leverage AI tools (e.g., Copilot for SQL, AI-driven data mapping) to accelerate pipeline development and error detection. Analytical Problem-Solving: The ability to trace complex data flows and resolve architectural inconsistencies across multiple platforms. What We Offer Career Evolution: We offer merit-based trajectory from Trainee Data Engineer Junior Data Engineer Senior Lead, culminating in Principal Data Architect. Your journey is defined by transitioning from technical execution to Strategic Data Governance. Project Tree Life: We believe in celebrating our wins together! Enjoy a vibrant culture with frequent team lunches, dinners, annual trips, and our signature Cricket tournaments. The Advantage: Technical autonomy to shape our data strategy, premium hardware at our Iconic Shyamal (Ahmedabad) or Surat offices, and competitive salary benchmarks. Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.