SUMMARY:

• More than 7 Years of IT experience in Analysis, Designing Development, Implementation Maintenance of business application systems for Health care, Banking, Insurance and Financial sectors using Informatica.
• Experience in Data Extraction, Transforming and Loading ETL between Homogenous and Heterogeneous Systems using SQL Server tools, Informatica, including SSIS.
• Strong Data Warehousing ETL experience of using Informatica 9.5/9.1/8.6.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP implementations teamed with all phases of SDLC project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Experience in Informatica to extract transfer and load the data from ODBC staging to Warehouse and Goldengate replication for real time data.
• Extensive experience in designing complex Relational Database models and implementations as per business requirements.
• Expert in creating Stored Procedures, User Defined Functions and T-SQL batch scripts to accommodate complex business specifications.
• Experience in migrating data from external system including flat files, XML, and oracle into SQL Server using Informatica.
• Created sessions ,workflows, worklets and scheduled the workflows using the workflow manager . Run the workflows and get the sessions log and run properties from workflow monitor
• Experience on OBIEE physical and logical joins and adding folders on MyBI
• Work experience in agile and scrum methodology.
• Excellent task oriented team player with good written and verbal communication skills.
• TOOLS AND TECHNOLOGIES: Informatica 9.x, OBIEE,MyBI,Goldengate, SQL Developer,JIRA,Version one, SQL Developer, SQL Server 2010, Microsoft Visual studio 2012/2008 , Oracle 9i, Power Pivot, UNIX,OLAP,SSRS.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL Informatica Developer

Project Description:

Cerner Corporation is a global supplier of health care information technology HCIT solutions, services, devices and hardware. Cerner solutions optimize processes for health care organizations. Cerner is the largest publicly-traded company focusing solely on health care information technology.

Responsibilities:

• The data migration, understanding the complex business rules that need to be implemented and planning the data transformation methodology.
• Work experience in agile and scrum methodology. Parsed high-level Functional spec to simple ETL Coding and Mapping standards.
• Communicated clearly and effectively with the QA team, business users and DA/DBA groups to gather requirements and translating into technical specifications for reporting purposes.
• Performed Requirements Analysis, Design, Development, Testing and Implementation of load processes and Data transformation processes.
• Performed data manipulations using various Informatica transformations like Joiner, Rank, Router, Expression, Lookup, Aggregator, Filter, Normalizer, Java, Update strategy, sorter and Sequence generator etc.
• Worked on developing Informatica new mappings, modified existing mapping, source qualifier queries, maplets and applying transformations based on the business requirements
• Worked with the Informatica/ETL team in development/enhancement of the existing models by adding extensions according to the business needs.
• Developed various Informatica mappings using Informatica Designer, to extract data from various sources like Oracle, Siebel,DB2, Remedy, PeopleSoft, Staging ODBC , FTP and send the data to downstream applications performing required transformation.
• Designed the data quality mappings to enforce validation and metrics collection to ensure quality.
• Created sessions ,workflows, worklets and scheduled the workflows using the workflow manager . Run the workflows and get the sessions log and run properties from workflow monitor
• Deploying the new development to various environments using Repository Manager from Development to TEST, CERTIFICATION, PROD environments and coordinating onsite and off shore teams.
• Work experience on star and snowflake schemas. Worked on slowly changing dimensions, facts ,bridges and views.
• Worked on OBIEE adding new business and physical joins.
• OBIEE to create new subject area folders and add new tables and modify existing ones. Creating aliases for new tables in physical layer.
• Used OBIEE to add fields to the MyBI in presentation ,logical, physical levels.
• MyBI dashboard and audit queries to track the audit analysis of Nightly run.
• Working on backend to analyze and retrieve the data from Oracle Server on Linux by using SQL Server Reporting Services SSRS BI tool and UNIX commands.
• Designed and developed UNIX Shell Scripts to automate the process of loading and pulling data during testing process.
• Created Objects on DAC to launch ETL workflows.
• Prepared code documentation in support of application development, including high level and detailed design documents, unit test specifications, interface specifications and also provided technical solutions for the Process requests raised by Data team to fix the issues in the existing system.
• Created test cases and performed Unit Testing for the Informatica mappings, documented Unit testing, Logged and resolved defects in the roll out phase.
• Environment: ETL Informatica, Informatica PowerCenter 9.1, Version One, JIRA, SQL Developer,OBIEE,MyBI,PL/SQL, SQL Server 2010, Microsoft Visual Studio 2012/2008 , Flat Files, Unit Testing, Erwin 4.0, T-SQL, SSRS, SSIS, MS-Access, MS-Excel, UNIX Shell Scripts, Linux.

Confidential

Sr. ETL Informatica Developer

Responsibilities:

• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Modified the existing Mappings and created new Mappings as per the requirement.
• Implemented Slowly Changing Dimensions SCDs, Both Type I II .
• Used parallel processing capabilities, Pipeline-Partitioning and Target Table partitioning.
• Worked on SCD1, SCD2,SCD3 dimensions. Created new dimensions and also modified existing dimensions.
• Created, scheduled and monitored sessions and batches on the Informatica server using Informatica Workflow manager.
• Created reusable transformations and Mapplets to use in multiple mappings.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Developed Mappings and Mapplet to extract Claims, Policies and Customer data from flat files and load into the Data Warehouse.
• Created different Transformations for loading the data into target like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Created Mappings to move from Various Systems into the Data Warehouse.
• Extensively involved in almost all the phases of Project life cycle right from Requirements Gathering to Testing and Implementation etc.
• Defined Target Load Order Plan for loading data into Target Tables.
• Experience in using Debugger in Informatica Designer tool to test and fix errors in the mappings.
• Created, updated and maintained ETL technical documentation.
• Monitored workflows Using Workflow monitor.
• Collaborate with business areas and data owners to successfully implement and maintain an enterprise level business analytics and data warehousing solution using OBIEE.
• Used OIEE to develop front-end, metadata and ETL specification to support business requirements for reporting across the organization.
• Performed Unit testing of mappings and sessions.
• Environment: ETL Informatica, Informatica PowerCenter 9.1, OBIEE, Version One, JIRA, SQL Developer, PL/SQL, SQL Server 2010, Microsoft Visual Studio 2012/2008 , Flat Files, Unit Testing, TOAD, Erwin 4.0, T-SQL, SSRS, SSIS, MS-Access, MS-Excel, UNIX Shell Scripts, Linux.

Confidential

Sr. Informatica Developer

Responsibilities:

• Analyzed the business requirements to implement coding using Informatica Power Center.
• Involved in Dimensional modeling to design and develop STAR Schema, using ERwin.
• Performed migration of objects in all phases DEV, TEST,CERTIFICATION and PRD of project and trained developers to maintain system in production.
• Analyzed the architecture to propose an ETL design solution for DWH.
• Documented the approach in the Technical design document to be approved by the client and performed part of the data modeling in Erwin.
• Was involved in logical and physical data model for Admin Server Project. Built the DDL and DML Scripts from the Erwin tool.
• Participated in Incident Management and production support tickets resolution.
• Created a database for various phases and assisted the QA team in building test cases.
• Automated the schedules for running sessions and processes with Informatica scheduler.
• Developed pre-session and post sessions routines for sessions to drop and re-create indexes and key constraints for bulk loading.
• Generated Informatica Mappings to populate the data into dimension and Fact tables for data classifications.
• Developed entity diagrams and data dictionaries to accomplish tasks. Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• As a routine, while working with design of mappings, used various transformations like Aggregator, Lookup, Filter, Router, Expression, Stored procedure and Sequence generator transformations.
• Worked on creating the delete process, eliminating the duplicates and implemented excellent exception handling strategies while developing the Informatica mappings.
• Designed mappings and created a range of transformations to obtain appropriate conversion between the sources and targets.
• Developed an understanding on grids, nodes, repository services and integration services.
• Solved various production issues and worked along with the Informatica global support to troubleshoot failures.
• Created Folders and managed user group access to objects in the repository.
• Performance tuning of the Informatica mappings using various components like parameter files, variables and Dynamic Cache.

Environment: Informatica Power Center 9.1, Oracle, SQL Developer, SQL Plus, Flat Files, PL/SQL, UNIX, TOAD, Erwin 4.0, MS-Access, MS-Excel, UNIX Shell Scripts, Linux.

Confidential

Informatica Developer

Responsibilities:

• Monitored the processes to identify potential issues and apply preventative and corrective actions.
• Provided daily support to clients including data research and test environment data refreshes
• Responsible for the development, implementation and support of the database of the server.
• UNIX Shell scripting for backup and monitoring of databases.
• Worked on Data cleansing, data conversion process implementation.
• Loaded data from various sources Flat files, Oracle, Sql Server, XML using different transformations like Source Qualifier, Joiner, Router, Sorter, Aggregator, Connected and Unconnected Lookup, Expression, Sequence Generator, XML Source Qualifier, Union and Update Strategy to load the data into the target.
• Extensively used Debugger Process to test Data and applied Breakpoints.
• Used PL/SQL to write stored procedures to increase performance.
• Created workflows with the event wait task to specify when the workflow should load the tables.
• Extensively worked with Informatica Tools Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Repository server and Informatica server.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Identified business rules for data migration and analyzed the business requirements.
• Designed the slowly changing dimension strategy for the warehouse.
• Responsible for the dealing with the problems, bug fixing and troubleshooting.
• Provided production support.
• Coordinated between Development, QA and production migration teams.

Environment: Informatica Power Center 8.6.1, Oracle 11g/10g, Clear Case, Clear quest, XML, PL/SQL, Toad 9.6.1.1, Unix Korn-shell scripts, Perl scripts, SQL Server Query Analyzer, Erwin, Linux.

Confidential

ETL Developer

Responsibilities:

• Designed and developed business rules to generate consolidated fact/summary data identified by dimensions using Informatica ETL Power Center Tool.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Created and scheduled sessions and Batch process based on demand, run on time, run only once using Informatica server manager.
• Involved in the performance tuning of mappings and sessions.
• Developed Oracle Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Developed deployment instructions to support the deployment of data marts and reports.
• Performed manual testing prior to automate testing on the application.
• Scheduled and monitored transformation processes using Informatica Server Manager.

Environment: Informatica Power Center, Oracle 9i, PL/SQL, TOAD, SQL Plus, SQL Loader, UNIX.