SUMMARY

• Around 7 years of IT experience in Design, Analysis and development of software applications and implementation of Data warehousing using ETL with Oracle database on windows.
• Experience in developing and maintaining Data Warehouse applications using INFORMATICA
• Power center Developing complex Mappings, Reusable Transformations, Sessions and Workflows using Informatica ETL tool to extract data from various sources and load into target tables.
• Has a clear understanding of Data Warehousing concepts with emphasis on ETL and life cycle development.
• Extensively worked with data warehousing, ETL methodologies, technologies, using Informatica Power Center Client tools Designer, Repository manager, workflow manager/monitor and Server tools Informatica Server, Repository Server manager.
• Developed complex mappings in Informatica using different transformations Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, Expression, Union, Stored Procedure transformation etc.
• Excellent hands-on ETL Informatica Power Center (Source Analyzer, Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation Developer) and Repository Manager, Workflow Monitor and Repository Server Admin Console with strong business understanding indifferent domains.
• Involved in loading different kinds of sources (xml, flat files, Oracle, SQL Server data) to Oracle and Teradata target databases.
• Strong knowledge in Data warehousing concepts, dimensional Star Schema, Snowflakes Schema and Galaxy Schema methodologies.
• Vast Knowledge in Data Warehouse Development Life Cycle where all dimensions of development including Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center
• Familiar in using cloud components and connectors to make API calls for accessing data from cloud storage (Google Drive, Salesforce, Amazon S3, Drobox) in Talend Open Studio.
• Good knowledge in working with Slowly Changing Dimension (SCD) Management type 1 and 2
• Served as developer on Informatica components dat included Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer and Mapping Designer
• Extensive knowledge in writing, testing and implementation of RDMBS such as SQL, PL/SQL, MYSQL and Sybase Database.
• Good experience with IDQ analyst tool and Informatica Developer tool.
• Strong Oracle database experience using Indexes, Triggers and Views. Highly proficient in large volume data migration to Enterprise Data.
• Experience with issue and project management tool Rally to track defects. Solid experience in project documentation including Technical specifications and Technical Design Documents (TDD).
• Used Informatica Data Quality (IDQ) in cleaning and formatting customer master data.
• Extensively worked on data warehousing and decision support systems with relational databases such as Oracle design and database development using SQL, PL/SQL, SQL PLUS and TOAD.
• Highly proficient in teh integration of various data sources involving multiple relational databases like Oracle 11g/10g/9i,MS SQL Server,DB2,COBOL Files and Flat Files.
• Experienced in supporting end-user reporting needs using Informatica. Efficiently involved in interacting with Business Analysts, Department Managers and Business Users. Competence to Manage and deliver results on multiple tasks by effectively managing time and priority constraints.
• Ability to address any ongoing or changing Business needs.
• Extensively worked in production support environment and process engineering related to day today business activities.
• Strong Leadership skills- involved in setting up and leading design, development and Production support teams.
• Excellent communication and strong interpersonal skills with teh ability to interact with end-users, managers and technical personnel.
• Highly skilled, motivated team player with excellent communication, inter-personal skills, analytical, logical programming skills and strong desire to achieve specified goals. Has good understanding at teh conceptual level and possess excellent presentation.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6, 9.5, 9.1, 8.6, 7.1, 6.2, Power Exchange 9.5. Informatica Data Quality 9.6.1, 9.5.

Data ware housing Concepts: OLTP, OLAP, Data Mart, ODS, Star Schema, Snowflake Schema, Dimensional modeling.

Other Tools: Toad, Oracle SQL Developer, SQL Navigator.

Databases: Oracle 9i/10g/11g, Teradata R12, SQL, PL/SQL,SQL PLUS

Web Technologies: HTML, DHTML, XML

Operating Systems: Windows and UNIX

Testing Tools: QTP, Quality Center, Test Director, Clear test, Clear case.

PROFESSIONAL EXPERIENCE

Confidential, Solon, OH

ETL Developer

Responsibilities:

