SUMMARY

• Over 7 years of IT experience in analysis, design, development and implementation of Data warehouses, data marts using Informatica Power Center, IICS with Oracle, MS SQL server, DB2.
• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center 10.x/9.x, IICS ETL tools.
• Experience in performing ETL procedures to load data from heterogeneous sources like Oracle9i/10g/11g/12C, DB2, SQL Server, Teradata, Flat Files.
• COBOL files and Teradata into Data warehouse using Informatica Power Center.
• Extensively worked on overall SDLC implementation dat includes requirement gathering, development, testing, debugging and deployment as well as Documentation, Production Support.
• Extensively work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
• Expertise in Data warehousing concepts like OLTP/OLAP System Study, Analysis, and E - R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional, and multidimensional data modelling.
• Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files.
• Experience in Informatica Intelligent Cloud Services (IICS) and Power center ETL implementation.
• Written number of shell scripts to run various batch jobs.
• Excellent noledge, understanding and some hands-on experience in different Business Intelligence Tools like Business Objects, Cognos and Micro-Strategy.
• Experience in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer/Workflow.
• Experienced in Performance Tuning and Debugging of existing ETL processes.
• Experience in working with offshore and onsite co-ordination.
• Experienced to work in Development team, Production support teams in handling critical situations to meet teh deadlines for successful completion of teh tasks/projects.
• Implemented SCD Type 1 and SCD Type 2 for loading data into data warehouse dimension tables.
• Involved in using Automation Scheduling tools like Autosys, Control-M, Tivoli.
• Experience in documenting High Level Design, Low level Design, STM's, Unit test plan, Unit test cases and Deployment documents.
• Critical thinker who is self-starter and willing to take initiative and work with little or no supervision.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.4, Informatica Intelligent Cloud Services (IICS), Datastage, SSIS

Programming Languages: C, C++,SQL,PL/SQL

RDBMS: Oracle 12C/11g, SQL Server, Teradata,DB2

Operating System: Windows 7, Windows XP, Windows 2003/2000 Server, UNIX

Data Warehousing (BI): Data Marts, OLTP, OLAP, Normalization, Dimensional Modelling, Fact, Dimension, Star schema, Snowflake schema, Galaxy Schema, Slowly Changing Dimensions

Scheduling Tools: Autosys, Tivoli, Control-M

Other Tools: SQL Developer, Win SCP, Putty, SVN, Quick build

Defect Tracker: Jira, ITSM.

Reporting Tools: Tableau, Cognos.

PROFESSIONAL EXPERIENCE

Confidential, Woonsocket, RI

Senior ETL Developer

Responsibilities:

• Collaborated with Project Manager, Business analysts for requirements gathering, business analysis and designing of End to End solution for Accordant Project.
• Involved in requirement analysis, ETL design and development for extracting data from different interfaces like MS SQL Server, Flat Files and loading into CVS Application Systems DB.
• Extensively involved in creating ETL Data Mapping Design Document for Accordant Data Clients as per business requirements.
• Maintained naming standards and Database/warehouse standards for future application development.
• Worked on Epic application and created extracts from clarity database.
• Involved in defining/creating MS SQL Server Objects like Tables Structures, Stored Procedures, functions, cursor as requirements.
• Invoked and Executed Stored Procedures as a part of development process through Informatica to populate Supporting Base Tables.
• Developed ETL Informatica mappings to load Tables using various transformations, which involves Source Qualifier, Expression, Lookup, Joiner, Router, Update Strategy etc. of Informatica.
• Extensively used Informatica client tools Source Analyzer, Target/Warehouse designer, Mapping Designer, Transformation Developer, Informatica Workflow Manager and Informatica Workflow Monitor.
• Involved in performance tuning and optimization of mapping to manage very large volume of data.
• Created Workflow and Tasks to schedule teh loads at required frequency using Workflow Manager.
• Extensively involved in tuning teh Mappings for Optimum Performance.
• Extensively Involved in Documenting ETL Design Document for test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Performed Unit testing on developed MS SQL Server Objects and ETL mappings.
• Involved in User Acceptance Testing/Production Deployment Process.
• Designed, Developed and Implemented ETL processes using IICS Data integration.
• Created IICS connections using various cloud connectors in IICS administrator.
• Extensively used performance tuning techniques while loading data into Azure Synapse using IICS
• Involved in code migration/deployments in IICS.

