•Designed and implemented data ingestion pipelines using AWS Glue, Lambda to load data from various file formats(e.g., XLSX, delimited) into AWS Redshift•Developed and managed CI/CD pipelines with GitHub Actions for seamless code deployment across environments•Set up role-based IAM resources and managed AWS services (Glue, Lambda, Redshift, PySpark codes) throughdedicated GitHub repositories•Transitioned existing Informatica components to AWS Redshift stored procedures using Python and SQL, decreasing process time by 20%•Migrated on-premises ETL processes to AWS and Azure cloud technologies, including AWS Glue and AWS Lambda•Led data migration efforts from Oracle to AWS Redshift, ensuring data accuracy and reliability•Created and maintained views in AWS Redshift for downstream teams, ensuring availability of refined and clean data•Developed ETL processes to extract, transform, and load data from multiple sources (databases, Salesforce, flat files)into the data warehouse, improving data accuracy by 25% and reducing inconsistencies by 30%•Conducted proof-of-concepts (POCs) for new business requirements, designing and maintaining data pipelines using AWS Glue, AWS Lambda, and Informatica•Mentored team members on support and monitoring of on-premises and cloud data pipelines•Collaborated with stakeholders and reporting teams to gather requirements and model data warehouses•Assisted and mentored team members in resolving incidents and issues raised by clients•Analyzed source data to identify quality issues and developed strategies to address them, reducing data errors and inconsistencies by 25%•Created Power BI dashboards to optimize business performance analytics, enhancing operational effectiveness by 15%