SUMMARY:

• Senior Informatica Developer with 8+ years of IT experience in ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 9.x/8.x/7.x.
• Experience in Requirement Analysis, Functional Analysis, Design, Development, Implementation, Testing, Debugging, Productions Support, and Maintenance of various Data warehousing Applications.
• Extensive experience with different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements and in conceptual, logical and physical data models using Erwin.
• Experience in full lifecycle implementation of Data warehouse.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Extracted data from various sources like Oracle, DB2, Flat file, SQL Server, XML files and loaded into Oracle database.
• Extensively worked with Stored Procedures, Triggers, Cursors, Indexes, Functions and Packages.
• Solid Modeling experience in Ralph Kimball Methodology, Star Schema, Snow Flake Schema, Fact Tables, Dimension Tables, Dimensional Data modeling, ERwin7x.
• Created transformations like source qualifier, joiner transformation, filter, update strategy, lookup transformation, rank transformations, expressions, aggregator and sequence generator to load the data from staging area to ODS and to DW in oracle
• Worked on making migration documents from development to testing and production environments.
• Proficient in designing, creating and scheduling workflows and worklets using Informatica Workflow Manager and monitoring using Informatica Workflow Monitor.
• Proficient in Agile/scrum project methodology.

TECHNICAL SKILLS:

Informatica Power Center 8.1.1, 8.6.1, 9.1,9.5.1,9.6, DW DesignerMapping DesignerWork Flow Manager

Work Flow MonitorRepository ManagerInformatica Power Exchange

SOAP, OLAP, OLTP.

Oracle 8i /9i/10gSQL Server 2005/2008, DB2.

PL/SQL, SQL, Shell ScriptsPHP, XML, Erwin 8/7.

RDBMS Tools Toad, TidalCrontab, SQL AssistantSQL Developer

Windows XP/2000/98/NTIBM Mainframes, UNIX

(Sun - SolarisHP/UX), Linux.

PROFESSIONAL EXPERIENCE:

Senior Informatica Lead Developer

Confidential, Honolulu, HI

Responsibilities:

• Developed and implemented the coding of Informatica Power Center Mapping for the different stages of ETL.
• Involved in Designing and creating mappings and mapplets using Informatica Power Center Source Analyzer, Warehouse designer, Mapplet Designer & Transformation Designer, Mapping Designer.
• Extensively worked on staging of multiple sources with different situations of data handling and on multiple sources.
• Worked as a lead with team of 10+ informatica developers. Providing solutions, fixes and different approaches to tasks.
• Worked on Informatica Data Quality to create rules and profiling.
• Created scorecards for different source systems to check threshold.
• Created a standardized environment, modified some of the existing standards and review codes from other developers to comply them to stick with these standards.
• Created UNIX shell script to FTP flat files from different ordering systems to the ETL server.
• Developed stored procedures for generating the data warehouse cycle dates.
• Upon performance tuning analysis, dropped and re-create the indexes to enhance performance of queries.
• Provided Informatica Power Center training/tutorial documents to interns on how informatica works and lead them with tasks.
• Developed scripts for CapPR project. Worked with the Business Analyst team to make sure the scripts execute according to FHB requirements.
• Worked with CDC option is captures database changes, forwarding them to powercenter for further processing.
• Involved in writing and executing the scripts for creating tables in the data warehouse.
• Worked extensively on different sources COBOL (CopyBooks), Oracle, SQL Server, Flat file, XML.
• Worked extensively on data cleansing from different sources like junk characters using REG REPLACE and other similar commands.
• Performance tuning on different mappings to increase efficiency.
• Import and Export of mappings to different repositories by creating corresponding folders and hierarchy.
• Migration from staging to prod environment. This was done by creating UNIX folders/batch scripts, importing informatica mappings, creating metadata batch scripts, tablespaces, DDLs and DB links in Oracle.
• Created multiple mappings to create dumps from staging to prod dev.
• Used Router, Filter, Sorter, Sequence generator, aggregator, lookup transformation, expression transformation extensively.
• Was part of EDW team, executed DDLS, and helped creating tablespaces, DB Links and documentation.
• Experienced in Performance Tuning by identifying the bottlenecks at sources, targets, transformations and session levels.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes.
• Involved in production support onshore and offshore teams. PBS reporting tool was used.

