Home

Soniya ETL Developer - ETL Test Lead

[email protected]

Location: Raleigh, North Carolina, USA

Relocation: Yes

Visa: H1B

Resume file: Soniya ETL Test Lead_1784038542643.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Soniya Shaik ETL Test Lead Phone: 248-876-0218 Email: [email protected] SUMMARY: 14 years of experience in ETL Testing, Data Validation, Data Warehousing, and Quality Assurance across Healthcare, Financial, and Government domains. Accomplished ETL Testing and Data Quality Professional with 14+ years of experience in ETL Testing, Data Warehousing, Data Migration, Data Integration, and Business Intelligence across Healthcare, Banking, Financial Services, and Government domains. Extensive experience validating complex ETL workflows, enterprise data pipelines, and large-scale data migration projects using IBM DataStage, Informatica, SQL, Oracle, DB2, Netezza, and UNIX/Shell scripting. Strong expertise in source-to-target data validation, data reconciliation, data profiling, transformation validation, referential integrity, and data quality assurance. Experienced in designing comprehensive ETL test strategies, test plans, test scenarios, and automated validation processes for enterprise data platforms. Proficient in writing complex SQL queries, joins, CTEs, stored procedures, and analytical functions to validate millions of records across multiple databases. Hands-on experience testing batch processing, scheduled ETL jobs, incremental and full data loads, CDC (Change Data Capture), and data synchronization. Skilled in validating data warehouse architectures, including Star Schema, Snowflake Schema, Fact Tables, Dimension Tables, Slowly Changing Dimensions (SCD Types 1, 2, and 3), and surrogate keys. Strong understanding of Data Warehousing, Data Lake, Data Lakehouse, and modern data integration architectures. Experience validating REST APIs, web services, and database integrations supporting ETL workflows. Hands-on experience with cloud-based data platforms such as AWS, Azure, and modern analytics technologies including Snowflake, Databricks, and SAS Viya. Experience using Python for data validation, automation, and reconciliation of ETL processes. Proficient in defect tracking using Jira and Azure DevOps, with expertise in root cause analysis and issue resolution. Strong knowledge of SDLC, STLC, Agile Scrum, Waterfall, DevOps, CI/CD practices, and release management. Experience performing performance testing, data volume testing, and production validation for enterprise-scale ETL applications. Adept at collaborating with business analysts, developers, data engineers, DBAs, and stakeholders to ensure data accuracy and successful project delivery. Excellent analytical, troubleshooting, and communication skills with a proven ability to manage multiple projects and deliver high-quality solutions within deadlines. Keywords: continuous integration continuous deployment