Summary:

• Eight plus years of total IT experience in Software Development Life Cycle SDLC with strong background in Database Development and ETL Data Warehousing using Informatica Power Center 9.1, 8.6.1, 8.6, 8.1, 7.1, 6.2.
• Extensive experience with Data Extraction, Transformation, and Loading ETL from Multiple Sources. Worked on data integration from various source files such as XML, flat files, CSV files, Relational Databases etc. into a common analytical Data Model.
• Extensive working experience in Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading ETL methodologies.
• Extensively worked on development of complex mappings using various transformations like Expression, Connected/Unconnected Lookup, Filter, Router, Joiner, Union, Aggregator, Update Strategy, SQLT, Transaction control etc.
• Worked on Stored Procedure concept to truncate tables and delete rows from error logs.
• Expertise in using various Informatica Designer Tools such as Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer, Workflow Manager and Workflow Monitor.
• Strong understanding of RDBMS and proficient in writing PL/SQL Procedures.
• Expertise in OLTP/OLAP System, Analysis and database schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Experience in generating various reports using BI tool OBIEE 11g/10g.
• Extensively worked on Performance Tuning techniques at various levels to increase the performance and minimize the time for work.
• Experience in integration of various data sources like Oracle, SQL server and sequential files into staging area.
• Conducted System, UAT and Functionality testing and investigated software bugs.
• Experience in UNIX Shell Scripting.
• Two years of experience in Informatica Power Exchange.
• Worked with Oracle and SQL Server Stored Procedures, Triggers, Cursors and Indexes and experienced in loading data into Data Warehouse/Data Marts.
• Strong business analysis skills to find business problem, process, management and possesses.
• Ability to work individually as well as Team.
• Excellent communication and interpersonal skills. Good team player with excellent analytical and presentation skills with strong aptitude towards learning new technologies.

Technical Skill:

ETL Tool: Informatica Power Center 9.1/8.x/7.x/6.x, Power Exchange 8.6

Data Modeling: ERwin r7.3/4.0/3.5, Star schema Modeling, Snow Flake modeling.

Languages: PL/SQL, SQL Plus, C, C , SQL.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 7.0/2000, DB2, Teradata 12, Neteeza 8050z.

OLAP Tools: BusinessObjectsXIR2, OBIEE 11g/10g.

SQL Tools: SQL Developer, TOAD, SQL PLUS, SQL Loader, CDC.

Office Tools: MSOffice, MS Project, Auto CAD.

Other Tools: SAS, Proficient in Reinsurance System TAI, LynchVal Defined Benefit Valuation Software , Aginity, ESP, Tivoli.

O/S: Windows 95/ 98/NT/2000, XP, UNIX, Sun Solaris, Linux, AIX

Professional Experience:

Confidential

Senior Informatica Developer

• Developed Detailed Design documents based on business requirements.
• Designed and developed Informatica code to extract, convert and load data for the application as per the business requirements.
• Involved in the full development lifecycle from Requirements gathering through Design, Build, QA, Deployment and Support using Informatica PowerCenter.
• 24x7 production support for jobs running in the production environment.
• Involved in debugging the failed mappings identify the root cause and developing error-handling methods.
• Resolved Source system data issues by performing Data profiling and providing workaround techniques.
• Worked closely with business analysts to gather functional specifications and turn them into technical specifications.
• Worked with Direct and Indirect Flat Files.
• Identified long running jobs and implemented various performance tuning techniques to mitigate the bottlenecks.
• Worked with DBA's to tune long running SQL queries.
• Designed and developed complex Informatica mappings including slowly changing dimension Type 1, Type2 .
• Used UNIX commands in sessions to handle multiple target files into one, clean unused Target or error files and remove special characters from Flat files.
• Developed reusable transformations and Mapplets transformations.
• Designed, developed and executed Run Control jobs.
• Worked with different source and target systems like XML, flat file and relational tables.
• Facilitated code reviews as a Lead developer, to ensure code quality.
• Worked on Informatica transformations including but not limited to SQL, XML, SFDC lookup and Stored Procedure to facilitate the business requirements.
• Used Variables and Parameters in Mappings, Workflows and Sessions.
• Created post-session and pre-session shell scripts and mail-notifications. Used various session tasks like Event wait, Timer, Decision and Control.
• Created labels, deployment groups and worked on migrating the code between different environments using deployment groups.
• Develop and maintain the best practices and guidelines throughout data Warehouse practice in the organization.
• Coordinated with the offshore team to make sure tables were loaded appropriately.
• Triaged issues worked on defects and implemented change requests as and when assigned.
• Coordinate with the GFA application team in modifying the existing Informatica ETL code as per the new business requirements.
• Followed agile methodology and used TFS for creating user stories, task and time estimation.
• Develop dashboard and reports using OBIEE 11 g.

