Senior ETL Engineer & Data Integration Specialist

SWARAJ SAMBARE

+1-347-***-**** •********@***.***• LinkedIn • Portfolio• Github

SUMMARY

Software Engineer / ETL Developer with 5+ years of progressive experience in software development, data integration, SQL optimization, production support, and enterprise application delivery across financial, insurance, cloud, and administrative systems. Experienced in designing, developing, testing, deploying, and supporting ETL/data integration solutions using SQL, Java, Python, UNIX/Linux scripting, Git-based deployments, Agile delivery, and cloud platforms. Strong background in working with business stakeholders, QA teams, DBAs, and architects to deliver secure, reliable, and performance-optimized integration solutions across enterprise environments. EDUCATION

Syracuse University - College of Engineering & Computer Science, Syracuse, NY August 2023 - May 2025 Master of Science in Computer Science

Relevant Coursework: Machine Learning, Data Structures & Algorithms, Operating System and System Design, Data Science, Internet of Things, Computer Architecture SKILLS

ETL & Data Integration: IBM InfoSphere DataStage, DataStage Designer, DataStage Director, DataStage Administrator, ETL Development, Data Mapping, Data Validation, Data Quality Checks, Batch Processing, File Transfers, SFTP, Data Migration Databases: Oracle, SQL Server, IBM DB2, MongoDB, PostgreSQL, Netezza, MS SQL Server Management Studio, Toad, MongoDB Atlas, Mongo Compass, SQL Developer Programming & Scripting: SQL, Python, Java, JavaScript, C++, UNIX Shell Scripting, SFTP, COBOL/JCL Concepts Tools & Platforms: Azure DevOps, Git, GitHub, ServiceNow, SharePoint, WinSCP, PuTTY, Eclipse IDE, Microsoft Visio, MS Office, Excel, PowerPoint Schedulers & Operations: CA7 Scheduler, Stonebranch, Batch Job Monitoring, Production Support, Incident Resolution, Deployment Validation Cloud & DevOps: AWS, Azure, Docker, Jenkins, CI/CD, Git-based Deployments, Release Management Operating Systems: UNIX/Linux, Windows

Methodologies: Agile/Scrum, SDLC, Unit Testing, Integration Testing, Documentation, Production Support, Security & Audit Compliance EXPERIENCE

Syracuse University, Software Engineer Trainee/Intern May 2025 – Present

● Developed and maintained scalable microservices using Java 17, Spring Boot, PostgreSQL, Docker, Kubernetes, and AWS for university-wide student administration systems, reducing latency by 25% for high-traffic enrollment workflows.

● Built and optimized distributed REST APIs connecting internal research databases with frontend dashboards, improving data retrieval performance for 5,000+ daily active users.

● Assisted in containerizing legacy services using Docker and Kubernetes, improving deployment reliability and reducing CI/CD deployment time by 40%.

● Improved backend performance by optimizing complex SQL queries, stored procedures, and reporting workflows, enabling faster operational dashboards for faculty and administrative teams.

● Supported debugging and troubleshooting of production issues through logs, API traces, and service-level monitoring, helping maintain system reliability during peak usage periods.

● Collaborated with cross-functional stakeholders to document deployment workflows, performance bottlenecks, and system improvement recommendations. ScriptAnalytica Technologies Pvt. Ltd., Software Engineer Trainee/Intern May 2024 – August 2024

● Engineered Python and Next.js automation pipelines for cloud-based document processing workflows, reducing manual operational overhead by 40%.

● Built and maintained Dockerized CI/CD pipelines with deployment validation and monitoring scripts, improving release stability by 30%.

● Developed internal tooling to track workflow execution status, failures, and processing metrics, improving visibility into pipeline reliability and operational bottlenecks.

● Worked with engineering teams in Agile sprints to improve developer velocity through automation, code reviews, and deployment documentation.

● Integrated secure cryptographic libraries including Endesive and Cryptography to strengthen data security and compliance for document workflows.

● Investigated pipeline failures, deployment issues, and integration bugs by analyzing logs, configuration changes, and runtime behavior. C2LBIZ Technology, Software Engineer January 2022 - July 2023

● Developed production-grade Spring Boot microservices and REST APIs for distributed enterprise applications, supporting modular backend services and customer-facing workflows.

● Built reusable frontend and backend components using React, Angular, Java, and SQL, improving application performance by 20%.

● Designed and optimized backend service logic using object-oriented design, data structures, and SQL query improvements to improve maintainability and response times.

● Partnered with QA and product teams to debug production defects, validate fixes, and maintain 95% defect-free releases.

● Created reporting and dashboard features to support business users with operational visibility into system performance, transactions, and customer workflows.

● Communicated status updates, issue resolutions, and release risks to technical and non-technical stakeholders during sprint cycles. DXC Technology, Associate Software Engineer July 2020 - Dec 2021

● Supported enterprise cloud-hosted applications on AWS and Azure, improving reliability for production systems used by large-scale clients.

● Served as a Designated Responsible Individual for production deployments, diagnosing and resolving live service issues within SLA.

● Troubleshot complex system issues across application, infrastructure, and deployment layers using logs, monitoring signals, and environment validation.

● Coordinated production releases, rollback plans, and post-deployment checks to reduce operational risk during maintenance windows.

● Authored technical documentation and led code walkthroughs to improve team knowledge sharing, incident response, and deployment readiness.

● Communicated incident updates and resolutions to internal teams and enterprise stakeholders during production support activities. PROJECTS

Smart Football Predictor (Python, Flask, Scikit-learn) University Coursework

● Developed ML-backed APIs for real-time probabilistic prediction of football match outcomes using Python, Flask, and Scikit-learn.

● Built data preprocessing and model inference workflows to transform historical match data into prediction-ready features.

● Exposed prediction results through backend APIs designed for low-latency analytics use cases.

● Evaluated model behavior and performance trends using structured data processing and statistical analysis. TripBin: Travel Visualization Application (Flutter, Google Firebase, AviationStack API, Booking.com API, Android Studio)

● Developed comprehensive travel planning application using Flutter framework, implementing cross-platform functionality for Android and iOS

● Integrated real-time flight booking features using AviationStack API, implementing RESTful web services and JSON data processing

● Implemented secure user authentication using Firebase, incorporated secure API key handling following security best practices MedAssist AI Clinical Assistant (Python, Streamlit, FAISS, RAG Models, LLMs, PubMedBERT, Deep Learning)

● Built an end-to-end ML retrieval pipeline using Python, FAISS vector search, PubMedBERT embeddings, and RAG models to process 25,000+ medical documents.

● Designed low-latency retrieval workflows supporting 2-second response times across medical Q&A use cases.

● Engineered backend logic for document ingestion, embedding generation, vector indexing, semantic retrieval, and response generation.

● Monitored query performance, retrieval quality, and response behavior across 50,000+ chatbot interactions.

● Improved system reliability and user satisfaction by reducing hallucination-prone responses through domain-specific retrieval grounding. WealthMitra – Financial Management System (React, .NET, Node.js, REST APIs, MS SQL)

● Built a full-stack financial analytics platform with React, .NET, Node.js APIs, and MS SQL Server.

● Designed dashboard views for income, expense, and financial trend analysis, improving user visibility into financial behavior.

● Implemented secure REST APIs and database workflows for reliable user-specific data storage and retrieval.

Contact this candidate