Sign in

Developer Data

Renton, Washington, United States
August 14, 2018

Contact this candidate


Anjani Geethika Gade +* (206) (247) 5642 Renton, WA


• 7 years of experience in development using different ETL tools.

• Strong knowledge in designing Informatica mappings and workflows

• Having skills and experience in B2B data transformations and Unix Shell scripting.

• Good working knowledge on Oracle 10g, 11g and Teradata 13.

• Effective team player with proven interpersonal, communication and presentation skills. TECHNICAL SKILLS:

Database Oracle 10g, 11g, Teradata 13

ETL tools Informatica Power Center 9.5, 9.1, IBM Infosphere Datastage 8.1 EXPERIENCE

ETL Developer

AvivaInsurance, UK May’14 to Mar’18

The Implementation project provides new applications for policy and claims administration comprising of Guidewire PolicyCenter

(PC) and Guidewire Claims Center (CC) integrated into the existing Aviva IT landscape. The objective of the project is to build new ETL system for data warehouse on Teradata using Agile methodology. Responsibilities:

Converting given input XMLs to flat files using serializer project of B2B Data transformations using different serializers like Alternative serializer, Content serializer, String serializer, Group and Repeating group serializer.

Developing mappings using transformations like Joiner, Router, Update strategy, Union, Source qualifier, Lookup, Expression and Aggregator.

Working on SCD type 0,1,2,3 logics using Informatica mappings.

Self-Reviews, IQA & EQAs. Testing the code for all possible scenarios.

Prepared Parameter files in UNIX for the Informatica mappings. Worked on wrapper scripts. Environment - Informatica Power Center 9.5, Teradata 13, UNIX and B2B. Informatica Developer

GE Consumer Finance, Bangalore, India Feb’12toMay’14 GE consumer finance is a finance company which sells products like credit cards to the borrowers like individual customers or business entities through distribution channels like Retailers, Telemarkets, Internet and Mail. This project is to generate decisions regarding customer accounts based on their regular payment of EMI. Responsibilities:

• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.

• Developed Workflows using task developer and workflow designer in Workflow manager and monitored the results using workflow monitor.

• Created Test cases for the mappings developed and then created integration Testing Document. Environment : Informatica Power Center 9.1, Oracle 11g Datastage Developer

AXA Insurance, Chennai, India Feb’11toJan’12

The objective of this system is to retrieve input data feed files from Burgundy system utilizing a secure FTP services running on AXA B2B Gateway, transform or translate the data if required, prepare data feeds for recipient systems and publish or distribute the data to appropriate recipients in a timely manner.


• Analyzing and understanding business requirements.

• ETL Jobs and Sequences design.

• Bug fixing, performing Unit testing and Integration testing Environment - Datastage 8.1, Oracle 10g


Bachelors of Engineering from JNTUK, India Sep’ 06 – Apr ‘10

Contact this candidate