SUMMARY

• An IT professional with 7 years of experience in mission critical software applications with a strong background in Data Warehousing and Oracle technology areas.
• Well versed with Data warehousing Architecture on the Design, Development, Extraction, Transformation and Loading of data using Informatica Power Center as an ETL tool.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Strong knowledge of Entity - Relationship, Facts and Dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in building the Data warehouse using Ralph-Kimball methodology.
• Extensive experience in developing mappings for Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse/Data Marts.
• Expert on Slowly Changing Dimensions Type1, Type 2 and Type 3 for inserting and updating Target tables for maintaining the history.

SKILLS

ETL:  InformaticaPowerCenter9.x/8.x/7.x

Designing and Scheduling tools: ERStudio 9.x, Erwin, Visio, Autosys, Control M

Databases: Oracle 11g/10g/9i, MS Access, SQL Server, Teradata, DB2

Languages: C, C++, HTML, SQL, PL/SQL, Visual Basic, Unix Shell Scripting

OS: Windows 98/2000/NT/XP, UNIX

Packages: SQL* PLUS, SQL Loader, Enterprise Manager Console, Toad 7.5, IBM Data Studio

EXPERIENCE:

Informatica Developer

Responsibilities:

• Worked closely with the Business Analysts to understand the Data requirements, definitions, and business rules to be implemented.
• Gathered business rules and requirements of different Lines of Business for the ETL process from various Development Centers in the Enterprise.
• Involved in developing the logical and physical models using ER Studio.
• Prepared the required application design documents based on functionality required.
• Used Informatica as an ETL Data movement tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various platforms.
• Developed mappings using flat files and relational databases as sources.
• Developed reusable transformations and mapplets, and used them in mappings.
• Used SQL override queries in source analyzer to customize mappings.
• Used Informatica debugger to find troubleshooting information about data and error conditions in the mappings.
• Responsible for creating mappings and transforming existing feeds into the new data structures maintaining client standards utilizing Normalizer, Router, Lookups (Connected, Unconnected), Expression, Aggregator, Update strategy transformation.
• Responsible for designing and creating restartability and failover mechanisms and implemented them using informatica mappings which can support real-time synchronization of mapping to run continuously 24/7.
• Involved in design discussions when creating a separate exception handling framework to deal with the real time and non real time exception records which helps in storing/reprocessing/audit purposes.
• Actively involved in various proof of concept discussions by exploring various solutions to meet and satisfy business requirements and needs.
• Handled UNIX operating system tasks to run informatica jobs using Control M and also generating Pre and Post-Session UNIX Shell Scripts.

Environment: Informatica Power Center 9.x, DB2, Flat files, Control M, ER Studio 9.x,Visio, UNIX Shell Scripting.

Informatica Developer

Responsibilities:

• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Prepared the required application design documents based on functionality required
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width), and Excel files to staging database and from staging to the target Oracle Data Warehouse database.
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Designed and developed the logic for handling slowly changing dimension tables load by flagging the record using update strategy for populating the desired.
• Involved in cleansing and extraction of data and defined quality process for the warehouse.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Involved in migration of mappings and sessions from development repository to production repository
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.

Environment: Informatica Power Center 9.1, Oracle 11g, TOAD 9x, PL/SQL Developer 7.1.0, LINUX, UNIX Shell Scripting, SQL*Loader

Informatica Developer

Responsibilities:

• Instrumental in Analysis, Requirements Gathering and documentation of Functional & Technical specifications.
• Involved in Dimensional modeling to Design and develop STAR Schemas using ERWIN to identify Fact and Dimension Tables.
• Worked extensively on Informatica client tools such as Designer, Workflow manager, Workflow Monitor.
• Extensively used ETL to load data from sources such as Flat Files, Oracle to Oracle, Teradata Target Data base.
• Based on the business requirements Reusable transformations are created in transformation developer and Mapplets in the Mapplet designer.
• Developed complex mappings to transform the data using Rank, Sorter, Stored Procedure, Joiner, Aggregator, Filter, Connected lookup, unconnected lookup and Router transformations.
• Implemented slowly changing dimensions type 2 to keep track of historical data.
• Extensively used dynamic lookup cache for slowly changing dimensions.
• Used workflow manager for creating, validating, testing and running the Sequential and Concurrent batches and sessions and scheduling them to run at specified time with required frequency.
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions.
• Used Workflow Monitor to monitor the jobs, review error logs that were generated for each session, and resolved them.
• Extensively performed unit testing and system testing.
• Performed Database end tuning using EXPLAIN PLAN and analyze table queries.

Environment: Informatica PowerCenter 8.6, Oracle 10g, DB2, Autosys, SQL Server 2008, PL/SQL, Teradata, Toad, ERwin 3.5, Unix.

ETL Developer

Responsibilities:

• Understanding the customer requirements and analyzing or resolving the discrepancies in the business requirements
• Worked to design the proper architecture which can isolate the application component (business context) of the data integration solution from the technology, it also helps for reuse - reuse of skills, design objects, and knowledge
• Prepared the Design documents as per the requirements of the Business Analysts and Data model
• Extensively used Informatica to load data from flat files and DB2
• Developed Shell Scripts for retrieving files from FTP server, achieving the source files, Concatenating files and finally to deliver them to remote shared drive
• Developed the error Logic for streamlining, automating the data loads for cleansing incorrect data and developed Auditing mechanism to maintain the load statistics of transactional records
• Designed and developed standard load strategies to load data from source systems to Actimise Database which is the final target system.
• Prepared documentation on the design, development, implementation, daily loads and process flow of the mappings and participating in review design documents
• Used IBM DB2 Control center, Control editor to check the table design, records populated in the DB and used to test the data to check whether it is correctly loaded into the required schemas as per the business requirements
• Extensively involved in performance tuning using various components in the mappings, sessions or database tables and used Parameter files, Variables, cache mechanism and using SQL overrides.

Environment: Informatica Power Center 8.1, DB2, AIX OS as platform and CA7 Scheduling tool.

ETL Developer

Responsibilities:

• Requirement Analysis and Design
• Coding (involves coding of shell scripts, Informatica mapping, sessions and workflows)
• Unit Testing
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Developed Shell Scripts, PL/SQL stored procedures, table and Index creation scripts.
• Created complex transformations using Source Qualifier, Joiner, Aggregator, Lookup, Router, Expression, Update Strategy and Sequence Generator.
• Used Informatica Power Center Server manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in developing the SQL scripts for Extract and load the data warehouse.
• Involved in Unit and Integration testing of Informatica Sessions and Target Data.

Environment: Informatica PowerCenter 7.1, MS Access, SQL Server 2005, Oracle 8i/7i, PL/SQL, SQL *Loader, Windows 2000, UNIX.