SUSHMITHA T
Ponneri
Summary
Results-driven Informatica ETL Developer with 3.2 years of hands-on experience in Informatica PowerCenter, Informatica Cloud (IICS), Snowflake, Oracle, AWS, Unix shell scripting, data warehousing & BI concepts. Skilled in analysis, designing, development, implementation, testing, and support of data warehousing and data integration solutions using Informatica PowerCenter and IICS.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Informatica ETL Developer
Tech Mahindra
05.2023 - Current
- Company Overview: After sales Data Mart application is aimed to be the single source of data for analytics covering entire Nissan North America Aftersales domain to create universe and dashboards for the users for reporting and analysis purposes
- Worked on complete Software Development Life Cycle (SDLC) from Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation and Post Implementation Support
- Identified ETL specifications based on business requirements and will ensure that all solutions and processes are aligned to architectural/requirement specifications and creating ETL MDD & WDD Technical Documentation for same
- Handled and developed complex informatica cloud mappings, tasks & task flows using IICS Data integration
- Handled data modelling, performance tuning and end-to-end ETL flow from development to testing and production environments
- Production Support has been done to resolve the ongoing issues and troubleshoot the problems
- Responsible for code implementation & peer review, bug fixing, Problem-solving and testing across all the environments
- Experience of handling Slowly Changing Dimensions to maintain the complete History
- Used various cloud connectors in IICS like (S3, Snowflake) and Loaded data from S3 into Snowflake using ETL mapping
- Participating in daily Scrum call (Kanban) with customer and providing all the status to team and customer and updating JIRA at the user story level every day and drive it to completion
- After sales Data Mart application is aimed to be the single source of data for analytics covering entire Nissan North America Aftersales domain to create universe and dashboards for the users for reporting and analysis purposes
Informatica Developer & Application Support
Nissan
08.2021 - 05.2023
- Company Overview: Automobile company in the United States
- Gather client requirements for new and existing logic enhancements
- Coordinated directly with Client-side Business Analyst in getting requirements and converting the same into coding
- Worked in RTB as Application owner for ETL Applications (ADAM, CRM, INCAR, CVMS & NDSN)
- Having support knowledge, worked on high priority tasks like P2, P3 & P4 and resolved within SLA
- Automated most of manual process or Ad hoc loads using PowerCenter Mappings and UNIX scripts
- Provided 24x7 production support for business users and solutions for running the workflows
- Conducted follow ups for clients based off SLAs as necessary as part of the support
- Created and managed documentation for all release changes and improvement planning
- Automobile company in the United States
Education
Bachelor of Engineering - Electrical And Electronics Engineering
RMD Engineering College, Kavaraipettai
Chennai01.2020
12th (Senior Secondary Examination) -
Velammal Matriculation Higher Secondary School, Panchetti
01.2016
10th (Secondary Examination) -
Velammal Matriculation Higher Secondary School, Panchetti
01.2014
Skills
- Informatica IICS
- Informatica PowerCenter
- SQL
- Snowflake
- AWS
- TWS
- Oracle
- PostgreSQL
- UNIX Shell Scripting
- Windows 10
- Linux
- Oracle SQL Developer
- JIRA
- Service now
- Git hub
- Jenkins
- Bitbucket
Certification
AWS certified Cloud Practitioner (02/01/2024)
DECLARATION
I hereby declare that the above written particulars are true to the best of my knowledge and belief.
Timeline
Informatica ETL Developer
Tech Mahindra
05.2023 - Current
Informatica Developer & Application Support
Nissan
08.2021 - 05.2023
Bachelor of Engineering - Electrical And Electronics Engineering
RMD Engineering College, Kavaraipettai
12th (Senior Secondary Examination) -
Velammal Matriculation Higher Secondary School, Panchetti
10th (Secondary Examination) -
Velammal Matriculation Higher Secondary School, Panchetti
Similar Profiles
Sandeep GinkaSandeep Ginka
Product Cost Engineer at Tech Mahindra Ltd., India & Tech Mahindra (America) Inc. USAProduct Cost Engineer at Tech Mahindra Ltd., India & Tech Mahindra (America) Inc. USA
Hemanth Kumar BangaruHemanth Kumar Bangaru
Team Lead at Tech Mahindra, Tech Mahindra Pvt LtdTeam Lead at Tech Mahindra, Tech Mahindra Pvt Ltd
Vinita HasabeVinita Hasabe
VAS Manager at Tech Mahindra Tech MahindraVAS Manager at Tech Mahindra Tech Mahindra
VISHNU RAMKISAN INGOLEVISHNU RAMKISAN INGOLE
Senior Network Engineer at Tech Mahindra, Payroll by RLAB (Client- Mahindra & Mahindra)Senior Network Engineer at Tech Mahindra, Payroll by RLAB (Client- Mahindra & Mahindra)
AKASH SRINIVASANAKASH SRINIVASAN
Quantity Surveyor - Projects at Sadhana Jennifer Constructions Private LimitedQuantity Surveyor - Projects at Sadhana Jennifer Constructions Private Limited