Pavan Kumar Iddamsetti
Professional Summary
Software Engineer with 5+ years of experience building backend automation, ETL pipelines, and test automation for data-driven applications. Strong Python and SQL background with practical C# experience used to implement integration and orchestration utilities. Experienced designing ETL flows and data models for Azure Data Warehouse and building BI artifacts in Power BI and Tableau to drive operational visibility. Skilled in unit testing and CI/CD (GitHub Actions, Git) to raise test coverage and accelerate delivery in Agile SDLC teams. Proven at reducing manual work through API integrations and scripted automation, and at translating stakeholder requirements into reliable data pipelines and production-ready backend services. Comfortable owning components end-to-end from ingestion to reporting.
Technical Skills
Work Experience
- Validated over 50 Python code modules through targeted unit test suites to catch edge cases during pre-merge checks.
- Improved defect detection by 30% by expanding unit test coverage and aligning test cases with DSE standards.
- Implemented test automation flows for pre-release verification to remove repetitive manual checks from the QA process.
- Refactored legacy Python functions to improve readability and maintainability and enforced coding standards in code reviews.
- Partnered with QA and engineering within Agile SDLC to triage defects and prioritize fixes for release readiness.
- Created unit testing guidelines and checklists to standardize module verification and reduce integration regressions.
- Developed Python ETL scripts to ingest and normalize API payloads into staging tables, reducing manual data preparation by 35%.
- Implemented ASP.NET endpoints and C# utilities to orchestrate scheduled data jobs and call REST endpoints for status updates.
- Designed ETL pipelines and data models to load cleansed data into Azure Data Warehouse to improve analytics availability.
- Wrote and maintained SQL stored procedures for incremental loads and data validation to ensure accurate daily refreshes.
- Integrated unit test hooks into ETL functions and contributed CI/CD configuration to streamline deployments and testing.
- Documented data contracts and coordinated with stakeholders to define refresh SLAs and alerting for data availability.
- Implemented Python-based REST API integrations to automate reconciliation processes and reduce manual reconciliation by 40%.
- Optimized CI/CD pipelines using Git and GitHub Actions to streamline test execution and accelerate deployments.
- Engineered ETL workflows and data models to centralize transaction data for downstream reporting and analytics.
- Automated failure alerts and basic remediation scripts to reduce time-to-detect pipeline issues and improve SLAs.
- Designed schema adjustments and performed SQL tuning to improve responsiveness of reconciliation reports.
- Partnered with remote stakeholders to validate integration contracts and onboard new data sources into pipelines.
- Analyzed complex SQL queries and automated reporting workflows to deliver weekly status updates, surfacing over 10 operational risk areas.
- Conducted root cause analysis on recurring incidents and documented process improvements that reduced recurrence and clarified escalation paths.
- Developed Power BI dashboards to visualize KPIs and enable business units to act on operational trends.
- Applied unit testing to SQL transformations and validation logic, reducing production report errors by 15%.
- Automated incident-resolution scripts using Python to accelerate triage and remediation of recurring issues.
- Standardized data validation procedures and authored SOPs to improve consistency of operational reports and stakeholder communication.
- Built Tableau dashboards combining Excel and database sources to identify bottlenecks and support process optimization.
- Maintained Java utilities that supported data extraction and reporting integrations for downstream pipelines.
Education
Powered by Drivetube · Create your own profile at drivetube.ai
Everything on Drivetube
Six products, two of them free forever. Start wherever you are.
Your free digital resume
at drivetube.ai/in/your-name: one true standard resume with a Hiring Snapshot (visa status, expected salary, notice period, work preference, relocation), an ATS-ready PDF download and a single shareable link. Free forever; interview requests come from verified employers and your contact details stay masked until you accept.
Documentation- Free Job BoardFree
Verified jobs, posted in the last 3 days
verified openings crawled ATS-by-ATS from 160,000+ real company career pages across 50+ ATS platforms. Shows the true posting date from the source ATS — not when a listing was indexed — and deletes every general listing 3 days after it was actually posted. No ghost jobs, no ad-sponsored listings, no staffing reposts, no account needed.
Documentation - Resume Writing ServicesFrom $25.99
Written by senior career writers
human-written, ATS-optimised resumes by senior career writers, from ₹499.99 / $25.99. Available in every country, written to the destination country's own standard — a US resume, UK CV, German Lebenslauf and Indian resume are genuinely different documents. A paid service, separate from the free Drivetube Profile.
Documentation - Drivetube OneFrom $39.99 / 3 mo
Daily matched jobs, tailored resumes, or we apply for you
Drivetube's paid service. Community sends daily Jobsheets of fresh jobs matched to your profile on WhatsApp and email, with the Drivetube Community ($39.99 for 3 months or $69.99 for 6 months; ₹999 or ₹1,899 in India). Jobhunt is one-time application credits with Community included: one credit tailors one resume and its cover letter (100 for $99 with 3 months of Community, 250 for $199 with 6 months). Let Us Apply is an add-on to Jobhunt: a human expert applies 250 times for you on your credits ($0.60 each, $150). Everything lives on one dashboard at drivetube.ai/drivetubeone.
Documentation - Drivetube HireFree tier
For employers — no job postings, no applications
hiring with no job postings and no applications. Paste your real job description and AI matches it against candidates' true standard resumes, returning ranked candidates with a match %, matched and missing skills and written reasoning. Free tier included; employers pay, candidates never do.
Documentation
- Documentation
every product explained in full, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.
- Playbooks
tactical job-search guides. Each post is one named tactic with the situation it applies to, the exact steps, a copy-paste message and honest failure modes. Free, no account.
The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.
Pricing is identical on the web, iOS and Android — no app-store markup. Monthly Community membership is purchased in the iOS app only; the website sells annual plans. The Android app has no in-app purchase, so Android members subscribe on drivetube.ai and then sign in to the app with full access. Membership follows your account, not your device.