• Created mappings using Flat Files and Relational Targets
• Performed data analysis, assist data analysts with mapping data from existing systems and halped generate required SDLC documentation
• Involved in teh DataMart and reports quality testing.
• Assist teh Development Lead in developing project plans to ensure Informatica solutions are executed flawlessly
• Support agency data management programs and data governance activities to align with teh Enterprise architecture
• Loaded data to Teradata target tables from different kinds of sources like flat files, Oracle, Teradata data using ETL Processes.
• Develop Extraction, Transformation, Loading (ETL) processes with Informatica Power Center leading to full life cycle development including requirement gathering, analysis, design, development, testing and documentation.
• Worked with logical and physical database designs using model viewer Involved in writing teh SQL and PL/SQL procedures and program blocks for data extraction, transformation and loading Extensively worked with Transformations like Router, Normalizer, Lookup, Aggregator, Expression and Update Strategy Transformations
• Worked on Informatica Cloud (SAAS) creating mappings and data synchronization tasks to performing daily loads and incremental loads of data from Salesforce Objects to Oracle and SQL server databases.
• Documented teh various development JIRA's me has worked on and created TDD (technical design document) incorporating teh changes done.
• Worked on migrating objects from dev to test and test to prod environments using org sandbox credentials.
• Involved in Informatica Application Information Lifecycle Management (ILM) software to empower teh IT organization to cost-effectively handle data growth.
• Key tasks included source-target analysis, design of source-target mapping specifications, development of Informatica mappings and workflows and end to end testing of interfaces
• Used Lookup Transformation to access data from tables, which are not teh source for mapping and also used Unconnected Lookup to improve performance
• Created and implemented Informatica workflows
• Created Data Synchronization scripts in ICRT to insert, update or upsert data into SalesForce based on teh type of data dat needed to be updated on SalesForce.
• Created Data Replication tasks in ICRT to extract teh GUID’s of SalesForce records to enable updates on Salesforce objects.
• Followed and automated teh Acceptance Test Driven Development (ATDD) and Test Driven Development (TDD) for unit tests for Informatica ETL.
• Scheduled teh ETLs using ESP scheduler.
• Automation of ETL processes with scheduling tools and exception-handling procedures
• Optimized code performance by analyzing indexes, joins and views
• Developed complex mappings also involving Slowly Changing Dimensions (SCD) Type-me and Type II mappings in Informatica to load teh data from various sources
• Used Repository manager to create Repository, User groups, Users and managed users by setting up their privileges and profile
• Created XML mappings for mapping certain objects where we upload data using a Salesforce tool called Data Loader.
• Used Transformations like Filter, Router, Expression, Source Qualifier, Connected and Unconnected Look up to develop mappings in teh DEV using Informatica Power Center Designer.
• Load and Extract from multiple cloud applications and Legacy applications.
• Created SOQL queries using XQuery to extract data from SalesForce which we used to create tables with SalesForce GUID’s for objects like Campaigns etc.,
• Used Fast Load, Multi Load and Tpump and TPT (Teradata Parallel Transporter) Utilities and used Push down optimization.
• Analyze teh data based on requirements and wrote down techno-functional documents and developed complex mappings using Informatica Data Quality (IDQ).
• Currently playing Lead role in teh project where teh development was carried out along with production support and maintenance
• Used Apex Data loader to read/write CSV files to Salesforce Objects
• Used tools like TOAD to run SQL queries and validate teh data
• Learn new techniques, strategies and concepts of Enterprise management system
• Evaluated teh performance issues in teh data marts which included analyzing query plans by involving teh DBA’s for teh SQL override lookups
• Extracted data from various sources like Teradata and relational databases (Oracle)
• Used Debugger to test and track teh path of teh source data and also to check teh errors in mapping
• Worked with fellow employees and client team members in planning, design development of ETL solutions

Environment: Informatica Power center 9.6.1, Informatica Power Exchange, Informatica Data Quality(IDQ) 9.6.1, Informatica Cloud Real-time (ICRT), Sales Force, Data Loader, SQL server 2012, DB2, SQL Navigator, Oracle11g, Erwin, Autosys, Teradata, UNIX, Windows XP

Confidential, Solon, OH

ETL/ Informatica Developer

Responsibilities:

