Lead informatica Developer
Nationwide Insurance
(Internet and Information Technology, < 10 employees)
Skills
My area of experience primarily spans the tools and technologies in the vast field of Business Intelligence [BI] and Analytics service delivery. I am well versed in the Data Warehousing concepts. My assignments have made me work in a spectrum of tools and processes i.e.
Languages: -
SQL, Basic UNIX
Database: -
Teradata, Oracle, VeevaInformatica PowerCenter client (V9.1,9.6 and 10.2),
PL/SQL Developer,
Toad,
Secure Shell Client,
Enterprise Tidal Scheduler,
Putty,
Cast Iron,
CA workstation
Languages: -
SQL, Basic UNIX
Database: -
Teradata, Oracle, VeevaInformatica PowerCenter client (V9.1,9.6 and 10.2),
PL/SQL Developer,
Toad,
Secure Shell Client,
Enterprise Tidal Scheduler,
Putty,
Cast Iron,
CA workstation
Project history
01/2019
-
Present
- I am working as a Team lead/Senior Developer
- The team consist of Development testing and support entities. My role is to create / design technical specification based on the business logic and work also share the work across the development team.
- Guide and lead the testing teams with the development catered to the UAT environment
- Lead the support team with the ticket allotment bandwidth management, and task allocation (patch fixing the existing component)
04/2016
-
12/2018
Lead informatica Developer
Novartis
(Internet and Information Technology, < 10 employees)
- Worked on Cast iron tool
- Discussing with business users on the requirements
- Analyzing the requirements
- Providing high level and detailed level estimations
- Preparing High level and detailed level technical design documents
- Co-ordination with the team to make sure that things are in line with requirement
- Unit testing, Integration testing followed by defect analysis and resolution
- Providing support to the end user during the UAT
- Responsible for creating the weekly & monthly status reports and update client team on the latest status
05/2015
-
03/2016
Senior Informatica Developer
Symantec
(Internet and Information Technology, < 10 employees)
- Worked as lead developer in the team
- Involved in design phase of the project
- Created mapping, session, workflows.
- Actively participated in Unit testing, QA defect and UAT phase of the project.
06/2013
-
04/2015
Senior Informatica Developer
Credit Suisse
(Internet and Information Technology, 10-50 employees)
- Working as a developer in IRDS.
- Communicating with business to understand requirements which we used to receive in the form of Business Requirements (BRU's) and STTS and Also implementing the same business logics in informatica mappings in Wave-1 and Wave-2.
- Having hands on experience in creating/managing the mappings/mapplets using various transformations.
- Involved in creation of Sessions and Workflows for the developed Mappings and worked on Informatica Mappings, Sessions and Workflows.
- Extensively used different transformations like Source Qualifier, filter, Aggregator, Expression, Connected and unconnected Lookup, Sequence Generator and Router.
- Troubleshoot data issues, validated result sets, recommended and implemented process improvements.
- Preparing the daily status report documentation of onsite and offshore team.
- Involved in daily status calls with onsite.
- Involved in writing Oracle scripts for the complex mappings.
- Running jobs for the mappings developed, through Control-M and UNIX.
- Developed test-cases and performed Unit Testing and Integration Testing.
- Involved in preparing documents such as LLDs, Jobnet (for running jobs) and BOS Document (input to Control-M).
03/2011
-
05/2013
Informatica Developer
EA Sports
(Internet and Information Technology, < 10 employees)
- Development, Production Deployment, Enhancements and Bug Fixes.
- Developed complex mappings and SCD Type-I, Type-II mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank, Router.
- Primarily involved all the design and prototyping for handshaking through TIDAL for all new interfaces and projects.
- Coordination with Onsite Lead and Team members in Development & Testing activities for all the enhancement and bug fixes.
Local Availability
Only available in these countries:
India
