* Designed and developed the Workflows, Worklets, Mappings, Mapplets, Sessions, Tasks, transformations and scheduled the Workflows and Sessions* Interacted with end users and functional analysts to identify and develop a Business Specification Document and transform it into technical requirements* Strong experience with Informatica tools - Source Analyzer, Mapping designer, Mapplet designer, Transformations Developer, Informatica Repository* Designed and Developed complex mappings to move data from multiple sources like flat files, DB pull to a common target area such as Data Marts and Data Warehouse using lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator, Update Strategy from varied transformation logics in Informatica* Experience in Task Automation using UNIX shell scripts, Job Scheduling, and communicating with server using pmcmd* Extensively used Autosys for Job Monitoring and Scheduling* Excellent analytical, problem-solving, and communication skills with the ability to interact with individuals at all levels* Exposure to overall SDLC flow including requirement gathering, data modeling, development, testing, debugging, deployment, documentation, and production support* Prepared Unit/Systems Test Plan and test cases for developed mappings* Responsible for developing, supporting, and maintaining the ETL (Extract, Transform, and Load) processes using Informatica Power Center* Performed tuning of the mappings by removing the Source/Target bottlenecks and Expressions to improve the throughput of the data* Identify the flow of Information, analyze the existing systems, evaluate alternatives, and choose the most appropriate alternative* Used SQL Override in Source qualifier to customize SQL and filter data according to the business requirements

* Identify the flow of Information, analyze the existing systems, evaluate alternatives, and choosing the most appropriate alternative* Monitor and troubleshoot batches and sessions for weekly and monthly extracts from various data sources across all platforms to target database* Extensively used Autosys for Job Monitoring and Scheduling

Internship in Unity Game Development

Internship on Internet of Things