Shreyas Meshram
Pune
Summary
Experienced, results-oriented, resourceful, and problem-solving Data engineer with leadership skills. Adapt and met the challenges of tight release dates. Over 8.6+ years of diverse experience in the Information Technology field including the Development, and Implementation of various applications in Informatica Power Center, Oracle environments and cloud knowledge.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Senior Software Engineer (Informatica Developer)
EPAM SYSTEMS INDIA PVT LTD
05.2021 - Current
- Involved in gathering the requirement and creating the technical design, and work breakdown structure documents.
- Developed and maintained ETL pipelines using Informatica Power Center 10.5/10.2
- Oversaw development, configuration, and deployment procedures of Salesforce Data Integration using Informatica Power Center.
- Design the Patterns to load data from Oracle DB into Salesforce using Informatica Powercenter.
- Created Mappings and Templates to use Salesforce different types of Bulk or Standard Batch Loads features
- Involved in Design, Development, Configuration, Testing, Implementation, and Maintenance of ETL processes.
- Used Informatica Designer to develop mapping specifications for various sources like flat files and relational databases (Oracle, MS SQL Server).
- Implemented various transformations like Normalizer, Aggregator, Rank, Lookup, Update Strategy, Expression, and Sequence Generator Experience
- Experience in developing various workflows like Session and Event Wait, Decision, Timer, Email, and Assignment to move data from source to target
- Monitors and tunes ETL jobs for optimal performance and implements performance-tuning techniques.
- Worked on the Data Purging SQL script to purge the historical irrelevant data.
Senior Software Engineer (Informatica Developer)
Tech Mahindra Ltd
03.2019 - 05.2021
- Understanding of HLD (High Level Document) given by the Solution Technical Architect.
- Prepared the Unit test cases and updated operational documents on a timely manner.
- Collaborated with onshore counterpart by attending daily/biweekly status call.
- Developed and maintained ETL processes using Informatica Power Center 9.6.1 to load feeds file to respective tables are then used to develop CUBE in SQL Server Management Studio.
- Designed and created cubes using SQL Server Analysis Services (SSAS). Prepared Money Map Report using SSAS CUBE to present it to Senior management.
- Tracked the daily task and ensured timely delivery on the respective requirements.
- Determining project requirements and developing work schedules for the team.
- Delegating tasks and achieving daily, weekly, and monthly goals.
- Liaising with team members, management, and clients to ensure projects are completed to standard.
- Motivating staff and creating a space where they can ask questions and voice their concerns.
Informatica Developer/Support Analyst
Syntel Pvt Ltd
02.2016 - 02.2019
- Understanding of requirements and Solution architect document. Prepared Technical design documents (TDD), unit test cases documents, and Application workbook (AWP).
- Developed mappings, workflows and tasks using Informatica PowerCenter
- Collaboration with onshore counterpart by attending the daily status call.
- Participate in development activities.
- Good exposure to Undraleau for code review Track daily tasks and ensure timely delivery. Unit test, coding and support QA/UAT testing.
- Identified, troubleshot and corrected bugs and bottlenecks.
Software Engineer (Datastage Developer)
Syntel Pvt Ltd
06.2015 - 02.2016
- Shadowed the senior developer in their tasks. Supported in the day-to-day activities.
- Migrated the Sybase queries to Oracle queries. Modified the datastage parallel Jobs
- Managed the defect management lifecycle using HPALM tool.
- Delivered unit-tested systems within customer-prescribed timeframes.
- Corrected, modified and upgraded software to improve performance.
Education
Post Graduation Diploma in Advanced Computing (PG-DAC) - Information Technology
CDAC ACTS, Pune - 411007
Pune02.2015
B.E (Information Technology) -
Sipna College of Engineering And Technology, Amravati - 444701
Amravati07.2013
Skills
- Informatica PowerCenter
- Data Warehousing Concepts
- Oracle SQL
- Unix
- Control-M Development
- Informatica - Salesforce Cloud (nCino) Integration
- Basics of Python
- SAP BO
- Technological Integration
Accomplishments
- Received an Delivery Excellence Award for the year 2023 from EPAM Systems
- Received an Delivery Excellence Award for the year 2022 from EPAM Systems
- Received an Pat on Back Award Award for the year 2019 from Tech Mahindra Ltd
Languages
English
Marathi
Hindi
Awards
DELIVERY EXCELLENCE AWARD, 11/24/21 PAT ON THE BACK AWARD, 12/25/19
Certification
- Amazon Cloud Certified Practitioner
Timeline
Senior Software Engineer (Informatica Developer)
EPAM SYSTEMS INDIA PVT LTD
05.2021 - Current
Senior Software Engineer (Informatica Developer)
Tech Mahindra Ltd
03.2019 - 05.2021
Informatica Developer/Support Analyst
Syntel Pvt Ltd
02.2016 - 02.2019
Software Engineer (Datastage Developer)
Syntel Pvt Ltd
06.2015 - 02.2016
Post Graduation Diploma in Advanced Computing (PG-DAC) - Information Technology
CDAC ACTS, Pune - 411007
B.E (Information Technology) -
Sipna College of Engineering And Technology, Amravati - 444701
Similar Profiles
Shivam SohaneShivam Sohane
Senior Software Test Automation Engineer at EPAM Systems India Pvt. Ltd.Senior Software Test Automation Engineer at EPAM Systems India Pvt. Ltd.
Farooq Ahamad MohammadFarooq Ahamad Mohammad
Senior Software Developer at E2OPEN SOFTWARE INDIA PVT LTDSenior Software Developer at E2OPEN SOFTWARE INDIA PVT LTD
JINESH SONIJINESH SONI
Project Manager at Brainvire Infotech Pvt LtdProject Manager at Brainvire Infotech Pvt Ltd