SUMMARY

• 8 years of total IT experience with around 7 years of progressive work experience as an Informatica developer
• 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.
• Experience as an ETL Developer in designing and implementing Data Mart / Data Warehouse applications using INFORMATICA Power Center 9.x /8.x / 7.x / 6.x
• 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 Profiling, 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 Modelling, 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 databases like DB2, Oracle 11g/10g/9i/8i
• Experience in UNIX/LINUX Shell scripting
• Have strong knowledge on Conceptual, Logical & Physical Data modelling using tools like ERWIN.
• Well versed with slowly changing dimension (SCD) and involved in migration of repository objects like mappings and workflows from development environment to test and acceptance environments.
• Proficient in various Software Development Life Cycle Methodologies (SDLC) as Waterfall model and 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, Decision Support Systems (DSS), and OLAP
• 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), Power Exchange, Change Data Capture (CDC), SSIS

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

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

OS: UNIX (Sun Solaris, HP-UX, AIX), Linux, Windows 2008/2003/XP/98, Mainframes z/OS

Others: Toad, SQL Developer, QC, WinSCP, QMF, Putty, Cobol, VSAM, JCL, SQL, PL/SQL, Shell Scripting, HP ALM, Rally

PROFESSIONAL EXPERIENCE

Confidential, New York

Informatica developer

Responsibilities:

• Working as an Informatica developer in CPB, 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) 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, flat files, DB2 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, 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.
• Analyzing and identifying fix for incidents/tickets and defects based on ticket Severity and Priority.
• 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) and monitoring of Production jobs.

Environment: Informatica Power Center 9.6, Oracle 11g, Toad, Unix, WIN SCP, HP ALM, Rally

Confidential

Informatica Developer

Responsibilities:

• Performed the Role of an Informatica developer, 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 mappings that use XML as sources & targets.
• Define solution and features and worked in the agile environment.
• Coordination with clients, Business Analysts, SMEs and team members.

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

Confidential

ETL Developer

Responsibilities:

• Performed the Role of an ETL Developer, analyzing the requirement given by client and preparing the various Business deliverables at different phases of SDLC following Waterfall methodology.
• Involved in gathering of business scope and technical requirements and created technical specifications.
• Responsible for the development and support of a Data Warehouse using Informatica as the primary ETL Tool and support for Cognos as reporting tool.
• Designed Fact and Dimension tables according to the business requirement for enhancement and built simple to complex mappings to populate all those tables using various transformations.
• Developing the ETL logic by understanding the Business Complex Functionalities and requirement.
• Involved in Migration of Repository objects from Development environment to Test environment.
• Used UNIX shell scripts to update the parameters dynamically and scheduling jobs using Control-M scheduling suite.
• Supported the ETL processes that run on daily and cyclic schedules. All the scheduling has been handled using the Control-M scheduling suite.
• Used heterogeneous data sources like Oracle, SQL Server, XML Files and Flat Files as source and used stored procedures for transformations.
• Created E-mail notification tasks using post-session scripts.
• Involved in writing pre-session and post-session procedures/SQLs to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Involved in identifying Performance issues, bug and fixing them in existing mappings by analyzing the data flow, evaluating transformations to eliminate inconsistency and inaccuracy and latency.
• Used DB tools like SQL developer to run SQL queries and verify and validate the loaded data in target tables.
• Used Informatica debugger to debug the mappings and used session log files/bad files to trace errors that occur while loading.
• Implemented Error Rejection process to load bad/invalid records into a separate reject table.
• Profiling, understanding and validating the source data using SQL for potential issues that could prevent data integration.
• Doing data cleansing - initial to clean file and then loading into staging tables.
• Written complex SQL overrides scripts at source qualifier level to improve the performance.

Environment: Informatica Power Center 8.1, Oracle 9i, MS-SQL Server, PL/SQL Developer, Windows XP, TOAD, MS Office and Delimited Flat files