Mano Ranjith A

Offering over 6.2 years (Dec 2016 to till date) experience in IT in various projects. Worked in various tools like Informatica ETL tool, Oracle DB, Linux server and commands and AWS. Have extensively worked in developing ETL program for supporting Data Extraction, transformations, and loading it using Informatica Power-center. Dedicative and extensive experience on collaborating with stakeholders, promptly identifying needs and recommending products and services to accomplish stakeholders goals. Highly adaptable team leader with excellent background of quick and effective performance.

• Father's Name: Mr.Arunachalam
• Date of Birth: 06/15/95
• Marital Status: Single

• Worked in Informatica ETL tool and developed workflows using task developer, worklets designer, and workflow designer in workflow manager and monitored the results using workflow monitor.
• Analyzing the business requirements with Business Analyst and translated into Informatica mappings to build data warehouse by using Informatica designer, which populated the data into the target.
• Working with various transformations like router, expression, filter, lookup, normalizer, and aggregator in building complex mapping.
• Applying slowly changing dimensions like type 1 and 2 effectively to handle the data loads.
• Performing the unit testing and integration testing.
• Troubleshooting and debugging if any issues occurs while integrating the workflow.
• Involved in understanding the whole application business scenarios and reporting it to the stake holders and in which they can use it for downstream process.
• Extensively involved in complex relational Oracle/SQL server queries to help with data validation.
• Using SQL, continuously monitoring and updating the database and delivering the data with maximum accuracy to the business.
• Worked on AWS services like EC2, IAM, S3, RDS, Lambda, VPC, SNS, SES, SQS, EBS, EFS, Cloud watch, Cloud Formation, Dynamo-Db, Load balancing, Auto-Scaling.
• Creating, modified and deleting IAM users, groups, roles, policies according to the requirement.
• Implementing and managing EC2 instance and storage of files in S3 depends on requirement.

1.SHIRE- Healthcare products, Accenture Solutions Pvt.Ltd., Dec 2016 – Aug 2018, Software Analyst

2.Amazon India private limited, Feb 2020 –till date, Catalog Lead