Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic
Swagatika Jena

Swagatika Jena

Hyderabad

Summary

6.5+ years of IT experience have honed my skills in data warehousing and ETL, with proven expertise in Informatica Power Center and IICS. I bring a holistic understanding of the SDLC, effectively contributing to development, testing, reporting, and production support for robust and reliable Client/Server applications.

Overview

8
8
years of professional experience

Work History

Senior Software Engineer

CGI Inc
Hyderabad
11.2022 - Current
  • Developed and reviewed variety of mappings, mapping tasks & task flows as per the client requirements using IICS (Informatica cloud Data integration) as well as deployed them to production environment.
  • Tested the data after running the task flows using various databases.
  • Prepared the design documents, insert scripts & promotion documents for the created mappings, mapping tasks & task flows.
  • Implemented Informatica transformation like Joiner, Aggregator, Connected & Unconnected Lookups, Filters, Sequence generators, Routers, Update strategy, Expression, Sorter etc.
  • Extensively created file ingestion for transferring files in Amazon S3 bucket.

Senior Software Engineer

Tech Mahindra
Hyderabad
11.2015 - 11.2022
  • Knowledge of developing high performance data warehouse infrastructure that integrates data from a variety of source systems (eg. Accounts Info, NBLG, CLAS, CPP, Billing Info, MCS, Premiums and dividends).
  • Experience in communicating with the client, monitoring of production jobs and troubleshooting issues within stipulated SLA time.
  • Knowledge of creating mappings, sessions and workflows as per the client requirements using Informatica 9.1 tool.
  • Maintained Mahindra Satyam and Customer Quality Standards.
  • Understanding of the overall Project Architecture and the data flow including the Source System Extraction, ETL concepts and Data Warehouse loading.

Education

Master of Computer Applications -

C.V. Raman College of Engineering
Odisha

Bachelor of Science - Physics

Maharshi College of Natural Law
Odisha

Skills

  • Database - Oracle, PostgreSQL, SQL Server 20122014, Adabase, Snowflake
  • ETL Tool - Informatica PowerCenter 10X, 9X, IICS (Data Integration )
  • Reporting Tool - Cognos, Cleo
  • Storage Tool - AWS S3, WinSCP
  • Testing tool - Undralue, Scoret
  • Scheduling Tool - Zena, Tidal, Informatica, Jira, Putty, Tortoise SVN
  • Scripting Language - Python, Linux

Accomplishments

    Received 2 "Pat on the back" in Tech Mahindra while working as a Developer.

Timeline

Senior Software Engineer

CGI Inc
11.2022 - Current

Senior Software Engineer

Tech Mahindra
11.2015 - 11.2022

Master of Computer Applications -

C.V. Raman College of Engineering

Bachelor of Science - Physics

Maharshi College of Natural Law

Similar Profiles

CREATE PROFILE
Swagatika Jena