SUMMARY:

• Over 8 years of IT experience in developing full life cycle including requirement gathering, analysis, design, development, testing, implementation and maintenance of Data Warehousing and OLAP Applications using Informatica ETL tool.
• Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access.
• Good working knowledge in data warehousing concepts and banking concepts.
• Have extensively worked in developing for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Extensively used SQL statements while performing process and applied Query. Developing and supporting ETL mappings using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplets and Mapping Designer
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected/Connected Lookups, Aggregators, and Re-usable transformations
• Extensively used Slowly Changing Dimension (SCD) techniques, implemented Error Handling Methodologies.
• Proficient in developing SQL with relational databases like Oracle 11g, 10g, DB2 9x, SQL Server 2012.
• Extensive experience in Oracle 11g/10g in both SQL and PL/SQL coding.
• Expertise in using Informatica client tools - Designer, Repository, Manager, Repository Server, Administration Console, Workflow Manager, and Workflow Monitor.
• Experience in preparing Source-Target Mappings, Functional and Technical design documents.
• Knowledge in developing Star schema and Snowflake schema using Fact Tables, Dimension Tables.
• Excellent experience on implementing Change Data Capture(CDC)techniques and slowly changing Dimensions (SCD)-Type I, II & III.
• Knowledge of Informatica administration in windows and Linux environment
• Extensive experience in ETL processes in extracting data from operational and legacy systems to data warehouse using Informatica. Understands complex mappings transformation rules, data formats and efficient in performance tuning of sources, mappings, targets and sessions.
• Expertise in Dimensional data modeling, Star schema modeling, Snowflake modeling, Data Normalization.
• Sound knowledge and understanding of OOP Languages like Java, C++. Worked with Eclipse IDE.

TECHNICAL SKILLS:

Operating System: MS-DOS, Unix, Linux, Windows XP, Windows 7, Windows 10

ETL Tools: Informatica Power Center 8.6 9.1 9.5, SQL*Loader.

Database: Oracle 9i 11g, IBM DB2, Teradata, SQL Server 2005

Database Tools: SQL Developer 2000, SQL*Plus, TOAD

Languages: SQL, PL SQL, UNIX Shell Scripting, C, C++, JAVA, .NET

Reporting Tools: OBIEE - Oracle Business Intelligence 10.1.3.X, Oracle BI Publisher, MS Word

Web Technology: HTML, XML

Scheduling Tools & Client: Control-M, Autosys, FTP, FileZilla, Putty, Win SCP

PROFESSIONAL EXPERIENCE:

Confidential, Costa Mesa, CA

Sr.Informatica Developer

Responsibilities:

• Responsible to analyze functional requirement. Created design specification and technical specifications based on functional requirements.
• Extensively worked on developing Informatica Mapplets, Mappings, Sessions, Worklets and Workflows for data loading.
• Worked on transformations such as Lookup, Aggregator, Expression, Joiner, Filter, Rank, Sorter, Router, Sequence Generator, XML transformation etc.
• Created mappings of initial load for all source systems, cleansed data and load it into staging area.
• Worked on Web Service Consumer transformation to gather metrological data.
• Extensively used ETL to load data from wide range of sources such as relational database, XML, flat files (fixed-width or delimited) etc.
• Expertise in writing Pre Post Sqls and overrides Sqls as per the requirement.
• Extensively worked on using the PDO (Push down optimization), CDC (Change data capture) mechanism.
• Experience in working with various data sources (Oracle, SQL Server 2005) into data staging area and target data warehouse.
• Responsibilities included designing and developing complex Informatica mappings including Type-II slowly changing dimensions.
• Identifies, researches, and resolves ETL root cause of production issues or system problems.
• Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs using CONTROL-M schedulers and involved in migration deployment of ETL codes from development to production environment Knowledge on STAR Schemas and Snowflake Schema.
• Responsible for creating the parameter files in order to connect to the right environment and data base.
• Responsible for monitoring sessions. Debugged mapping of the failed session.
• Handled Production Support for the monitoring of daily and Monthly jobs. Part of the implementation team.
• Involved in creating data mappings, data quality and loading different type of sources into Oracle target database.
• Writing the SQL queries for the incremental logic. Worked on database connections, SQL joins, loops, aliases, views, aggregate conditions.
• Wrote Unix Shell Scripts to perform operations on text files. Developed SQL Overrides for the Source Qualifiers Based on the Business Requirements.
• Worked extensively on Stored Procedure transformations.

Environment:: Informatica Power Center 9.5/9.6, IBM DB2, Oracle 11g, Control-M, PL/SQL, FileZilla, Windows, UNIX Shell Scripting, etc.

Informatica Developer

Responsibilities:

• Understanding the business requirements by partnering with business users, worked with data architects in creating conceptual, logical and physical data models.
• Worked on Informatica Designer tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and monitor.
• Developed complex mappings and SCD Type-I, Type-II mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations.
• Tuning and monitoring applications and operating system performance.
• Development of Source-target data mappings, Transformations for the ETL process using Informatica Power Center.
• Install and set up Chef on Linux Virtual Machines
• Developed PLSQL Procedures, Triggers, SQL queries (Oracle, Db2), performed Gather Stats, created indexes, Synonyms, Views, table partitions and fine-tuned the SQL queries to improve data extraction.
• Assist in maintaining Linux/Unix based Web Applications. Worked on SQL tools like TOAD to run SQL Queries to validate the data.
• Network Protocols (such as ARP, DNS, SMTP, HTTP, NTP, TCP/IP, SSH and FTP) and solving troubleshooting problems.
• Created and modified UNIX scripts to process the Informatica jobs, file handling, executing SQL scripts. Involved in the Unit testing and System testing.
• Analyzed existing system and developed business documentation on changes required. Involved in making the adjustments in Data Model and SQL scripts to create and alter tables.
• Extensively involved in testing the system from beginning to end to ensure the quality of the new system up-gradation.
• Creating/Building and Running Sessions/workflows and worklets using the Workflow Manager/ Workflow Monitor.
• Written several complex SQL queries to validate the Data Transformation Rules for ETL testing.
• Efficient Documentation was done for all phases like Technical Specs, development, testing, migration and maintenance.
• Automated the process by defining the dependencies using Control-M scheduler.
• Involved in On call support on a rotation basis, performed analysis on the job failures and notify respective people based on the findings.

Environment:: Informatica Power Center 9.1.0/9.5.1, Oracle 10g, DB2 9.1, Flat files, Unix, Aqua Studio 15.0.9, Windows 7, Solaris, FTP and Control-M.

Data Analyst

Responsibilities:

• Good understanding of Data warehousing concepts, Strong Analytical, Interpersonal, Programming and Problem solving skills.
• Identifying and loading different sources and targets into flat files and target tables using business logic and involved in performance tuning. Have good knowledge on different versions of Informatica.
• Worked with all kinds of transformations and involved in requirements gathering and design, development and unit testing.
• Involved in data modeling and have good user interaction with users. Used to work individually and able to give the work with quality.
• Configured the connection settings to external Oracle using ODBC Connections. Used DB Links to access different source systems. Created complex SQL Overrides to read data from different tables and worked extensively with Materialized views.
• Used various transformations such as Filter, Expression, Aggregate, Look-up, sequence, Joiner, Router, Update and stored procedure transformation for the better data massaging and to migrate clean and consistent data.
• Worked with all kinds of transformations and created complex mappings and worked with slowly changing dimensions.
• Created UNIX scripts to perform load runs, file handling, SCP process handling, defined dependencies and set up batches to create run schedules and schedules the loads at required frequency.
• Created Test plans for unit-test, System Integration Test and UAT and tested code in all Development.

Environment:: Informatica Power Center 8.6/9.1, Oracle 11g, PL/SQL, Erwin 4.0, Windows NT, Unix, TOAD.

ETL/Informatica Developer

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Involved in creating Logical and Physical Data Models and creating Star Schema models.
• Assisted in designing Star Schema to design dimension and fact tables.
• Involved in developing star schema model for target database using ERWIN Data modeling.
• Worked on Informatica Power center - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Created Complex mappings using Unconnected and connected Lookups and Aggregate and Router transformations for populating target table in efficient manner.
• Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files
• Created Mapplet and used them in different Mappings. Used sorter transformation and newly changed dynamic lookup. Created Schema objects like Indexes, Views and Sequences.
• Developed Informatica mappings and also tuned them for better performance with PL/SQL Procedures/Functions to build business rules to load data.
• Created Stored Procedures, Functions and Indexes Using Oracle. Worked on batch processing and file transfer protocols.
• Performance tuning of the workflow which are taking time. Developed mappings for policy, claims dimension tables.
• Analyzed the enhancements coming from the individual Client for application and implemented the same. Creation of technical documents.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Simulated real time transaction feed by fabricating transactions required for UAT and manually calculating expected results to generate expectancy going into the testing process.

Environment:: Informatica Power Center 8.1/8.6.x, Power Exchange, PL/SQL, Oracle 10g/9i, SQL Server 2008/2005, Windows Server 2003, UNIX, Control-M, Toad

ETL Developer

Responsibilities:

• Understanding present process flow and business functionalities and prepare ETL process flow for Predictive analysis.
• Created technical document for ETL process for each module.
• Implementing validation and verification practices in an UNIX test environment.
• Developed and Supported Extraction, Transformation and Load Process (ETL) with Informatica Power Center 8.1.
• Very good knowledge of UNIX Shell Scripts to write and maintain script for Oracle.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Systems log management, Data backup and restoration with UNIX native tools (tar/dd).
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems and worked with complex mappings having an average of 15 transformations.
• To provide ongoing support in systems management and administration of LINUX/UNIX in global-scale environment.
• Extensively involved in Recovery process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.
• Extensively worked on tuning of sessions and mappings for better performance.
• Job responsibilities include developing on-line screens using SQL Forms 4.5, creating database objects like tables, indexes, views etc. using SQL Plus, import and export of data using SQL Loader.
• Developed shell scripts for automating routine day-to-day tasks, management reports, set up alerts for server resources utilization (CPU, memory, disks, etc.).
• Wrote Shell scripts for monitoring Unix servers. Wrote test scripts to validate the data for the testing team. Did unit testing, system integrated testing.
• Worked with production support in finalizing scheduling of workflows and database scripts using Autosys.

Environment:: Informatica Power Center 8.0/8.6, Oracle 9i, UNIX, SQL Server 2005, SQL Loader, TOAD, SQL *Plus, PVCS, Windows XP.