Shreya Gupta Email & Phone Number

Gurugram, Haryana, India

• Analyzing data and developing or understanding ETL specifications for data integration solutions• Extracting data from various heterogeneous sources, including Oracle, SQL Server, and flat files, into the target database and CSV files for ERP Oracle Cloud using OIC while identifying and resolving data integration issues• Developing Informatica mappings and reusable transformations to facilitate the timely loading of data while adapting to new technologies and methodologies• Creating Stonebranch workflows and tasks to schedule Informatica workflows and ensure successful execution while improving performance and scalability• Performing unit testing and supporting the QC team through environmental testing in QA and UAT environments• Creating stored procedures, and writing merge statements to load and update data in dimension tables while optimizing performance and ensuring data accuracy• Developing Informatica mappings and Stonebranch tasks to load data from CSV-format BIP reports generated by the ERP into dimension tables• Created functional & technical documentation - e.g., data integration architecture flows, source-to-target mappings, ETL specification documents, run books, and test plans• Created change requests for deploying objects to higher environments and created Stonebranch bundles of the workflows or tasks required for deployment to higher environments• Participated in design review sessions and ensure all solutions are aligned with pre-defined architectural specifications• Reviews work objects (Technical design documents, ETL code, Unit testing documents etc.)• Provide technical assistance in identifying, evaluating, and developing systems and procedures• Proactively communicate innovative ideas, solutions, and capabilities over and above specific task requests• Providing knowledge transfer to new team members and leading a team of four members while continuously developing their skills and expertise

Bengaluru Area, India

• Excelled in analyzing, designing, developing, implementing, testing, and supporting Data Warehousing and Data Integration solutions using Informatica PowerCenter at Wipro Technologies• Demonstrated a high level of proficiency in developing SQL with various relational databases and exhibited extensive knowledge of full life cycle development of data warehousing• Spearheaded the development of ETL programs to support data extraction, transformation, and loading using Informatica PowerCenter• Successfully demonstrated a deep understanding of business rules based on high-level document specifications and implemented effective data transformation methodologies• Worked with UNIX shell scripts to run Informatica workflows and control the ETL flow, and skilfully used Autosys to process through the job runs• Performed complex troubleshooting, root-cause analysis, and solution development independently with remarkable proficiency• Possess strong leadership qualities with the ability to meet deadlines, handle multiple tasks, and adapt flexibly to work schedules

Bachelor Of Technology (B.Tech.), Information Technology

Pcm