Indrajeet Niture
Summary
•10.5 years in Business Intelligence & Data Warehousing.
• Expert in AWS basic cloud concepts.
• Experience in Informatica Power Center (Designer, Workflow Manager, Workflow Monitor and Repository Manager).
• Experience in designing and implementing Data Warehouse and Data mart applications including ETL processes using Informatica.
• Expert in Data warehousing concepts, dimensional Star Schema, Snowflakes Schema methodologies and SCD type 1-2.
• Responsible for understanding & documenting business processes, managing business users to meet specific user requirements, adept in handling design & coding functions.
•Expertise in AutoSys Scheduling Tool, Creating and monitoring Autosys Jobs.
• Well versed in UNIX Operating System and Shell scripting.
• Known for strong analytical skills and collaborative approach to problem-solving.
• Adept at adapting to rapidly changing technologies and team environments.
Overview
10
10
years of professional experience
Work History
Informatica Migration From 10.2 to 10.5
MUFG Bank
04.2024 - Current
- Migrating the informatica code from informatica 10.2 version to 10.5
- The new UNIX server will be used
- More than 8 applications and 200 plus informatica objects will migrate
- All the workflows are triggered by job scheduler (Autosys)
- Responsibilities: Understanding the application flow and process
- Creating the required repositories on informatica 10.5
- Migrating the all informatica objects from 10.2 to 10.5 in receptive folders
- Validating the connections with target/source database
- Creating the GIS mailbox for SFTP process
- Updating the autosys job jils
- Validation of all the migrated and updated components
GRC AWS Migration
MUFG Bank
01.2023 - 03.2024
- The GRC portfolio was using On-Perm data center
- The supporting technologies were going to EOL for on-perm data center
- So, bank has decided to move the database to AWS data services
- Responsibilities: Requirement gathering, design & analysis
- Procure the AWS server
- Establish the all applications and required tool on new AWS servers
- Open Firewall between new AWS servers and upstream-downstream servers to establish the connection between them
- Create the databases with required size and properties on AWS servers
- Create IAM groups and roles to maintain access security on servers
- As part of change management, take all the necessary approvals
- Migrate the databases from old on-perm to new AWS servers
NFRR
MUFG Bank
08.2020 - 12.2022
- MUFG has complex data and reporting structure across institution due to multilevel legal entity structure
- Due to limited data aggregation capability, report generation mostly relies on manual process
- It entails high level of risks such as low accuracy, time consuming
- As part of NFRR project, well structured data warehouse will be created
- A robust and user friendly reporting environment will build
- Responsibilities: Requirement gathering, design & analysis
- Interacting with client/stakeholder, set up business meeting to clarify design queries, suggest alternatives, provide regular status to clients, prepare and get detail design document sigh-off
- ETL code development using Informatica Power Center 10.2 abiding client coding standards
- Assign development task, peer review and capture unit testing results
- Support components, system and end-to-end unit testing, manage and fix defects, get sigh-off at each stage
- Provide KT sessions to support team before production deployment, support live proving activity
Informatica Migration from 9.5.1 to 10.2
MUFG Bank
12.2019 - 07.2020
- Migrating the informatica code from informatica 9.5.1 version to 10.2
- The new UNIX server will be used
- More than 10 applications and 300 plus informatica objects will migrate
- All the workflows are triggered by job scheduler (Autosys)
- Responsibilities: Understanding the application flow and process
- Creating the required repositories on informatica 10.2
- Migrating the all informatica objects from 9.5.1 to 10.2 in receptive folders
- Validating the connections with target/source database
- Creating the GIS mailbox for SFTP process
- Updating the autosys job jils
- Validation of all the migrated and updated components
Enterprise Data Warehousing (General Ledger)
MUFG Bank
11.2015 - 11.2019
- Collecting transnational data of bank customers from different sources at the end of a business day in a Centralized Data Warehouse (Greenplum), containing lowest level of data of subject areas for one time analysis and statistics about changing business
- Data is sourced from flat files coming from mainframe systems, cleansed and transactions are validated using UNIX scripting and Informatica and dumped into Greenplum database for the downstream applications
- Informatica workflows are scheduled using AutoSys scheduling tool
Union Bank Data Warehousing (UDW)
MUFG Bank
01.2015 - 11.2019
- Worked in all the SDLC stages like Requirement Gathering, Design Documents, Coding, Testing and Deployment
- Used transformations like Joiner, Expression, Router, Aggregator, Filter, SQL Transformation, Stored Procedure, Lookup, and Update Strategy
- Developed mappings, sessions, workflows to source the data from flat files and oracle database
- Worked on SCD type1 and SCD type2 dimension
- Created and scheduled AutoSys jobs to trigger UNIX scripts, Informatica workflows or any other tasks
- Created UNIX shell scripts to call Informatica workflows, create script logs and trigger the success and failure emails
- Worked extensively on mapping variables and session parameters
- Used debugger to identify bugs and validate the mapping
- Used Deployment Groups to migrate objects across various environments
- Automation: Developed UNIX scripts to automate monitoring tasks
- Worked on process improvement by optimizing the queries and minimizing job run timings
- Support and monitoring after development phase
- Overview: Collect the data from more than 50 sources and load it into a data warehouse as a data capture process
- Data is sourced from Flat files, Oracle and Greenplum database
- Separate AutoSys box job is created for every source to run the Informatica workflows
Education
Bachelor of Engineering - Information And Technology
Gov. College of Engineering Aurangabad
Aurangabad 01-2014
Higher Secondary - Science
Vivekand College
Aurangabad 01-2010
Senior Secondary -
State Board of Maharashtra
Aurangabad01-2008
Skills
- Data warehousing
- ETL development
- SQL expertise
- Unix
Awards
• Received Client appreciation for automation done for daily monitoring for critical applications.
• Received five ‘On the Spot Award’ from Project Management as appreciation of my work in the project.
• Received Star Team Award for the Success of DR Exercise.
Timeline
Informatica Migration From 10.2 to 10.5
MUFG Bank
04.2024 - Current
GRC AWS Migration
MUFG Bank
01.2023 - 03.2024
NFRR
MUFG Bank
08.2020 - 12.2022
Informatica Migration from 9.5.1 to 10.2
MUFG Bank
12.2019 - 07.2020
Enterprise Data Warehousing (General Ledger)
MUFG Bank
11.2015 - 11.2019
Union Bank Data Warehousing (UDW)
MUFG Bank
01.2015 - 11.2019
Bachelor of Engineering - Information And Technology
Gov. College of Engineering Aurangabad
Higher Secondary - Science
Vivekand College
Senior Secondary -
State Board of Maharashtra
Similar Profiles
Chie Okada-Wighe 岡田知恵Chie Okada-Wighe 岡田知恵
Economist (Japanese-English Bilingual) at MUFG BankEconomist (Japanese-English Bilingual) at MUFG Bank
Tapas Kumar ParidaTapas Kumar Parida
Assistant Vice President at MUFG BankAssistant Vice President at MUFG Bank
JAMUNA RAMACHANDRANJAMUNA RAMACHANDRAN
Trade Finances Professional- Global Trade Services at MUFG BANKTrade Finances Professional- Global Trade Services at MUFG BANK