• Worked closely with Business Analyst and teh end users in writing teh functional specifications based on teh business requirement needs.
• Teh purpose of dis project was to build a Data warehouse for claims processing for CIGNA health care. It also involves teh changes intended for 5010 compliance.
• Involved in Dimensional modeling (Star Schema) of teh Data warehouse and used Erwin 4.5 to design teh business process, dimensions and measured facts.
• Responsible for developing, support and maintenance for teh ETL (Extract, Transform and Load) processes using Informatica power center 9.1 and 8.6.1.
• Migrating from informatica 8.1.1 mappings into informatica 8.6.1 which consists of grid technology
• Understanding teh domain and nodes as well as by using teh informatica integration service to run teh workflows in 8.6.1.
• Involved in analyzing different modules of facets system and EDI interfaces to understand teh source system and source data and extensively used teh reusable transformation, mappings and codes using Mapplets for faster development and standardization and used reusable Session for different level of workflows.
• Collaborated with teh data architect, database administrators and other team members to understand dimensional requirements and translate into functional specifications.
• Involved in massive data cleansing prior to data staging.
• Created mapping using XML, COBOL sources.
• Worked on power exchange to access teh data from different sources and to avoid manual coding
• Innovative design for Change data capture of Suppliers and millions of Account every business day
• Experience with high volume datasets from various sources like Oracle, Text Files, and Relational Tables and XML targets.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and Java Transformations.
• Manage regular enterprise operations and ensure smooth project operations
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program paced to interact with teh server to start and stop sessions and batches, to stop teh Informatica server and recover teh sessions.
• Created procedures to drop and recreate teh indexes in teh target Data warehouse before and after teh sessions.
• Implemented Type1 and Type2 methodologies in ODS tables loading, to keep historical data in data warehouse.
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and teh target Data.
• Tuning teh complex mappings based on source target and mapping, session level.
• Involved in performance and tuning teh ETL processes.
• Wrote SQL, PL/SQL, stored procedures &triggers, cursors for implementing business rules and transformations.
• Used SQL tools like TOAD 9.5 to run SQL queries and validate teh data in warehouse.

Environment: Informatica Power Center 9.1, 8.6.1/8.1.1, Oracle 10g, Teradata, Informatica Power Connect / Power Exchange, TOAD, XML,PL/SQL, SQL server 2008, Windows.

Confidential

ETL/Informatica Developer

Responsibilities:

• Analyzed business requirements, performed source system analysis, prepared technical design document and source to target data mapping document
• Developed complex mappings using Transformations like Lookup (Connected and Unconnected), Joiner, Sorter, Rank, Source Qualifier, Router, Union, Aggregator, Filter, and Expression in teh Power Center Designer.
• Involved in troubleshooting performance issues in teh mappings and Optimized performance by tuning teh Informatica mappings as well as SQL.
• Worked closely with QA team during teh testing phase and fixed bugs dat were reported Extensively worked with various re-usable components like tasks, workflows, Worklets, Mapplets, and transformations
• Performance tuning techniques in Informatica - Pushdown Optimization, Teradata Fast Load/Export, SQL tuning, mapping different relational and non-relational sources and targets - Oracle, Teradata, Flat files, text files and other file formats.
• Worked with DB2 database and also with mainframe COBOL files. Developed Informatica workflows and sessions associated with teh mappings using Workflow Manager
• Worked with session logs, Informatica Debugger, and Performance logs for error handling to fix Workflows and session failures.
• Created UNIX Shell Scripts for batch scheduling and loading process.

Environment: Informatica Power Center, Oracle 9i, Teradata, DB2, PL/SQL, TOAD, SQL* Plus, SQL*Loader, SQL Server 2005, Autosys, and, Windows Server 2003.

Confidential

Informatica Developer

Responsibilities:

• Based on teh requirements created Technical design specification documents for ETL Process.
• Analyzed teh requirements to identify teh necessary tables dat need to be populated into teh staging area.
• Involved in analyzing teh source data coming from different Data sources such as Oracle, Sybase files, Flat files.
• Created and Configured Workflows, Worklets and Sessions to transport teh data to target warehouse tables using Workflow Manager.
• Optimized teh performance of teh mappings by various tests on sources, targets and transformations. Developed Procedures and Functions in PL/SQL for ETL.
• Extensively used ETL to load data from source systems like Flat Files and Excel Files into staging tables and load teh data into teh target database Oracle.
• Used Update strategy and Target load plans to load data into Type-2 /Type1 Dimensions.
• Created and used reusable Mapplets and transformations.
• Improved performance by identifying teh bottlenecks in Source, Target, Mapping and Session levels.
• Design and Developed pre-session, post-session routines and batch execution routines.
• Debugging and Trouble Shooting of Mappings.
• Importing source and target tables from their respective databases.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner and Union.
• Used Parameter files to define values for parameters and variables used in a mappings.
• Used workflow manager to create workflows, sessions. Use Debugger to gain troubleshooting information from teh mappings.

Environment: Informatica Power Center, Oracle 10g, SQL, Windows.