SUMMARY

• Around 9 years of IT Experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Retail, Banking & Financial services, Telecom, Manufacturing, Insurance, and Pharmaceutical sectors.
• Strong Data Warehouse experience in using Informatica Power Center 9.6.1/9.6/9.5/9.1/9.0/8.6.1 client tools like Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Hands - on experience across all stages of Software Development Life Cycle including requirement analysis, data mapping, build, unit testing, system integration and user acceptance testing.
• Experience in designing and implementing Data Mart/Data warehouse using Informatica and developed transformations, mapping/Mapplets, Sessions and workflows.
• Proficient in the integration of various data sources like Oracle, flat files, XML, MS SQL Server and Teradata into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in designing/developing complex mapping using transformations like Connected and Unconnected Lookup, Router, Filter, Expression, Aggregator, Normalizer, Joiner, Union and Update Strategy.
• Created and maintained Informatica users and privileges.
• Strong Knowledge on E-R modeling and Dimensional Data Modeling Methodologies like Star schema and Snowflake Schema used dimensional and multidimensional modeling.
• Experience in using Informatica Utilities like Pushdown Optimization, partition and implemented SCD (Slowly Changing Dimension) Type 1, Type 2, Type 3 methodologies.
• Hands on Experience in Performance Tuning Techniques on various levels like source, target, mapping, session and databases.
• Conducted System, UAT and Functionality testing and investigated software bugs.
• Extensive experience in conducting Requirement-gathering sessions, writing Business Requirement Document (BRD), Functional Requirement Document.
• Experience in using SQL, PL/SQL, SQL*Loader, SQL*Plus, Import/Export utilities.
• Worked with Oracle Stored Procedures, Triggers, Indexes, DML, DDL, Database Links, Sequences.
• Experienced in Data Profiling, Data Mining and Cleansing.
• Worked on UNIX shell scripts used in scheduling Informatica pre/post session operations.
• Excellent communication and documentation skills using tools like Visio and PowerPoint.
• Have excellent analytical, problem solving & interpersonal skills and can work as a part of a team as well as independently.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6.1/9.6/9.5/9.0/9.1/8.6.1

Data Modeling: Erwin 9/7/8/9, MS Visio

Databases: Oracle 12c/11g, SQL Server 2008/2008R2/2012,2014, DB2, MS Access 2000, Teradata, Netezza

Reporting Tools: Congo’s, Micro Strategy and Hyperion Brio

Tools: /Utilities: TOAD, SQL Developer

Testing Tools: Test Director, Rational Clear Quest, HP Quality Center

Scripts: SHELL

Operating Systems: Windows98/2000/XP/ 2003/2012/2016 , LINUX, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Deerfield, IL

Sr. Informatica Developer

Responsibilities:

• Interacted with Business users/customers to confirm the requirements needed for developing and modifying the jobs and to identify the various sources of data in operational systems and developed strategies to build data warehouse.
• Analyzed the business and functional requirements and provided high level technical design specifications to drive ETL Development efforts.
• Actively involved in the Design and development of the STAR schema data model.
• Designed ETL specification documents to load the data in target using various transformations according to the business requirements.
• Extensively worked withInformaticaPower Center to load data from flat files, oracle and other source systems into target database.
• Designed and developed Complex Informatica mappings using various transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, and Rank for populating target tables/Files in an efficient manner.
• Designed and developed ETL workflows with job dependencies and scheduling, participated in code reviews of ETL processes.
• Created Visio diagrams of ETL process to include in the design documents.
• Created check-lists for coding, reviewing, bug logging, troubleshooting, testing and release for smooth functioning of the entire project.
• Created and Configured Workflows, Worklets, and Sessions to load the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Wrote Unix Scripts to invoke Informatica Workflows and sessions.
• Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements.
• Implemented Error handling logic to capture Invalid/Null records coming from staging tables.
• Tuned and optimized ETL jobs for performance and throughput.
• Created test plans for unit testing, integration testing and UAT.
• Developed SQL Scripts and ad-hoc queries for data verification and validation processes.
• Managed QA and PROD deployments and automation of ETL Jobs.
• Provided assistance in diagnosing production problems related to the project.

Environment: Informatica Power Center 9.6.1, Erwin 4.0, Oracle 12c, TOAD 12.10, Quality Center and UNIX.

Confidential, Columbus, OH

Sr. Informatica Developer

Responsibilities:

