SUMMARY

• 7+ years of experience in the Software Development Life Cycle (SDLC) that includes expertise in the Analysis, Design, Development, Implementation, Modeling, Testing and Support for Data Warehouse.
• Experience in Data Warehousing using the tool Informatica PowerCenter (Designer, Repository Manager, Workflow Manager, Workflow Monitor and PowerCenter Administration Console) to extract data from diverse sources including flat files (fixed width, delimited), XML, Oracle and SQL Server.
• Extensively used applications in the Informatica PowerCenter Designer such as Source Analyzer, Transformation Developer, Target Designer, Mapping Designer, Mapplet Designer and Schedulers
• Developed complex mappings using transformations such as Aggregator, Connected and Unconnected Lookup, Filter, Joiner, Expression, Filter, Sorter, Router, Normalizer, Source Qualifier and Update Strategy
• Experience working with various heterogeneous source systems such as Oracle, DB2, MS SQL server, XML files, flat files and MySQL server
• Performed ETL performance tuning of the sources, targets, transformations, mappings, workflows and sessions to resolve or remove the bottlenecks
• Expert in using debugger in the Informatica PowerCenter Designer to test and fix errors in the mappings
• Strong background in Data Warehousing concepts and implementing Dimensional modeling concepts (Star and Snowflake schema, type 2 and type 3 SCD’s)
• Experience in using SQL tools such as TOAD/ SQL Developer/ SQL Plus/ SQL Loader to run SQL queries and validate the data
• Extensively used PL/SQL to write Stored Procedures, Functions and Triggers and involved in DB partitioning for improving performance of SQL queries
• Written stored procedures for Automatic Scripting to backup transaction logs, log files, maintain archive of objects and so on.
• Experienced in writing T - SQL queries and stored procedures, Performance tuning.
• Good experience in SQL, PL/SQL, Forms & Reports, Interfaces and APIs.
• Good Experience in working on Data Conversions.
• Well versed with Unix Shell Scripting and Data Conversion from Flat files to client’s database using SQL* Loader.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions
• Experience in working with Mainframe files, COBOL files, XML, and Flat Files
• Expertise in working with database like Oracle, SQL Server and Teradata.
• Implementing Business Logic for Financial, Health Care, Insurance and manufacturing verticals
• Computer-literate performer with extensive software proficiency covering wide variety of applications, along with analytical thinking for identifying, scrutinizing, improving, and streamlining complex work processes.

TECHNICAL SKILLS

ETL Tools: Informatica 10.x/9.x/8.x/7.x, Informatica Repository Manager, Informatica Designer, Informatica Workflow Manager, Informatica Monitor .

Database Integration Tools: Oracle 12c/11g/10g/9i/8i, MS SQL server 2005/2008

Date Modelling: Star Schema, Snow Flake Schema, Physical And Logical Modeling, Dimension Data Modeling, Fact Tables, Dimension Tables.

Enterprise Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL Developer, SQL Plus, TOAD, SQL Server Reporting Services

Languages: CICS, COBOL, C, C++, HTML, VB scripting, SQL, XML

Testing tools: Query Test Professional, HP- Quality Center, PRATS (Performance Testing tool)

Other: Rational Rose, Lotus Notes, VSS, MS Office, MS Project 2007, Tidal, Control-M

PROFESSIONAL EXPERIENCE

Confidential, BIRMINGHAM, AL

Sr.Informatica Developer

Responsibilities:

