Sruthi Rose Thomas
Etl Developer and Analyst @Inspire
Signup · Get unlimited contacts
WORK HISTORY
Etl Developer and Analyst @Inspire
NJ, US
Created new mapping designs using the various tools in Informatica Designer like SourceAnalyzer, Warehouse Designer, Mapplet Designer and Mapping Designer. Developed the mappings using Transformations in Informatica tool according to technicalspecifications. Created complex mappings that involved implementation of Business Logic to load datain to staging area. Used Informatica reusability at various levels of development. Developed mappings/sessions using Informatica Power Center for data loading. Performed data manipulations using various Informatica Transformations like Filter,Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy,Joiner, Sorter and Union. Developed Workflows using task developer, Worklet designer and workflow designer inWorkflow manager and monitored the results using workflow monitor. Extracted data from Oracle and SQL Server then used Teradata for data warehousing. Created mappings and workflows in Informatica, Scheduled and implementedexecution through Control M. Raised tickets in JIRA and ServiceNow and coordinated with other teams like DBA’s andApplication admins for deploying code to Production. Monitored and provided Level 1 support in ETL load for the custom Informaticamappings. Set up mail notifications for start, stop, error and success with stats of the load. Worked with IICS to develop various mappings and tasks involving several businesslogics to extract the data from various application such as SalesForce and OraclePlatform and load the data into the respective. Developed various IICS Tasks using DSS (Data Synchronization), DRS (DataReplication), Saved Queries and Complex Cloud Mappings, Mapping Tasks, Task flowsand creating Re-Usable Assets. Involved in Batch design, and Automated/Scheduled the Cloud jobs to run daily withemail notifications for Success or Failures Participated in daily scrum meetings with Squad lead and SMEs for businessrequirements.
EDUCATION
Vellore Institute of Technology
Master of Technology - MTech
Karunya Institute of Technology and Sciences
Bachelor of Technology - BTech
ABOUT SRUTHI ROSE THOMAS
Around 7+ years of experience in Requirement gathering, Analyzing, Planning, Coding, ETL, Test Execution, Defect management and UAT in Agile/Scrum and waterfall SDLC models.• Extensive Datawarehouse, DataMart modeling and Query development experience in Oracle, SQL Server, Teradata and Netezza.• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment. • Good experience in working with business analysts to identify, study and understand requirements and translated them into ETL code in Requirement Analysis phase• Experience in Extract, Transform and Load (ETL) data using Informatica BI tool.• Qualified to Build, Generate, and analyze reports with various Data Visualization tools including Business Objects, Microstrategy Reporting Tools and Tableau.• Expertise in financial services domains like Risk management, Regulatory Reporting (FFIEC) and Capital Markets.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.