SUMMARY

• Over 6+ yearsof experience in software development and extensive experience with Informatica Power Centerin all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications using Informatica Power Center 10.X/9.X, IDQ 9.1, SQL, PL/SQL, Oracle and Unix.
• Expertise in Data extraction, cleansing, parsing, standardization, consolidation, validation and migration.
• Strong working experience on Informatica Power center and power Exchange directly responsible for the Extraction, Transformation and Load (ETL) of data from Legacy Systems using Informatica.
• Strong knowledge and experience in Insurance, Health Care and Finance domains.
• Expertise in designing confirmed and traditional ETL Architecture involving Source databases Oracle, Flat Files (fixed width, delimited ),DB2, SQL server, and Target databases Oracle,and Flat Files ( fixed width, delimited).
• Extensive experience in creating the Workflows, Worklets, Mappings, Mapplets, Reusable transformations and scheduling the Workflows and sessions using Informatica Power Center.
• Experience in writing complex SQL queries and PL/SQL, including the use of stored procedures, functions and triggers to implement business rules and validations.
• Working knowledge of data warehouse techniques and practices, experience including Dimensional Data Modeling, OLTP and OLAP.
• Experience in Data modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Logical & Physical data modeling, ERWIN
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specific goals. Excellent written and verbal communication skills.
• Experience inUNIXandWINDOWSenvironment
• Hands - on experience on scheduling tools like AUTOSYS, CONTROL-M, Informatica scheduler and UNIX Crontab.
• Experience in Oracle and Other Utilities/tool: TOAD, UNIX Shell Scripting, Export/Import, SQL*Loader.
• Expertise in fineperformance tuningof SQL statements andPL/SQLmodules usingExplain Plan,SQL Tracefor optimizing the cost and evaluating the performance.
• Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.
• Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint.

TECHNICAL SKILLS

ETL and BI Tools: Informatica Power center 10.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Power Connect MS SQL Server Analysis Services, OLAP, OLTP, ETL

Database: Oracle 12c/10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, TOAD.

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT, dimension tables and ERWIN.

Design: SQL, PL/SQL, SQL*Loader, Oracle Import/Export, OEM, TOAD, SQL Navigator.

Operating Systems: Unix, Windows 2019/2016/2012

Schedulers: Cron (UNIX), JIT (Windows), AUTOSYS (Windows/Unix).

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Informatica Developer

Responsibilities:

• Interacted with Business Analysts to identify the process and requirements gathering, implementing designs process, development and preparing business rules.
• Held various interactive meetings with different users and business analysts for a clear understanding of the Business requirements and to bridge the gap between user needs and tool functionalities.
• Interacted with Data modelers and involved in data modeling of the project.
• Worked with business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data.
• Worked closely with data modelers on Erwin tool for dimensional modeling (Star schema).
• Used Informatica 10.2/10.4 to extract, transform and load data from multiple input sources like flat files, SQL Server into Oracle database.
• Created Mappings, Mapplet and Transformations using the Designer and developed Informatica sessions as per the business requirement.
• Worked on Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer and Transformations, Informatics Repository Manager, Workflow Manager and Monitor.
• Used most of the transformations such as the B2B Data Transformation, Expression, Lookup, Joiner, Router, Filter, Aggregator, Sequence Generators, Normalizer, Xml, and Update Strategy and Transaction Control.
• Worked with different types of partition techniques like key range, pass through, Round Robin and Hash partitioning.
• Generated Reusable Transformations, Mapplets and used them extensively in many mappings.
• Involved in performance tuning on Informatica mappings.
• Involved in Data integration and Data quality analysis.
• Developed mappings to implement complex logic of SCD2, incremental Aggregation, and Cumulative Calculations etc.
• Developed and configured various Tasks, Sessions and Workflows. Monitored Repository services, Integration Services.
• Involved in Production support in resolving issues.
• Involved in Unit testing and System Testing of Informatica mappings and Workflows.
• Responsible for Testing and Validation of the code in the mappings using the data populated

Environment: Informatica Power Center 10.4, Power exchange, Oracle 12c, SQL, PL/SQL, Toad, Erwin, Main Frames, Cognos, Tivoli, Windows NT, XML, Unix Shell Scripting.

Confidential, Plantation, FL

Informatica Developer

Responsibilities:

• Interacted with Business Analysts to identify the process and requirements gathering, implementing designs process, development and preparing business rules.
• Used Informatica 10.2/10.4 to extract, transform and load data from multiple input sources like flat files, SQL Server into Oracle database.
• Developed ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, Flat Files and SQL server, and loaded into Oracle.
• Created Mappings, Mapplet and Transformations using the Designer and developed Informatica sessions as per the business requirement.
• Worked on Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer and Transformations, Informatics Repository Manager, Workflow Manager and Monitor.
• Used most of the transformations such as the B2B Data Transformation, Expression, Lookup, Joiner, Router, Filter, Aggregator, Sequence Generators, Normalizer, Xml, and Update Strategy.
• Worked with different types of partition techniques like key range, pass through, Round Robin and Hash partitioning.
• Generated Reusable Transformations, Mapplets and used them extensively in many mappings.
• Involved in performance tuning on Informatica mappings.
• Involved in Data integration and Data quality analysis.
• Developed mappings to implement complex logic of SCD2, incremental Aggregation, and Cumulative Calculations etc.
• Developed and configured various Tasks, Sessions and Workflows. Monitored Repository services, Integration Services.
• Involved in Production support in resolving issues.
• Involved in Unit testing and System Testing of Informatica mappings and Workflows.
• Responsible for Testing and Validation of the code in the mappings using the data populated