• Designed and Developed ETL architecture/solution including the nightly batch process, physical integration/infrastructure of ETL servers and databases.
• Involved in gathering business requirements, establishing functional specifications and translating them to design specifications.
• Knowledge on dimensional modeling to design and develop the STAR Schema using Erwin.
• Worked as an Administrator on creating users, groups, folders, categories and connections in the repository and assigned access privileges.
• Developed mappings using Informatica 9.5.1 to load data from multiple sources and file systems such as Cobol VSAM, Flat files,SEQ files into Oracle tables .
• Extensively Used Informatica client tools like Source Analyzer, Target designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Extensively worked with transformations like Lookup, Update Strategy, Expression, Filter, Router, Joiner, and Aggregator.
• Worked on lookup caches like Static, Dynamic, and Persistent in Lookup transformation as per the requirement for better performance.
• Developed complex mappings involving SCD type-I, Type-II mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations and used Update strategy and Target load plans.
• Created and used Mapplets and reusable transformations using Informatica Power Center and created data break points and error break points for debugging the mappings using Debugger Wizard.
• Used Mapping parameters, variables and session parameters to dynamically enter values between sessions and to parameterize Relational and Application connections, Filenames and other objects.
• Implemented Performance Tuning measures in source, target, mapping, session design
• Worked on different tasks in Workflows like sessions, event raise, event wait, decision, e-mail, command, Assignment, Timer etc.
• Generated interactive reports using SQL Server Reporting Services as per the client's request.
• Created multiple operational and finance reports and Charts and scheduled them to run Hourly, Daily, Monthly according to client requirements for the periodic analysis using SSRS 2012 and SSRS 2014
• Developed PL/SQL procedures, for creating/dropping of indexes on tables using target pre-load and post-load strategies to improve session performance in bulk loading, for gathering statistics and archiving table Data.
• Created pre-session and post session UNIX scripts for file delete, rename, archive and zipping tasks.
• Responsible for Testing and Validating the Informatica mappings against the pre-defined ETL design standards.
• Implemented Test plans and test cases for unit-test and peer-review Test and Fixed bugs and validated mappings.
• Worked as production support and in finalizing scheduling of workflows using Tidal, Control-M and Deployed the Workflows in the production repository and server and supported them through automated Shell scripts.
• Good Knowledge onapplying rules and policies using ILM (Information Life Cycle Management) workbench for Data Masking Transformationand loading into targets.

Confidential, Louisville, KY

Sr.Informatica Developer

Responsibilities:

• Gathered Business requirements from the end users and reporting team.
• Developed Informatica Mappings for the complex business requirements provided using different transformations like Normalizer, SQL Transformation, Expression, Aggregator, Joiner, Lookup, Sorter, Filter, Router and so on.
• Used Informatica Power Center 9.x for extraction, transformation and load (ETL) of data in the data warehouse.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.Participated in the entire life cycle of the project, which involved understanding scope of the project, functionality, Data modeling, technical Architecture document, technical design and complete development.
• Designed and developed Operational Data Store, Slowly Changing Dimension, Staging areas etc.
• Involved in extraction of data from various sources like flat files, Oracle and SQL Server.
• Used debugger to test the mapping and fixed the bugs. Created and used Debugger sessions to debug sessions and created breakpoints for better analysis of mappings.
• Extensively worked in the UNIX environment using Shell Scripts.
• Implemented Slowly Changing Dimension Methodology (type 2) for accessing the full history of accounts and transaction information.
• Analyzed the session logs, bad files and error tables for troubleshooting mappings and sessions
• Designed and Developed pre-session, post-session routines for Informatica sessions to drop and recreate indexes and key constraints for Bulk Loading.
• Involved running the various types of Pipelines and running the True comp Data Mart etl's.
• Involved in the automation of True comp activities through unix shell scripts.
• Created Indexes and sequences for faster retrieval of the member information and enhance the database performance.

Environment: Informatica Power Center 9.5/9.1/v 8.6.1, IBM Data Stage7.5.1, Power Exchange, IBM Rational Data Architect v7.0.5, HP 3000, XML/XSD, Qwest Center, MS SQL Server, Teradata.

Confidential

ETL Developer

Responsibilities:

• Extensively involved in development of mappings using various transformations of Informatica according to business logic
• Extensively used ETL tool to extract data from Oracle, Flat Files and XML sources
• Implementing the transformation rules of ETL specs in Informatica mappings
• Designed and developed more than 60+ Mappings to load data from Source systems to staging Area and then to ODS, and to Data Mart
• Created and Monitor the sessions using workflow manager and workflow monitor
• Developing Transformations like Lookup, Joiner, Expression, Update Strategy, XML Parser and Source Qualifier Transformations in the Informatica Designer.
• Crosschecked / testing the mapping designs according to the business rules and suggested alternate designs to make the mapping design more robust and error-free.
• Data Quality Analysis to determine cleansing requirements
• Extensively used ETL to load data from Oracle and Flat files to Data Warehouse
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Scheduled Sessions in the Informatica workflow Manager
• Fine-tuned existing sessions for performance increase measures.
• Involved in developing test plans, writing test scripts and test executions, analyzing test results
• Involved in unit testing and Integrate testing from Source to staging area
• Created and Scheduled Sessions and Batches using Server Manager
• Successfully deployed the Sessions and Batches from the Development environment to Production environment.

Environment: Informatica Power Center 9.5/9.1/v 8.6.1, IBM Data Stage7.5.1, Power Exchange, IBM Rational Data Architect v7.0.5, HP 3000, XML/XSD, Qwest Center, MS SQL Server, Teradata.