SUMMARY

• 11+ years of overall experience working in the Information Technology Industry for Finance, Banking, Communications, Mortgage, Insurance and Health Care industries. Having experience in Data Warehousing, Business Intelligence, ETL/ELT, Netezza/Teradata/Oracle/DB2 appliance, Data Profiling/Quality and Big Data projects.
• 10+ years of experience in data warehousing using various ETL tools (Informatica 6.1/7.1/ 8.x,9.x).
• 3+ yrs of experience in Informatica administration with installation and maintenance hands - on
• Installed/Upgraded Informatica PowerCenter 7.x/8.x/9.x on Linux, IBM AIX and Windows Applied Hot Fixes as required.
• Have experience with Informatica Performance Tuning, Troubleshooting, Backup & recovery, Code Deployment & Pro-active health check
• Co-ordinate with Informatica Technical Support for any issues or hot fixes/patches
• Have experience to provide technical support for the Informatica environment
• Experience in creation and maintains new user accounts, permissions for different folders
• Experience in taking periodic backups and restores as required
• Configured Team-based development, Real-time edition and Change data capture
• Have experience creating and maintaining Prod and Non-Prod Environments.
• Experience on Enterprise Grid clustering, Load Balancer, Failover and High Availability.
• Experience with authentication methodologies: Active Directory, and/or LDAP
• Experience in UNIX shell scripting, automation of ETL processes using Crontab, Autosys, Tidal, DAC and Tivoli, Autosys, Control-M, ESP
• Worked with Informatica SRs (support requests) and infrastructure support team to investigate and resolve issues
• Experience in advanced Power Center features like Recovery and Pushdown Optimization
• Experience in Integration of various data sources like Oracle, SQL Server, Flat Files, Webservices,XML files, Teradata,COBOL files and Mainframe
• Have experience on 24X7 Production Support for Informatica Product Suite Services
• Experience in working with data warehouses and data marts using Informatica Power center (Designer, Repository Manager, Workflow Manager, and Workflow Monitor).
• Developed Strategies for Extraction Transformation Loading (ETL) mechanism.
• Extensive knowledge with Dimensional Data modeling, Star Schema/snowflakes schema, Fact and Dimension tables.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Experienced with Informatica Power Exchange (6.x/8.x) for Loading/Retrieving data from mainframe systems.
• Extensively worked on web service sources extracting data as consumer
• Hands on experience in web service source as consumer and web service consumer transformation
• 10+ year’s Extensive experience with relational databases (Oracle 8i/9i/10g, Teradata v2 R6, SSIS, Sql Server 2000/2005).
• Experience in writing unix scripts and invoking pmcmd command
• Reliable, responsible, hard working and good team player

TECHNICAL SKILLS

ETL Tools: Informatica 7.1, 8.6,9.1, 9.5.9.6,SSIS,Cognos

RDBMS: Oracle 8.x/9.x,10g Teradata v2 R6, DB2, Sql Server 2005

Database skills: Stored Procedures, Database Triggers, and Packages

Languages: C, SQL, PL/SQL, Unix

OS: UNIX, AIX, Windows 2000/2003/XP/Vista

Tools: Control M, Auto sys,Toad,WinSQL,SQL Assistant

PROFESSIONAL EXPERIENCE

Confidential

Informatica Lead

Environment: Informatica Power Center 9.6, Oracle, Autosys, Unix,SSIS,Cognos

Responsibilities:

• Analyzed functional requirements and provided end-to-end ETL development in a BI Environment supporting ITRC projects.
• Worked with business analysts, and end users to define business rules and interpret data.
• Proficiency with RDBMS systems, SQL, Oracle PL/SQL, UNIX Shell scripting, and database optimizations
• Hands On Experience in XML, XSLT, etc
• Extensive working experiance in webservices as consumers connecting using WSDL file
• Hands on experiance in modifying the SOAP request in web services as per the requirement
• Worked on web service consumer source extractin data from web services
• Worked on webservice transformation for some of the sources as consumers
• Designed and developed UNIX shell scripts as part of the ETL process to automate the Process of loading, pulling and pushing data from & to different servers.
• Implemented best practices, standards, and procedures to encourage team consistency, efficiency, and maintainability
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and Worklets.
• Involved in Informatica Architecture, Design Development, testing and migrating the code to various environments
• Facilitated meetings to track team progress, review designs, confirm readiness for implementation, uncover requirements and resolve issues
• Involved in working with other project managers and leaders to coordinate cross-project initiatives and activities.
• Assisted in fixing the development timelines and project delivery for various sprints
• Lead the Development team at offshore through the SDLC process and ensure that the milestones are met.

Confidential

Informatica Application Administrator