Environment: Informatica Power Center 10.4, Power exchange, Oracle, SQL, PL/SQL, Toad, Erwin, Main Frames, Cognos, Tivoli, Windows NT, XML, Unix Shell Scripting.

Confidential, New York NY

Informatica Developer

Responsibilities:

• Coordinated and analyzed the existing business, system and reporting requirements for IDR and Workforce Dashboard projects.
• Gathered and documented the user requirements and report specifications on a regular basis to maintain the integrity of the development.
• Held various interactive meetings with different users and business analysts for a clear understanding of the Business requirements and to bridge the gap between user needs and tool functionalities.
• Interacted with Data modelers and involved in data modeling of the project.
• Worked with business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data.
• Worked closely with data modelers on Erwin tool for dimensional modeling (Star schema).
• Used Informatica 10.2/10.4 to extract, transform and load data from multiple input sources like flat files, SQL Server into Oracle database.
• Created Mappings, Mapplet and Transformations using the Designer and developed Informatica sessions as per the business requirement.
• Worked on Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer and Transformations, Informatics Repository Manager, Workflow Manager and Monitor.
• Used most of the transformations such as the B2B Data Transformation, Expression, Lookup, Joiner, Router, Filter, Aggregator, Sequence Generators, Normalizer, Xml, and Update Strategy.
• Worked with different types of partition techniques like key range, pass through, Round Robin and Hash partitioning.
• Generated Reusable Transformations, Mapplets and used them extensively in many mappings.
• Involved in performance tuning on Informatica mappings.
• Involved in Data integration and Data quality analysis.
• Developed mappings to implement complex logic of SCD2, incremental Aggregation, and Cumulative Calculations etc.
• Developed and configured various Tasks, Sessions and Workflows. Monitored Repository services, Integration Services.
• Involved in Production support in resolving issues.
• Involved in Unit testing and System Testing of Informatica mappings and Workflows.
• Responsible for Testing and Validation of the code in the mappings using the data populated

Environment: Informatica Power Center 10.2, Power exchange, Oracle, SQL, PL/SQL, Toad, Erwin, Main Frames, Cognos, Tivoli, Windows NT, XML, Unix Shell Scripting.

Confidential, Bloomfield, CT

Informatica Developer

Responsibilities:

• Identified various boundary systems such as SAP, JD Edwards, and custom built third party systems such as HSERS and PPR from which data was to be converted
• Involved in gathering business requirements and translating them into technical requirements.
• Hosted the Mapping sessions to map the data elements between source and target systems as a part of data extraction process.
• Experience in Identifying and understanding the Data Patterns, Identify the Data Deviations and report them to the stakeholders.
• Involved in Data Quality Team, migrating data likeHTR - Hire to Retire,PTP - Procure to Pay,PTC - Project to Close &ATC - Accounting to Close.
• Created Complex Informatica mappings that transfer SAP data from ODS (Operational Data Source) to Oracle EBS.
• Conducted End to End testing as a part of Project Plan to complete Mock and INT cycles leading up to the Foundation release.
• Analyzed the source data and identified the filter conditions needed to address the data needs from the Target system.
• RecommendedData Quality Standardsfor domestic/international addresses for Customers/Sites present in the US/Canada.
• Built theData Validation reportsfor the Mock and INT cycles to capture the timings and process in the preparation of Production cutover.
• Involved in loading the GL Data (Balanced & Open) into EBS, Inception to date.
• Designed the Aggregations and Roll ups per requirement of ATC conversions that includes GL.
• Involved in loading and creating the Supplier Hierarchy in EBS from SAP.
• Created Parameter Files and Variables in many of the Complex Mappings to virtually create a User Interface.
• Involved in creating Functions, Stored Procedures in PL/SQL as per the requirements.
• Involved in creating the very large Intermediate tables, which were used across multiple conversion objects.
• Involved in designing and performance tuning the ETL mappings, which load very large tables in Oracle, up to 10GB.
• Scheduled the Informatica Workflows inUC4.
• CreatingRelational Connections,Migrating the Mappingsfrom Development to StageandStage to Production.
• Conducted End to End testing as a part of Project Plan to complete Mock and INT cycles leading up to the Foundation release.
• Built the Data Validation reports for the Mock and INT cycles to capture the timings and process in the preparation of Production cutover.

Environment: Informatica Power Center 10.2 & 10.4, OracleE-Business Suite (EBS) v12, SAP ECC - 4.7, TOAD, Oracle 12c, Windows,Oracle SQL Developer.

Confidential, San Francisco, CA

ETL Developer

Responsibilities:

• Analyzed various Schemas for Implementation and Modeled the Data Warehousing Data marts using Star Schema.
• Created mappings using the Transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy etc.
• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Developed complex mappings & mapplets in Informatica to load the data using different transformations.
• Created and Monitored Sessions and Batches using Server Manager.
• Extensively used various Performance tuning Techniques to improve the session performance (Partitioning etc).
• Successfully moved the Sessions and Batches from the development to production environment.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Generated completion messages and status reports using Workflow manager.
• Created workflows and worklets for designed mappings.
• Developed mappings and loaded data on to the relational database. Worked on Dimension as well as Fact tables.
• Used PL/SQL Procedures/Functions to build business rules.
• Defined, created, published and maintained cubes using Power Play.
• Created User conditions and Filters to improve the report generation.
• Wrote stored procedure to check source data with Warehouse data if it is not present written that records to spool table and used spool table as Lookup in Transformation.
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database data modeling (capacity planning, object creation and aggregation strategies) as per business requirements Using UML Tool ERWIN.

Environment: ETL-Informatica 10.1.1-Power Center, Oracle 11g, DB2, Flat files, SQL, PL/SQL, UNIX Shell Scripts, Erwin, TOAD.