Summary
Overview
Work History
Education
Skills
Interests
Timeline
Generic

Itishree Dixit

ETL Developer
Bengaluru

Summary

Working in Accenture as Data Engineer Specialist having 10+ years of ETL development experience. A proficient programmer in Informatica Power Center and Unix Shell Scripting having strong experience in Extraction, Transformation and Loading (ETL) process using Informatica Power Center 10.5(Designer, Workflow Manager and Repository Manager) in financial and Healthcare services domain. Responsible for Solution Design, Requirements Gathering, Business Analysis, Business Process Design and Mapping, Functional Analysis, Program Management. collaborated with engineering team and user designers following Agile methodology to deliver best in class solutions for business users Worked extensively on all Informatica Designer tools including (Source Analyzer, Target Designer and Mapping Designer), created Informatica Mapping, Parameter file configuration, Data validation and handled error, Configured & executed parameter files and workflow/sessions for the mappings.Prepared functional, technical, Code review, Peer review, Checklist, Migration/Deployment documents, extensively worked on Informatica Workflow Manager and Workflow Monitor to build sessions and run workflows. Have sound knowledge of Unix Shell Scripting, worked on Unix Shell scripting to handle Email Notification and File movement across different environment. Sound understanding of Relational Database Management Systems like Oracle 10g, SQL SERVER 2008 R2, DB2, MYSQL, Amazon Redshift (Aginity) . Basic knowledge on Informatica Cloud Services and Azure Data factory. Have experience of working in Banking & Pharmaceutical domain. Provided support to the Lead Architect, Senior Management, Segment heads to develop the strategic vision and architectural direction for client for Digital, reflecting alignment of technology to business strategy. Developed Strategy for business growth of the account, delivered artefacts that addressed aspects such as current and target state, future roadmaps of the account.

Overview

10
10
years of professional experience

Work History

DATA Engineer Specialist

Accenture
Bengaluru
08.2021 - Current
  • Used strong analytical and problem-solving skills to develop effective solutions for challenging situations.
  • Skilled at working independently and collaboratively in a team environment.
  • Identified, troubleshot and corrected bugs and bottlenecks.
  • Implemented business logic parameters for model execution.
  • Collaborated with business analysts to understand and define requirements.
  • Developed mappings, workflows and tasks using Software.
  • Designed and developed forward-thinking systems that meet user needs and improve productivity.
  • Analyzed work to generate logic for new systems, procedures and tests.
  • Conducted data modeling, performance and integration testing.
  • Created proofs of concept for innovative new solutions.
  • Translated technical concepts and information into terms parties could easily comprehend.
  • Coordinated deployments of new software, feature updates and fixes.

MINDTREE

Module Lead
Hyderabad
11.2020 - 08.2021
  • Mindtree Ltd is an Indian multinational information technology and outsourcing company, headquartered in Bangalore, having revenue (US$1.1 Billion, 2020)
  • Client : Wolters LKluwer
  • This project aims to extract, transform and load the data from Master Database to Warehouse Analytical Layer with strict quality check
  • Data from source files (UCC_SDI File and CHT SDI File) loaded to landing tables
  • The data extracted from landing standardized to a generic structure and loaded to staging
  • Data got stored with history in Warehouse
  • Responsibilities included:
  • Troubleshooting of the data issues
  • Solving Bugs in the Dashboards
  • Development of the lower and higher level codes
  • Creating mappings to load data from one database to another
  • Integrating and Unit testing
  • Technical and Architecture documentation of various Processes
  • Creating and maintaining Datawarehouse
  • Creating ADF pipelines to store files into Azure Blobs.

ETL Developer

SAAMA TECHNOLOGIES
Pune
01.2019 - 11.2020
  • Actionable insights, driven by the industry's #1 AI-powered clinical analytics platform, give you the intelligence required to manage risk and improve Business
  • Client : Insmed
  • Life Science Analytics Cloud is the leading AI-powered clinical analytics platform that seamlessly integrates, curates, and animates data, delivering more actionable insights.

WIPRO | ETL Developer

