RAJ KUMAR
Bangalore
Summary
Accomplished Senior Software Engineer with 9 years of experience at Wells Fargo & Co., specializing in all phase of development, including Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using IICS Informatica Cloud and Power Center(Repository Manager, Designer, Server Manager, Workflow Manager and Workflow Monitor). Expertise in IICS Informatica Cloud ETL Development using CIH, CDA, CAI. Proven track record in data warehousing and agile project management, resulting in significant improvements in data quality and performance metrics. Expertise in coordinating with offshore teams to optimize data processes for critical banking applications. Dedicated to leveraging technical skills to drive innovation in future software projects.
Overview
10
10
years of professional experience
Work History
Senior Software Engineer
Wells Fargo & Co.
08.2016 - Current
- Implemented solution enhancing risk assessment through historic trends and predictive modeling.
- Handles vital software related to banker certification and authorization.
- Transitioned PC code functionality to IICS platform.
- Engineered and executed advanced ETL workflows leveraging IICS for efficient data integration.
- Configured diverse cloud connectors for creating IICS connections within the administrator interface.
- Gathered datasets from distinct origins, including RDS, SQL Server, Oracle, and Flat Files.
- Developed efficient interfaces through optimized Informatica techniques.
- Compiled target listings by interpreting requirements and organizing them into structured documentation.
- Designed and supervised data loads utilizing Abinitio GDE graphs, Business Rule Engine, UNIX, and Autosys.
- Continuously supported production by overseeing scheduling of ETL and NDM jobs.
- Authored high-quality functional and technical documentation for various projects.
- Enhanced data governance through meticulous auditing and monitoring.
- Optimized mapping performance to enhance efficiency.
- Addressed and resolved technical challenges to enhance system performance.
- Strengthened collaboration between teams through active representation in meetings.
- Coordinated data loads across 45 banking applications catering to branch, ATM, customer, mortgage, and teller systems.
- Supervised Informatica mappings for seamless reporting for end-users.
- Enhanced existing ETL systems through targeted improvements and optimizations.
- Provided customized reporting solutions based on operational demands.
Technical Analyst
ITTI Private Limited
07.2015 - 07.2016
- Developed and validated ETL processes for migrating sales compensation data from staging tables to the main database, focusing on Oracle DB
- The project supported sales force and compensation calculations, adjusting workflows as per changes in products, commissions, and product lifecycle events
- Created SQL and PL/SQL queries to validate data migration and ensure accuracy in the target tables
- Supported the business in ensuring proper data loads for sales compensation calculations
- Validated reference and transaction data for consistency
- Assisted in report generation for month-end finalization and compensation reporting
Education
Bachelor of Engineering - Computer Science
Anna University
Vellore, India03-2015
Skills
- Skilled in Cloud-Based ETL Processes
- Experienced with IICS CAI Implementation
- Applied Knowledge of Informatica IDMC
- Experienced with Informatica PowerCenter 105
- Ab Initio GDE Expertise
- Ab Initio Express IT Data Processing
- ETL design and implementation
- Proficient in ETL Tools
- Proficient in APIGEE/APIC
- IBM LSF Platform Manager
- CA AutoSys Job Scheduling
- Experience with UrbanCode Deploy
- Version Control Expertise Using Git
- Jenkins Pipeline Management Skills
- Oracle PL/SQL Development
- Data validation
- SQL analytics
- Performance tuning
- UNIX Operating System
- Agile Project Management
- Data Warehousing Expertise
- Lifecycle Management in Software Development
Timeline
Senior Software Engineer
Wells Fargo & Co.
08.2016 - Current
Technical Analyst
ITTI Private Limited
07.2015 - 07.2016
Bachelor of Engineering - Computer Science
Anna University
Disclaimer
I do here by declare that the information provided in this form is true to do the best of my knowledge and belief.
Similar Profiles
Jimmy FerrellJimmy Ferrell
Business Execution Consultant at Wells Fargo & Co.Business Execution Consultant at Wells Fargo & Co.
Rhonda PezzorelloRhonda Pezzorello
Information Security Associate Manager at Wells Fargo & Co.Information Security Associate Manager at Wells Fargo & Co.
Kanmani SomasundaramKanmani Somasundaram
Business Systems Consultant at Wells Fargo & Co.Business Systems Consultant at Wells Fargo & Co.