SUMMARY

• 14+ years of ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 9.5.1/9.1/8.6.1/7.1/6 using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor.
• 1 year Informatica PowerCenter Administrator experience.
• Experience in setup and configure PowerCenter domain, grid and services and managing Informatica servers and projects for various businesses.
• Experience in migrating Informatica objects like Mappings, Sessions and Workflows from DEV, QA and Production environments.
• Experience in creating Roles, Privileges and assigned them to user groups.
• Experience in managing users and administer PowerCenter security.
• Primary strengths include Data Warehousing and Decision Support Systems in a Unix/Windows environment using Informatica, Oracle PL/SQL, DB2 UDB, SQL Server, Teradata and Dimensional Modeling.
• Hands on experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• Expert in UNIX shell script programming and UNIX utilities.
• Expertise in designing and developing mappings from various transformations Using filters, expression, rank, router, aggregator, joiner, lookup, Normalizer, XML transformations, Java Transformation and update strategy.
• Expertise in Defining Workflows &Tasks, Monitoring Sessions, Export & Import Mappings and Workflows and Backup, Recovery.
• Experience in performance tuning of Informatica Sources, Targets, Mappings and Transformations & Sessions.
• Proven track record in planning, building, and managing successful large - scale Data Warehouse and decision support systems. Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
• Expertise in Information Builder Data Migrator (ETL Tool) and Webfocus (Business Intelligence and Reporting Tool).
• Competency in understanding business application, business dataflow, and data relation.
• Ability to rapidly learn new concepts together with excellent interpersonal skills.
• Excellent skills in understanding business needs and converting them into technical solutions.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.
• Fast learner, flexible team player and ability to understand the requirements and translate into solutions, excellent verbal and written communication skills.
• Can work efficiently as an individual and as a team member.
• Have played a lead role in the projects.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5.1/9.1/8.6.1/8.5/7.2/6.1 , Power Connect 7.1, Data Migrator 6.1

Reporting Tools: Crystal Reports 10

OLAP Tools: Business Objects 12.1/6.5, Web Focus 6.1

Data Modeling Tools: Erwin 4.2, E/R Studio

Data load and unload utilities: Teradata FastExport, Teradata FastLoad

RDMS/Databases: Oracle 9i/10g/11g, Exadata, SQL Server 2000/2012, DB2, MS Access, Teradata

Scripting Languages: SQL, PL/SQL, T- SQL, SOQL(Salesforce Object Query Language), UNIX Shell Script

Data Base Development Tools: Toad, AQT ( Advanced Query Tool), SQL Developer, SQL Server management Studio, Teradata SQL Assistant, Apex Explorer 8.0, Apex Data Loader 11.0

Operating Systems: Windows 2000/ XP/Windows 7, DOS, UNIX, Linux

Test Management tool: Mercury Quality Center 9.0

XML Parser: XML Marker 1.1

Scheduling Tools: Tidal Enterprise Scheduler, Redwood, Tivoli

SCCM Tools: BMC Remedy’s Action Request system 6.0

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton, CA

Lead ETL Developer/Technical support Analyst/Informatica Admin

Responsibilities:

• Analysis of the specifications provided by the clients and business.
• Design and Development with special emphasis on performance and optimization.
• Preparation of the High Level and Detailed Design documents.
• Production Support.
• Writing and testing UNIX Scripts used for both scheduling and in Informatica development. used Tivoli Scheduler to schedule Informatica jobs.
• Leading and guide other developers for both SAPS3 Vents and Vitals Cleaning tracks.
• Communicating with the business units for getting the requirements and reconciling the results produced.
• Managed PowerCenter 8.6.1/9.1/9.5.1 instances.
• Coordinated with UNIX and Database Administrators.
• Created users, Roles, Groups and assigned roles, Groups and privileges to users.
• Created relational Connections and assigned users and permissions.
• Coding using Informatica Power Center Client tools, Teradata and Oracle.
• Resolving discrepancies during the certification and production release.
• Conduction of Code Review activities.
• Preparation and Review of Test Cases (Unit/Module/Integration).
• Testing - Unit testing, Integration testing and Regression testing.
• Creating the scheduling jobs and sheets using the scheduling tool Tivoli.
• Deployment activities Includes creating Deployment Groups and deployment to other repositories.
• Identifying root cause and implement resolution for production processing issues
• Setup and administer PowerCenter security
• Setup and configure PowerCenter domain, grid and services
• Creation and maintenance of Informatica users and privileges.
• Performance tuning activities.
• Responsible for overseeing the Quality procedures related to the project.
• Developing queries and help other team members with in team to speed up development process.

Confidential, San Francisco, CA

SR ETL Developer/Analyst

Responsibilities:

