PROFESSIONAL SUMMARY

• 8 years of experience in IT industry. Roles played during the career include Senior Developer, Onsite-Coordinator, Application Developer and Quality Analyst.
• 7 years of extensive hands on experience with Informatica client tools like designer, workflow manager, workflow monitor, and repository manager.
• Excellent Knowledge on Slowly Changing Dimensions, Change Data Capture, Dimensional Data Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data Marts, OLAP, and FACT Dimensions tables, Physical Logical data modeling.
• Worked in different phases of the projects involving Requirements Gathering, Design, Development, Deployment and Project Closure
• Domain Knowledge in Healthcare, Banking, Finance and Insurance Industry.
• Hands on Experience in Application Development, Production support and Application Quality Assurance.
• Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout the Software Development life cycle SDLC .
• Excellent Knowledge in creating Test Scripts and executing those across environments. Also strong experience in Execution and Documentation of Regression, System User Acceptance Test Plans, Test Scenarios and Test Results for Large Mainframe System.
• Expertise using the defect tracking tools like Quality Center .
• Populated slowly changing dimensions tables using SCD Type 2 to maintain full History of data.
• Extensive knowledge on data quality measurement using IDQ.
• Managing overall product performance, providing oversight of significant enhancements to the product and setting priorities to ensure client satisfaction.
• Having strong analytical ability and excellent communication skills.
• Provide leadership and strategic direction to the project team, providing coaching, training, development and feedback to line managers as needed.
• Experience in scheduling and executing jobs through Autosys, Control-M, and Crontab schedulers.
• Experience in working with Oracle using SQL, PL/SQL.
• Hands on experience in Change management and Project Management.
• Build a standards-driven, scalable, secure and dynamic portal for the information delivery of specific based applications.
• Develop enhancements, resolve issues, coordinate testing of statement releases and oversee regular production efforts including data extracts, data warehouse feeds and printing.

TECHNICAL EXPERTISE

PROFESSIONAL EXPERIENCE

Confidential

Role: ETL Developer

Responsibilities:

• Worked extensively on various transformations like Normalizer, Expression, Union, Joiner, Filter, Aggregator, Router, Update Strategy, Lookup, Stored Procedure, and Sequence Generator and created mappings.
• Analyzed the business requirements and framing the Business Logic for the ETL Process and maintained the ETL process using Informatica Power Center.
• Developed an ETL Informatica mapping in order to load data into staging area. Extracted from flat files and databases and loaded into Oracle 10g target database.
• Created workflows and worklets for Designed Mappings.
• Implemented logic for Slowly Changing Dimensions.
• Wrote Stored Programs Procedures Functions to do Data Transformations and integrate them with Informatica programs and the existing applications.
• Used Workflow Manager for Creating, Validating, Testing and Running the sequential and concurrent Batches and Sessions, scheduled them to run at a specified time.
• Also extensively worked on SQL coding for overriding for generated SQL query in Informatica.
• Involved in Unit testing for the validity of the data from different data sources.
• Design and develop PL/SQL packages, stored procedure, tables, views, indexes, and functions.
• Worked on Parameterize of all variables, connections at all levels in Window XP.
• Involved in migrating the ETL application from development environment to testing environment.
• Performed data validation in the target tables using complex SQLs to make sure all the modules are integrated correctly.
• Analyzed Session log files to resolve error in mapping and identified bottlenecks and tuned them for optimal performance.
• Created UNIX shell scripts for Informatica pre/post session operations.
• Documented and presented the production/support documents for the components developed, when handing-over the application to the production support team.

Environment: Informatica 9.5.x, Oracle 11g, MS SQL Server 2008, Power Exchange 8.6.1, flat files, Windows XP, UNIX.

Confidential

Role: ETL Developer

Responsibilities:

• Mainly Involved in ETL Developing.
• Using Informatica Power Center as an ETL tool to pull data from source systems, transforms, and load data into targets in various Layers.
• Creating the mappings based on the mapping specification document and creates sessions and workflows for respective Mappings.
• Working on Power Center client tools like Source Analyzer, Target designer, Mapping Designer.
• Importing Sources and Targets from Shared Folder and used Shortcuts in Mappings.
• Prepared Pre and Post SQL Queries used in the Session Level.
• Working on the transformations such as Source Qualifier, Expression, Lookups, Filter, Router, Sorter, Joiner, Sequence Generators, Aggregators, Union, and Rank.
• Wrote detailed design specs for ETL and converted the functional specs written by Data Modelers into the detailed design spec for ETL.
• Populated slowly changing dimensions tables using SCD Type 2 to maintain full History of data.
• Checked and tuned the performance of Informatica Mappings and Involved in Defect Fixing.
• Create Sessions and Workflows and run the Workflows through Third Party tool Autosys.
• Creating mapplets, reusable transformations and using them in mapping.
• Analyzed tables, Indexes and Hints to tune the performance on long running mappings
• Performed profile run to analyze the structure and content of the data and identify the loops.
• Be as on call support during the nightly ETL run and attend to any emergency, which affect SLAs work with business.
• After Successful the workflows, Execute the Row Count validation queries to check the count match between Source and Target.
• Create documents including data quality plan design, mapping specifications, change request form, test cases.
• Import data from various Sources transformed and loaded them into Targets in each Layer.
• Perform the Unit testing whether the data is loading based on the business logic or not.
• Create and test ETL processes based on specifications.
• Support testing and Production issue resolution on newly developed or existing ETL processes.
• Troubleshoot data loading and transformation procedures for functionality and performance problems.
• Loaded data from CSV files to the oracle database using SQL loader.

Environment: Informatica Power Center 9.1, Oracle 11g, SQL Developer, UNIX, Autosys, Windows 7, Quality Center

Confidential

Role: ETL Developer

Responsibilities:

• Experience with ETL/ETI Informatica Extraction Transform and Loading, Extraction Transform and Import data from production database to data warehouse database.
• Developed Technical Specifications of the ETL process flow.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer Mapplet, and Transformation Developer.
• Created different transformations such as source qualifier, joiner, lookup, rank, expression, aggregator and sequence generator etc.
• Developed/Enhanced the complex mappings, Workflows to Extract, Transform, Load data from different source systems like Oracle, SQL Server, Flat files, Excel, to Target Oracle systems.
• Reused mapping, Mapplets and transformations.
• Worked on OBIEE tool for customizing the Physical layer, Business layer, Presentation layer and modifying it according to the business requirements.
• Created Business Process Modeling BPM diagrams using standard Business Process Modeling Notations in Informatica.
• Used CRON TAB on Unix Server to schedule and monitor sessions and batches.
• Scheduled sessions and batches on the Informatica Server using Informatica Server.
• Tuned the transformations and mappings in Informatica.
• Implemented slowly changing dimensions.
• Prepared Custom Dashboards and Reports using OBIEE.
• Created users, groups using Web Admin Tool assigned different dashboards permissions
• Worked with mapping variables, mapping parameters and variables functions like Set variable, Count Variable, Set invariable and Set max variable.
• Developed Mappings that extract data from ODS to Data mart and monitored the Daily, Weekly and Monthly Loads.
• Worked on SQL stored procedures, functions and packages in Oracle.
• Created and monitored Sessions/batches using Informatica Server manager/ Workflow Monitor to load data into target Oracle database.
• Involved in Production Support in resolving issues and bugs.

Environment: Informatica Power center 9.1, Database Systems, SQL and PL/SQL, Windows NT, UNIX/Linux, OBIEE, Oracle10g and UNIX Shell Scripts.

Confidential

Role: ETL Developer

Responsibilities:

