SUMMARY:

• 6 years of total IT experience with work experience as an ETL developer and Application Lead.
• Diversified experience covering all stages of Software Development Life Cycle (SDLC) implementation: Requirements gathering and system analysis, design, development, data conversion, unit, integration and system testing, support end user testing, Implementation, Post - implementation support and Maintenance of business applications.
• Involved in Development, Maintenance as well as Support of large scale data warehouse and data marts with strong business understanding in Financial sector.
• Strong ETL experience in using Informatica Power Center 9.0.1/8.x tool
• Involved in all the phases of the Data warehouse life cycle Database design, SQL, PL/SQL programming and Concepts experience including ETL processes consisting of Data Analyzing, Data Modeling, Data Cleansing, Data Transformations, Integration, Migration, Mapping and Loading.
• Experience in optimizing query performance, fine tuning mappings and identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Working knowledge of Data Warehousing techniques and Concepts experience including ETL processes, Dimensional Data Modeling, Star Schema/Snowflake Schema, Fact and Dimension tables and high level design, low level design, best practice to drive standardization and reusability of coding practices.
• Expertise in handling various databases like DB2, Oracle 11g/10g/9i/8i, Sybase and SQL Server .
• Experience in UNIX Shell scripting and also Job Scheduling on Control-M.
• Have knowledge on Conceptual, Logical & Physical Data modeling using tools like ERWIN .
• Well versed with slowly changing dimension ( SCD ) and i nvolved in migration of repository objects like mappings and workflows from development environment to test and acceptance environments.
• Proficient in Software Development Life Cycle Methodology ( SDLC ) Waterfall model and Scrum process of Agile development methodology.
• Expertise in implementing complex Business rules by creating robust mappings, mapplets and reusable transformations using Informatica Power Center.
• Worked closely with Business Analyst, Data Modelers, Database and Data warehouse Architects in determining the exact business rules and functionalities required for the delivery of the work units.
• Experience and solid understanding of Data Warehousing, and OLAP and Business Intelligence skills.
• Excellent problem solving skills with a strong technical background and good interpersonal skills. Quick learner and motivated team player, willing to accept exciting new challenges and ability to meet tight deadlines.

TECHNICAL SKILLS:

ETL: Informatica Power Center 9.x/8.x (Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Repository/Metadata Manager, Workflow Monitor, Workflow Manager), Change Data Capture (CDC)

Reporting: Business Objects

Data Modeling: ERWin, Microsoft Visio, Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, SnowFlake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagram.

Database: RDBMS Oracle 11g/10g/9i/8i, SQL Server 2008, DB2 SQL, PL/SQL. Sybase

Operating Systems: UNIX (Sun Solaris, HP-UX, AIX), Windows 2008/2003/XP/98

Others: Control-M Scheduler, Toad, SQL Developer, PuTTY, SQL Plus, SQL Loader, SQL, PL/SQL, Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer/Application Lead

Responsibilities:

• Working as an Application lead/developer in the OTC Client Clearing Risk, analyzing the requirement given by client and preparing the various Business deliverables at different phases of SDLC following agile methodology.
• Extensive work experience in Analysis, High level and low level Designs, Coding, Testing (Unit testing, System Testing and Integration Testing) and Implementation/post implementation support.
• Developed mappings to load the data from various sources using different transformations, created new tables, mappings and workflows, sessions and jobs.
• Extensive work experience in fact tables, dimension tables, Normalization/De-normalization techniques in physical and dimensional database environments.
• Worked on integrating data from heterogeneous feeds and sources like Oracle, SQL Server, flat files, SWIFT Messages and XML files and loaded them into Oracle database that were hosted on UNIX servers.
• Experience with complex mappings using transformations like Source Qualifier, Filter, Aggregator, Expression, Router, Lookup (connected and unconnected), Update Strategy, Sequence Generator, Rank, Union, Stored Procedure, Transaction Control and Joiner.
• Experience in working with PL/SQL, Cursors, Stored Procedures/Functions, Triggers and Packages, Tables, Constraints, Views, Indexes and Synonyms.
• Coordination with business, client SMEs, Sources, BI team, Business Analysts and Release management and provide daily/weekly status updates.
• Implemented many Data Mart CRs by creating and modifying mappings and workflows to facilitate BI Reporting and Data Mining.
• Analyzing and identifying fix for incidents/tickets and defects based on ticket Severity and Priority.
• Follow the Incident Management Lifecycle in fixing the incidents and implement the fix in Production.
• Defects that were raised after warranty support are tracked, reviewed and taken to resolution following documentation processes as per client standards.
• Supported Adhoc, Daily, Weekly and Month end batch runs (Both Production and UAT).
• Have done a quality coordinator role as well for my project and created documentation for Internal and External Quality Audits.
• Have worked in onsite-offshore model.

Environment:: Informatica Power Center 9.1, Oracle 11g, Toad, Unix, Remedy, Control-M Scheduler

Confidential

Systems Engineer/ETL Developer/Support Analyst

Responsibilities:

• Performed the Role of an Systems Engineer, creating design document by analyzing the Business requirements.
• Knowledge in creating Physical and Logical Data Models using Erwin. Loaded the extracted SQLs into the target data warehouse.
• Complex mappings including Slowly Changing Dimensions (SCD) loading strategy were used in the mappings.
• Extract data into staging tables, transform and load data into data warehouse tables using Informatica and responsible for automating the ETL process, filtered out header and trailer records to implement source balancing on the maps to generate reports and create system log.
• Worked with testing team in tracking and resolving the defects.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command and Decision.
• Working closely with architect team to finalize the loading approach and ETL standards to follow.
• Performed Data Architecture of source to target logical mappings, slowly changing dimensions strategy design, tuning of slow running processes by optimizing the SQLs, tuning mappings and deleting and recreating indexes.
• Extensively used Informatica debugger to figure out the problems in mappings.
• Involved in System Integration Testing (SIT) and making Test Coverage and Test Cycle Strategy for User Acceptance Testing (UAT).
• Created Bug Reports and provide alternate design specs.
• Define solution and features and worked in the agile environment.
• Offshore-Onsite Coordination, scrum calls, project status update to the management and daily agile stand up meetings.
• Coordination with clients, Business Analysts, SMEs and team members.
• Migration of Application to Production Set up after user acceptance.
• Automation of various reports to reduce manual intervention and Human error.
• Monitor daily batch jobs scheduled for data flow from source systems to ISE, BIGS addressing any failures/gaps in the flow.
• Daily check for all the Informatica Services, Repository Backups. Administration related activities. Preparation and dissemination of reports.

Environment: Informatica Power Center 8.6, SQL Server 2008, Oracle 10g, SQL Developer, ERWIN, UNIX Shell Scripting.