Environment: Oracle 10g/11g, SQL Server 2012, Informatica Power Center 9.1,/9.5 Power Exchange 9.1, JIRA, Toad, Microsoft SQL Server Management Studio 2012, WinSCP, Crystal Reports.

Confidential

Senior Informatica Developer:

Business Intelligence Group

• Coordinate with business and the requirements to identify and understand source systems, design, develop, implement, and support ETL Extract, Transformation, and Load processes.
• Migrate data from the organizations various operational systems and platforms to the centralized data warehouse.
• Implemented data cleansing process, efficiently adapting existing ETL routines to accommodate on going changes to the source systems.
• Participate in design and implementation of enterprise data warehouse architectures and best practices.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used SCD Type 1 and Type 2 mappings to update slowly Changing Dimension Tables.
• Extensively used SQL loader to load data from flat files to the database tables in Oracle and created Stored Procedures, functions, views, packages and triggers.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Ability to work on complex data structures, dashboards and ad hoc reporting using OBIEE.
• Worked extensively on OBIEE Answers to create the reports as per the client requirements and integrated them into the Dashboards.
• Provide production support activities in a very large relational database environment including scheduling and monitoring of ETL processes, change management, quality assurance, and Meta data management.

Environment: Informatica Power Center 9.1, Oracle 11g, Teradata 14, DB2, OBIEE 11g, Flat files, PL/SQL, SQL, Erwin 7.5, Toad 7.0, Remedy, ESP.

Confidential

Informatica Lead

Responsibilities:

• Gather Business requirements by interacting with Business Analyst team and analyzed the requirements to translate into Technical Specifications.
• Perform unit testing for Migration of Clients from one date warehouse to another.
• Lead the project for creating custom reports for client that is migrating from Oracle to Neteeza
• Developed various Ad-hoc Technical documents for various business needs.
• Optimized and tuned existing ETL scripts SQL and PL/SQL .
• Maintained, supported, and created ETL scripts for the inBound and outBound systems.
• Managed the load and extraction of data to over seventy internal and external systems.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created Complex mappings using Unconnected connected Lookup, Aggregate, SQLT, Transactional control, Normalizer and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Used sorter transformation and newly changed dynamic lookup
• Created events and tasks in the work flows using workflow manager
• Tuned Informatica mappings for better performance with PL/SQL Procedures/Functions to build business rules to load data.
• Created Schema objects like Indexes, Views, and Sequences.
• Designed and Developed Oracle PL/SQL and UNIX Shell Scripts, Data Import/Export.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Developed shell scripts for running batch jobs and scheduling them.

Environment: Informatica Power center 9.1, Oracle exadata, Aginity work Bench for Neteeza 8050z, PL/SQL.

Confidential

ETL Informatica Developer

Responsibilities:

• Gathered Business requirements by interacting with Business Analyst team and analyzed the requirements to translate into Technical Specifications.
• Responsible to maintain the master data in different schemas and manage the staging table to use in various mappings.
• Developed various Ad-hoc mappings for various business needs.
• Used Informatica Profiler to do Data Analysis.
• Worked with WinSCP to get output from Informatica.
• Developed the mapping to pull the information from different tables and used SQL Override to join the tables instead of Joiner transformation to improve the performance
• Developed the mapping using XML as Target.
• Responsible to write complex SQL queries and PL/SQL procedures to perform database operations according to business requirements
• Used IDQ Informatica Data Quality to extract, transform and load ETL rules and source-to-target mappings to derive additional business rules for Data Quality checks.
• Worked with Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.
• Created Technical Design Document from the functional specification documents.
• Involved in discussing Requirement Clarifications with multiple technical and Business teams.
• Involved during the Source to Target Design documents, Technical Design documents.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations

Environment: Informatica Power Center 9.1, Power Exchange 9.0, SQL Server 2008, UNIX, Erwin, Oracle 11g, WinSCP, Informatica Profiler

Confidential

Sr. ETL Developer/ Data Analyst

Responsibilities:

• Involved during gathering information from the Hospitals, Laboratory, Employers and Doctors from different departments.
• Worked with analysts, using work sessions, to translating business requirements into technical user specifications, including data, process and interface specifications.
• Involved during the Source to Target Design documents, Technical Design documents.
• Followed carefully the International Classification of Diseases while designing the Diagnosis Dimension.
• Developed Logical and physical Data model using Erwin.
• Developed the methods and procedures for data warehouse staff.
• Developed mappings Mapplets to load data from various sources using standard ETL transformations to store the data in the staging area and target tables
• Developed Reusable Transformations, and Reusable Mapplets.
• Created Power Exchange Registration for CDC on oracle tables.
• Involved in discussion of late arrival records. Used surrogate key whenever the business need to make it easier access to Data Warehouse.
• Involved during the design of granularity of the fact and dimension table.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Created and reviewed Test case, Migration doc and release plan doc.
• Coordinated SIT, UAT and Prod release.

Environment: Informatica Power Center 9.1, Power Exchange 9.0, SQL Server 2008, UNIX, Toad, Erwin, Oracle 11g, Linux, Windows XP.

Confidential

ETL Informatica Developer

Responsibilities:

• Requirement gathering and Business Analysis.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
• Reviewed source systems and proposed data acquisition strategy.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Designed the Data Mart defining Entities, Attributes and relationships between them.
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Extensively used PowerCenter to design multiple mappings with embedded business logic.
• Created database objects like Stored procedures, function, packages and triggers.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations, Mapplet for populating target table in efficient manner.
• Created restart token configured workflows and sessions for real time Informatica objects.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.

Environment: Informatica PowerCenter 8.1, Informatica Exchange 8.1, Oracle 10g/9i, SQL Server 2000, PL/SQL, DB2, Erwin, TOAD, SQL Plus, SQL Loader, Windows, UNIX.

Confidential

ETL Developer

Responsibilities:

• Understand the business needs and implement the same into a functional database design.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• End-to-end ETL development of the Premium Module Data Mart.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping Mapplet Designer and Transformation Designer.
• Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting.
• Worked on Informatica utilities like pmcmd, pmrep to start, stop and get status of workflows.
• Designed and developed UNIX scripts for ESP Scheduler to scheduling the jobs.
• Data Quality Analysis to determine cleansing requirements.
• Extensively used Erwin for data modeling and Dimensional Data Modeling.
• Extracted data from various departments to flat files and load the data to the target database.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Created and maintained several custom reports for the client using Business Objects.
• Generated reports using BO tools querying database.
• Created List Reports and Cross Tab Reports and Drill through reports.
• Created standard and Ad hoc reports using Business Objects.

Environment: Informatica PowerCenter 7.2, Teradata V2R5, Business Objects XI/6.5, Erwin 3.5, PL/SQL, Oracle 10g, DB2, Windows 2000, HP-UX, AIX 4.3.3, Shell Scripting.

Confidential

Developer

Responsibilities:

• Developed and maintained complex Informatica mappings.
• Perform data validation tests using complex SQL statements.
• Function as backup on-call programmer for nightly ETL load.
• Analyzed, designed, created and manipulated MS Access and Oracle 9i tables.
• Researched manual and automated systems, developed recommendations and
• Prepared documentation. The recommendations identified unnecessary steps.
• Worked with data warehouse staff to incorporate best practices from Informatica.
• Developed implementation plans and schedules for Informatica enhancements.
• Developed reports based on issues related to the data warehouse.
• Worked with finance staff to document their business rules, data needs and requirements in order to create data warehouse systems.
• Assessing and documenting existing business processes and identifying where improvements can be made or where new processes can be installed.
• Developed data marts using sources such as: agency's HRM data, personnel files and payroll and financial files.

Environment: Power Center 6.2/7.1, Oracle 9i, Flat files, XML, PL/SQL, Windows XP, UNIX, Toad.