• Understanding of client business requirement and documentation of same
• Preparation of mapping documents based on client requirement specifications.
• Created Informatica Mappings, usage of Lookups, Aggregator, Ranking, Mapplets, connected and unconnected and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.
• Preparation of ETL Design documents and Functional Technical specifications.
• Worked on Informatica Data Quality 8.6.1 IDQ toolkit and performed data profiling, cleansing and matching and also imported data quality files as reference tables.
• Worked on rules to validate the data in a profile and measured the data progress in data quality.
• Perform in depth unit testing for all development, including data analysis for verification of accuracy and performance tuning for optimal execution.
• Assisting in Developing of Dimensions and Facts for the Data Warehouse.
• Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions
• Wrote complex SQL queries involving multiple joins and sub-queries.
• Involved in taking requirements and writing specifications for designing the Universes to get the data from the Data Warehouse.
• Created Class and Objects and following the Naming standards.
• Developed Complex reports using Web I.
• Used ERWIN 7.2 to reverse engineer the table scripts.
• Conducted Training Programs to team members.
• Prepared the Test case and Test Scripts for Unit testing.
• Involved in production support based on the Remedy tickets modified/resolved the Reports using TSG.
• Scheduled the WEBI reports using INFO View.
• Handled 5 members of team.
• Universe and Report Migration from Dev to QA to Prod.

Environment: Informatica Power Center 8.6, Oracle 9i, SQL Loader, IDQ 8.6.1, ERWIN 7.2, Windows Server 2008, UNIX and Web Intelligence

Confidential

Role: Informatica Developer

Responsibilities:

• Created Technical Design Document from the functional specification documents.
• Worked on different Transformations like Union, Rank, Sorter, Aggregator, Lookup, Expression, update Strategy, Joiner, and Router to load the data into staging tables and then to target.
• Involved In loading data into common staging area and then loaded them to the target Warehouse database.
• Developed Mappings using Type 1, Type 2 SCD Slowly Changing Dimensions logic to load data into Dimension tables.
• Gathered Functional Requirements and used them in designing the Mapping Technical Specifications.
• Performed Data Extraction, Data Cleansing, Data Scrubbing and Data Staging of operational sources.
• Created reusable mapplets and transformations, Initializing concurrent batch process in server and performed backup, recovery and tuning of sessions.
• Extensively used Informatica client tools like Source Analyzer, Mapping designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.
• Developed scripts in UNIX, SQL and PL/SQL
• Used SQL, PL/SQL, TOAD to validate the Data going in to the Data Ware House
• Worked with Crontab Scheduler to schedule the workflows.
• Coordinated with the new joiners in the team by explaining the project in functional perspective.

Environment: Informatica Power Center 8.6, Oracle 10g, PL/SQL, ERWIN 4.1, MS-Excel XP Spreadsheet Add-In, Shell Scripting, and Windows 7.

Confidential

Role: ETL Developer

Responsibilities:

• Developed Informatica mappings and workflows to create intermediate data files by integrating data from various feeds and database.
• Responsible for developing a data-mart for the early collection system of the bank.
• Responsible for upgrading the dialer system of the bank.
• Upgrading the existing module for banking applications.
• Developed PL/SQL scripts for Data loading and Data extraction.
• Developing various excels reports and maintaining the web based reports.
• Implementing Change Requests as requested by the customer.
• Resolving the Service Requests and Priority Requests as raised by the business.
• Providing production support for the jobs.
• Applied slowly changing techniques and Dynamic lookup techniques.
• Documenting all new and modified mappings according to standards as part of the Data Operations documentation.-
• Performed troubleshoot on all system performance to maintain data integrity.
• Preparing the weekly status report for reporting to the customer.
• Created Unit Test Cases and documented the Unit Test Results.
• Conducted Knowledge sharing sessions with the Development team.
• Coordinate between different teams to ensure the completion of the work.

Environment: Informatica Power center 8.1/8.5.x, UNIX/Linux, Database Systems, SQL and PL/SQL, Windows NT, Oracle9i.