SUMMARY

• Around 7 years of experience in Information Technology with a strong background in Data Warehousing, Business Intelligence and ETL process using Informatica PowerCenter 9.1/8.x/7.x and Informatica Data Quality and Informatica Data Analyst tools and expertise skills in reporting using the Business Objects.
• 2+ years data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Extensive work experience in the areas of Banking, Finance, Insurance and Manufacturing Industries.
• Extensively used ETL methodology for supporting of Extract, Transform, and Load environment using Informatica Power Center 8.x/7.1 (Designer, Repository manager, Repository Server Administrator console, Server Manager, Work flow manager, workflow monitor).
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer, Schedulers and Warehouse/Target Designer.
• Expertise in Extracting and Transforming data using DTS in SQL Server 2000, SSIS in SQL Server 2005, SQL Server Import Export, Bulk Insert and BCP.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Normalizer, Union, and XML Source Qualifier.
• Highly experienced in developing, designing, reviewing and documenting Informatica work products like Mappings, Mapplets, Reusable transformations, Sessions, Workflows, Worklets, Schedulers and experienced in using Mapping parameters, Mapping variables, Session parameter files.
• Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions.
• Analyzed and designed the database. Involved in database normalization process.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, transformations and sessions.
• Proficiency in using Informatica Power Center tool to design data conversions from wide variety of sources
• Experience in integration of various data sources like Oracle, SQL server and MS access and non - relational sources like flat files into staging area.
• Extensively worked with SQL loader for bulk loading into the oracle database.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflake Schema methodologies, fact and dimension tables and Dimensional modeling, OLAP and OLTP process.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Experience with SQL Plus and TOAD as an interface to databases, to analyze, view and alter data.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Highly adept at creation, execution, testing and debugging of Informatica mappings, mapplets, sessions, tasks, worklets and workflows in UNIX and Windows environment.
• Excellent overall software Development life cycle (SDLC) experience, Conceptual and Logical thinking, Goal oriented, self-motivated and able to work independently and as a member of a team.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center/Power Mart 9.x/8.x/7.x, Power Exchange 8.x/9.x, Data stage, Talend

Business Intelligence: Business Objects 6.5/5.1.7, OBIEE 10.1.3.2/ 10.1.3.3/ 10.1.3.4

Databases: Oracle 11g/10g/9i/8i, SQL Server, Greenplum 4.0/4.1

MS SQL Server 2000/2005/2008 :

Big Data Ecosystems: Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop

Languages: UNIX, Shell scripting, SQL, PL/SQL, C

Web Technologies: HTML, DHTML, Joomla 1.6

Design: ERWin Platinum 4.0/3.5

Tools: MS Office Suite 2003, TOAD, SQL Plus, Autosys r11.x, PGAdmin III, SQL Developer Data Modeler

Operating Systems: UNIX, Windows 9x/2000/XP/VISTA, DOS

PROFESSIONAL EXPERIENCE:

Sr Informatica Developer

Confidential, Hines, IL

Responsibilities:

• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Profiled the data using Informatica Data Explorer (IDE) and performed Proof of Concept for Informatica Data Quality (IDQ).
• Parsed high-level design specification to simple ETL coding and mapping standards.
• 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 procedures in Oracle Database.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Responsible for creating artifacts for Rational Unified Process (RUP) - use cases, system architecture document using UML, supplemental requirements document and architecture diagrams.
• Designed and Developed Oracle PL/SQL and UNIX Perl/Shell Scripts, Data Import/Export.
• Designed Mappings using B2B Data Transformation Studio.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Experienced in scheduling Sequence and parallel jobs on Autosys Production and Lower environments using UNIX perl scripts and JIL (Job Information Language).
• Understanding web application based on J2EE Struts framework.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on Informatica B2B Data Exchange that allows supporting the expanding diversity of customers and partners.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, Worklets, Assignment, Timer and scheduling of the workflow.
• Designed and developed reports using Crystal Reports XI version.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Shared responsibility for administration of Hadoop, Hive and Pig.
• Managed and reviewed Hadoop log files.
• Designed XML stages for reading XML log files for capturing data stage jobs audit data.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Two years’ experience in configuring and testing Hadoop ecosystem components.
• Setup Multi User Development Environment (MUDE) in OBIEE.

Environment: Informatica Power Center 8.6.1, OBIEE 11g, Workflow Manager, Workflow Monitor, Informatica Power Connect /Power Exchange, Informatica B2B Data Exchange, IBM Infosphere DataStage 8.5, Hadoop, MapReduce, HDFS, Business Objects Data Services 4.0, Crystal Reports XI, Data Analyzer 8.1, PL/SQL, Oracle 10g/9i, Erwin, Autosys, SQL Server 2005, Sybase, UNIX AIX Toad 9.0, Cognos 8, Teradata.

ETL Consultant

Confidential, Stamford, CT

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica Power Center created mappings and mapplets to transform the data according to the business rules.
• Worked on built Process Chains to run data validation before loading Excel files and to load delta load for R/3 data.
• Created tables and partitions in database Oracle.
• Developed PL/SQL scripts to validate and load data into interface tables as the backend was in Oracle and database operations were handled using stored procedures.
• Developed strategic planning, mapping and staging of a very large data conversion project.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, and router, Filter, Expression and Update Strategy.
• Involved in writing stored procedures to check the conversion errors.
• Extracted data from Oracle and migrated into SQL Server 2005 using SSIS.
• 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.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Have generated reports using OBIEE 10.1.3 for the future business utilities.
• This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.

Environment: Informatica Power Center Designer 8.6/8.1, Business Objects Data Services 4.0, Informatica Repository Manager, Oracle10g/9i, DB2 6.1, Erwin, TOAD, SAP Version: 3.1.H, Unix- SunOS, PL/SQL, SQL Developer.

Sr. ETL/Informatica Developer

Confidential, Pittsburgh, PA

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Designed ETL specification documents for all the projects.
• Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Target.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).
• Created detailed Unit Test Document with all possible Test cases/Scripts.
• Conducted code reviews developed by my team mates before moving the code into QA.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Modified existing mappings for enhancements of new business requirements.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Worked on production support.
• Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

Environment: Informatica Power Center 9.1.0, Oracle 11g, SQLServer2008, IBM I Series (DB2), MS Access, Windows XP, Toad, Tidal, Cognos 8.4.1., SQL developer.

ETL Developer

Confidential

Responsibilities:

• Developed mappings in Informatica Power Center 6.1that catered to the Extraction, Transformation, and Loading from various source systems to target systems.
• Used Informatica tool to handle complex Mappings and extensively used the various Transformations like Source Qualifier, Aggregators, Lookups, Filters, Update Strategy, Expression, Sequence generator and Sorter etc.
• Used Informatica Power Center 6.1for mapping and workflow design including the use of maplets, reusable transformations and worklets.
• Extensively used workflow manager to create tasks and workflows.
• Used PL/SQL with Informatica Power Center 6.1for Oracle 8i database.
• Developed mapping using Informatica Power Center Designer to bulk load data from Oracle and Flat file source system to target database.
• Used Informatica tool to handle complex mappings and extensively used various Transformations including Source Qualifier, Aggregators, Lookups, Filters, Update Strategy, Expression, Sequence generator and Sorter.
• Developed, implemented and enforced ETL best practices standards.

Environment: Informatica Power Center 6.1, Flat files, Oracle 8i, BO 5, Windows 2000