• Developed Informatica Power Center mappings using transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Sequence Generator, Update Strategy, Normalizer and Java Transformation.
• Extracted data from different sources like Flat files (CSV and Text), Oracle and SQL Server Data Bases.
• Developed mappings using advanced transformations like Java in order to load variable columns data and pivot data into Rows.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager and also created various tasks like e-mail, Command, Event-Raise, Event-Wait, Timer and Decision.
• Performed data validation and reconciliation in the load process
• Performed source data profiling before implementing and bringing data into EPDM (Enterprise Data Mart).
• Developed, executed, documented test cases, test plans for integration and system testing
• Analyzed business requirements, performed source system analysis, prepared technical design document and source to target data mapping document
• Involved in Designing Dimensional modeling based on source and report requirements.
• Developed Oracle Stored Procedures, Functions, Views and Materialized Views.
• Developed UNIX scripts like File validation, File availability to validate and check csv and Text files availability.
• Involved in Analyze and Fixing of code Bugs.
• Also involved in B2B project which generates EDI files (873) to Vendors using Informatica Data Transformation Studio.

Environment: Informatica Power Center 9.1, Informatica Data Transformation Studio, Oracle 10g/11g, SQL Server 2008/2012, SQL, PL/SQL, SQL Developer, SQL server Management Studio, Business Objects XI 3.1, XML Marker, Eclipse, Windows 7, ESFT, Quality Center, Sun Solaris UNIX and Linux.

Confidential, San Francisco, CA

SR ETL Developer

Responsibilities:

• Developed Informatica Power Center mappings using transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy, Union and Normalizer.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager
• Extracted data from different sources like Flat files, Sales Force (Application) and Oracle Data Base.
• Created pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables
• Performed tuning of Informatica sessions by implementing increasing block size, data cache size, sequence buffer length, target based commit interval and SQL overrides
• Performed data validation and reconciliation in the load process
• Developed, executed, documented test cases, test plans for integration and system testing
• Analyzed new source data, developed mappings and aligned with existing code.
• Analyzed business requirements, performed source system analysis, prepared technical design document and source to target data mapping document
• Worked closely with QA team during the testing phase and fixed bugs that were reported
• Worked as a developer and Production support analyst and fixed Production bugs as reported by Commercial Compliance Office (CCO).

Environment: Informatica Power Center 8.6.1, Oracle 10g/11g, SQL, PL/SQL, TOAD, EII, ESB, Salesforce, Apex Explorer 8.0, Apex Data Loader 11.0, Remedy Action Request System 5.01, Redwood Scheduler, business objects 12.1.0, Windows XP/Windows 7, Sun Solaris UNIX and Linux.

Confidential

Responsibilities:

• Working as an Operational and Production support Analyst and also involved in Maintenance and Enhancement (M&E) Activities.
• Coordinating and managing Offshore operations and responsible for Onsite- Offsite coordination.
• Involved in Error Handling SQL procedure development.
• Involved in onboarding new vendor activities.
• Developed Informatica Power Center mappings using transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy
• Developed Technical Specification documents for new On-boarding vendors and daily operations.
• Involved in cross projects activities to support EMGT M&E activities and downstream applications.
• Developed, executed, documented test cases, test plans for integration and system testing
• Migrated the mappings and workflows from the development server to the QA Server and developed migration documents for M&E tasks and new functionality.
• Developed File availability, naming convention and File format check UNIX scripts.

Environment: Informatica Power Center 8.6.1, Oracle 10g/11g, SQL, PL/SQL, TOAD, EII, ESB, XML, XML Marker 2.1, Remedy Action Request System 5.01, Redwood Scheduler, Windows XP/Windows 7, Sun Solaris UNIX and Linux.

Confidential, Santa Clara, CA

SR ETL Developer

Responsibilities:

• Analysis of requirements, existing system, Identification of required dimensions and facts
• Extracted data from different sources like Flat files and IDOCS into Staging DB.
• Generated Entity-Relationship diagrams based on actual values and relationships held in source data
• Identified mismatches between the data, metadata, documented definitions from source systems and developed a comprehensive report for data management purposes
• Developed Informatica Power Center mappings using transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy
• Developed complex mappings to implement type 2 slowly changing dimensions using transformations such as the Source qualifier, Aggregator, Expression, Static Lookup, Dynamic Lookup, Filter, Router, Rank, Union, Normalizer, Sequence Generator, Update Strategy, and Joiner
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager
• Created pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables
• Performed tuning of Informatica sessions by implementing database partitioning, increasing block size, data cache size, sequence buffer length, target based commit interval and SQL overrides
• Performed data validation, reconciliation and error handling in the load process
• Migrated the mappings and workflows from the development server to the Test Server to perform the integration and system testing
• Developed batch file to automate the task of executing the different workflows and sessions associated with the mappings
• Developed, executed, documented test cases, test plans for integration and system testing
• Documented standards for Informatica code development and prepared a handbook of standards
• Scheduled walkthroughs of design documents, specifications, code, test plans etc. as appropriate throughout project lifecycle
• Involved in the Software Configuration Management process by maintaining all the releases of various documents in the Microsoft Visual Source Safe 6.0 Database for Version Control