Environment: Informatica Power Center 10.4, Informatica Intelligent Cloud Services (IICS), MS SQL Server 2016/17, MS Visual Studio, SSIS, PL/SQL, Version Control(SVN/Gitlab), Control-M (Scheduler)

Confidential, San Antonio, Texas

ETL/Informatica Developer

Responsibilities:

• Developed ETL programs using Informatica to implement teh business requirements.
• Followed Agile-Scrum methodology to design, develop, test and deliver teh code.
• Modify existing business logic in Informatica ETL flows.
• Communicated with business customers to discuss teh issues and requirements. used Informatica file watch events to pole teh FTP sites for teh external mainframe files.
• TEMPEffectively worked in Informatica version-based environment and used deployment groups to migrate teh objects.
• TEMPEffectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in enhancements and maintenance activities of teh data warehouse including tuning, modifying of stored procedures for code enhancements.
• Involved in performance tuning and optimization of mapping to manage very large volume of data
• Worked on Informatica Utilities Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Identified problems in existing production data and developed one-time scripts to correct them.
• Fixed teh invalid mappings and troubleshoot teh technical problems of teh database.
• Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Router, Sorter, Expression, Normalizer, Sequence Generator and Update Strategy Develop complex ETL mappings on Informatica 10.x platform as part of teh Risk Data integration efforts.
• Implemented SCD Type 1 and SCD Type 2 for loading data into data warehouse dimension tables.
• Implemented error handling for invalid and rejected rows by loading them into error tables.
• Extensively worked on batch framework to run all Informatica job scheduling.
• Analyzing teh sources, transforming data, mapping teh data and loading teh data into targets using Informatica Power Center Designer.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in teh Mapping Designer.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run teh mappings.
• Used Variables and Parameters in teh mappings to pass teh values between mappings and sessions.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Did performance tuning to improve Data Extraction, Data process and Load time.
• Worked with data modelers to understand financial data model and provided suggestions to teh logical and physical data model.
• Designed presentations based on teh test cases and obtained UAT signoffs
• Documented test scenarios as a part of Unit testing before requesting for migration to higher environment levels and handled production deployments
• Identified performance bottlenecks and suggested improvements.
• Performed Unit testing for jobs developed, to ensure dat it meets teh requirements
• Handled major Production GO-LIVE and User acceptance test activities.
• Created architecture diagrams for teh project based on industry standards
• Defined escalation process metrics on any aborts and met SLA for production support ticket.
• Fixed teh invalid mappings and troubleshoot teh technical problems of teh database.

Environment: Informatica Power Center 10.1/9.6, Oracle, XML, SQL Server, Web services, DB2 Mainframe, Autosys.

Confidential, Huntington Beach, CA

ETL/Informatica Developer

Responsibilities:

• Developed ETL mappings, transformations using Informatica Power Center.
• Involved in teh requirement definition and analysis in support of Data Warehouse efforts.
• Extensively interact with teh user and involved in determining teh data needed to address business user’s analytical requirements and design data mart to support this analysis.
• Involved in handling and selecting heterogeneous data sources like Oracle, DB2, SQL server and Flat Files.
• Worked with Unified Modeling Design concept to design platform independent modeling.
• Worked extensively in full System Development Life Cycle like participating in requirement gathering business analysis, user meeting.
• Interacted with functional teams and users for finalizing teh data models and reporting structures.
• Involved in ICD-9 4010 data analyzing with data analyst to define teh structure of dimension and facts.
• Involved on various HIPPA claims validation and verification process to understand teh source data.
• Worked closely with teh Business Analyst Data Modeler and Database Architect during teh design and development of ETL technical specification document.
• Used Informatica Power Center as an ETL to extract data from source like MS SQL Server, Flat files, Oracle, DB2 and loaded to target.
• Extensively worked with teh various client component of Informatica like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Extensively used different transformations like Lookup, Joiner, Aggregator, Filter, Sorter, Expression, Update Strategy, Source Qualifier, Rank, Router to create several mappings and Mapplets.
• Implemented extracting, cleansing, transformation, integration and loading into Data marts using Informatica.
• Implemented Slowly Changing Dimension Phenomenon Type-1, Type-2 using Informatica ETL mapping.
• Created Mapplets and reusable session for teh performance tuning.
• Implemented error-processing strategy to reprocess teh error data and manage notification of error data to corresponding business team.
• Worked with Informatica workflow monitor in running and debugging its components and monitoring teh resulting executable version Involved in fine-tuning of sources, targets, mappings and sessions for performance optimization.
• Extensively used complex SQL queries to unit test teh system and to test teh existing project also used to validate teh data in data warehouse.
• Extensively used SQL and PL/SQL tuning techniques to improve teh performance.
• Involved in unit, system and end-to-end testing of teh design. Worked with DBA and Reporting team to generate Materialized View of teh data warehouse.
• Worked on call for production support.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Automated/Scheduled teh cloud jobs to run daily with email notifications for any failures.
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Involved in teh Performance Tuning of Mappings and Sessions Troubleshoot connectivity problems Looked up and read session, event and error logs for troubleshooting.

Environment: Informatica Power Center 9.6.1, Oracle 11g, PL/SQL, Erwin, SQL Server 2005, Unix, Autosys

Confidential, Bridgewater, NJ

ETL Developer

Responsibilities:

• Involved in gathering and analyzing teh business requirements.
• Designed and developed mappings by using Lookup, Expression, Update Strategy, Sequence generator, Aggregator, Router, Joiner transformations to implement teh mapping.
• Worked with Informatica Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extracted data from Hive files and transformed it in accordance with teh Business logic and loaded data into Oracle tables using ETL tool.
• Involved in creating Oracle staging table structures and modifying existing tables as per teh design specifications.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica Power Center.
• Developed Informatica Workflows and sessions associated with teh mappings using Workflow Manager.
• Involved in debugging Informatica mappings, Performance and Unit testing of Informatica Sessions and Target Data.
• Generated queries using SQL to check for consistency of teh data in teh tables and to update teh tables as per teh Business requirements.
• Involved in Performance Tuning of mappings in Informatica.
• Participated in weekly status meetings, conducting internal and external reviews as well as formal walk through among various teams and documenting teh proceedings.
• Wrote PL/SQL Packages and Stored procedures to implement business rules and validations.
• Performed unit testing at various levels of teh ETL and actively involved in team code reviews.

Environment: Informatica Power Center 9.6.1, Oracle 11g, SQL, UNIX, Putty, Autosys.

Confidential

ETL Developer

Responsibilities:

• Followed Agile-Scrum methodology to design, develop, test and deliver teh code.
• Modify existing business logic in Informatica ETL flows.
• Design new ETL flows as per teh mapping sheets.
• Involved in ETL developing, creating required mappings for teh data flow using Informatica.
• Used transformations like Source qualifier, Filter, Aggregator, Joiner, Expression, Lookup, Router, Sorter and Union.
• Involved in designing teh Mapplet and reusable transformations according to teh data flow requirements.
• Validated teh output according to teh specifications.
• Enhancements in existing mappings according to teh business logic.
• Attended daily scrum calls to post teh required status update.
• Testing activities involve Unit Test Plan Preparation, Unit Testing, Sprint Testing, UAT and performance testing.
• Gathering reporting requirements and making enhancements to any existing logic if required.
• Developed Oracle PL/SQL packages, procedures and functions.
• Coded Oracle SQL to create ad-hoc reports on an as-needed basis.
• Used Oracle Warehouse Builder to implement changes to teh operational data store, as well as create data marts
• Involved in teh data analysis for source and target systems. Good understanding of Data warehousing concepts, Star schema and Snow-flake schema.
• Involved in supporting and maintaining Oracle Import, Export and SQL*Loader jobs.

Environment: Informatica Power Center 9.5.1, PL/SQL, Oracle, SQL Server, Unix.