SUMMARY

• 9 years of IT experience as Technical consultant for Data Warehouse ETL, experienced in requirement analysis, data analysis, application design, modeling, development, testing and support life cycle of Data Warehouse applications using Informatica 10.x, 9.x.
• Experience in providing Business Intelligence solutions in Data Warehousing using Informatica ETL tool (Extraction, Transformation and Loading).
• Good Understanding of Ralph Kimball and Bill Inmon approaches.
• Excellent knowledge of OLTP and OLAP System Study, Analysis and E - R modeling.
• Designed and developed logical and physical models based on Star and Snow Flake schemas, identification of fact and dimension tables.
• Played significant role in various phases of project life cycle, such as requirements analysis, functional & technical design, testing, production support, and implementation and scheduling.
• 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 writing, testing and implementation of Triggers, stored procedures, functions using PL/SQL.
• Experience in installing, configuring and updating Informatica server and Client.
• Prominent experience in Data Integration, Extraction, Transformation and Loading data from multiple heterogeneous data source systems like Oracle, SQL Server, DB2, XML and Flat files into Data warehouse by using Informatica tool.
• Expertise in working with Informatica tools - Power Center Client tools - Designer, Repository manager, Workflow Manager, Workflow Monitor and Server tools - Informatica Server, Repository Server manager.
• Worked extensively on various data transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, XML, HTTP, Sequence Generator and Stored Procedure transformations in Informatica Power Center Designer.
• Expertise working on slowly changing dimension type1and type2.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations using Informatica debugger .
• Well versed with HIPAA , Facets , claim adjustments , claim processing from point of entry to finalizing, claim review, identifying claims processing problems, their source and providing corresponding solutions.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings and sessions levels.
• Experience in designing and implementing partitioning to improve performance while loading large data volume.
• Strong experience in UNIX shell scripting.
• Strong exposure to working on scheduling tools like TWS and AutoSys .
• Experience in Working under SDLC, Waterfall and Agile methodologies.
• Ensure that user requirements are effectively and accurately communicated to the other members of the development team and Facilitate communications between business users, developers and testing teams.
• Excellent problem-solving and trouble-shooting capabilities. Quick learner, highly motivated, result oriented and an enthusiastic team player.
• Good interpersonal skills, experience in handling communication and interactions between different teams.

TECHNICAL SKILLS

Operating System: Windows NT / XP / Vista, Windows Server 2000 / 2003 / 2008 , UNIX, Linux.

ETL tools: Informatica Power center 10.x, 9.x.

Databases: Oracle 11g/10g/9i, MS-SQL Server 2005/2012, DB2 UDB, MS- Access.

Database Tools: SQL* Plus, SQL Loader, TOAD, DB2 Import, DB2 Export.

Programming Languages: C, C++, Java, SQL, PL/SQL, Shell scripting.

Database Modeling: Star-Schema Modeling, Snowflakes Modeling, FACT and Dimension Tables, Erwin.

Internet Technologies and Microsoft tools: HTML, XML, MS Office toolset ( Word, Excel, Visio, Power point)

Scheduling tools: Autosys, TWS

Reporting tools: SSRS, OBIEE, Crystal reports

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, Production and support for production environment.
• Developed mappings/sessions/workflows using Informatica Power Center 10.2.0 for data loading. Developed mapping to load the data in slowly changing dimension (SCD).
• Also, involved in tuning the mappings in the transformations by tracking the reader, writer, transformation threads in the session logs and used tracing level to verbose during development & only with very small data sets.
• Expertise with connected and unconnected transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Used HTTP transformation for REST API call and validated mailing addresses.
• Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.
• Extensively built mappings with SCD1, SCD2 implementations as per requirement of the project to load Dimension and Fact tables.
• Exclusively worked on the transformations like Aggregator to get monthly, quarterly, Yearly claim aggregations, Connected & unconnected lookups.
• Experience in UNIX shell scripting, for various functions such as maintenance, backup, FTP and configuration.
• Used PMCMD to start and abort sessions and tasks. Also, used INFACMD to track the status of the applications and automate the service notification emails.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Worked on the Database Triggers, Stored Procedures, Functions and Database Constraints.
• Extensive exposure to data extraction, conversion loading from various sources including flat files, SQL Server and DB2.
• Involved in Data Quality Analysis to determine the cleansing requirements.
• Used Power Exchange to extract DB2 Source from mainframe server.
• Used various debugging techniques and Informatica debugger tool to debug the mappings.
• Performed Unit testing and created unit test plan of the code developed and involved in System testing and Integration testing as well. Coordinated with the testers and helped in the process of integration testing and UAT to check the data quality. .
• Prepare Analysis and Design Documents, Source to Target Mappings documents and Unit Test Case documents to get the code ready for production.
• Used Informatica parameter files to filter the daily data from the source system.
• Responsible to provide resolutions for production incidents/failures, user requests and problem tasks.
• Used Informatica Version control to create packages and used Deploy commands for migrating code to upper environments.
• Used CA Harvest workbench to create and deploy deployment group.
• Used Service-now to track sprint stories, screen demands and create change request.
• Worked with Workflow Manager for maintaining Sessions by performing tasks such as monitoring, editing, scheduling, copying, aborting, and deleting.
• Experience in scheduling of jobs using Tivoli Workload Scheduler (TWS).
• Responsible for scheduling the workflow based on the nightly load.

