Summary

• Around 8 years of IT experience in all phases of Software Development Life Cycle analysis, design, development, test, implementation and support .
• 7.5 years of experience in Data Warehousing using ETL and OLAP tools Informatica PowerCenter 9.5/9.1/8.x/7.x, OBIEE 11g/10g, Business Objects XI/6.1.
• Accomplished and highly experience in Informatica applications.
• Designed and Developed the ETL processes for various domains like Finance, Event Management,Energy Sector, and Railways.
• Interacted with end-users and functional analysts to identify and develop Business Specification Documents BSD and transform it into technical requirements.
• Proficient with RDBMS systems, SQL, Oracle PL/SQL, database design and optimizations
• Skilled in Data warehousing, Scripting and Data Modeling with 7 years' experience in dealing with various Data sources like Oracle, SQL Server, MS-Access, Web Services and DB2.
• Strong knowledge of Data warehouse design such as dimensional data model, logical and physical design.
• Profound knowledge of Change Data Capture CDC technologies.
• Worked on MLOAD, F LOAD, F EXPORT and TPUMP to load data to DWH system.
• Proficient in creating Oracle Function, Stored procedure, Package, Trigger and Materialized View.
• Handled Design, Development, Test, Debug and maintenance of application programs.
• Excellent working knowledge of UNIX shell scripting, job scheduling on multiple platforms, experience with UNIX command line and LINUX.
• Worked on scheduler tool Tidal and Control-M to create job for ETL workflows.
• Having good knowledge on creation and scheduling of T-SQL jobs to run daily.
• Excellent working knowledge of tracking work status, effort estimation, coordination with various team, reporting and resolving prod issues, creating prod process and run book.
• Developed and Implemented Error logging, Error handling and Error resolution process in many projects.
• Strong organizational, problem solving and decision making skills with the proven ability to assimilate, research information to develop sound and ethical solutions Detail-oriented, process-driven with excellent communications skills with the ability to work with and influence colleagues and customers at all levels.

Software Skills

Experience:

Sr ETL Informatica Developer September 2012 Present

Confidential

Description:

Responsibilities:-

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Converted business requirements into technical documents BRD, explained business requirements in terms of technology to the developers.
• Developed Data Flow diagrams to create Mappings and Test plans.
• The Data flow diagrams ranged from OLTP systems to staging to Data warehouse.
• Developed Test plan to verify the logic of every Mapping in a Session. The test plans included counts verification, look up hits, transformation of each element of data, filters, and aggregation and target counts.
• Developed complex Informatica mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
• Extensively used SCD's Slowly Changing Dimension to handle the Incremental Loading for Dimension tables, Fact tables.
• Designed various mappings for extracting data from various sources involving Flat files, Oracle, Sybase and SQL Server, IBM DB2.
• Designed and developed real-time data warehouse.
• Worked on Debugging and Troubleshooting of the Informatica application. For debugging utilized Informatica debugger.
• Worked on Performance Tuning to optimize the Session performance by utilizing, Partitioning, Push down optimization, pre and post stored procedures to drop and build constraints.
• Experience in building of the Repository RPD using the OBIEE toolset.
• Developed OBIEE technology such as Answers, Dashboards, and BI Publisher.
• Identify users and see what level of familiarity do they have with this data. Segment these users based on criteria like influence, authority and participation levels.
• Identifying automated decision-making possibilities.
• Worked on Audit login, Error login and Reference check while loading data to Data warehouse.
• Created UNIX Script for ETL jobs, session log cleanup and dynamic parameter.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor and Scheduler alert editor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Wrote Unix scripts, Perl scripts for the business needs. Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process.

Environment: Informatica PowerCenter Cloud 9.5/9.1, Power exchange, Oracle Exadata, Teradata 13, MSSQL Server 2008 R2, T-SQL, Erwin 8, SQL Server 2008, TOAD, PL/SQL Developer, Linux, Tidal, Shell Scripting, Perl Scripting, Windows XP, Putty, DB2 Mainframe, OBIEE 11g, Informatica Cloud, Salesforce.

Informatica Developer October 2010 July 2012

Confidential

Responsibilities:-

• Involved in Requirement Gathering and Business Analysis and created tech specs for ETL process.
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Setup folders, groups, users, and permissions and performed Repository administration using Repository Manager.
• Design, development and implementation. It includes the several modifications, enhancement and maintenance of existing software.
• Build the Dimension Facts tables load process and reporting process using Informatica and OBIEE.
• Consolidate sales order data using Informatica and loaded to aggregate tables for reporting.
• Coordinated with Onsite and Offshore team.
• Transfer the source code setup file to outside conversion team for production movement and support. Coordinate with vendor, business, developers tester for UAT and system testing.
• Developed various complex Mapplets and Stored procedure to facilitate loading of data on weekly and monthly basis.
• Worked on Various transformations such as Joiner, Filter, Update Strategy, Expression, Router, Lookup, Union, and Aggregator.
• Administered and developed monitoring scripts for power center server process and workflow jobs.
• Designed and developed enhanced data models and ETL applications to meet the business requirement.
• Used Informatica Power Connect to extract data from third party databases, web services and XML.
• Mapping type 1 type 2 Slowly Changing Dimension SCD using Informatica.
• Timely delivery of ETL tasks is performed using workflow manager and scheduler.
• Worked closely with DBA and developers during planning, analyzing, developing and testing phase of the project.
• Involved in Designing of Data Modeling for the Data warehouse.
• Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
• Involved in the Performance Tuning of Database and Informatica. Improved performance by identifying and rectifying the performance bottlenecks.
• Involved in user acceptance testing. Defect reporting tracking in Jira and resolved them.
• Wrote PL/SQL Packages and Stored procedures to implement business rules and validations.

Environment: Informatica PowerCenter 8.6.1, Informatica Power Exchange 8.6, MS OFFICE/VISIO 2007, Oracle Exadata, DB2 Mainframe, UNIX, AIX, Rally, MS Series, Web Services, Java, Tidal, Putty, Basecamp, Erwin 7.5, PL/SQL

ETL/ Informatica Developer

Confidential

Description

Metaphor Software Technologies. It is an implementation partner who provided successful projects for different Clients.

Confidential

Responsibilities:-

• Designed and developed complex mappings using various transformations in Designer to extract the data from sources like Oracle, SQL Server and flat files to perform mappings based on company requirements and load into Oracle tables.
• Extensively worked on various source like flat files, Databases, XML and Web services.
• Created and altered Tables, Triggers, Sequences, and other DDL, DML, DCL and utilities of Oracle.
• Extensively worked in the performance tuning of ETL procedures and processes.
• Error checking testing of the ETL procedures programs using Informatica and Oracle procedures.
• Performance Tuned Informatica Targets, Sources, mappings sessions for large data files by increasing data cache size, sequence buffer length and target based commit interval.
• Developed UNIX shell scripts to automate applications, Schedule jobs, develop interfaces and Created pre-session and post-session shell scripts and mail-notifications.
• Responsible for production support.
• Mainly responsible for solving Informatica and Database Issues for different departments if ticket is opened.
• Any problem with the ETL codes, prime responsibility was to test in Integration Environment before loading in Production.
• Used Debugger utility of the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results for various tickets.
• Used FTP on a few occasions to solve complex supply chain problems.
• Created Oracle Stored Procedure, Function, Cursor, Package and Triggers.
• Wrote Analytical queries to generate report, designed normal and materialized View.
• Optimized mappings having transformation features like Aggregator, filter, Joiner, Expression and Lookups
• Created daily and weekly workflows and scheduled to run based on business needs

Environment: Informatica PowerCenter 8.6, Oracle 10g, Teradata V2R5, XML, TOAD,SQL, PL/SQL,IBM AIX, UNIX Shell Scripts, Web Intelligence, DS BASIC, Erwin 6.1, Remedy, Maestro job scheduler, Mercury Quality Center

Confidential

Responsibilities:-

• Collection of requirements from business users and analyzed based on the requirements.
• Extensively used flat files for Designed and developed complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications.
• Designed and developed complex mappings using various transformations in Designer to extract the data from sources like Oracle, SQL Server and flat files to perform mappings based on company requirements and load into Oracle tables.
• Well versed with creating and Altering Table, Triggers, Sequences, and other DDL, DML and DCL utilities of Oracle 9i and 10g.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Error checking testing of the ETL procedures programs using Informatica session log.
• Performance Tuned Informatica Targets, Sources, mappings sessions for large data files by increasing data cache size, sequence buffer length and target based commit interval.
• Developed UNIX shell scripts to automate applications, Schedule jobs, develop interfaces and Created pre-session and post-session shell scripts and mail-notifications.
• Performed error handling for removing database exceptional errors.
• Used Debugger utility of the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results.
• Worked with tools like TOAD to write queries and generate the result.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings. Involving also in the functional and technical design document sessions with Technical team and business users team.
• Working on the Data Analyzer, Data Quality and data profiler tool for handling the business logic and exception logic from the inbound feeds and also the outbound feeds.

Environment: Informatica PowerCenter 8.1, Informatica Power Exchange 8.1, DB2 Mainframe, Cobol, ORACLE 10g, UNIX, Windows NT 4.0, Sybase, UNIX Shell Programming, PL/SQL, TOAD, Putty, WinScp, Remedy