Software Engineer with 3+ years in ETL/BI Testing & Automation (Python)
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Software Test Engineer specializing in ETL/BI Testing, Advanced SQL, API & Performance Testing, and Selenium (Python). Seeking roles in Healthcare, Insurance, and Investment Banking analytics to harden data pipelines, dashboards, and transactional journeys with CI-ready, traceable test assets.
Yashwantrao Chavan Institute Of Science, Satara (Shivaji University, Kolhapur)
B.Sc
N/A – June 30, 2022
Infosys
Software Test Engineer
November 1, 2022 – Present
Pune, Maharashtra, India
Capital Markets Analytics Lake - Investment Banking - DNB ASA
November 1, 2022 – June 1, 2026
Built and validated an analytics data lake for DNB ASA (Norway's largest bank). Ingested trading/market data into bronze/silver/gold layers, and curated marts served risk/reporting dashboards. Authored test plans for schema evolution, partitioning, and late data handling. Validated trade/market reconciliations (counts/sums/notional) using advanced SQL. Verified dimension/fact designs (trade, position, instrument, calendar, counterparty) and assessed SCD handling and surrogate keys for instrument metadata. Ensured metadata/lineage completeness for audit and regulatory needs. Executed performance tests for ingestion and BI queries, reviewing storage/compute metrics. Validated conformed dimensions across asset classes for cross-desk reporting. Ran negative/edge scenarios (stale market data, clock skews, broken feeds). Reconciled BI KPIs with SQL baselines, verified drill paths for traders. Performed inter-system tests with risk engines and reconciliations. Automated smoke checks (Python) for new partitions and scheduled them in Jenkins. Managed defects with prioritization based on business impact. Supported UAT with CIB teams, documented acceptance criteria. Delivered knowledge articles and handover assets for operations. Suggested indexing/partition tweaks for faster KPIs.
Provider Data Access & Onboarding - Mastered Provider Hub - Santa Clara Family Health Plan (SCFHP)
November 1, 2022 – June 1, 2026
Unified provider onboarding and directory with a provider golden record for SCFHP. Standardized, matched/merged provider data to remove duplicates, align specialties/contracts, and feed portals/APIs and analytics. Designed test scenarios for match/merge/survivorship and provider hierarchies (groups/locations/specialties). Verified metadata contracts (types, constraints, nullability) and lineage. Built source-to-target mapping checks, validated transforms (trim/case/cast, pivot/unpivot). Ensured incremental loads/CDC, error handling, and retry/fallback logic. Wrote SQL to validate fuzzy matching thresholds and reference codesets. Confirmed performance SLAs for onboarding spikes using JMeter. Created negative tests (invalid specialties, expired contracts, network conflicts). Validated parallel processing and recovery for aborted sessions. Checked downstream API/portal feeds, executed inter-system tests. Audited directory exports for accuracy and timeliness. Tracked defects in Jira/HP ALM with reproducible evidence. Collaborated with Data Governance on DQ thresholds and profiling. Reviewed BI dashboards (filters/joins/RLS) and reconciled metrics. Prepared UAT packs and supported go-live readiness. Published runbooks and KT to operations.
End-to-End Health Plan Dashboards & APIs - Payer Analytics
November 1, 2022 – June 1, 2026
Adopted a vault-based cloud data platform for payer analytics. Integrated clinical, claims, and eligibility data; hardened Power BI datasets and member/provider APIs for portals. Mapped business rules to ETL transformations; authored data mapping documents. Validated hubs/links/satellites populations and history tracking. Executed data quality checks (completeness, accuracy, uniqueness, timeliness). Benchmarked queries; recommended indexing/partitioning improvements. Checked Power BI calculations and RLS; matched visuals with SQL baselines. Performed API contract tests (auth/error contracts) via Postman. Ran JMeter tests; monitored latency/percentiles/throughput for endpoints. Verified compatibility/configuration across environments. Executed installation/upgrade validations and rollback tests. Practiced negative testing for invalid codes, edge date cases. Coordinated defect management with reproducible evidence. Prepared UAT scripts and drove sign-offs. Delivered release notes and operational runbooks. Mentored juniors on SQL review techniques for BI. Maintained audit artifacts and dashboards for exec reporting.
Cultural Fit Analysis
The candidate's experience across Investment Banking and Healthcare domains, coupled with their proficiency in a wide array of testing methodologies (Manual, ETL/BI, Database, API, Automation, Performance) and tools (Informatica, SSIS, Azure, SQL, Power BI, Postman, JMeter, Selenium, Python, PyTest, Jenkins, Jira, HP ALM), suggests a versatile and adaptable individual. Their focus on data rigor, traceability, and audit-ready documentation indicates a commitment to quality and compliance, which is valuable in structured environments. The breadth of skills and project diversity align with a candidate who can integrate into various technical cultures and contribute across different project types.
Soft Skills & Operational Fit
The candidate demonstrates strong operational fit through their detailed project descriptions, highlighting defect management, UAT support, documentation (runbooks, knowledge articles), and collaboration with various teams (Data Governance, CIB teams, BI squads). Their experience in mentoring juniors also indicates leadership potential. The resume clearly outlines a structured approach to testing, including test plan authoring, scenario design, and performance validation, which are critical for operational excellence.