Senior Data Integration Specialist

4 days ago


Pune, Maharashtra, India Kellton Full time
About the Role

We are seeking a skilled professional to lead data migration projects from legacy systems to modern architectures using DBT and Snowflake. The ideal candidate will have strong experience in building data pipelines, working with SQL Server, and leveraging DBT for data transformation.

Key Responsibilities
  • Develop and execute unit tests for migrated SQL Server stored procedures rewritten in Snowflake SQL to ensure functionality and performance are consistent with the original logic.
  • Validate data accuracy, consistency, and performance in the new Snowflake environment.
  • Create and execute unit tests and integration tests for DBT pipelines, ensuring that transformations are accurate, reliable, and performant.
  • Implement DBT test suites to verify the correctness of data models, transformation logic, and data quality.
  • Validate the output of scripts against expected results and ensure efficient processing in the AWS/Snowflake cloud infrastructure.
  • Perform end-to-end testing for the entire data flow, from DBT pipelines and Snowflake transformations to report generation via Python/R scripts.
Requirements
  • Proven experience in testing data pipelines and ETL processes using DBT or similar tools.
  • Experience testing SQL transformations, particularly migrating from SQL Server to Snowflake SQL.
  • Hands-on experience with testing Python and R scripts, particularly in data processing or analytical environments.
  • Experience working in data migration projects, particularly to cloud environments like Snowflake.
  • Strong knowledge of SQL for writing test cases and validating query results.
  • Experience with DBT testing frameworks, including setting up and running DBT tests.
  • Proficiency in Python and R for testing and debugging data transformation scripts.
  • Familiarity with version control systems (e.g., Git) for managing test scripts and test case versioning.
  • Knowledge of CI/CD pipelines for integrating automated testing into the development process.
  • Familiarity with cloud platforms (AWS) and cloud-native databases like Snowflake.
  • Experience in performance testing and load testing for SQL queries, pipelines, and scripts running on large datasets.