• My involvement in this project revolved around development, enhancements, Production support, testing and documentation.
• Coding for new Business requirements and Work Requests by designing mapping as per the ETL Specification.
• Worked with Team Lead and Development team for analysis, design, development and implementation of project.
• End to end creation of mappings and workflows involving the sources from Flat files, XML, Oracle and Sqlserver with the inclusion of all the transformations and the execution of the workflows.
• The SQL overrides in Source Qualifier and Look ups, Partitioning, Usage of Source Qualifier and Joiner etc. were done as a part of performance tuning measure.
• Create various Transformations like Source Qualifier, Union, Update Strategy, Joiner, Aggregator, Expression, Update Strategy, and Filter, Lookup (Connected & UN Connected) & Router etc.
• Administered the repository by creating folders and logins for the group members and assigning necessary privileges.
• The testing phase involved the preparation of the test cases and the relevant validations regarding the data integrity and the data Quality.
• Worked on the Windows Batch scripting, indirect loading, Creation and alteration of tables in Oracle and SQL Server inserting and updating data.
• Used AUTOSYS as a scheduling tool.
• Compare the counts in SQL server and Oracle for Critical workflows.
• Error Handling, Scheduling, Identifying ETL Job Dependency to run the jobs.
• Attend and Lead Daily status calls and provides status to the Client and onsite team daily on the Open items and tasks we do and understanding the changes being applied to the application.
• Developing and preparing program documentation in accordance with client requirements.
• Ensure bug-free production implementation.

Environment: Informatica Power Center 9.6, Oracle 11g, SQL Server 2014, TOAD 12.7, AUTOSYS, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Involved in Systems Study/Analysis and understand the business and implement the same into a functional database design.
• Created source definitions from flat files, Oracle, imported Target definitions and created Reusable Transformations in Informatica Power Center.
• Participated in designing the data model using Erwin.
• Created Informatica mappings to build business rules to load data.
• Identified and tracked the Slowly Changing Dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository manager.
• Used Unix Shell scripting to get data from source for the transformation to cleanse data as per business rule and also to automate pre-session & post-session processes.
• Developed Transformation Logic in Informatica to cleanse the source data to inconsistences before loading the data into the staging area which is the source for stage loading.
• Worked on connected & unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter, Sequence Generator and Joiner Transformations to implement complex business logic.
• Used PMCMD commands for automating Batches and Sessions.
• Extensively used Teradata Utilities including FAST LOAD, FASTEXPORT, TPump and TPT.
• Identifies and fixed bottlenecks and turned the Informatica mappings for better performance.
• Created Test cases for Unit Test. Used TOAD to validate the data with SQL Query.

Environment: Informatica Power Center 9.5, Oracle 11g, TOAD, UNIX, ERWIN, Teradata 15.10, Windows XP.

Confidential

ETL/Informatica Developer

Responsibilities:

• Worked on Informatica tools like Power Center Designer, Workflow Manager and Workflow Monitor.
• Performed data manipulations using various Informatica Transformations like Joiner,
• Expression, Lookup, Sorter, Aggregate, Filter, Update Strategy, Normalizer and Sequence Generator.
• Developed InformaticaType-1 and Type-2 Mappings based on the requirements.
• Involved in Mapping, Session and database level optimization techniques to improve the performance.
• Involved in creating complex workflows which utilize the various tasks like Event Wait, Command, Mail decision and Session.
• Extracted data from Flat files and Oracle to load them into Teradata.
• Worked on WLM Scheduler to automate the Workflows.
• Prepared SDLC Work book and conducted walk through before moving to SIT, UAT and Production.
• Involved in the Performance Tuning of Database and Informatica
• Debugged invalid mappings using break points, tested stored procedures, functions, Informatica sessions, batches and the target data
• Wrote stored procedures in PL/SQL and UNIX Shell Scripts for automated execution of jobs
• Identified performance bottlenecks and resolved those issues by Query optimization, dropping Indexes and Constraints, bulk loading.
• Created reusable transformations and Mapplets to use in multiple mappings.
• Created complex/ad-hoc reports using Business Objects reporter and exported to the repository.
• Defects were tracked, reviewed and analyzed.

Environment: Informatica Power Center 9.5, Teradata V12, Oracle 11g, WLM, UNIX, Windows XP.

Confidential

ETL/Informatica Developer

Responsibilities:

• Involved in client meetings for requirements and analysis, translate the Business requirements into technical requirements for ETL transformations.
• Involved in the analysis of the user requirements and identifying the sources.
• Created technical specification documents based on the requirements.
• Involved in the preparation of High level design documents and Low level design documents.
• Designed and developed Informatica’s Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.
• Worked on various kinds of transformations like Expression, Aggregator, Stored Procedure, Lookup, Filter, Joiner, Rank, Router and Update Strategy.
• Developed reusable Mapplets and Transformations.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Involved in monitoring the workflows and in optimizing the load times.
• Used Change Data Capture (CDC) to simplify ETL in data warehouse applications.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Worked with SQL*Loader tool to load the bulk data into Database.
• Prepared UNIX Shell Scripts and these shell scripts will be scheduled in AUTOSYS for automatic execution at the specific timings.
• Rational Clear case is used to Controlling versions of all files & Folders (Check-out, Check-in)
• Prepared test Scenarios and Test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.
• Defect Tracking and reports are done by Rational Clear Quest.

Environment: Informatica Power Center 8.6/9.0, SQL*Loader, HP Quality Center, Oracle 11g, AUTOSYS, Rational Clear case, Rational Clear Quest, Windows XP, TOAD, UNIX.