NISHA SHARMA

• Working for Westpac Bank for 3 years 5 months and handled multiple Projects like JSON PROJECT (2023 to till date): Working on OP Cache (JSON) Project to load data from Source into IFF file in the form of Array Structure with help of Informatica PowerCenter Tool, conducted performance tuning and optimization of ETL scripts and SQL queries to improve data processing efficiency
• Performed multiple solutions to load million data into tables
• Used UNIX Commands at informatica session level to add last bracket and remove last comma in the output JSON file.

• Designed, developed and implemented ETL processes to extract data from various sources, transformed it to fit business needs, and loaded it into data warehouses or other target systems.
• Collaborated with business analysts and data architects to understand data requirements and translate them into ETL solutions.
• Optimized and tuned ETL processes for performance and scalability.
• Monitored ETL jobs, troubleshoot issues, and ensured data integrity and quality.
• Developed and maintained documentation for ETL processes, data mappings, and data lineage.

Worked with ETL tools such as Informatica PowerCenter, IICS.

Worked with SQL developer, Oracle to meet Business Requirements.

Worked closely for data profiling, data cleansing, and data quality techniques.

Attended Trainings and completed certifications for Informatica Intelligent Cloud Services, ETL, MySQL, Unix And Hadoop.