Pune
10.2017 - 01.2019
  • Wipro is an Fortune India 500 (rank 29 by revenue) multinational corporation that provides information technology, consulting and business process services
  • Client : Charles Schwab
  • The Charles Schwab Corporation is a bank and brokerage firm which offers an electronic trading platform for the purchase and sale of financial securities including common stocks, preferred stocks, futures contracts, exchange-traded funds, options, mutual funds, and fixed income investments
  • It also provides margin lending, and cash management services, as well as services through registered investment advisers
  • Project objective was to develop new jobs (SCD, Event, Snapshot) according to project requirement and maintenance of all other running Informatica objects.

Associate

COGNIZANT TECHNOLOGY SOLUTION
Pune
02.2015 - 09.2017
  • Cognizant (NASDAQ 100) is an American multinational technology company that provides business consulting, information technology and outsourcing services
  • Bank Julius Baer
  • The objective is to replace OLYMPIC Banking System to T24 Banking System from where we get source in the form of flat file(CSV) and XML which contains static and Master, and Transactional and Processed data (real time data) and loads the data into ODS tables (both for SINGAPORE and HONG KONG instance)
  • Responsibilities Included:
  • Client : Allergan
  • Allergan, Plc is a multi-national pharmaceutical that produces branded and generic drugs, and performs pharmaceutical research and development
  • Migrating existing DataStage ETL Jobs to Informatica 10.1
  • Project objective is the analysis of up and running existing DataStage code to create equivalent Informatica objects
  • Responsibilities Included:
  • Troubleshooting of the data issues
  • Solving Bugs in the Dashboards
  • Development of the lower and higher level codes
  • Creating mappings on FAE to load data from one database to another
  • Integrating and Unit testing
  • Technical and Architecture documentation of various Processes
  • Creating and maintaining Datawarehouse
  • Developing Informatica jobs for processes like SCD, Event, Intra-day Changes, Snapshot
  • Working on MongoDB and using it both as a source and target (writing data to MongoDB) through Informatica jobs
  • Working on performance tuning and troubleshooting issues as and when required
  • Performing root cause unit testing and provide support during user acceptance testing
  • Discussing project roadmap and solution with client and project stakeholders
  • Developing mappings for both xml and csv files to load data from T24 to ODS (staging)
  • Working extensively on different types of transformations like xml parser, expression, filter, aggregator, lookup, joiner
  • Working on Performance Tuning & data validation for all the mappings developed
  • Doing Reverse Engineering on DataStage jobs, UNIX scripts & their conversion to corresponding Informatica code
  • Working on Informatica mapping creation and Performance Tuning of Informatica Mappings/sessions
  • Performing root cause analysis, resolving UAT issues, validating all data and performing routine tests on databases
  • Proactively monitoring the system from data load perspective and taking required actions to improve implementation
  • Working on user defined functions as per business requirement

Software Engineer

SYNTEL PVT LTD
Pune
12.2012 - 01.2015
  • Atos Syntel is a subsidiary of Atos and a multinational provider of integrated technology and business services
  • The company is led by Rakesh Khanna
  • Atos Syntel was created by the acquisition of Syntel, Inc
  • By Atos S.E., which was announced on July 22, 2018 and completed on October 9, 2018
  • Client : Anthem
  • Enterprise Provider Database Solution (EPDS) v2.0 is the centralized provider repository for Anthem Enterprise that accommodates current and future state provider Demographic, Contracts, Affiliations, and Network data
  • This system has a web- based front-end GUI that provides Provider Operations the ability to view, add and update provider data
  • Provider data is passed to other Enterprise Applications for further processing and claims payment
  • Responsibilities Included:

Education

B. Tech - Information Technology

Silicon Institute of Technology, Kendriya Vidyalaya Balasore
04.2008 - 7 2012

12th - undefined

04.2006 - 7 2007

Skills

Informatica Power Centerundefined

Interests

Business Solutions

Timeline

DATA Engineer Specialist

Accenture
08.2021 - Current

MINDTREE

Module Lead
11.2020 - 08.2021

ETL Developer

SAAMA TECHNOLOGIES
01.2019 - 11.2020

WIPRO | ETL Developer

10.2017 - 01.2019

Associate

COGNIZANT TECHNOLOGY SOLUTION
02.2015 - 09.2017

Software Engineer

SYNTEL PVT LTD
12.2012 - 01.2015

B. Tech - Information Technology

Silicon Institute of Technology, Kendriya Vidyalaya Balasore
04.2008 - 7 2012

12th - undefined

04.2006 - 7 2007
Itishree DixitETL Developer