Data Integration Specialist

10 hours ago

Jaipur, Rajasthan, India beBeeEtldesigner Full time ₹ 20,00,000 - ₹ 25,00,000
Job Overview">

Position Title: ETL Developer - Data Integration Specialist

We are seeking a highly skilled and experienced ETL (Extract, Transform, Load) developer to join our team. The successful candidate will have strong expertise in designing, developing, and implementing efficient and scalable data integration solutions using SQL Server Integration Services (SSIS). This is an excellent opportunity for a motivated professional to leverage their technical skills and experience to contribute to the success of our organization.

Key Responsibilities:

  • Design and develop complex SSIS packages to extract, transform, and load data between systems
  • Develop reusable ETL components that support modular, configuration-driven architecture
  • Integrate data from multiple heterogeneous sources including SQL Server, flat files, APIs, Excel, etc.
  • Implement business rules and data transformations such as cleansing, standardization, enrichment, and deduplication
  • Manage incremental loads, full loads, and slowly changing dimensions (SCD) as required
  • Write complex T-SQL queries, stored procedures, and functions to support data transformations and staging logic
  • Perform joins, unions, aggregations, filtering, and windowing operations effectively for data preparation
  • Ensure referential integrity and proper indexing for performance
  • Optimize SSIS packages by tuning buffer sizes, using parallelism, and minimizing unnecessary transformations
  • Tune SQL queries and monitor execution plans for efficient data movement and transformation
  • Implement efficient data loads for high-volume environments
  • Develop error-handling mechanisms and event logging in SSIS using Event Handlers and custom logging frameworks
  • Implement restartability, checkpoints, and failure notifications in workflows
  • Conduct unit and integration testing of ETL pipelines
  • Validate data outputs against source and business rules
  • Support QA teams in user acceptance testing (UAT) and defect resolution
  • Package, deploy, and version SSIS solutions across development, test, and production environments
  • Schedule ETL jobs using SQL Server Agent or enterprise job schedulers (e.g., Control-M, Tidal)
  • Monitor and troubleshoot job failures and performance issues
  • Maintain documentation for ETL designs, data flow diagrams, transformation logic, and job schedules
  • Update job dependencies and maintain audit trails for data pipelines
  • Collaborate with data architects, business analysts, and reporting teams to understand data needs
  • Provide technical support and feedback during requirements analysis and post-deployment support
  • Participate in sprint planning, status reporting, and technical reviews
  • Ensure ETL processes comply with data governance, security, and privacy regulations (HIPAA, GDPR, etc.)
  • Follow team coding standards, naming conventions, and deployment protocols

Requirements:

  • 4-8 years of hands-on experience with ETL development using SSIS
  • Strong SQL Server and T-SQL skills
  • Solid understanding of data warehousing concepts and best practices
  • Experience with flat files, Excel, APIs, or other common data sources
  • Familiarity with job scheduling and monitoring (e.g., SQL Agent)
  • Strong analytical and troubleshooting skills
  • Ability to work independently and meet deadlines

