informatica teradata developer
Resume:
Sharma Neha *************@*****.***
Professional Summary:
Having 3.2+ years of professional experience in the implementation of Data Warehousing projects with the tools like TERADATA and INFORMATICA.
Significant Strengths:
Have around one year experience on Informatica tool.
Extensively worked on Data extraction, transformation, loading with Oracle, Flat Files using Informatica
Having 2+years of experience as a Teradata Developer.
Currently working as a Teradata developer.
Good Understanding in protection concepts like Fallback, Raids, and Journals
Worked with Teradata 12 utilities like BTEQ, Fast Load, Multi Load and Query man.
Have experience on implementing business rules in BTEQ scripts.
Worked with parameters like UPI,USI and other Indexes.
Proficient in understanding business processes / requirements and translating them into technical requirements.
Did Data Reconciliation across Source System
Worked with different sources like Flat files and Relational Databases.
Strong Knowledge on Data warehousing concepts.
Ability to work in groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
Having basic knowledge on UNIX.
Work Experience:
Working as a Software Engineer for HSBC Global Technologies, Hyderabad from Jun 2008 to july 2012.
Education:
B.Sc. Barkatulla University Bhopal
PGDCA, Barkatulla University Bhopal.
Technical skills:
Operating Systems Windows Family, UNIX Basics
RDBMS Teradata v2r12), Oracle 9i,10g
Tools Informatica 8.6
Query Tools
Tools BTEQ, Query man
Teradata Utilities Fast load, Multi Load, Fast Export
Project Title: RDC – ARW Maintenance and Enhancements
Client : HSBC Technology Services(HTSA), USA, Buffalo
Organization : HSBC Global Technology, Hyderabad
Duration :oct 2011 to july 2012
Role : Teradata Developer
Project description:
HSBC is a global banking and financial services company headquartered in Canary Wharf, London, United Kingdom As of 2011 it was the world's second-largest banking and financial services group and second-largest public.
This product offering is a benefit of the “Check Clearing for the 21st Century” (Check 21) legislation that enables financial institutions to provide substitute checks as legal tender for check processing, in place of the original US paper checks. ARW is a warehouse of the data from an Image Exchange file.Data in this warehouse is to be maintained for minimum 8 years.
This Project involves the creation of a Data Warehouse for the Sales Reporting System. Data from Operational Source System is extracted and loaded into data warehouse Using Teradata.
Roles and Responsibilities:
• Initiated sit down sessions with the Sales team for requirement gathering. Created and loaded tables, views
• Created scripts using FastLoad, Multi-Load to load data into the Teradata data warehouse.
• Involved in Sql scripts Macros, stored procedures in Teradata to implement business rules.
• Updated numerous Bteq/Sql scripts, making appropriate DDL changes and completed unit and system test.
• Involved in peer to peer reviews.
• Identifying Bugs and reporting defects.
• Knowledge transition to new team member.
• Daily Communication regarding the status of the work to Onsite coordinator
Project Title: Debt Manager-Recovery Management
Client : Avago, Finance DSO
Duration : aug 2010 to sep 2011
Role : ETL Developer.
Environment : Informatica Power Centre 8.6.0, Oracle 10g, Teradata V2R6, Windows 2000
Project description:
Avago Finance DSO provides daily sales out standings to its customers.The objective of this project and applications describes the functional requirements gathered for different receivable reports and build Data Marts for all metrics of Overview, AR Balance, Payments Due, Effectiveness, Payment Performance, Customer Report, and Invoice Details. Based on these metrics, they analyze their business and make the decisions to improve the business. Distributed data residing in heterogeneous data sources is consolidated into the target Teradata database. Performing some Aggregate calculation. Data Mart is developed in Star Schema Fashion consisting the Facts and Dimensions. The sources included Oracle databases. Using these Facts and Dimensions BI Team generate the various types of reports and distributed to Company Level.
Roles & Responsibilities:
• Uploaded data from operational source system (Oracle 8i) to Teradata.
• Used utilities of FLOAD, MLOAD, FEXP of Teradata and created batch jobs using BTEQ.
• Imported Metadata from Teradata tables.
• Prepared BTEQ scripts to load data from Preserve area to Staging area.
• Worked on Teradata SQL Assistant querying the source/target tables to validate the BTEQ scripts.
• Involved in peer to peer reviews.
• Identifying Bugs and reporting defects.
• Knowledge transition to new team member.
• Daily Communication regarding the status of the work to Onsite coordinator
• Daily Communication regarding the status of the work to Onsite coordinator
Project Title: HSBC Cards
Client : HSBC Technology Services, USA
Organization : HSBC Global Technology, Hyderabad
Duration : June 2009 to July 2010
Role : ETL developer
Description:
HSBC is a global banking and financial services company headquartered in Canary Wharf, London, United Kingdom As of 2011 it was the world's second-largest banking and financial services group and second-largest public.
One HSBC cards project is used to find out the performance of their product across various regions and the also the business behavior across the territories.
Responsibilities:
Responsible for Extracting, Transforming and Loading data from Oracle and placing it into Data warehouse.
Worked extensively on different types of transformations like Expression, Aggregator, Lookup, Sequence Generator and Joiner.
Involved in testing the Informatica Objects to validate the test data based on the test data.
Creating / Building and Scheduling workflow and Sessions using the Workflow manager.
Involved in unit testing.
Involved in reviewing the Mappings.
Contact this candidate