Environment: Informatica Power Center 10.2.0, Power Exchange, DB2, UNIX, Maestro, Windows 10, Flat files, SQL, Developer & Toad, shell scripting, CA Harvest, Service-now, TWS Scheduler.

Confidential

Sr. Informatica Developer

Responsibilities:

• Worked with BA in preparing functional specifications and also involved in user meetings.
• Preparation of technical specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining the standards.
• Perform impact analysis, identifying gaps and code changes to meet new and changing business requirements.
• Created informatica mappings to extract data from Trizetto Facets 4.51 and 4.3 claims database. Analyzed the Trizetto Facets 4.51 data model and assist the Data architecture team to build claims Canonical data model in the ODS.
• Worked with various informatica transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update strategy, Stored procedure, Router and Normalizer etc.
• Worked with connected and unconnected stored procedure for pre and post load sessions.
• Conducted SQL testing for database sources for insert and update timestamps, Counts, Data definitions and Error logic for Facts and Reference tables.
• Developed sequential, concurrent sessions and validated them. Scheduled these sessions by using Workflow manager.
• Extensive use of SCM tool for the maintenance and migration of ETL code across different repositories like Dev, QA and PROD.
• Scheduling of the developed workflows of Informatica using Tivoli by making use of calendar and in build features of Tivoli.
• Created SSRS reports for the business users daily reporting of the inpatient and outpatient daily census data.
• Created test plans, test strategies; setup the test environment, co-ordinate with the business analysts and business users for creating test data to perform extensive testing.
• Involved in production support and resolving the production issues promptly by attending the high priority issues immediately providing best customer support.

Environment: Informatica Power Center 9.1, Informatica Power Exchange, Windows XP/2003, UNIX, Oracle 11g/10g, Trizetto Facets 4.51/4.31, MS SQL server 2005/2012, SQL, PL/SQL, WinScp, HummingBird, IBM Tivoli Work Load Scheduler, SSRS.

Confidential

Informatica Developer

Responsibilities:

• Involved in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into MDR databases.
• Based on the requirements created Functional design documents and Technical design specification documents for ETL Process.
• Interacted with business users, source system owners and Designed, implemented, documented ETL processes and projects completely based on best data warehousing practices and standards.
• Designed, developed Informatica mappings, enabling the extract, transform and loading of the data into target MDR tables on version 9.5
• Involved in performance tuning and fixed bottle necks for the processes which are already running in production. Also gained 3-4 hours load time for each process.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given load window or load intervals.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Created complex mappings using Aggregator, Expression, Joiner transformations including complex lookups, Stored Procedures, Update Strategy and others
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Extensively developed shell scripts for Informatica Pre-Session, Post-Session Scripts.
• Extensively involved in migration of Informatica Objects, Database objects from one environment to another.
• Tested data integrity among various sources, targets and various performance related issues.
• Involved in monitoring and production support in a 24/7 environment.
• Involved in scheduling the workflows using Autosys.

Environment: Informatica Power Center 9.5, ETL, Oracle 10g/9i, PL/SQL, Toad, Autosys, UNIX (HP-UX, Sun Os) and Linux servers.