Environment: Informatica Power Center 9.5,Teradata 13.0.0.14,ESP,Unix

Responsibilities:

• Informatica Infrastructure support
• Involved in code reviews and migrations from DEV -> QA -> UAT -> PPRD -> PROD
• Worked on Security management, creating Groups, Users and Folders
• Created Shell scripts to automate code deployment, monitoring, backups and cleanup
• Created reusable scripts using Informatica command line for all projects
• Performance tuning of Informatica code
• Application Linux Admin support for Galaxy Project Teams
• Use Harvest Tool for Versioning control of linux files
• ETL Scripts maintenance. Created Shell scripts to automate code deployment, monitoring, backups and cleanup
• Worked with DBA’s, Linux, Network, Storage and Exchange teams
• Ensures to follow standards, policies and procedures set by client and Informatica best practices
• Oracle DBA Application Support
• Validating and running production scripts for project.
• ESP - Maintain Application Scheduler for all projects.
• Oncall Duty Rotation depending on ETL roster. Involved in Change and Incident Management process

Confidential, Columbus

ETL Lead

Environment: Informatica Power Center 9.1,Teradata 13.0.0.14,Control M

Responsibilities:

• Worked on Field analyzing like identifying the business logic for each field.
• Understanding the Data warehouse architecture ICDW by interrelating with source legacy systems.
• Interacting with Business people and SOR owners for requirements gathering and designing
• Leading the offshore team by guiding them with the requirements and reviewing all the deliverables.
• Preparing the High level Design Specifications for ETL Coding and mapping standards.
• Performed Unit-testing by generating sql scripts based on the pre-defined test plans
• Worked with Flat files as sources and targets
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner etc.
• Created Mapplets and reusable transformations to be re-used during the development life cycle
• Coordinated with Source System Owners to analyze sources for data feeds, mappings and Defaults for the Data.
• Worked extensively on web services as one of the sources
• Good understanding in webservices WSDL files,SOAP requests
• Extensively worked in PDO mappings for handling massive data transformation an loading.
• Standardized parameter files to define session parameters such as database connection for sources targets, last updated dates for Incremental loads and many default values of fact tables.
• Performed tuning of Informatica Mappings for optimum performance. Implemented Data Validation and Exception handling logic in the mapping to handle at runtime.
• Implemented Slowly Changing Dimensions to update the dimensional schema.
• Extensively used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode.

Confidential, Cleveland,OH

Technical Lead

Environment: Informatica Power Center 8.5/8.6, IDE, Oracle 10g, Toad, UNIX, Autosys, Harvest

Responsibilities:

• Worked extensively with Business community and database administrators to identify the business requirements and data realities.
• Working closely with data modeling team for new requirement and Enhancements in the database
• Parsing high-level design specification to simple ETL coding and mapping standards.
• Handling all phases including Requirement Analysis, Design, Coding, Testing and Documentation.
• Participated in client meetings and proposed various ETL Strategy.
• Leading 30 people of the offshore team and providing the inputs from the clients to the team
• Performing as co-coordinator between the business users and the technical team by converting the business requirement to technical design
• Worked on Informatica Power Center 8.6 Tool - Designer, Work Flow Manager, Work Flow Monitor and Repository Manager
• Coordinated with Source System Owners to analyze true sources for data feeds, mappings and Defaults for the Data
• Implemented end-to-end mappings involving complex logic using Transformations like Expression, Joiner, Filter, Lookup, and Router.
• Performed functional testing by generating sql based on the Test Plans.
• Performing code review, formal testing, performance testing, and specification review
• Implementing performance tuning methods to optimize developed mappings
• Responding quickly and effectively to production issues and taking responsibility for seeing those issues through resolution

Confidential, California

Data Analyst/Senior Informatica Developer

Environment: Informatica Power Center 7.1.1, UNIX (AIX 5.2), Toad, Shell Scripting, Flat files,SSIS

Responsibilities:

• Analyzed the source data coming from Oracle, Flat Files, and DB2 coordinated with data warehouse team in developing Dimensional Model.
• Analyzing the already existing data model and the existing Bridges and providing solutions for the new mode of data movement.
• Implemented Slowly Changing dimension methodology for accessing the full history of claims information
• Incorporating changes in the physical model for the changes in the Erwin logical model.
• Designed and developed several ETL scripts using Informatica, UNIX shell.
• Extensively used all the features of Informatica 7.x including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Created flexible mappings/sessions using parameters, variables and heavily using parameter files.
• Developed Procedures and Functions in PL/SQL for Data ETL
• Involved in Unit Testing, Integration Testing, and System Testing.
• Involved in conceptual, logical and physical data modeling and used star schema in designing the data warehouse.
• Provided post - implementation Production Support for the project (including being on-call during nights and weekends).

Confidential, Chicago

Technical Lead

Environment: Informatica Power Center 7.1.x, 8.5/8.6, Power Exchange, Oracle 10g, PL/SQL, Toad, UNIX, Windows XP,Cognos

Responsibilities:

• Participated in user meetings, gathered Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design docs.
• Defined, and documented the technical architecture of the Data Warehouse, including the physical components and their functionality.
• Designed ETL architecture to Process large no of files and created High-level design, low-level design documents.
• Extensively worked on flat files and involved in creation of UNIX shell scripts for FTP, generating list files for loading multiple files and in archiving the files after the completion of loads.
• Involved in the creation of Informatica mappings to extracting data from oracle, Flat Files to load in to Stage area.
• Worked data mapping, data cleansing, program development for loads, and data verification of converted data to legacy data.
• Involved in error handling, performance tuning of mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, and the Target Data.
• Experienced in loading data into Data Warehouse/Data Marts using Informatica.
• Possess expertise with relational database concepts, stored procedures, functions, triggers and scalability analysis.
• Generated SQL and PL/SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, and constraints.
• Optimized the SQL and PL/SQL queries by using different tuning techniques like using hints, parallel processing, and optimization rules.
• Carry out Defect Analysis and fixing of bugs raised by the Users
• Involved in support and troubleshooting of production systems as required, optimizing performance, resolving production problems, and providing timely follow-up on problem reports

Confidential

Senior ETL Developer / Informatica Administrator

Environment: Informatica Power Center 7.1.x, 8.5/8.6, Power Exchange, Teradata v2 R6, Oracle 10g, PL/SQL, Toad, Unix, Windows XP.

Responsibilities:

• Worked as Sr. ETL Developer/Informatica Admin to Transformed bulk amount of data from Oracle Database sources to Teradata database using Informatica using BTEQ scripts.
• Written the scripts needed for the business specifications (BTEQ Scripts).
• Design/develop and manage power center upgrades from v 7.x to V 8.6, Migrate ETL code from Informatica v 7.x to V 8.6.
• Transferred data using Teradata utilities like SQL Assistant, Fast Export, Fast Load, Mload and T-pump.
• Developed extraction routines and design specs to get data from Flat /Online Transaction Processing System (OLTP) and load into Oracle and Teradata Server systems for ODS
• Developed mapping designs to generate reports for Revenue Accounting System (RAS) for interfacing month-end close general ledger (GL) accounting data and transactional policy/endorsement detail from TRAX to RAS.
• Involved in requirement gathering, analysis and designing technical specifications for the data migration according to the Business requirement.
• Developed complex mappings and SCD type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations. Created complex mapplets for reusable purposes.
• Involved in optimization and performance tuning of Informatica objects and Database objects to achieve better performance.
• Offered production support for daily jobs.
• Worked with UNIX commands and used shell scripting to automate jobs.
• Worked extensively in defect remediation and supported the QA testing.
• Worked as primary administrator to support the Production, QA and Dev environments
• Responsible for creating Folders, Users and Groups with proper previlages
• Responsible for installing new servers, Integration services and Repository services
• Involved in periodic maintenance of environments by applying patches and content upgrades.
• Involved in Code migration for versioned repositories, creating Deployment group using Query
• Experience in taking repository backup and restoring it, recycling Informatica services
• Involved in interacting with Belgium Informatica Support for various issues and solving them
• Constant Monitoring of CPU server usage and raising suitable alarms for over loading to the users

Confidential

Informatica Senior Developer

Environment: Informatica Power Center 8.1.1, Oracle 9i,Toad

Responsibilities:

• Worked on Field analyzing like identifying the business logic for each field.
• Participated in team meetings and proposed ETL Strategy.
• Preparing the High level Design Specifications for ETL Coding and mapping standards.
• Performed Unit-testing by generating sql scripts based on the pre-defined test plans
• Performed tuning of Informatica Mappings for optimum performance.
• Implemented Slowly Changing Dimensions to update the dimensional schema.
• Extensively used Unix Scripting to interact with Informatica Server from command model.

Confidential

Service Delivery Associate

Environment: Informatica Power Center 7.1, Oracle

Responsibilities:

• Expertise in handling production issues with applications like FPM
• Investigating these issues by gathering detail from different teams like SE, Development and the Clients. And analyzing the ETL code, debugging SQL, input, output feed through UNIX to provide root cause analysis on production bugs.
• Provided DML statements to DBA have to work on data cleaning.
• Communicate and co- ordinate between various teams that are involved in the scope of the ticket and track all the tickets to closure.