Datawarehousing, ETL, Informatica Resume

SUMMARY:

8+ years of extensive working experience in Data Warehousing applications with prime focus on Development, Testing and deployment using Informatica Power Center, UNIX and Windows based platform.
Having experience in implementation of ETL Applications for Sales and Pharma verticals.
Extensive data integration builds and deployment experience using Informatica Power Center 9.5/9.1/8.6/8.1. x/7.1.x, IDQ on both UNIX and Windows based platforms. Good knowledge in interacting with Informatica Data Explorer (IDE ) and Informatica Data Quality ( IDQ ).
Expertise in designing and implementing data integration platform using traditional ETL strategies (SQL / PL/SQL ) as well as tools like Informatica Power Center
Extensively worked on various Active and Passive transformation within the Power Center. Experienced in implementing business rules by creating transformations such as Expression, Aggregator, Unconnected and Connected lookup, Filter, Router, Joiner, Union and Update Strategy.
Good understanding of Data Warehousing concepts and Dimensional modelling (star schema and snowflake schema design); Fact and Dimensional tables, Physical and Logical data modeling. Good understanding of Ralph - Kimball and Inmon approaches to Data Warehousing
Experience in using Teradata SQL Assistant and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, and Exposure to TPump on UNIX/Windows environments and running the batch process in Teradata.
Developed Scripts to use TPT, MLoad, BTEQ, FastExport & FastLoad Teradata utilities and very good hands on these utilities.
Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
Proficient in coding SQL’s, PL/SQL (Procedures, Functions, Triggers and Packages) using SQL * Plus and TOAD. Have used SQL* Loader utility to import data on UNIX and Windows platforms.
Well-versed with debugger to validate the mappings and gain troubleshooting information about data and error conditions.
Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
Proficient in implementing data validation rules and exception handling mechanism while loading dimension and facts.
Expertise in developing and running Mappings, Sessions/tasks, Workflows, Worklets, and Batch processes on Informatica server.
Having extensive hands-on technical proficiencies in developments using databases like Oracle, SQL Server.
Good experience in shell scripts for Informatica pre and post session operations, in UNIX Shell Scripting, CRON, FTP and file management in various UNIX environments.
Good exposure to design, development, testing, debugging, implementation, documentation, production support and responsible for Weekly and Monthly loads.
Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and ability to work independently and as well as part of the team..

TECHNICAL SKILLS:

DI/ETL Tools: Informatica Power Center 9 /8.x /7.x, Informatica Power Connect/Exchange, Informatica Data Explorer, MSBI (SSIS, SSRS), Pentaho 5.x/6.x

Data Modelling / Concepts: ERwin, Star schema, Snow-Flake schema

Database: Oracle 11i/10g/9i, MS SQL Server 2012/2008R2, Teradata v15/v14, DB2, MySQL

Database Utilities / Querying Tools: SQL* Loader, SQL, Transact SQLTOAD, SQL Developer, SQL Navigator, Query Analyzer

Job Schedulers: Maestro, Informatica Scheduler

OPERATING SYSTEM: Windows 10/7/2008/NT/XP, HP UNIX, RHEL Linux, MS-DOS

LANGUAGES: UNIX Shell Scripting, C, PL/SQL

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship