Sourabh Seth

Informatica Developer

702-***-**** acc6zo@r.postjobfree.com

Summary

• Over 7+ years of professional IT experience in Data warehousing, Design, Modeling, Development, Analysis,

Implementation and Testing.

• Experience in using Informatica Client tools: Power Center Designer, Workflow Manager, Workflow Monitor, and

Repository Manager.

• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter,

Expression, Router, Normalizer, Joiner, Sales Force, Update Strategy, Rank, Aggregator, Stored Procedure,

Sorter and Sequence Generator.

• W ell acquainted with Informatica Designer Components (9.x/8.x/7.x/6.x) - Source Analyzer, Warehouse Designer,

Transformation Developer, Mapplet, Worklets, Mapping Designer, Reusable transformations and scheduling the

Workflows and sessions.

• Excellent skills in retrieving/manipulating data by writing simple/ complex SQL Queries, Stored Procedures,

Triggers, Views, Functions and optimizing queries by using SQL Profilers, Tracing and Tuning Advisors.

• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and

evaluating transformations.

• Experience in creating entity relational and dimensional relational data models with Kimball Methodology (Star

schema architectures, Fact/dimension tables).

• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.

• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.

• Analytical and Technical aptitude with the ability to solve complex problems.

• Active participation in Knowledge Transfer and experience in mentoring team members in an understandable user

friendly manner.

Education

Bachelor of Technology - Computer Science, Guru Nanak Dev University, Amritsar (India)

Technical Skills

Operating Systems Windows 7/95/98/2000/XP, Minix3

ETL Tools Informatica 9.x/8.x/7.x/6.1 (Power Mart/ Power Center).

Languages C#, JAVA Swings, Java Script, HTML, CSS, PL/SQL, Transact-SQL, ANSI-SQL.

Oracle11g/10g/8i/9i, MS SQL server 2012/2010/2008/2005 including SSRS, MS Access,

Databases

and Raiser’s Edge.

Database utilities SQL *plus, Stored procedures, Functions, Views, Triggers, Exception handling

Development ASP.Net and ADO.Net in Microsoft Visual Studio 2005, 2008 and 2010, Eclipse

Technologies/IDE

Application Tools MS Office (Word, Excel, PowerPoint), MS Visio, MS Project and Adobe Professional

Package.

Professional Experience

Lincoln Financial Group, Fort Wayne, IN Mar’13 - Present

Position: Informatica Developer

Lincoln Financial Group is a diversified financial services organization, which provides comprehensive financial solutions

that help our customers secure their retirement and manage life transitions. The project is to provide multiple sources of

data to a new data warehouse for metrics reporting. This repository will be used to produce internal productivity and audit

business reports.

Responsibilities:

• Interaction with the users/analysts to understand the business of the application, gather requirements and put into

technical design documents.

• Performing User Administration using Informatica Repository Manager Like creating Folders, users and groups.

• Interpreting logical and physical data models for Business users to determine common data definitions and

establishing referential integrity of the system.

• Extracted data from various heterogeneous sources such as Flat, Excel and XML files, Cloud, FTP, etc.

• Designing complex informatica mappings with transformations such as Aggregator, Expression, Joiner, Filter,

Source Qualifier, XML, Union, connected/unconnected Lookups, Sales Force Look ups, Sequence Generator,

Update Strategy, Stored Procedure and Router Transformation’s to transform and load the data from SQL Server,

Flat Files and Excel files to the Oracle warehouse.

• Defining Target Load Order Plan/Pipeline partitioning mechanism for loading data into Target Tables.

• Creating Reusable Transformations, Mapping Parameters and Mapping Variables.

• Involved in Tuning the Informatica objects to increase the Performance of the Informatica loads.

• Creating Sessions, Tasks, Workflows and worklets using Workflow manager.

• Monitoring and improving query performance by creating views, indexes and sub queries.

• Extensive participation in ETL Testing, checked data transformed and loaded in the Target Data Warehouse.

Environment: Informatica PowerCenter 9.x/8.6.0/8.1.1, Oracle 11g/10g, Flat Files, XML Files, Excel Files, SQL

2008/2010/2012, PL/SQL, Transact-SQL, Microsoft Project.

