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 integration.• 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 procedures based on complex table schemas and relationships.• 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.• Provide technical guidance and training to new team members, ensuring effective knowledge transfer and adherence to best practices.• Work closely with collection analysts to address client queries, offering expert data insights and resolving issues efficiently.