Preferred Skills:

  • Exposure to Azure Data Factory or cloud-based ETL tools
  • Experience with Power BI or other reporting platforms
  • Experience in healthcare, finance, or regulated domains is a plus
  • Knowledge of version control tools like Git or Azure DevOps

  • Data Integration Specialist

    5 days ago

    Jaipur, Rajasthan, India beBeeDataIntegration Full time ₹ 1,27,16,400 - ₹ 2,54,32,800

    Job Title: Data Integration SpecialistWe are seeking an experienced data integration specialist to take on a key role in our organization. The ideal candidate will possess a strong background in testing and analysis, with a proven ability to work efficiently and effectively.Must have at least 8 years of experience in test engineering, preferably with a focus...

  • Data Integration Specialist

    7 days ago

    Jaipur, Rajasthan, India beBeeIntegration Full time ₹ 12,00,000 - ₹ 20,00,000

    Data Integration SpecialistWe are seeking a skilled Data Integration Specialist to design and build data integration solutions using the o9 platform.Key Responsibilities:Create data crawlers to extract data from customers' data sources using ETL platforms, troubleshoot issues during data loading and processing.Design and implement data warehouse models in...

  • Data Integration Specialist

    10 hours ago

    Jaipur, Rajasthan, India beBeeData Full time ₹ 8,00,000 - ₹ 15,00,000

    Job Title: Data Integration Specialist - Cloud ExpertJob Description:We are seeking an experienced professional to fill the role of a Data Integration Specialist with expertise in cloud-based platforms, particularly Google Cloud Platform (GCP).The ideal candidate will have a strong background in testing and a proven track record of working with large data...

  • Lead Data Integration Specialist

    5 days ago

    Jaipur, Rajasthan, India beBeeData Full time ₹ 12,00,000 - ₹ 20,00,000

    Lead Data Integration Specialist Job DescriptionWe are seeking a seasoned Lead Data Integration Specialist to spearhead our data engineering efforts.The ideal candidate will design and develop end-to-end data integration solutions, optimize workflows, and collaborate with business and technical stakeholders to deliver scalable and high-performing data...

  • Enterprise Data Integration Specialist

    2 days ago

    Jaipur, Rajasthan, India beBeeDataTransformation Full time ₹ 15,00,000 - ₹ 20,00,000

    Job OpportunityWe are seeking an experienced data transformation specialist to lead our enterprise data integration project.Key Responsibilities:Design, develop and implement data mappings/transformations using Informatica Powercenter.Utilize Oracle SQL PLSQL and Unix skills to deliver high-quality results.Experience with Agile methodologies is essential for...

  • Data Integration Specialist

    2 days ago

    Jaipur, Rajasthan, India beBeeInformatica Full time ₹ 20,00,000 - ₹ 25,00,000

    Unlock your career potential with a new opportunity in data integration and management.We are seeking an experienced professional to join our client's team in Bengaluru and leverage their skills in Informatica MDM software.Role OverviewThis role involves utilizing expertise in data integration solutions using ETL processes, designing and optimizing data...

  • Backend Integration Specialist

    4 days ago

    Jaipur, Rajasthan, India beBeeIntegration Full time ₹ 90,00,000 - ₹ 1,20,00,000

    Job OverviewWe are seeking a seasoned Backend Integration Specialist to join our team. This full-time remote role requires strong technical skills and experience working in fast-paced environments.Main Responsibilities:Design, build, and maintain seamless integrations with Property Management Systems (PMS) and third-party platforms.Develop and optimize...

  • Enterprise Data Integration Specialist

    1 week ago

    Jaipur, Rajasthan, India beBeeDataIntegration Full time ₹ 15,00,000 - ₹ 20,00,000

    Job Opportunity:We are seeking a skilled Data Integration Specialist to design, develop, and deploy ETL workflows, create and optimize reports, write advanced SQL queries, and troubleshoot performance issues.Key Responsibilities:Workflow Development & Maintenance:Design, develop, and deploy complex ETL workflows (data extraction, transformation,...

  • SAP CPI Integration Specialist

    2 days ago

    Jaipur, Rajasthan, India beBeeIntegration Full time ₹ 90,00,000 - ₹ 1,20,00,000

    SAP CPI Integration SpecialistWe are seeking a seasoned SAP CPI integration specialist to deliver comprehensive solutions.Key Responsibilities:Develop and implement end-to-end integration scenarios using SAP CPIDesign and configure iFlows for SAP and third-party systemsPerform data mapping, transformation, and content modification using XML, JSON, and...

  • Senior Data Integration Specialist

    6 days ago

    Jaipur, Rajasthan, India beBeeDataIntegrator Full time ₹ 20,00,000 - ₹ 25,00,000

    Job Title: Oracle Data IntegratorWe are seeking a highly skilled Oracle Data Integrator to join our team.Design and develop ETL processes using ODI.Implement ODI Knowledge Modules and optimize performance.Work on end-to-end ODI projects from requirement gathering to deployment.Troubleshoot issues in ODI processes and ensure smooth data...