Key ResponsibilitiesDevelop dbt models for staging, intermediate, ODS, and consumption layersConvert legacy SQL, SAP BODS, and Informatica IICS transformation logic into dbt modelsDesign reusable dbt macros and scalable transformation frameworksOptimize Snowflake queries, warehouse utilization, and overall platform performanceImplement ELT best practices and modern data engineering standardsCreate technical documentation, lineage, and source-to-target mapping documentsParticipate in code reviews, deployment activities, and release managementConduct migration validations, testing, and reconciliation activitiesCollaborate with onshore technical leads and enterprise architecture teamsRequired Skills7+ years of Data Engineering experience3+ years of Snowflake experienceStrong hands-on experience with dbtAdvanced SQL expertiseData Warehouse Design & ArchitecturePerformance Tuning & OptimizationGit Version ControlCI/CD IntegrationAgile MethodologyPreferred SkillsSAP BODS Migration ExperienceInformatica IICSInsurance Domain KnowledgeGuidewire Data ModelPythonAzureAWSPosition OverviewThe ideal candidate will have strong hands-on experience with Snowflake, dbt, Advanced SQL, and Data Warehousing concepts, along with expertise in designing and implementing modern cloud-based data transformation frameworks.We are looking for a highly skilled Senior Snowflake/dbt Data Engineer to join a large-scale Enterprise Data Modernization Program. This role involves migrating legacy SAP BODS, SQL, and Informatica IICS workloads into a modern Snowflake and dbt ecosystem, while building scalable, high-performance ELT solutions.Ideal CandidateA results-driven Data Engineer who can successfully modernize legacy data platforms, build efficient ELT pipelines, and deliver enterprise-grade data solutions using Snowflake and dbt while ensuring scalability, performance, and best practices.ContactInterested candidates can share their updated CV via DM or email.Email: Careers@Onmogsoftsol.comSubject: SS100926 - Senior Snowflake/dbt Data Engineer
3 days ago