PROFESSIONAL SUMMARY:

• 6 years of experience in implementing Data Warehousing & Business Intelligence application end - to-end
• 6 years of experience in Informatica, UNIX, SQL and PL/SQL
• Exposure to Design, Development and Implementation of data warehousing projects
• Good understanding and experience with Data Modeling (ErWin), including both ER and Dimensional modeling
• Efficient in performing Data cleansing, Scrubbing and validating the data before loading the data into Data Warehouse
• Knowledge in Performance tuning,
• Knowledge of data warehousing techniques, Star / Snowflake schema, ETL, Fact and Dimension tables, Physical and logica data modeling, OLAP and Report delivery methodologies
• Has noledge on Informatica 9.x architecture and has good admin noledge like configuring various services, taking back up, restoring Backups and user level operations.
• Good experience in Production Support, Identifying root causes, Trouble shooting and Submitting Change Control
• xperience in working with Web Service Hub (WSH) and running the WSH workflow using tryit and SOAPUI
• Strong Experience in using Informatica Data Quality (IDQ) tool for discovery and cleansing, deduping and data standardization using Profiling techniques, Address Validator, Standardizer, Labeler and etc. transformations to maintain quality of data.
• Building a process in IDQ for cleansing and migrating global customer data from different source systems
• Has experience in integrating Various Data Sources like Oracle, Amazon Redshift and SaleForce using Informatica Cloud
• Experienced in development and data load into BigData - Hadoop HDFS using Informatica PowerCenter and Hive 3 years of IT experience in design, development of Data Warehousing applications using Ab initio (ETL).
• Has good noledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema.
• Used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Ab Initio.
• Has good experience in ETL tool Ab Initio in using GDE Designer. Very good working experience with all the Ab Initio components.
• Well versed with various Ab Initio Transform, Partition, Departition, Dataset and Database components.

TECHNICAL EXPERIENCE:

Databases: Teradata, Oracle 10g, DB2, Oracle

Languages: SQL, PL/SQL, UNIX Shell programming

Scheduling Tools: Autosys, Control -M.

ETL Tools: Ab Initio (GDE 3.15,3.13,3.0.3), EME,Informatica

Teradata Tools & Utilities: BTEQ, Multi Load, Fast Load, Fast Export,Tpump, Teradata Manager, SQL Assistant, Teradata AdministratorModeling Tools:

DB Tools /Utilities: Toad, SQL Plus, TeradataSQL Assistant, Fast load, Multiload, TPT

MS Tools: MS Project, MS Word, MS Excel

PROFESSIONAL EXPERIENCE:

Confidential, Strongsville Ohio

Informatica Developer

Responsibilities:

• Interacted with various client group (Data Services, Vendors etc.) for requirement analysis, design specification, Project and Test plans.
• Co-ordinated and led Onsite-Offshore team
• Created/Modified Business requirement documentation.
• Created Detail ETL Specification Documents.
• Subscribers and Members.
• Automated Sessions and Workflows by using Informatica Scheduler.
• Used Command Tasks to call UNIX Scripts. Extracted Data from EDW/EDM as per specification for End Client requests.
• Used Complex SQL Logic to extract data from EDW.
• Tuned SQL by running Parallel queries after Analyzing Execution Plan.
• FTP'd the File using Session property FTP Connection to Informatica Server.
• Created and used reusable Mapplets and transformations using Informatica Power Center.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Design and Development of ETL routines, using Informatica Power Center Within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Stored procedures, functions, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.

Environment: Informatica Power Center 9, Oracle 11g, SQL Developer, UNIX Script

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Extensively used Informatica 9.x/8.x ETL tool for data transfers from Legacy systems to Oracle warehouse.
• Profiled the data using Informatica Data Explorer (IDE) and performed Proof of Concept for Informatica Data Quality (IDQ).
• Worked closely with project management and assisted in ensuring timely and effective implementation.
• Created the test cases and assisted in UAT testing.
• Actively participated in code reviewing and assists to ensure developers follow the standards. Provide quality reviews for the work of other team members when required.
• Assist DBA and Architect to identify proper distribution keys for Netezza tables
• Used Informatica power center 9.x to Extract, Transform and Load data into Teradata Data Warehouse from various sources like Oracle and flat files.
• Extensively worked with Informatica Developer (IDQ) - Expression, Match, Standardizer, Address Validator, Labler, Key Generator, etc to maintain the quality of information and make recommendations for improvements.
• Migrated IDQ mappings to Informatica Power Center to schedule the jobs within the Power Center client tools.
• Creating Connections, Task flows and Schedule information for the Informatica Cloud Data Synchronization/Replication tasks
• Working on Informatica Cloud to integrate the various data Source like Oracle, Amazon Redshift and Saleforce
• Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various complex mappings, mapplets, reusable transformations, session tasks and Workflows.
• Performed extraction, transformation and loading of data from various heterogeneous sources like Oracle, SQL Server, MY SQL, Flat Files, etc and loaded into Data Marts (Oracle, Teradata, Paraccel) using Informatica.

Environment: Informatica Power Center 9, Oracle 11g, SQL Developer, UNIX Script

Confidential

Informatica Developer

Responsibilities:

• Extensively worked with Informatica Developer (IDQ) - Expression, Match, Standardizer, Address Validator, Labler, Key Generator, etc to maintain the quality of information and make recommendations for improvements.
• Migrated IDQ mappings to Informatica Power Center to schedule the jobs within the Power Center client tools.
• Creating Connections, Task flows and Schedule information for the Informatica Cloud Data Synchronization/Replication tasks
• Working on Informatica Cloud to integrate the various data Source like Oracle, Amazon Redshift and Saleforce
• Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various complex mappings, mapplets, reusable transformations, session tasks and Workflows.
• Performed extraction, transformation and loading of data from various heterogeneous sources like Oracle, SQL Server, MY SQL, Flat Files, etc and loaded into Data Marts (Oracle, Teradata, Paraccel) using Informatica.

Environment: Informatica Power Center 9, Oracle 11g, SQL Developer, UNIX Script