Wisconsin Health Care Systems, Madison, WI May’11 – Feb’13

Position: ETL Developer

W isconsin Health Care is a community-based health care system that offers a full range of services, from fitness and

wellness services to primary care and specialty care, hospital care, rehabilitation care, home and hospice care and

more. It is also dedicated to serving residents of Waukesha County and surrounding areas with the highest quality care to

promote a healthier community.

Responsibilities:

• Analyzed and understood business and customer requirements by interacting with Business Analysts, Data

Modelers and Subject Matter Experts, Participated in Database Design(ER Diagrams) and Database Architecture.

• W rote and reviewed Functional Specifications, Data Mapping Sheets and Technical Specification Documents.

• Analyzed Session Log files in case the session fails in order to resolve errors in mapping or session

configurations and Optimized query performance and session performance.

• Extracted data from a wide variety of sources like flat files, XML files, Excel Files, Relational Databases (Oracle,

SQL Server) by using Informatica Power Center Designer.

• Involved in creation of Informatica mappings to build business rules to load data using transformations like Source

Qualifier, Expression, Aggregator, Lookup, Filter, Router, update Strategy, Sales Force Look ups, Normalizer

used for Data Pivoting, Stored procedure, XML and Sequence generator transformations.

• Created and defined Target Load Order Plan/Pipeline partitioning mechanism.

• Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the

workflows for different system loads.

• Creation of sessions and workflows according to the data load in to different systems.

• Creation of Review documents for specification document and test cases.

• Performance tuning of targets, sources, mappings and sessions.

Environment: Informatica PowerCenter v8.6.1, SQL Server 2008/2010, Oracle 11g/10g, Windows-XP (Client),

Informatica servers on AIX Unix, Transact-SQL, PL/SQL, MS Visio and MS Project.

Symantec, Mountain View, CA Nov’10 – Apr’11

Position: Informatica Developer

Symantec provide security, storage and systems management solutions to help customers manage their information

driven world against more risks at more points, more completely and efficiently than any other company. Project is to

integrate bookings and the invoice data of all the SSl brands that recently merged into Symantec. This is to provide the

feed to the Symantec users for the sales compensation and to provide the input for the installed base reports.

Responsibilities:

• Reviewed System Design Documents for the Data Acquisition Requirements for moving data from external

systems to Staging Area and Source-to-Target Mapping.

• Interacted with the Business Personnel to analyze the business requirements and transformed the business

requirements into the technical requirements

• Extracted data from Oracle, flat files, Excel files and XML Files, transformed the data according to the business

requirements and loaded to target SQL server database.

• Designed and developed mappings with optimal performance using Aggregator, Joiner, Normalizer, used for Data

Pivoting, Rank, Sequence Generator, SQL, Connected-Unconnected-Source Target pre and post load Stored

Procedure Transformations,Update Strategy, Union, XML Transformations, etc.

• Created sessions and workflows to help schedule nightly loads and process data from all source terminal Data

Collection points.

• Executed stored procedures from source qualifiers and SQL transformations and used the return data set in the

mapping. Involved in migration of mappings and sessions from development repository to production repository.

• W rote Stored Procedures, Functions, Views and Triggers in SQL Server for regular Maintenance and Production

Support to load the warehouse in regular intervals.

• Used reusable Look-Up Transformations, Maplets and Worklets across the folders.

Environment: Informatica Power Center 8.6/8.1, Work Flow Manager, Oracle 10g, SQL Server 2005/2008/2010, T-SQL,

Windows – XP, PL/SQL

Devon Energy, Oklahoma City, OK Feb’10 - Oct’10

Position: ETL Developer

Devon is among the nation's leading U.S.-based independent gas and oil producers and independent processors of

natural gas and natural gas liquids in North America. It is a results-oriented natural gas and oil company that builds value

for shareholders employees by creating an atmosphere of optimism, teamwork, creativity and resourcefulness. Devon’s

vision is to be the premier independent oil and natural gas Company in North America.

Responsibilities:

• Involved in gathering business requirements, helped in creating Functional Spec document and created technical

Spec/data mapping documents.

• Build ETL mappings to pull data from SQL Server, Oracle, flat files, excel files to Oracle Warehouse.