Environment: Informatica Power Center 9.6.1/9.5.1/9.1 , 8.1/8.6.0 Tools (Designer, Workflow Manager, Workflow Monitor), IDQ 9.5.1, Oracle 10g/11g, PBS tool, Tidal, Crontab, SQL Developer 4.1/3.0, PL/SQL, Toad 7.0, Erwin 7.x, AIX 6.1, SQL Server Management Studio 2014

Senior Informatica Lead Developer

Confidential, Portland, OR

Responsibilities:

• Involved in understanding Business and data needs and analyze multiple data sources and document data mapping to meet those needs.
• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica Power Center. Leading analysis, design, development and testing activities at client location.
• Worked as a lead along with the project manager to assist team on performance tuning, debugging, providing different solutions and logic wherever needed. Worked with team of 20+ Oracle/Informatica developers.
• Provided technical documentations for the applications that the client requires.
• Used Analyst tool (IDQ9.5.1) for data profiling.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger
• Created Workflow, Worklet, Assignment, Decision, Event Wait and Raise and Email Task, scheduled Task and Workflow based on Client requirement.
• Worked on the project, Analytics Solution to Extract Transform and Load (ETL) the large number of records provided by the Company such that the quality of the data needs to be checked according to the business logics using the tool Informatica Big Data Edition. Worked mainly on creating mappings for applying the business logics.
• Developed complex Informatica mappings to implement Change Data Capture (CDC)mechanism by using Type-2 effective date and time logic to perform Upsert operations at database level. production support involving scripting issues and failed logs.
• Expertise in Change Data Capture (CDC) using Informatica Power Exchange.
• Was part of the team working on Hadoop technology to manage large data.
• Responsible for running UNIX shell scripts to update and maintenance of database.
• Used mapping and mapplet designer to generate different mappings for different loads.
• Used Informatica Workflow Manager to create Workflows, database connections, sessions, and batches to run the mappings.
• Monitoring the workflow performance and the status with Workflow Monitor.
• Perform Informatica code migrations from DEV to QA, UAT and PROD repositories and monitoring all the environments.
• Maintained different versions of the mappings, sessions and /workflows using Informatica version control mechanism.
• Created the ETL Design Document, Unit Test Case Document, Technical Design Document, Data Validation Scripts.
• Accessed the data, creation of stored procedures and functions using TOAD.
• Involved in writing and executing the scripts for creating tables in the data warehouse.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.

Environment: Informatica Power Center 9.0/9.1,8.1/8.6.0 Tools (Designer, Workflow Manager, Workflow Monitor), Informatica BDE, IDQ 9.5.1, Oracle 10g/11g, Terradata DB v14, Toad 9.5, Sql Developer 3.0, PL/SQL, Toad 7.0, Erwin 7.x, IDQ5.9.x

Informatica Developer

Confidential, Irving, TX

Responsibilities:

• Involved in requirement gathering and performed ETL Process.
• Created Dimension Tables and Fact Tables based on the warehouse design.
• Wrote Triggers and Stored Procedures using PL/SQL for Incremental updates
• Developed mappings to extract data from SQL Server, Oracle, Teradata, Flat files, XML files, and load into Data warehouse using the Mapping Designer.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Involved in customizing data models for Data warehouse supporting data from multiple sources on real time.
• Used advanced techniques of Informatica to load data from MS SQL Server, Db2, Flat files into the target Teradata database.
• Extensively worked with transformations Lookup, Update Strategy, Expression, Filter, Stored Procedures, Router and others.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions.
• Implement best practices to maintain optimal performance.
• Capture the change stream by using the Informatica Power Exchange.
• Extensively Used Informatica Power Exchange tools to capture the data change (CDC) for DB2.
• Created and ran workflows using Workflow Manager to load the data into the Target Database.
• Developed mapping parameters and variables to support SQL override.

Environment: Informatica Power Center 8.1/7.1.2, Erwin 4.5, Oracle 10g/9i, Teradata V2R5, XML, PL/SQL, SQL Server 2005/2000 (Enterprise Manager, Query Analyzer), Sybase, SQL* Loader, SQL * Plus, Autosys, OLAP, Windows XP/NT/2000, Sun Solaris UNIX, MS Office 2003, Visio Project, Shell scripts, Mainframe.

