Anjani Geethika Gade

adxtl2@r.postjobfree.com 604-***-**** Vancouver, BC

Expertise summary:

Over 8 years of experience accomplished in ETL development working in Banking and Insurance domains, highly organized, effective leader and communicator.

Professional summary:

Extensive knowledge and experience across the project life cycle.

Experience in Development using ETL tools Informatica Power Center.

Strong knowledge in designing Informatica mappings and workflows as per client requirement.

Having skills and experience in B2B Data Transformations.

Having good working knowledge on UNIX Shell Scripting.

Having good working knowledge on Data Warehousing concepts

Strong hands on experience using Teradata utilities (SQL, B-TEQ, FastLoad, MultiLoad, FastExport, Tpump)

Good working knowledge on Oracle 10g, 11g.

Good knowledge on IBM InfoSphere DataStage and Microsoft SQL Server.

Effective team player with proven interpersonal, communication and presentation skills.

Anticipate and adapt to changing Business Requirements.

Strong experience in developing Use Cases, Test Cases and support business users in preparing UAT scenarios.

Strong skills in coding and debugging Teradata Utilities like FastLoad, FastExport, MultiLoad and Tpump for Teradata ETL processing huge volumes of data throughput.

Proficient in Application Support Management through Study & Analysis of Problem Tickets/Change requests, Impact Analysis and Specification corrections (if necessary)

Involved in requirement gathering phase.

Technical Skill set:

Project Methodologies : Agile, Waterfall

Databases : Oracle 10g, 11g, Teradata 13

ETL tools : Informatica PowerCenter 10, 9.5, 9.1

Defect Tracking : JIRA

Operating Systems : MS Windows 7/10/XP, Mac OS, Linux

Projects Undertaken:

#ETL Developer, CIBC, Vancouver, Canada Apr’22 to Dec’22

Environment: Informatica Power Center 10, Oracle 11g, UNIX

Description:

Mobile Wealth Management Application will be accessible to advisors and other customers, in order to support multiple business area including Asset Management, capital markets, Portfolio Management and Risk Management. Application allows portfolio managers to process orders for various fixed income securities and corporate bonds. The client also wanted to enable its clients to access historical information and generate reports in a faster and more efficient manner over the Internet.

Responsibilities:

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

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

Self-Reviews, IQA & EQAs

Testing the code for all possible scenarios.

Preparing Parameter files in UNIX for the Informatica mappings.

Worked on wrapper scripts.

#Informatica Developer, T-Mobile, Infosys, Bellevue, US Aug’18 to Feb’19

Environment: Informatica Power Center 10, Teradata 13, UNIX

Description:

TDFADS is a DWH which is majorly built to support financial reporting. Datasets like Billing data, Sales data, Finance data are integrated on this platform. TDFADS has data of EDW plus some additional information. Data in EDW is refreshed 3 times a week. So there is an issue with data latency for reports build on EDW. TDFADS are introduced to resolve this issue.

Responsibilities:

Transforming given input as per requirement using different transformations in mappings.

Building workflows and related sessions for mappings.

Preparing SQL script using Teradata SQL

Testing the code for all possible scenarios.

Preparing parameter files in UNIX for Informatica mappings

Worked on wrapper scripts.

Coordinating with offshore.

#ETL Developer, Aviva Insurance, TCS, Bangalore May’12 to Mar’18

Environment: Informatica Power Center 9.5, Teradata 12, UNIX and B2B.

Description :

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 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, Aggregator and Normalizer.

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

Self-Reviews, IQA & EQAs

Testing the code for all possible scenarios.

Preparing Parameter files in UNIX for the Informatica mappings.

Worked on wrapper scripts.

#Informatica Developer, GE Consumer Finance, TCS, Chennai Feb’11 to May’12

Environment: Informatica Power Center 9.1, Oracle 10g

Description:

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,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.

Development of ETL workflows using Informatica.

Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.

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

Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.

Created Test cases for the mappings developed and then created integration Testing Document.

Educational qualifications:

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

Contact this candidate