5+ years of experience in BI/DWH/Data Migration/ETL/SQL in all phases of Software Development Life Cycle (SDLC).
Latest experience in Application Support Analysis.
Experience in preparing Test cases and writing SQL scrip…
5+ years of experience in BI/DWH/Data Migration/ETL/SQL in all phases of Software Development Life Cycle (SDLC).
Latest experience in Application Support Analysis.
Experience in preparing Test cases and writing SQL scripts based on Mapping document and performing end-to-end DWH testing.
Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
Have ability to evaluate an ETL/BI specification, verify it with Systems experts and data architects, and assess if it complete and fully understand EDW and ETL Architecture.
Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
Successfully integrated Python into BI/DWH projects, demonstrating versatility in utilizing scripting languages for diverse aspects of software development.
Applied Python scripting to complement SQL and PL/SQL scripts, enhancing data validation processes within the database systems.
Extensively strong on databases including Oracle 10g/9i/8i, MS SQL Server 2000/7.0, Teradata and DB2
Involved in full lifecycle development of various assignments including Data Warehouse projects.
Experience in Data Warehousing and Data Migration projects.
Experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and change data capture.
Hardworking, Dedicated, Flexible and versatile to adapt new project environment having good communication, analytical and interpersonal skills.
• 5+ years of experience in BI/DWH/Data Migration/ETL/SQL in all phases of Software Development Life Cycle (SDLC).
• Latest experience in Application Support Analysis.
• Experience in preparing Test cases and writing SQL scripts based on Mapping document and performing end-to-end DWH testing.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Have ability to evaluate an ETL/BI specification, verify it with Systems experts and data architects, and assess if it complete and fully understand EDW and ETL Architecture.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Successfully integrated Python into BI/DWH projects, demonstrating versatility in utilizing scripting languages for diverse aspects of software development.
• Applied Python scripting to complement SQL and PL/SQL scripts, enhancing data validation processes within the database systems.
• Extensively strong on databases including Oracle 10g/9i/8i, MS SQL Server 2000/7.0, Teradata and DB2
• Involved in full lifecycle development of various assignments including Data Warehouse projects.
• Experience in Data Warehousing and Data Migration projects.
• Experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and change data capture.
• Hardworking, Dedicated, Flexible and versatile to adapt new project environment having good communication, analytical and interpersonal skills
Analyzed requirements for migrating data from Legacy to SAP S/4 HANA using SAP BODS utilizing out of box SAP RDS Data Services package.
Worked with SQL Server Management Studio and SQL Developer to access the Source and Target Database systems to perform Data Analysis and Testing.
Wrote complex SQL queries to validate the DWH data versus Source data including identification of duplicate records and quality of data including validation of complex Source to Target Mapping/Transformation rules.
Performed end-to-end data reconciliation between the Oracle Data-warehouse and Cognos TM1 Cubes by writing SQL queries against Data Warehouse and creating the Cognos Cube summary reports to match the expected Warehouse SQL results based on the requirements/Transformation rules.
Implemented ETL processes using PySpark, harnessing its capabilities for distributed data processing and transformation.
Tested Salesforce and Web Services.
Validated Request and Response XML, SOAP Calls, Restful calls and WSDL using SOAPUI tool.
Wrote extensive SQL and PL/SQL scripts to test the Data Reconciliation, Initialization, and Data Capture, Delta Processing, Incremental process of Policy and Claims systems.
Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
Initiated and developed new techniques to improve the testing process and improve the performance of the test scripts.
Ran SQL queries to verify the number of records and validated the referential integrity rules as per the design specifications.
Verified correctness of data after the transformation rules were applied on source data.
Identified appropriate test data in relevant source systems and incorporated this data into test scripts.
Used Mercury Quality Center to document issues found during the test automation process, suggested appropriate solutions, and prioritized defects for resolution in coordination with the development team.
Performed Regression testing of the fixed issues in the new build until no new issues are identified.
Submitted Final Test Report and required documentation for the entire project within the assigned time frame.
Updated the status of the testing to the QA team and accomplished tasked for the assigned work to the Project Management team regularly.
Provided 1st and 2nd front line support of Low-Code Application Platform applications and infrastructure.
Recorded issues and actions and provided incident and problem management.
Tracked and monitored clients hosted platforms.
Acted in a strict change management regime, involving testing in UAT and like-live environments.
Performed small scale application upgrade, configuration, and patching across multiple environments in line with requirements.
Provided oversight, QA and sign off for all go live and production changes/upgrades.
The AI-first Recruitment Operating System that unifies and automates the entire hiring lifecycle for modern enterprises worldwide.
Dr Job FZ LLC. 2026 © All Rights Reserved
