SUMMARY:

• Over Seven years of experience in Analysis, Design and Development of Data warehousing solutions and in developing strategies for data extractions from various sources and transforming the data to fit business needs.
• Strong experience in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies. Experience in dimensional and relational database design.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing using Informatica Power center 9.1/8.6.1 and Ab Intio.
• Expertized in ETL tool Ab Initio using GDE Designer. Very good working experience with all Ab Initio components and well versed with various Transformations, Partitioning, DE partitioning, and working on Dataset and Database components.
• Constructed many AbInitio graphs using components like Join, Lookups, Reformat, Sort, Rollup, Filter by expression, Dedup Sorted, and Replicate etc.
• Highly experienced in ETL tool Informatica 9.1/8.6.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.
• Experience in creating Mappings and Mapplets using various Connected and Unconnected transformations like Source Qualifier, Expression, Lookup, Filter, Joiner, Union, Router, Rank, Sequence Generator and Update Strategy transformations etc.
• Created Reusable Transformations, Mapplets, Sessions and Worklets and made use of the Shared Folder concept using shortcuts wherever possible to avoid redundancy
• Expertise in working with relational databases Oracle 11g, SQL Server 2008, 2012 and working knowledge on Teradata and Netezza.
• Hands on experience in System Testing, Unit testing and Integration testing.
• Created requirement specification documents and mapping documents.
• Extensive experience in writing efficient and well-tuned SQL Queries.
• Experience in developing Unix Shell Scripts for automation of ETL process.
• Over 7 years of experience in Autosys scheduling Tool.

TECHNICAL SKILLS:

Dataware housing: Informatica Power Center 8.6.1/9.1, Informatica Designer, Workflow Manager, Work flow Monitor, ETL, Mapplet, Ab Initio GDE

Databases: MS SQL Server 2008/2012, Oracle (10g/9i), Teradata, Netezza

Scheduling Tools: Autosys

Reporting Tools: Oracle BI Discoverer reporting tool, Crystal reports

Programming Languages: SQL,UNIX Shell Scripting, PL/SQL

Operating Systems: Windows, Unix(IBM AIX), Linux

PROFESSIONAL EXPERIENCE:

Confidential

Lead Ab Initio/Unix Developer

Responsibilities:

• Participated in meetings with Users, Business analysts in understanding the business requirements
• Working as a lead developer and engineering point of contact.
• Involved in design of various graphs and Extensively used various components like Input, Output (Table/File), Filter by Expression, Rollup, Sort, Sort with in Groups, Dedup sort, Reformat and Join etc...
• Performed major role in understanding the business requirements and designing and loading data into Data Warehouse (ETL).
• Extensively involved in Data Extraction, Transformation and Loading (ETL) from Source to Target systems using Abinitio.
• Developed many UNIX shell scripts
• Using Autosys tool for Job scheduling
• Documentation of all modules for user level and system level maintenance.

Environment: Ab Intio ETL Tool, Unix, Autosys, Toad for Oracle, Netezza

Confidential

Informatica Developer

Responsibilities:

• Working with business users and business analyst for requirements gathering
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Technical Requirements Analysis and preparing technical design decisions.
• Development of ETL process and UNIX scripts.
• Prepared migration documents to move the mappings from development to testing and then to production repositories.
• Handling delivery by leading offshore team and coordinating with different stakeholders
• Taking Responsibility of project role outs and implementations within the specified SLAs.
• Integration testing of ETL process, UNIX shell scripts and queries.

Environment: Informatica power center 9.1, Unix, Autosys, Oracle SQL Developer

Confidential

Ab Initio Developer

Responsibilities:

• Extensive usage of Multifile system where data is partitioned into four/eight partitions for Parallel processing.
• Wide usage of Lookup Files while getting data from multiple sources and size of data is limited.
• Developed Generic graphs for data cleansing, data validation and data transformation.
• Responsible for cleansing the data from source systems using Ab Initio components such as Join, Dedup Sorted, Denormalize, Normalize, Reformat, Filter-by-Expression and Rollup
• Worked on Departition Components like Concatenate, Gather, Interleave and
• Merge in order to departition and repartition data from Multifiles accordingly.
• Worked on Partition Components like Partition-by-key, Partition-by-expression,
• Partition-by-Round Robin to partition the data from serial file.
• Tuning of Ab Initio graphs for better performance
• Development of ETL process and UNIX scripts.
• Scheduled Jobs using Autosys scheduling tool

Environment: Ab Initio GDE, EME, Unix, Autosys, Teradata

Confidential

Informatica Developer

Responsibilities:

• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems oracle 10g, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Developed UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.
• Creating ad-hoc reports by using oracle BI discoverer tool based on the queries given

Environment: Informatica Power center, Autosys, SQL Server, UNIX, Oracle BI discoverer tool