Senior ETL Developer

Optimas Solutions

Maharashtra

Hybrid

INR 1,800,000 - 3,000,000

Full time

6 days ago

Be an early applicant

Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Hybrid work policy

Career growth opportunities

Job summary

Optimas International in Pune, Maharashtra, invites a Senior ETL Developer with 8+ years of experience in Data Warehousing, SSIS, and SQL Server. The role focuses on designing scalable ETL pipelines, integrating ERP/CRM data, and building robust data models to support enterprise reporting and analytics.

Hybrid work policy and opportunities for growth are part of the package. The ideal candidate will drive modernization of Optimas' data ecosystem, ensuring data quality, security, and governance

Qualifications

8+ years of hands-on ETL/DW experience with SQL Server and SSIS.
Strong SQL/T-SQL, data modeling, and ETL/ELT design skills.
Experience with ERP integrations and enterprise data platforms.
Knowledge of data governance, quality, and security standards.

Responsibilities

Design, develop, and support enterprise Data Warehouse solutions for multiple domains.
Architect scalable ETL/ELT pipelines integrating ERP/CRM/SCM data.
Develop dimensional models (Star/Snowflake) and SCDs as needed.
Build reusable ETL frameworks, monitoring, and error handling
T-SQL development including complex procedures, views, and performance tuning.
Lead data integration projects, data profiling, lineage, and governance.

Skills

ETL development

Data Warehousing

SQL Server

SSIS

Power BI

Data integration

Data governance

ERP integrations

T-SQL

Data modeling

Education

Bachelor's degree in Computer Science/Information Systems/Engineering

Tools

SSIS

SQL Server

Power BI

Snowflake

Microsoft Fabric

GitLab

Job description

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.

Description

Position at Optimas International

Senior ETL Developer

Location: Pune, Maharashtra (Hybrid)

Company: Optimas International

Experience: 8-12+ Years

Employment Type: Full-Time

Work Policy: Hybrid

About Optimas

Position Summary

Optimas is seeking a highly skilled and experienced Senior ETL Developer with 8+ years of expertise in Data Warehousing, Microsoft SQL Server, SSIS, ETL, ERP Integrations, Data Replication, Database Administration (DBA), 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.

Key Responsibilities

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 & DBA 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