What We Offer
  • A competitive base salary: ₹25,00,000 per annum
  • Existing clients in multiple domains to work with
  • A strong and efficient team committed to quality output
  • The opportunity to enhance your knowledge and gain industry domain expertise by working in varied roles
  • A hybrid work arrangement for flexibility and work-life balance (If the client/project allows)
  • Job satisfaction and a chance to make a significant impact in the IT industry


  • Pune, Maharashtra, India Avanciers Full time

    Job Title: Senior Data Integration SpecialistAbout Us:Avanciers is a reputable organization committed to delivering innovative solutions that drive business growth.Salary and Benefits:We offer an attractive salary package of ₹1,200,000 - ₹1,500,000 per annum, along with a comprehensive benefits package that includes health insurance, retirement plans,...


  • Pune, Maharashtra, India John Bean Technologies Corporation Full time

    OverviewAt John Bean Technologies Corporation, we're passionate about fortifying the future of food through innovative technology solutions. Our purpose is to harness our expertise and partner with customers to pioneer sustainable innovation.The OpportunityWe're seeking an experienced Senior Data Integration Specialist to join our team in a remote role. As...


  • Pune, Maharashtra, India Luxoft Full time

    We are seeking an experienced Senior Data Integration Specialist to join our team at Luxoft. As a key member of our offshore presence, you will collaborate closely with clients' existing teams to ensure the successful delivery of project objectives.Job DescriptionWe are partnering with a leading Australian company to support their Treasury projects. The...


  • Pune, Maharashtra, India L&T Technology Services Full time

    Job Description:We are looking for a skilled Senior Data Integration Specialist to join our team at L&T Technology Services.This role involves transforming data from various PLM systems like Windchill, Enovia, Teamcenter and ERP, requiring strong architectural experience.The ideal candidate should have at least 6+ years of experience in data integration and...


  • Pune, Maharashtra, India Nirmitee Full time

    Job Title: Senior Data Integration Specialist - Pune">About the Role:">We are seeking a highly skilled Senior Data Integration Specialist to join our team in Pune. The successful candidate will have 5+ years of experience in ETL development, with strong expertise in IBM DataStage and SQL. The ideal candidate will have a proven track record of delivering...


  • Pune, Maharashtra, India Wenger & Watson Full time

    We are seeking a highly skilled Senior Data Integration Specialist to join our team at Wenger & Watson. As a key member of our data integration team, you will play a crucial role in designing and developing ETL artifacts using IBM DataStage.With 4-6 years of experience, you will have a strong background in business analysis and requirement definition, as...


  • Pune, Maharashtra, India Taggd Full time

    Job DescriptionAt Taggd, we are seeking a highly skilled Senior Data Integration Specialist to join our team. This is a full-time position that requires a minimum of 5 years of experience in Informatica, with a strong focus on Informatica Cloud IICS (Data Integration) and Cloudera.We offer an estimated salary of $120,000 per year, based on the location in...


  • Pune, Maharashtra, India Taggd Full time

    Job Description:We are seeking a skilled Data Integration Specialist to join our team at Taggd. As a key member of our data integration team, you will be responsible for designing, developing, and implementing comprehensive solutions using Informatica Cloud Application and Data Integration.Key Responsibilities:Develop and implement data integration workflows...


  • Pune, Maharashtra, India Team Engine HCM Full time

    Job DescriptionWe are seeking a highly skilled Senior Oracle Data Integration Specialist to join our team at Team Engine HCM.Key ResponsibilitiesData Integration: Develop and manage data integration workflows and mappings to extract, transform, and load (ETL) data from various sources into the target systems.Oracle Data Integrator Expertise: 5+ years of...


  • Pune, Maharashtra, India Zensar Technologies Full time

    Data Integration SpecialistZensar Technologies is seeking a skilled Data Integration Specialist to work on designing, developing, and deploying integration processes using Dell Boomi. The ideal candidate will have 4-6 years of experience in integration development and strong understanding of integration concepts, including data mapping, data transformation,...


  • Pune, Maharashtra, India Scoop Technologies Full time

    **Job Title:** Data Integration SpecialistWe are seeking a highly skilled Data Integration Specialist to join our team at Scoop Technologies. The ideal candidate will have hands-on experience in automation scripting, complex SQL queries, and data validation.**About the Role:Perform ETL testing, ensuring data integrity, accuracy, and reliability throughout...


  • Pune, Maharashtra, India Salvo Software Full time

    About Salvo SoftwareWe are a cutting-edge technology company focused on developing innovative software solutions for the automotive aftermarket. Our mission is to deliver top-notch products that meet the evolving needs of our clients.Job OverviewWe are seeking an experienced Senior Automotive Data Integration Specialist to join our team. This role will...


  • Pune, Maharashtra, India Staff4Me Full time

    Staff4Me is seeking a highly skilled Senior Integration Specialist to join their team. The ideal candidate will have expertise in designing, developing, and implementing integrations using the Workato platform.About the RoleDesign and develop seamless integrations between various applications and systems using Workato. Collaborate with business stakeholders...


  • Pune, Maharashtra, India Coders Brain Technology Private Limited Full time

    We are seeking a highly skilled Data Integration Specialist to join our team at Coders Brain Technology Private Limited. The ideal candidate will have a strong background in ETL development using Pentaho DI or similar tools, as well as experience with big data platforms and cloud technologies. This role involves designing, developing, and maintaining ETL...


  • Pune, Maharashtra, India Salorix Consulting Full time

    Job Overview:We are seeking a highly skilled Data Integration Specialist to join our team at Salorix Consulting. As an ETL ODI Consultant, you will play a key role in designing and developing data warehouse tables and accompanying documentation.Key Responsibilities:Design and develop Extract Load Transform (ELT) processes using Oracle Data Integrator...


  • Pune, Maharashtra, India Pro Integrate Consulting Full time

    Job Title:Data Integration SpecialistAbout Us:Pro Integrate Consulting provides consulting services for a variety of IT skills globally, including MuleSoft, webMethods, Dell Boomi, and more.We offer expertise in strategic planning and execution to optimize business investments with operations and customers in multiple countries.Job Description:This is a...


  • Pune, Maharashtra, India Admin Looks Full time

    We are seeking a skilled Data Integration Specialist to join our team at Admin Looks. The successful candidate will be responsible for designing and developing efficient data integration workflows using KingswaySoft and SQL.As a key member of our team, you will work closely with business analysts and other stakeholders to understand data requirements and...


  • Pune, Maharashtra, India PeopleStrong Full time

    About the RoleWe are seeking a highly skilled Data Integration Specialist to join our team in Mumbai. This is a full-time position that requires a minimum of 5 years of experience in Informatica Cloud and related technologies.Key ResponsibilitiesDesign and develop comprehensive data integration solutions using Informatica Cloud Application and Data...


  • Pune, Maharashtra, India Randstad Digital Full time

    About the Role:">We are seeking a skilled Data Integration Specialist to join our team at Randstad Digital. This is a fantastic opportunity to work with cutting-edge technology and be part of a dynamic team that drives innovation in data management.">Key Responsibilities:">Develop, implement, and maintain robust data integration solutions using Informatica...


  • Pune, Maharashtra, India Capgemini Full time

    Capgemini is a global leader in consulting and digital transformation. We are seeking an experienced Senior SAP CPI Integration Specialist to join our team.Salary:$120,000 - $180,000 per annumJob Description:As a Senior SAP CPI Integration Specialist, you will be responsible for designing, implementing, and maintaining integration solutions using SAP Cloud...