Prasanna S
Senior Software Engineer @Comerica Bank
Signup · Get unlimited contacts
WORK HISTORY
Senior Software Engineer @Comerica Bank
Auburn Hills, MI, US
Reg Reporting project incorporates retail customer information. This project aims to build a data warehouse (DWH) to maintain the customer data of USA and Canada including ledger balances, deposits information data sources and enable the required reporting from the DWH.
EDUCATION
Andhra University College of Engineering
Master's degree, Control Systems Engineering
Jawaharlal Nehru Technological University
Bachelor's degree, Electrical and Electronics Engineering
ABOUT PRASANNA S
Software professional with 12+ years of experience with significant expertise in Data warehousing, ETL process using, Informatica PowerCenter, DataStage, SSIS, SQL Server, Oracle/PLSQL, Snowflake, Teradata, Kafka in various segments of Software Development Life Cycle (SDLC).• Strong experience as Azure Cloud Data Engineer in Microsoft Azure Cloud technologies including Azure Data Bricks, Azure Data Factory (ADF), Azure Data Lake Storage (ADLS), Azure Synapse Analytics (SQL Data warehouse), Azure SQL Database, Azure Analytical services, Azure Cosmos NoSQL DB, Azure Key vaults, Azure DevOps, Azure HDInsight Big Data Technologies like Hadoop, and Apache Spark.• Strong experience in Amazon simple storage service (Amazon S3), AWS Redshift, Lambda and Amazon EC2, Amazon EMR, AWS Glue, Apache Airflow, and Apache Spark (PySpark).• Expertise in designing and developing Data marts and Data Warehouses using multi-dimensional Models such as Snowflake and Star schema while implementing decision support systems.• Excellent Experience in Designing, Developing, Testing and Documenting of ETL jobs and mappings using Informatica PowerCenter and Datastage• Extensively worked on creating pipelines in Azure Cloud ADFv2 using different activities like Move & Transform, Copy, filter, for each, Data bricks etc.• implementation of Databricks transformations (SQL/Python) of data stored in Azure Data Developed Pipelines and Notebooks within Azure synapse. Choosing correct data storage solution to meet the technical and business requirements.• Implemented ETL workflows using AWS Glue ETL and EMR, ensuring efficient data extraction, transformation, and loading. Utilized AWS cloud services including EMR, Redshift, Glue, and S3 for data processing and storage.• Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source systems into snowflake table.• Extensively worked on performance tuning of the ETL process and SQL optimization on a large database. Automated the jobs in production environment.• Experience in migrating the data from on-prem to Azure Cloud. Experience in CICD model of deployment using GitHub and Jenkins.• Experience in writing the Solution Design Documents, gathering requirements and provide estimates for new development and change request.• Effective communication skills, work ethics and the ability to work in a team efficiently with good leadership skills.• Ardent desire to learn new technologies with positive attitude.• Ability to work independently and as a part of team.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.