ETL Developer

Confidential, Trenton, NJ

Responsibilities:

• Developed PL/SQL stored procedures and UNIX shell scripts for pre and post session commands, batch jobs.
• Created mapping and mapplets using various transformations like Joiner, Filter, Aggregator, Lookup, Stored Procedures, Router, Sorter, Rank, Normalizer and Update Strategy etc.
• Developed UNIX Shell Scripts and SQLs to get data from Oracle tables before executing Informatica workflows.
• Worked on various projects at the same time as a Developer and Analyst.
• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Designed and developed solutions for very complex business logics. Designed and build reusable objects (Informatica Mapplets, Sessions, Email Task, Worklets and more) as Standards for multiple projects.
• Used Normalizer transformation with COBOL sources stored in DB2.
• Created reusable mapplets and Transformations starting concurrent batch process in server and did backup, recovery and tuning of sessions.
• Created sequential batches and concurrent batches for sessions.
• Created Connected and Unconnected lookup transformation for better performance of the mappings and sessions.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Created SSIS Packages to extract data from Excel Files, MS Access files using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes.
• Created a standardized environment, modified some of the existing standards and review codes from other developers to comply them to stick with these standards.

Environment: Informatica 8.6.1, Oracle, TOAD, SQL SERVER 2008, Control-M, Quality Center.

Informatica Developer

Confidential

Responsibilities:

• Understanding existing legacy system and extensively worked on the requirement definition and analysis in support of Data Warehousing efforts.
• Participating in Business, Functional requirement walk through.
• Using Transformations to clean the data from staging area as per the Data Warehouse requirements.
• Extraction, Transformation and loading of data from DB2, MS-Access, MS-Excel, flat file sources into oracle database.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL.
• Extensively worked with various Passive transformations in Informatica PowerCenter like Expression Transformation, Sequence Generator, and Lookup Transformation.
• Worked with various active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
• Successfully Implemented Slowly Changing Dimensions (SCD). Used Type 2 dimension to keep the history changes.
• Partitioned Sessions for concurrent loading of data into the target tables.
• Involved in Error handling strategies, Unit, System testing, UNIX test scripts, test scripts and fix bugs in the application.
• Troubleshoot and tune SQL using EXPLAIN PLAN.
• Developed PL/SQL stored procedures and UNIX shell scripts for pre and post session commands, batch jobs.
• Developed and implemented the UNIX shell script for the start and stop procedures of the sessions.
• Created and Monitored Tasks, Workflows and Worklets using Workflow Manager.

Environment: Informatica Power Center 8.6, Oracle, PL/SQL, DB2, SQL*Plus, UNIX, Autosys Scheduler, Sun Solaris

ETL Developer

Confidential

Responsibilities:

• Created primary Database storage structures (Table Spaces, Segment, Extent, Data files, Data blocks) and objects (Tables, Views, and Indexes).
• Created and maintained Table Spaces, rollback segments and indexes for applications.
• Managed security of the application by granting and revoking various privileges/roles to users and applications.
• Done Installations and configurations of Oracle Databases.
• Design and Developed pre-session, post-session tasks for the workflows.
• Implemented slowly changing dimensions methodology and developed mappings to keep track of historical data.
• Extracting data from various Siebel base tables (s org ext, s doc agree, s agree item, s contact, s addr per etc), legacy systems and applying transformation logic and loading into Siebel EIM Tables (Accounts, Agreements, Offers, Offer Elements, Products, Conditions, Address and Contacts).
• Used Pipeline partitioning to improve Session performance.
• Documented Design Documents and Unit Test plans for Informatica mappings, design and validation rules.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Created different types of reports such as Master/Detail, Cross Tab and Chart (for trend analysis) using Business Objects. Use of filters, conditions, calculations etc.

Environment: Informatica Power Center 6.2/7.1, Power Connect, Business Objects 6.5/6.0, Erwin 4.0, Oracle 9i, Teradata V2R5, Autosys, Toad, SQL, PL/SQL, Sun Solaris 8.0 and Windows 2000, UNIX shell Scripts, Mainframe.