Pavithra Sathishkumar Email & Phone Number

Chennai, Tamil Nadu, India

As a data engineer and SQL developer at Aspire Systems, I led data migration projects from diverse client sources to Azure Data Lake Storage (ADLS) and Azure SQL Database. I design and implement ETL processes using Azure Data Factory (ADF) to convert raw data into a structured Data Warehouse. My expertise includes creating efficient pipelines in ADF to automate data extraction, transformation, and loading (ETL), ensuring data integrity, quality, and security throughout the process.I collaborate with cross-functional teams, tailoring data solutions to meet business requirements while optimizing SQL queries for high performance. I maintain comprehensive documentation of ETL pipelines, data mappings, and transformation rules, ensuring compliance and future reference.Key Projects:Project 1: Assurant (Trainee) - Assisted in basic ETL processes, developed SQL queries for data extraction, and supported senior engineers in data transformation using SQL Server and SSIS.Project 2: KPMG - Created ADF pipelines for seamless data migration. Azure services (ADF, Key Vault, ADLS) were utilized to ensure data quality and security. Documented pipeline creation, data lineage, and transformation rules.Project 3: ArchKey Solutions (ETL Developer) - Developed and managed ADF pipelines to extract, transform, and load data into Azure SQL DB. Worked across DEV, QA, and PROD environments, ensuring smooth deployments.With expertise in SQL, Python, ADF, and data warehousing, I ensure the timely delivery of robust data solutions. My strong communication skills, attention to detail, and stakeholder management lead to successful project outcomes.

Chennai, Tamil Nadu, India

- Worked with data from various sources, including SQL databases, APIs, and flat files, to ensure seamless data integration.- Assisted in designing, developing, and implementing ETL processes using tools such as Talend and Microsoft SSIS.- Optimized ETL workflows for performance and efficiency by identifying bottlenecks and implementing improvements.- Supported the management and maintenance of data warehouses, ensuring data was organized and accessible for analysis.- Documented ETL processes, including data mappings, transformations, and business logic.