• Designed and developed mappings using transformations such as Aggregator, Joiner, Normalizer, Rank,

Sequence Generator, Lookup, Connected-Disconnected Stored Procedures, Update Strategy, Union, XML,

Sorter, Filter, Maplets, etc.

• Monitored the jobs daily and involved in production support including immediate fixes for the production job

failures.

• W orked with Session logs and Workflow logs for Error handling and troubleshooting in DEV environment.

• Used Incremental Aggregation technique to load data into Aggregation tables for improved performance.

• Developed joiner transformations for extracting data from multiple sources.

• Informatica Designer tools were used to design the source definition, target definition, target load plans and

reusable transformations to build mappings.

• Involved in fixing invalid Mappings, creating data load connections using Work Flow Manager, testing of Stored

Procedures and Functions, testing of Informatica Sessions, and the Target Data.

Environment: Informatica Power Center 8.1/7.1, Oracle 10gR2/9i, W orkflow Manager, Workflow Monitor, PL/SQL, Flat

files XML files, SQL Server 2005/2008, Transact-SQL.

Value Retail Ltd, Bangalore, India Dec’07 – Dec’09

Position: ETL Developer

Value retail Ltd of India is a leading retailer that operates multiple retail formats in both value and lifestyle segment

of Indian consumer market. As a focused entity driving the growth of the group's value retail business, Value Retail

Limited continues to deliver more value to its customers, supply partners, stakeholders and communities across the

country and shapes the growth of modern retail in India.

Responsibilities:

• Studied the existing environment and accumulating the requirements by querying the Clients on various aspects.

• Identification of various Data Sources and Development Environment.

• Developed and Implemented Stored Procedures, Functions, Triggers, SQL Server Jobs for data transformation

and various data administration activities.

• W orked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures

transformations.

• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.

• Documented the mappings used in ETL Code.

• W orked with Architect and DBA to ensure availability of Databases (for loading).

• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Target.

• Created users in Informatica, assigned them various permissions.

• Created scheduled and emailed reports at support level using SSRS and implemented data source connections.

• Provided consultancy in Application Development, Support and Maintenance.

• Handled Change Requests, Service Requests and Implemented dynamic web page designs.

• Monitored top load consuming queries on production servers during the peak hours and Improved Application and

Database performance through Query Optimization, SQL Profilers, Tuning Advisors, Tracing and Debugging.

Environment: Informatica Power Center 7.1/7.3, Oracle 9i, SQL, PL/SQL, SQL Server 2005/2008, SSRS, Report Servers,

SQL*Plus, Windows 2000/XP, Microsoft Project, Transact-SQL, ADO.Net and ASP.Net in Microsoft Visual Studio

2005/2008, CSS/HTML.

Indian Overseas Bank, Hyderabad, India Jan’07 – Nov’07

Position: Informatica Developer

Indian Overseas Bank has an ISO certified in-house Information Technology department, which has developed the

software that 3003 branches use to provide online banking to customers; the bank has achieved 100% networking status

as well as 100% CBS status for its branches. This data warehouse was developed to aid and assist the management

committee in making various decisions regarding a customer.

Responsibilities:

• Supported in the analysis and database design, produced and maintained data model documentation.

• Responsible for development activities at the back-end side taking lead role in analysis and designing part.

• Extensively used PL/SQL features such as stored procedures, functions, packages and database triggers for

maintaining complex integrity constraints and implementing the complex business rules.

• Developed many complex mappings and maplets using various transformations (Source Qualifier, Joiner, Update

Strategy, Lookup, Rank, Expressions, and Aggregator) for loading the data into Data Warehouse.

• Involved in Extraction, Transformation and Loading (ETL) process for creating source and target definitions using

Informatica Power Center Designer.

• Extracted data from Heterogeneous source systems such as Flat Files, Excel Files and Oracle.

• Resolve access issues and tickets raised by users accessing the database.

• W orked on Performance tuning, optimization of complex queries and testing the target data.

Environment: Informatica Power Center 7.1/7.3, Oracle 9i, SQL Server 2005, Windows 2000, Microsoft Project,

Transact-SQL.

Contact this candidate