ETL Solutions Specialist

2 weeks ago

Palakkad, Kerala, India beBeeDeveloper Full time ₹ 25,00,000 - ₹ 35,00,000
ETL Developer Position

We are seeking skilled professionals to fill an ETL developer position. The ideal candidate will have experience in designing and developing efficient, scalable ETL solutions using SSIS.

Key Responsibilities:

  • Design and Development:
    • Translate business requirements into technical ETL solutions using data flow and control flow logic.
    • Develop reusable ETL components that support modular, configuration-driven architecture.
  • Data Integration and Transformation:
    • Integrate data from multiple heterogeneous sources such as SQL Server, flat files, APIs, and Excel.
    • 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.
  • SQL and Database Development:
    • 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.
  • Performance Tuning:
    • 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.
  • Error Handling and Logging:
    • Develop error-handling mechanisms and event logging in SSIS using Event Handlers and custom logging frameworks.
    • Implement restartability, checkpoints, and failure notifications in workflows.
  • Testing and Quality Assurance:
    • 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.
  • Deployment and Scheduling:
    • 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.
  • Documentation and Maintenance:
    • Maintain documentation for ETL designs, data flow diagrams, transformation logic, and job schedules.
    • Update job dependencies and maintain audit trails for data pipelines.
  • Collaboration and Communication:
    • 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.
  • Compliance and Best Practices:
    • Ensure ETL processes comply with data governance, security, and privacy regulations.
    • Follow team coding standards, naming conventions, and deployment protocols.

Requirements and Qualifications:

  • 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.

  • ETL Operations Specialist

    2 weeks ago

    Palakkad, Kerala, India beBeeData Full time ₹ 9,00,000 - ₹ 15,00,000

    We are seeking an ETL Operations Specialist, responsible for ensuring the integrity and accuracy of our data.Key Responsibilities:Foster effective communication with stakeholders to guarantee seamless collaboration.Develop strong team engagement skills to promote a positive work environment.Technical Requirements:Advanced knowledge of SQL and database...

  • ETL Migration Specialist

    1 week ago

    Palakkad, Kerala, India beBeeMigration Full time ₹ 80,00,000 - ₹ 1,00,00,000

    Job OpportunityWe seek a highly skilled ETL professional to lead the Informatica to SSIS migration process. The ideal candidate will be responsible for designing, developing, and implementing efficient ETL processes ensuring seamless migration and optimal workflow automation across multiple database systems.Key Responsibilities:Execute Informatica to SSIS...

  • ETL Architect

    1 week ago

    Palakkad, Kerala, India beBeeData Full time ₹ 30,00,000 - ₹ 40,00,000

    Senior ETL Developer PositionAt Hyrhub, we are seeking a seasoned Senior ETL Developer with 6+ years of experience to join our dynamic team.Job Summary:The ideal candidate will have extensive knowledge of designing, developing, and deploying scalable data pipelines and ETL processes using Databricks. They will be responsible for collaborating with...

  • ETL Automation Specialist

    1 week ago

    Palakkad, Kerala, India beBeeEtl Full time ₹ 25,00,000 - ₹ 35,00,000

    Job OverviewWe are seeking an ETL Test Engineer with expertise in advanced SQL and Python automation to join our team for a high-profile project.This role involves designing and executing comprehensive testing strategies across complex data pipelines, ensuring seamless integration with enterprise-grade data systems.Key Responsibilities:Develop and execute...

  • Senior ETL Developer

    1 week ago

    Palakkad, Kerala, India beBeeData Full time ₹ 12,00,000 - ₹ 18,00,000

    Job Description:This is a full-time role for an ETL (Extract, Transform, Load) Developer responsible for designing, deploying and managing ETL processes that integrate data from various sources. As part of our team, you will work with clients to architect and implement data pipelines using Informatica and other tools.Daily Tasks:Designing and deploying...

  • Data Solutions Architect

    1 week ago

    Palakkad, Kerala, India beBeeDataSpecialist Full time ₹ 20,00,000 - ₹ 25,00,000

    Technical Data Management SpecialistWe are seeking an experienced Technical Data Management Specialist to help us build and manage systems that organize important business data.Key Responsibilities:Configure and customize the Stibo STEP platform for data management solutions.Create and manage data models (structures that define how information is stored and...

  • SAP Data Integration Specialist

    1 week ago

    Palakkad, Kerala, India beBeeData Full time ₹ 20,00,000 - ₹ 25,00,000

    Key Responsibilities for SAP Data Integration Specialist:Develop and implement efficient ETL processes to transform SAP dataMaintain and optimize existing ETL solutions to ensure high-quality data flowCollaborate with cross-functional teams to identify and address data integration challengesRequirements:6+ years of experience in Talend ETL development and...

  • System Architect – Database Solutions

    1 week ago

    Palakkad, Kerala, India beBeeData Full time ₹ 1,00,00,000 - ₹ 2,00,00,000

    Backend Data SpecialistWe are seeking a skilled Backend Data Specialist with strong SQL expertise to support the migration of data solutions from Azure Synapse Analytics to SQL-based systems. The ideal candidate will have at least 2+ years of professional experience in backend development and SQL, with the ability to design, optimize, and deliver scalable...

  • AI Solution Specialist

    1 week ago

    Palakkad, Kerala, India beBeeAnalysis Full time ₹ 6,00,000 - ₹ 15,00,000

    Job Title: AI Solution SpecialistOverview:Our organization seeks a skilled AI Solution Specialist to collaborate with our AI for Delivery team. This role will involve the design, configuration, and implementation of AI-enabled solutions within Copilot Studio and Power Platform.Key Responsibilities:Documenting requirements, processes, and outputs.Supporting...

  • Implementation Specialist

    1 week ago

    Palakkad, Kerala, India beBeeImplementation Full time ₹ 60,00,000 - ₹ 1,00,00,000

    Are you a seasoned professional looking to take your career to the next level? We have an exciting opportunity for a highly skilled Implementation Specialist. As an Implementation Specialist, you will be responsible for leading full-cycle implementations of our solution. This includes requirements gathering, configuration, testing, and deployment.Key...