Mallikarjuna Paramsetty

About Mallikarjuna Paramsetty

Having 6+ Years of IT experience in Analysis, Design, Development ETL this includes mapping creation and designing Informatica development/Informatica Production Support, Monitoring & Maintaining performance of databases and Control-M jobs.* Skilled in gathering business requirements, converting them into functional and technical specifications, and developing mapping documents.* Strong experience in ETL processes using Informatica Power Center, including Repository Manager, Designer, Workflow Manager, Workflow Monitor.* Worked with various data sources such as Oracle, MS SQL Server, fixed-width and delimited flat files, and XML files.* Performed data quality checks and generated error reports for validation failures.* Involved in major and minor enhancements based on business requirements, including production issue resolution.* Proficient in Workflow Manager tools, including Task Developer, Workflows & Worklet Designer, and managing, scheduling, and monitoring workflows.* Experienced with all transformations, including connected and unconnected transformations like Remote Lookup, Aggregator, Expression, Filter, Router, Update Strategy, Sequence Generator, Sorter, and Rank.* Integrated various data sources into staging areas.* Extensive experience in end-to-end development, unit testing, and deployment activities.* Knowledgeable in creating CI/CD pipelines using GitHub for code deployment.* Performed DML operations to address various issues.* Involved in end-to-end testing for Informatica upgrades, ensuring 100% quality data delivery.* Managed weekly, monthly, and annual tasks, and sent daily reports to business teams.* Used SQL tools like Oracle SQL Developer, Teradata, and MySQL for running queries and validating data.* Participated in weekly and monthly maintenance activities, delivering extracted data on time.* Good knowledge of Teradata and Greenplum, including creating macros, performance tuning, and building CI/CD pipelines.* Strong skills in SQL, Unix scripting, Control-M jobs, and creating macros and JIL files using Autosys.* Experienced with performance tuning techniques.

Experience

1. Developer Iii-software Engineering

   UST

   Apr 2021 — Present · Hyderabad, IN

   Project : EDSDSC DRE DDL Technologies Technologies Company : US TechnologiesClient name : Dell technologiesDell Role : Informatica Development

Education

• JNTU Anantapur

  Bachelor of Engineering - BE, Electrical and Electronics Engineering