A self-motivated ETL INFORMATICA developer with 6+ years of experience in Informatica and a wide knowledge of service-now. Using problem-solving skills to identify and troubleshoot data issues, develop solutions to optimize the data flow, and ensure the accuracy and completeness of the data. And create automated processes for extracting, transforming, and loading large amounts of data.Throughout my career, I have worked on diverse projects, ranging from small-scale applications to large enterprise systems. I am proficient in Informatica Power Center and experienced in data extraction, data transformation, and data loading. Extracted data from Oracle database using SQL, APIs, files, and web services, and transformed into a required format followed by cleaning, filtering, and aggregating data from different sources as mentioned. The transformed data was loaded into the target Oracle database. After loading the data for data quality assurance the test cases were written and data validation, data profiling, and data cleansing were performed to check accuracy and consistency. Used performance optimization techniques to increase speed and efficiency, monitored the ETL jobs to make sure they ran smoothly, and troubleshot the issues when they arose. Experienced in creating documentation for ETL process such as work flow executions using Informatica Power Center Workflow Monitor (detailed information about status, progress, session logs, error message, statistics), Informatica Power Center Workflow Manager (to manage, design and schedule workflows), Informatica Power Center Repository Manager (to edit and view repository mappings, workflows, sessions and monitor usage and dependencies), Informatica Power Center Designer (graphical development tool used to create and configure workflows for ETL processes). Continuous Improvement of the ETL process was done depending on new requirements for performance optimization. Besides being an ETL developer I am experienced as a QA and skilled in Cucumber, JavaScript, Python, and Postman, with good hands-on using Git, and Jira. Experienced working in waterfall, and Agile Project Management environments. I have a proven track record of successful project delivery and a commitment to staying ahead of emerging technologies. I am eager to leverage my expertise to drive impactful contributions in dynamic software development environments.