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.
Key Responsibilities
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