PROFESSIONAL SUMMARY:

• Having 7 Years of IT Experience in Software Analysis, Design, Development, Testing and Maintenance for a wide range of applications.
• Expertise in using Informatica client tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Sound knowledge/skills in ETL, Data warehouse concepts, RDBMS, SQL, PL/SQL and UNIX shell scripts.
• Proficient in all phases of software development life cycle ( SDLC ) including requirements definition, data conversion, system implementation, maintenance and acceptance testing.
• Good Knowledge on Data Warehousing Concepts, Business Objects (BO), Reporting tools, Informatica MDM, Teradata utilities, IBM Netezza Oracle PL/SQL.
• Hands on experience with Informatica Data Quality ( IDQ ) tools for Data Analysis / Data Profiling / IDQ Developer.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions .
• Experience in creating complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle, flat files etc.,
• Practical understanding of the Data modelling concepts, Star schema, Snowflake schema, fact and dimension tables .
• Designed complex ETL mappings, reusable transformations using Regular Expressions, Dynamic Lookups, and Update Strategies for slowly changing dimensions, critical performance tweaking stages with partitioning, persistent cache, and extensive use of mapplets for common sub routines.
• Experience in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Hands on Experience in writing SQL queries, Stored Procedures, Packages through the use of cursors, triggers. Extensive experience in working with the TOAD tool.
• Highly proficient in Oracle SQL, PL/SQL including writing queries, stored procedures, functions and triggers and implement business rules and validations.
• Have good understanding of ETL/INFORMATICA standards and best practices, Confirmed Dimensions, Slowly Changing Dimensions (SCD1, SCD2, and SCD3).
• Extensively used Informatica versioning to maintain different versions of ETL code.
• Proficient and prompt in learning and adapting to new technologies. Experienced in coordinating, managing and assigning responsibilities in team.
• Excellent oral and written communication skills, Analytical skills, capable to convey technical information at all levels, excel in research, analysis and problem solving.
• A team player with strong communication, leadership qualities, achieves organizational goals and milestones in an accurate and consistent manner
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member with excellent Verbal and Communication Skills and clear understanding of Business procedures.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/ 8.x/7.x, MDM, IDQ

Databases: Oracle11g/10g, SQL Server 2008/2005, NETEZZA, TERADATA

Languages: SQL, PL/SQL, UNIX Shell Scripting, FTP/SFTP, HTML

Operating Systems: UNIX, Windows 7/Vista/XP

Database Tools: Toad, SQL DeveloperOther Tools: MS Office (MS Word, MS Excel, MS Power Point),SQL server Management StudioScheduling Tools: Control-M

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

ETL Programmer

Responsibilities:

• Developing mappings/reusable objects/ transformation mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
• Written SQL override queries in source analyzer to customize mappings.
• Created reusable transformations and mapplets and used them in mappings.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Aggregator, Update strategy & stored procedure transformation.
• Designed complex Business rules in IDQ.
• Developed complex IDQ rules which can be used in Informatica and as well in Online
• Developed webServices through IDQ to be interacted in online.
• Worked on Informatica Data Quality (IDQ) to create the Mapplets.
• Hands on Master Data Management tool, IBM Initiate Inspector.
• Supporting ETL routines required for populating the Data Warehouse and Experience in loading high-volume data, Tuning and troubleshooting of mapping.
• Developed workflows and sessions associated with the mappings using Workflow Manager.
• Working on Repository manager to create and manage user profiles, and used Repository manager extensively while migration the code from development to production and compared both codes.
• Involved in writing SQL queries, PL/SQL programming and created new packages and procedures and modified and tuned existing procedure and queries using TOAD.
• Implemented Type II slowly changing dimension to keep a full history of dimensional data in the table

Environment: Informatica Power Center 9.6.1/8.6.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Repository Server Admin console), Informatica Dashboard, Oracle 10g/11i,SQL, PL/SQL, UNIX, DB2, Toad, MS SQL Server

Confidential, Calabasas, TX

ETL Developer

Responsibilities:

• Creating the design document as per requirements.
• Create CA7 jobs for scheduling and NDM jobs for sending and receiving file between two servers.
• Developing Informatica mappings to implement business logic and also creating test cases and executing to minimize the defect.
• Experience in resolving issues related to file transfer processes taking place through accellion manager
• Analyzed queue managers and queues to find potential problems and worked towards fixing them
• Developing ETL components and loading data from numerous data sources to Oracle database, flat file, mainframe systems.
• Hands on Master Data Management tool, IBM Initiate Inspector.
• Create Pl/Sql functions and procedures to provide ETL solution and also create change requests and database requests to move code to production.
• Used MQ explorer to check the status of the queues, delete messages in the DLQs, browse messages in the queues just to name a few.
• Developed complex code based on PL/SQL (Procedure, Packages, Functions etc.) and UNIX Shell scripts for new enhancements
• Analyzed Informatica job failures & connection issues and worked with DBA and network teams to resolve them
• Experience in code migration and folder refreshes across different environments.
• Used admin console to create and modify different Informatica services
• Experience in decommissioning the extra servers, removing servers from Informatica grid, and deleting nodes belonging to the decommissioned servers
• Worked with respective teams for the cleanup of the agents and outboxes in the decommissioned servers.

Environment: Informatica Power Center 9.5 (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Repository Server Admin console), Autosys Scheduler, Oracle 10g/11i,SQL, SQL *PLUS, MS SQL Server SSIS, BladeLogic, UNIX, Putty,CA7 Automation Tool, Harvest, ToadforOracle

Confidential, New York, NY

ETL Informatica

Responsibilities:

• Interacted with the Functional Analysts to understand the process flow and the business.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files
• Design and develop solutions for new strategic initiative
• Assist other developers and other groups in identifying and correcting issues with data and/or programming
• Worked on slowly changing dimension Type2.
• Involved in performance tuning of the process at mapping, session, source level and at target level.
• Used debugger in identifying bugs in existing mappings by analysing data flow, evaluating transformations.
• Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Power Center 9.6.1, Oracle, Teradata, SQL Server 2008, DB2, SQL Loader, Flat Files, Unix.

Confidential, Reston, VA

Informatica Developer

Responsibilities:

• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager and Informatica Power Exchange.
• Worked with Data modeler, according to changes in the model worked on changes in the Informatica.
• Imported the source definition into source analyzer from oracle and for DB2, VSAM files used Informatica power exchange in the source analyzer.
• Imported the Target definitions into Target Designer from oracle and for DB2, VSAM files used Informatica power exchange in the Target Designer.
• Created mappings using Reusable Transformations.
• Migrating mappings, workflows and parameter files from development to production.
• Developed PL/SQL scripts line packages and store procedures for data updates.

Environment: Informatica Power Center 8.1/8.5/8.6, Informatica Power Exchange 8.1/8.5/8.6, Oracle 10g, DB2, Flat files, UNIX, shell scripting, SQL Developer, Windows XP.

Confidential, Herndon, VA

Informatica Developer

Responsibilities:

• Interacted with Business Analyst to understand the business requirements.
• Involved in developing the logical and physical data models using Erwin.
• Involved in staging the data from external sources and was responsible for moving the data into the Warehouse using ETL Informatica.
• Used SCD2 to populate the data in a generic way. Single mapping is used to load multiple tables’ data.
• Created mappings using flat files and relational databases as sources to build update Mappings.
• Created reusable transformations and mapplets and used them in mappings.
• Written SQL override queries in source analyzer to customize mappings.
• Debug mappings to gain troubleshooting information about data and error conditions using Informatica Debugger.
• As the requirement is to maintain the history of every change for all columns, have implemented the slowly changing dimension type 2 with effective start and end date of the record.
• Handled UNIX operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Analyzed source data and formulated the transformations to achieve the customer requested reports.

Environment: Informatica Power Center 9.5/9.0/8.6.1, MS SQL server2005/2008, Oracle 11g, PL/SQL,TOAD, Flat Files, Windows XP, Unix.

Confidential, Raleigh, NC

Informatica Developer

Responsibilities:

• Involved in extraction of data from various sources like flat files, Oracle and SQL Server.
• Created Star Schema design using Data warehouse concepts like Fact Table and Dimension Tables.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Validate the data in the target tables once it was loaded.
• Fine-tuned existing mappings for performance optimization.
• Worked on bug fixes on existing mappings to produce correct output.
• Running the workflows quarterly and scheduling the workflows and monitoring them.
• Developed workflows and sessions associated with the mappings using Workflow Manager.
• Involved in writing complex queries for generating different reports as per client needs.

Environment: Informatica Power Center 8.3, Oracle 10g, SQL, PL/SQL, TOAD, Shell Scripts, UNIX (AIX).

Confidential, Livingston, NJ

Informatica Developer

Responsibilities:

• Worked on the installation and configuration of Informatica Power Center 7.1.
• Created and Documented ETL Test Plans, Test Cases, Test scripts, Expected results, Assumptions and Validations.
• Used most of the transformations such as the Source Qualifiers, Routers, Java, SQL,
• Transaction control, Sequence Generators and Expressions as per the Business requirement.
• Extraction, Transformation and Load was performed using Informatica 7.1 to build the data warehouse.
• Monitored and improved the performance of Sessions, Load Manager Properties, Parameter files, Mappings and documented the rectified issues in detail.

Environment: Informatica Power Center 7.1, Oracle 8i, MS SQL Server, SQL plus, UNIX, Auto Sys, TOAD.