Data Integration Specialist
Current- Perform comprehensive Quality Assurance (QA) and data validation checks to ensure data integrity and accurate representation throughout the pipeline.
- Architect and implement sophisticated ETL (Extract, Transform, Load) procedures using PL/SQL, involving Common Table Expressions (CTEs), complex JOIN operations, and merge statements for precise data transformation and.
- Utilize data staging environments to preprocess and temporarily store raw data before executing final load processes.
- Automate data preprocessing and data normalization tasks using Python and macros, streamlining ETL workflows and reducing manual intervention. Developed dynamic PL/SQL scripts to automate the construction of load.
- Leverage Natural Language Processing (NLP) techniques in Python to accurately parse and standardize addresses, minimizing manual workload and enhancing data quality.
- Collaborate with cross-functional teams to identify and implement process improvements, optimizing workflow orchestration and enhancing overall pipeline performance.