ETL Developer

ETL Developer

Location: Pune, Maharashtra (Hybrid)

Company: Optimas International

Experience: 4 + Years

Employment Type: Full-Time

Work Policy: Hybrid

About Optimas

Optimas is a global distributor of integrated supply chain solutions and engineering support services, specializing in fasteners, industrial components, safety products, and supply chain optimization. Operating across multiple regions, Optimas partners with leading manufacturing and distribution organizations to deliver reliable, efficient, and scalable business solutions. Our teams combine local expertise with global capabilities to support customers through innovative technology, data-driven decision making, and operational excellence.

Position Summary

Optimas is seeking a highly skilled and experienced Senior ETL Developer with 4 + years of expertise in Data Warehousing, Microsoft SQL Server, SSIS, ETL, ERP Integrations, Data Replication, and Enterprise Data Management Solutions and Power BI( Nice to Have) .

The ideal candidate will have extensive hands-on experience designing, developing, optimizing, and supporting enterprise-scale ETL/ELT solutions , Data Warehouse platforms, and integration frameworks that consolidate data from ERP, CRM, Supply Chain, Distribution, Procurement, Finance, and Manufacturing systems into centralized reporting and analytics environments.

This role will be instrumental in driving the modernization of Optimas' enterprise data ecosystem, supporting both on-premises and cloud-based data platforms while ensuring high standards of data quality, scalability, performance, security, governance, and business alignment.

Data Warehouse & Enterprise Data Integration

Design, develop, enhance, and support enterprise Data Warehouse solutions supporting Sales, Finance, Procurement, Inventory, Supply Chain, Manufacturing, and Operations reporting.

Architect and implement scalable ETL/ELT pipelines that integrate data from multiple enterprise applications into centralized analytical platforms.

Develop and maintain dimensional data models using Star Schema , Snowflake Schema , and Data Vault concepts where appropriate.

Design and implement Fact Tables, Dimension Tables, Aggregate Tables, and Slowly Changing Dimensions (SCD Type 1, Type 2, and Hybrid approaches).

Build reusable ETL frameworks, metadata-driven processes, error handling mechanisms, audit logging, data reconciliation, and validation frameworks.

Develop advanced T-SQL solutions including complex stored procedures, views, functions, triggers, CTEs, window functions, and performance-optimized queries.

Perform source-to-target mapping, data profiling, data lineage analysis, and data transformation design.

Implement enterprise data quality controls to ensure completeness, accuracy, consistency, and integrity across business systems.

SSIS Development & Data Migration

Design, develop, deploy, and support enterprise-grade SQL Server Integration Services (SSIS) packages.

Build SSIS solutions utilizing: Control Flow and Data Flow Tasks

Package Configurations

Parameters and Expressions

Script Tasks and Script Components

Lookup Transformations

Merge and Merge Join Transformations

Derived Column Transformations

Conditional Split Transformations

Slowly Changing Dimension Transformations

CDC and Change Tracking Implementations

Error Handling and Logging Frameworks

Develop high-performance SSIS solutions for large-volume data extraction, transformation, loading, and migration activities.

Optimize package execution through parallel processing, partitioning, bulk loading, and performance tuning techniques.

Support data migration and system modernization initiatives involving ERP, WMS, CRM, and legacy platform consolidations.

Implement and manage incremental loading, near real-time integration, and change data capture (CDC) solutions.

Microsoft SQL Server & Responsibilities

Administer, maintain, and optimize Microsoft SQL Server environments across Development, QA, UAT, and Production.

Support SQL Server databases, including performance monitoring, capacity planning, indexing strategies, and query optimization.

Manage database backup, recovery, disaster recovery, and high-availability solutions.

Implement and support: SQL Server Replication (Transactional, Snapshot, and Merge Replication)

Always On Availability Groups

Database Mirroring

Log Shipping

High Availability and Disaster Recovery (HA/DR) Solutions

Conduct database health checks and proactively identify performance bottlenecks.

Support database security, permissions management, auditing, encryption, and compliance requirements.

Analyze execution plans and optimize database objects to improve system performance.

Collaborate with Infrastructure and Application teams on database upgrades, patching, maintenance, and release activities.

ERP & Enterprise Application Integration (Value Addition)

Design and maintain integrations between Data Warehouse platforms and enterprise applications.

Integrate data from: NetSuite ERP

Warehouse Management Systems (WMS)

Distribution Systems

Collaborate with business stakeholders to understand upstream and downstream data dependencies and integration requirements. Awareness of MCP (Model Context Protocol) and emerging AI integration patterns , with an understanding of how AI agents can securely connect with enterprise data platforms such as Enterprise Data Warehouses (EDW).

Familiarity with AI/LLM concepts and AI-enabled data access is a plus, demonstrating a forward-looking mindset toward adopting AI capabilities within the enterprise data ecosystem.

ETL Operations, Production Support & Data Governance

Monitor, troubleshoot, and optimize ETL and Data Warehouse processes to meet defined SLA requirements.

Provide Level 2 and Level 3 production support for enterprise data platforms.

Perform root cause analysis and permanent resolution for ETL failures, data discrepancies, and production incidents.

Support 24x7 production environments, deployment activities, code releases, and emergency support requirements.

Conduct impact assessments for source system changes and implement required enhancements.

Define and maintain data governance, master data management, and data quality standards.

Implement audit, reconciliation, and data validation controls across critical business processes.

Ensure data security, compliance, retention, and regulatory requirements are met.

Collaboration & Technical Leadership

Partner with Business Intelligence, ERP, Infrastructure, Finance, Supply Chain, and Application Development teams to deliver high-quality data solutions.

Participate in architecture discussions, solution design, project planning, effort estimation, and technical reviews.

Mentor junior ETL developers and database professionals.

Conduct code reviews and enforce development standards and best practices.

Drive continuous improvement initiatives related to ETL development, database performance, automation, and platform modernization.

Create and maintain technical documentation throughout all phases of the SDLC lifecycle.

Support Agile/Scrum delivery processes, sprint planning, backlog refinement, and release management activities.

Required Qualifications

Bachelor’s degree in computer science , Information Systems, Engineering, or a related field.

8+ years of hands-on experience in ETL development, Data Warehousing, Data Integration, and SQL Server technologies.

Technical Skills

Core Data & Database Technologies

Microsoft SQL Server

SQL Server Integration Services (SSIS)

SQL Server Agent and SQL Server Replication

Change Data Capture (CDC)

ETL/ELT Development

Data Migration , Data Warehousing , Data Modeling

Database Performance Tuning

Backup & Recovery

Cloud & Modern Data Platforms

Snowflake

Microsoft Fabric

Integration Technologies

REST APIs

Web Services

File-Based Integrations

ERP Integrations

Data Synchronization & Replication

Reporting & Analytics

SSRS (SQL Server Reporting Services)

Power BI

Enterprise Reporting & Dashboard Development

DevOps & Version Control

GitLab

CI/CD Pipelines

Release Management

Agile/Scrum Methodologies

DevOps Practices