Peddiraju Mulagala
ETL Technical Lead
Toronto,OR
Summary
Over 8+ years of IT expertise in Technical Leadership, Analysis, Design, Development, Implementation, Testing, and Production Support for Data Warehousing and Data Analytics applications.
Overview
8
8
years of professional experience
Work History
Technical Lead
Scotiabank
4 2019 - Current
- Provided technical leadership to development and testing teams, ensuring efficient project execution
- Aligned technical solutions with project timelines and business goals through collaboration with project management
- Designed scalable solutions for IB AML projects, maintaining compliance with best practices
- Conducted performance tuning, code reviews, and process optimization in a Hadoop environment with Hive and Diyotta ETL.
- Coordinated with cross-department teams like QA, DevOps, and Support to ensure seamless end-to-end software delivery process.
- Mentored junior developers through regular 1-on-1 meetings, providing guidance on best practices, coding standards, and career growth opportunities.
- Enhanced system performance with thorough code reviews, debugging, and optimization techniques.
- Led a team of developers to successfully deliver high-quality software projects on time and within budget constraints.
- Increased application stability by regularly monitoring performance metrics, addressing bottlenecks proactively to minimize downtime occurrences.
- Maintained close communication with clients throughout project life cycles for accurate progress reporting and prompt issue resolution.
- Mentored junior developers, providing guidance and support to accelerate their professional growth.
Technical Analyst
Diyotta India Private Limited
08.2016 - 03.2019
- Developed and optimized ETL processes in Hadoop and Amazon Redshift environments
- Designed mappings and business logic using Diyotta and SQL, and ensured efficient data loading and transformation.
Education
Master of Computer Applications -
JNTU University, Kakinada
India09.2014
Skills
Project Leadership
Functional requirements understanding
Technical Mentoring
Design development
Code Review Expertise
Mentorship and coaching
Issue investigation
Performance Optimization
Automation methods
Cost-benefit analyses
Multitasking
Reliability
Projects
Project 1: IB AML EDL.
This Project involved, It is mandatory for financial institutions to conduct anti-money laundering (AML) risk assessments to determine the overall risk rating of their customers. The assessment and subsequent rating are derived using a risk rating methodology based on industry standards and rules defined by regulatory bodies. The purpose of this document is to outline the processes and strategies for the maintenance of the IB AML for Customer Risk Rating and Name Scanning (CRR and NS) project.
Project 2: PMI (Philip Morris International) .
This Project involved in development of a Data Warehousing code which loads customer information form of JSON files and loading to the staging area (PostgreSQL) where we applied all the Business logics using the required transformations and Stored Procedures and Unix Scripts where ever required and loading the transformed data to the Amazon Redshift.
Languages
English
Bilingual or Proficient (C2)
Timeline
Technical Analyst
Diyotta India Private Limited
08.2016 - 03.2019
Technical Lead
Scotiabank
4 2019 - Current
Master of Computer Applications -
JNTU University, Kakinada