Nishikanta Swain

Technology Analyst with extensive experience and hands on working knowledge in various domains of the IT industry. I am an adept learner, in a constant pursuit to enhance my career and keep myself equipped and updated with the industry standards. Currently, I have around 5 years of experience in IT with hands-on experience in Informatica PowerCenter, AutoSys, Informatica Intelligent Cloud Services, Infogix, SQL etc.

Technology Analyst at INFOSYS (2025-04 – Present)

• Involved in the design, implementation, and maintenance of a data warehouse and data mart solution using Informatica PowerCenter and Intelligent Cloud Services (IICS).
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Sorter, and Sequence Generator transformations.
• Used Informatica reusability at various levels of development.
• Created and scheduled sessions, jobs based on demand, run on time, and run only once. Building reports according to user requirements.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Worked with different non-relational Databases such as Flat files, XML files, Mainframe Files
• Engaged in discussions with SME/Business analyst to enhance the performance of data mappings.
• Installed and configured Windows Secure Agent register with IICS org
• Created IICS connections using various cloud connectors in IICS administrator
• Extensively used cloud transformations - Aggregator, Expression, Filter, Joiner, Lookup (connected and unconnected), Rank, Router, Sequence Generator, Sorter, Update Strategy, Union Transformations
• Developed Cloud integration parameterized mapping templates (DB, and table object parameterisation) for Stage, Dimension (SCD Type1, SCD Type2, CDC and Incremental Load) and fact load processes
• Provided support and maintenance for production ETL processes, actively troubleshooting issues, and implementing effective solutions.
• Overseeing the team's efforts in monitoring and maintaining application performance, promptly addressing issues, and meeting the SLA expectations.
• Building reports according to user requirements.
• Lead the team in claims monthly release which involves development work.
• Involved in identification and decommissioning of GreenPlum jobs.

Systems Engineer/Senior Systems Engineer at INFOSYS (2021-09 – 2025-03)

• Implemented python-based solution for identification and validation of personally Identifiable Information (PII) by employing advanced text processing techniques.
• Generated reports highlighting PII Instances, validation outcomes and any potential issues.

Bachelor of Technology in Computer Science – Silicon Institute of Technology, Bhubaneswar (2021)