Sashrutha Manoharan

Data Engineering Associate

Accenture

Bengaluru

06.2023 - Current

Delivered secure, scalable ETL solutions, integrating data across systems using Informatica IICS, Oracle SQL/PLSQL, and Unix scripting.
Built over 50 reusable Informatica mappings and task flows, utilizing transformations like lookups, routers, aggregators, and update strategies to load data into data marts/warehouses.
Automated ETL pipelines with Unix shell scripts, handling job scheduling, exception handling, and pre/post-SQL tasks, reducing manual efforts by 40%.
Created and optimized database objects (tables, views, indexes, triggers), enhancing data retrieval speed and consistency by 30%.
Designed and implemented relational schemas for high-volume transactional data, improving accuracy and reducing query time significantly.
Built staging file generation and loading interfaces using Shell scripting and PL/SQL to streamline the ingestion of large datasets.
Successfully migrated and reconciled over 1,000 customer records during post-acquisition integration, ensuring 100% alignment with the existing system.
Authored comprehensive technical and functional design documents to standardize interface development across teams.
Used Git for version control, participated in code reviews, and collaborated with QA teams to ensure clean, production-ready deployments.
Partnered with business analysts and end users to convert BSDs into technical specs, and handled production support and change requests.
Monitored production environment for errors or anomalies that could affect system performance.
Compiled and analyzed data from tests and experiments to support engineering solutions.