Vinayak Pattar
Bangalore
Summary
Dynamic Lead Software Engineer with extensive experience at Wells Fargo, specializing in ETL processes and data warehousing. Proven expertise in Informatica and Oracle SQL, coupled with strong leadership skills. Recognized for enhancing application performance and driving team development, contributing to significant improvements in project delivery and customer satisfaction.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Lead Software Engineer
Wells Fargo EGS India Pvt Ltd
Bangalore
09.2018 - Current
- Offshore ETL lead managing a team of developers to analyze, design, build and deploy Data Warehouse applications built predominantly using Informatica as the ETL tool and Oracle as the Data Warehouse platform.
- Review technical design documents, code and test plans in addition to imparting technical expertise to the developers in building efficient code. Review the data model of the newly created tables in Oracle database and suggest most optimal table structures.
- Assist with application performance tuning and capacity planning. Promote development best practices and leverage industry standard technology.
- Analyzed development requirements in JIRA portal with Onshore Technical lead, provided design options, work breakdown, and estimates.
- Delegated tasks to the team and monitored progress of work packages to meet delivery timelines. Liaised effectively between onshore and offshore technical teams daily.
- Provided technical input on team members' performance and skills, conducted performance reviews, and focused on team member development.
- Acknowledged as Wells Fargo Champion for valuable contributions to the Application Migration Project.
- Supported financial services at Wells Fargo, contributing to enhanced customer satisfaction.
Associate
Cognizant Technology Solutions Ltd.
Bangalore
02.2014 - Current
- Develop SyncSort DMX-H custom Tasks & Jobs to copy raw data files from Genesys's FTP server to HDFS layer through Edge Node via Named pipe process.
- Developed pre-processing file validation scripts on Edge Node using Linux shell scripting to ensure data integrity through zero byte checks, record count verification, and header/footer reconciliation.
- Code and test a variety of SyncSort DMX-Hadoop Tasks such as Sort, Aggregate, Join tasks to extract, transform and load transactional data from HDFS files to corresponding Hive tables.
- Create external Hive tables that store data in Optimized Row Columnar (ORC) file format for improved performance during reading, writing, and processing operations.
- Configure HCATALOG connection to connect to Hive tables and load transformed data from raw data files to external Hive tables.
- Analyzed call header and call detail requirements to construct Hive aggregation layer by translating mapping specifications into DMX tasks utilizing sort, join, and aggregate operations.
- Leveraged Partitioning and Bucketing strategies in external Hive tables for enhanced query response time.
- Build de-dup layer to compare daily incremental data with History data on the fly and load the cleansed, de-dup delta records from flat files to hive table.
- Executed data analysis operations using Zeppelin to query Hive tables.
- Established audit process to track vital ETL statistics including start time, end time, and completion flag, enhancing data pipeline transparency.
Senior Software Engineer
iGATE Global Solutions
Bangalore
11.2010 - 02.2014
- IGATE is a global technology and services company that provides integrated technology and operations solutions.
- Managed all project modules, executing tasks independently to meet deadlines.
- Developed data for all 5 modules using DMExpress tool, ensuring alignment with project goals.
- Developed automation scripts for all 5 modules.
- Performed QA activities for all 5 modules.
- Gathered and analyzed project requirements to define clear specifications.
- Created a detailed design document outlining project specifications and requirements.
- Conducted data modeling and profiling activities.
- Participated in production migration activities.
Education
Bachelor of Engineering - Computer Science
Visveswaraiah Technological University
07-2010
Pre University College - Science Education
Department of Pre-University Education
06-2006
SSLC -
Karnataka Secondary Education Examination Board
06-2004
Skills
- Informatica PowerCenter 105x
- Teradata 1720
- Oracle SQL Developer
- PL/SQL
- DMExpress 86
- Apache Hadoop-Hive
- Unix Scripting
- Autosys
- Control-M
- Python fundamentals
- Deep learning fundamentals
- Natural language fundamentals
- Azure fundamentals (Certified)
- GitHub
Certification
Azure Fundamentals
Timeline
Lead Software Engineer
Wells Fargo EGS India Pvt Ltd
09.2018 - Current
Associate
Cognizant Technology Solutions Ltd.
02.2014 - Current
Senior Software Engineer
iGATE Global Solutions
11.2010 - 02.2014
Bachelor of Engineering - Computer Science
Visveswaraiah Technological University
Pre University College - Science Education
Department of Pre-University Education
SSLC -
Karnataka Secondary Education Examination Board