Around 8 plus years of experience as a Software Engineer / Informatica Developer in developing large-scale Data Warehouse and Client/Server Applications, including Data Profiling, Data Migration, Data Modeling, Business Process, Design and Development, Integration and Testing, Database Programming, SDLC, Web Services, Project Management and Production Support.

Experience in Financial, Telecom, pharmaceutical and insurance domains.

SUMMARY:

• Domain expertise in requirement gathering, system/business analysis, development, Customization, implementation and support of applications in database, environments and testing.
• Worked with all phase of Software Development Life Cycle involving ETL/OLAP and databases.
• Strong work experience with Business Users to analyze the business process model and made necessary changes to schema objects to cater users reporting needs.
• Extensive experience in ETL methodologies for supporting Data Migration, Data Exchange, Data Transformation using Informatica Power Center v 9.x/8.x Suite,
• Implemented Informatica Naming standards and Best Practices for the full life cycle of data warehouse projects, right from design to development through go-live and support.
• Experience with the Business Naming conventions and Quality standards of various Repository objects, Workflow objects, Transformation Objects, Ports and variable.
• Experience in documenting the Informatica mapping with comments in various objects
• Experienced in data modeling using Erwin with Ralph Kimball's dimensional modeling techniques.
• Experience in integration of various data sources like Oracle, DB2, IMS, COBOL copybooks, MQ, VSAM, datacom, SQL Server, Flat Files, Excel, and XML files.
• Extensively used various Performance Tuning techniques to improve the performance for data loads
• Strong Quality Assurance and debugging skills in ETL Process,
• Executed and tested various Reports using OLAP Tools for data accuracy and format stability.
• Well versed with Defect Tracking Management with Management Tools.
• Outstanding verbal and written customer communications/presentation skills.
• Excellent problem solving, analytical, interpersonal skills and ability to perform independently or in a team.

Summary of Qualifications:

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

• Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.
• Created the dimensional logical model with facts and dimensions using ER Studio.
• Gather data necessary to accomplish analysis from a number of sources, accumulate it together in prearranged format and enter the data in several data analysis software
• Trained data analysis basics to improved overall efficiency
• Involved in Architecture, design and building of the EDW tables
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter8.x/9.x.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center 8.x/9.x. for extraction, loading and transformation ETL of data in the data warehouse.
• Implemented slowly changing dimensions to maintain current information and history information in dimension tables.
• Created deployment groups, migrated the code into different environments.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Documented technical design documents based on the BRD and SRS.
• Lead the offshore team for business transformation project
• Designed the ETL process flow and guided offshore developers with the development process
• Involved in developing Data Marts for sub 360 and sales tax for ratio analysis
• Created Informatica workflows and mappings to load the data from Netezza/Oracle/Flat files/CSV files to Teradata
• Extensively worked on performance tuning the long running queries
• Gathered requirements from the business users and analyzed Source Data
• Developed the OLAP cubes
• Created and maintained dimensions and facts to make 360 degree view of the subscriber information available to business
• Involved in developing Data Marts for sub 360 and sales tax for ratio analysis
• Developed mload/fastload/fastexport scripts and used in loaded data into Teradata.
• Used SQL queries to unit test the Informatica mappings
• Developed Autosys JIL scripts to schedule the job
• Responsible for creating plans for migrating the code between environments
• Monitoring the ETL jobs and fixing the Bugs.
• Generated reports using OBIEE
• Designed and developed of UNIX Shell Scripts to handle pre and post session processes.
• Used Unix Shell Scripts to automate day-to-day operations.

Environment: Windows XP, Informatica, Oracle, OBIEE, ER studio, Autosys, Teradata assistant, Teradata Viewpoint, UNIX, Teradata Administrator, Aginity, Winscp, Putty

Confidential

Informatica Developer

Responsibilities:

• Settle on the methodologies and procedures for carrying out effectual data analysis
• Worked as an offsite project coordinator once the design of the database was finalized in order to implement the data warehouse according to the implementation standards.
• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter8.6.1.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center 8.6.1. for extraction, loading and transformation ETL of data in the data warehouse.
• Worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Erwin.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented slowly changing dimensions to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and Java Transformations.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Wrote SQL, PL/SQL, stored procedures triggers, cursors for implementing business rules and transformations.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Created deployment groups, migrated the code into different environments.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Documented technical design documents based on the BRD and SRS.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, SQL, PL/SQL, XML, AS 400, MS Access, Web services, JAVA, UNIX, UDB DB2 8.1, Shell Script.

Confidential

Informatica Developer

Responsibilities:

• Designed and developed ETL processes to extract data from the source systems and load into the Data Warehouse both in production and development environments.
• Evaluated the data that comes in from each department
• Using Informatica Power Center created maps and mapplets defining the transformation logic according to the business rules for the loads.
• Developed strategies for integrating data from various source systems and for initial and daily loads.
• Tuning the Informatica maps and SQL's for optimal load performance.
• Created sessions and batches using Informatica workflow Manager and monitored and scheduled the sessions and batches.
• Created transformations such as Joiners, Lookups, Filters, Aggregator, Sequence Generators, according to the business rules.
• Analyzed and determined the most complex transformations
• Involved in the production support, watch the workflow monitor carefully to see all workflows and all Tasks are running properly and data is loading in the proper way and to the right targets and at the right time.
• Lead the offshore team for multiple on going projects
• Analysis and resolution of all data related production issues
• Monitored the jobs and loads.

Environment: Informatica Power Center 8.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Data Analyzer 8.1, PL/SQL Dev V7, Oracle 10g/9i,Business Objects, SQL Server 2005, UNIX AIX, Toad 9.0.

Confidential

Informatica Developer

.

Responsibilities:

• Extensively used Informatica Power center for extracting, transforming and loading data from relational sources and non-relational sources.
• Extensively used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy, and Joiner while migrating data from various heterogeneous sources like Oracle, DB2, XML and Flat files to Oracle.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.
• Developed Mappings using Designer to extract, transform data according to the requirements and loaded into database.
• Handle slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Designed complex UNIX scripts and automated it to run the workflows daily, weekly and Monthly.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Created sessions, database connections and batches using Informatica Workflow Manager. Developed mappings to load data in slowly changing dimension.
• Created connected and Un-Connected transformations to lookup the data from Source and Target Tables.
• Scheduled Sessions and Batches on the Informatica Server using Informatica workflow Manager.
• Migrate Informatica objects and Database objects to Integration Environment and schedule using the Control M
• Created complex PL/SQL stored procedures and functions.
• Worked along with the DBA to resolve performance and tuning issues.
• Provided reliable, timely support of integration, performance and user acceptance testing processes.
• Involved in doing Unit Testing, Integration Testing and System Testing.
• Identified and created various classes and objects for report development.

Environment: Informatica Power Center 7.1, Oracle 9i, DB2, XML, Flatfiles, SQL, PL/SQL, TOAD, Perl, SQL Plus, Control-M, Windows, UNIX, Business Objects 6.0.

Confidential

Informatica Developer

Responsibilities:

• Extracted Data from Different Sources by using Informatica.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer and Mapplet Designer.
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Analyze, design, construct and implement the ETL jobs using Informatica.
• Developed mappings/Transformations/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center 5.1.1.
• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.
• Created Users, user groups, database connections and managed user privileges using supervisor.

Environment: Informatica Power Center, Oracle 8i, MS SQL SERVER 2000, SQL, PL/SQL, SQL Loader, UNIX Shell Script.

Confidential

SQL Developer

Responsibilities:

• Involved in Business Analysis and Requirements Gathering.
• Database and Screen design as per customer requirements.
• Generation of Reports to suit the functionality.
• PL/SQL coding at the database level for the new objects.
• Documentation, creation and execution of test cases.
• Interaction with users for screen design approval and user friendliness.

Environment: Oracle 7.3, PL/SQL, Visual Basic 5.0, and Windows NT.