Environment: Informatica Power Center 8, Oracle 8/10g, SQL, PL/SQL, SQL*Plus, TOAD, Teradata 12, SQL Assistant, Dollar U, Windows 2000, UNIX

Confidential, Foster City, CA

ETL Developer / Analyst/Support Engineer

Responsibilities:

• Analyzed business requirements, performed source system analysis, prepared technical design document and source to target data mapping document
• Worked with Data modeler on logical and physical model designs
• Worked with DBA to set up development, test, stage and production environments
• Performed impact analysis for systems and database modifications
• Coordinated development efforts with offshore team
• Developed ETL processes to populate the Enterprise Product Orders data mart Dimensions and Fact using Informatica, Oracle SQL, UNIX shell scripts
• Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update Strategy, and Joiner
• Optimized performance by tuning the Informatica ETL code as well as SQL
• Performed unit testing and documented the results
• Worked closely with QA team during the testing phase and fixed bugs that were reported
• Developed and Scheduled Appworx jobs for the daily load of the Orders data mart that invoked Informatica workflows & sessions associated with the mappings, SQL scripts to drop & recreate the indexes on source and target tables, Unix Script to create / update the parameter file, check source / target database connectivity, delete tag files etc
• Prepared code migration document and worked with release team in migrating the code ( Informatica Objects, SQL Scripts, UNIX Scripts & Appworx jobs) from Development to Test, Stage, Production Servers
• Reviewed code, design and test plans as appropriate throughout project lifecycle to assure SOX compliance
• Involved in the Software Change and Configuration Management process by checking in all versions of the Informatica objects and all releases of various documents in Serena PVCS change manager to keep track of the changes in the development, test and production environment

Environment: Informatica Power Center 7.1 (Designer, Workflow Manager, Workflow Monitor), Crystal Reports 8, Business Objects, Data Migrator, WebFocus, Oracle 9i, SQL Server 2000, FTP/SFTP, Infospan, Windows XP, UNIX Shell Scripting, Toad, Erwin, Remedy Action Request System.

Confidential, CA

ETL Developer

Responsibilities:

• Analyzed user requirements for the system
• Identified business rules for data migration and performed data administration
• Installed and configured Informatica Power Center 6.2 on Client (windows) / Server (UNIX) for Development, Test and Production Environments
• Extensively used Informatica Client Tools -- Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Mapplet Designer to develop mappings
• Used designer debugger to test the data flow and fix the mappings
• Performed Data Extractions, Data Transformations, Data Loading, Data Conversions and Data Analysis
• Parsing high-level design specifications to simple ETL coding and mapping standards
• Developed Stored Procedures and invoked the same through PowerCenter Stored Procedure Transformation
• Developed workflows and tasks using Informatica PowerCenter Work flow Manager.
• Analyzed newly converted data to establish a baseline measurement for data quality in data warehouse
• Developed Universes and reports using Business Objects Designer
• Developed Shell scripts to setup runtime environment
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes when necessary
• Developed test cases for Unit, Integration and system testing
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment

Environment: Informatica Power Center 6.0 (Designer, Workflow Manager, Workflow Monitor), Business Objects 5.1, Oracle 8i, UNIX Shell Scripting, TOAD (Tool for Oracle Application Developer), Windows 2000 Professional, Linux

Confidential, CA

Programmer/Analyst

Responsibilities:

• Performed system design consisting of modeling of ER diagrams, normalization of table structure definitions.
• Wrote procedures, functions and database triggers using PL/SQL
• Created Object Groups with the help of GUI standards consisting of various property classes, alerts and visual attributes
• Developed front-end screens using Forms 4.5
• Developed reports for account status position, transaction Information, and Customer information
• Coded triggers at various levels for cascading functionality crosschecking and complex referential integrity
• Analyzed System Specifications and converted them into Manual Test Cases
• Executed test plan for Identified, Classified, Reviewed and Resolved Defects in consultation with developers and other team members
• Interacted with Developers, Users and Operations in resolving risk factors and other issues
• Performed system testing

Environment: Visual Basic 5.0, JavaScript, HTML, Java, JDBC, UNIX, Oracle 8i, SQL, PL/SQL, Developer 2000, Forms 4.5, Reports 2.5.