SUMMARY

• 8+ 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.
• 6+ years of experience in data warehousing using various ETL tools (Informatica 6.1/7.1/ 8.x,9.x) .
• Hands on experience in Informatica IDQ
• 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 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.
• Experinace in SQL and PL/SQL scripts to install create and drop database objects including tables, views, stored procedures, packages, primary keys, indexes, and constraints.
• 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.
• 8+ 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

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,ESP

PROFESSIONAL EXPERIENCE:

Confidential

Senior Informatica Developer

Enviornment: Informatica Power Center 9.6, Informatica IDQ,Oracle, Autosys, Unix,SSIS

Job responsibilities:

• Analyzed functional requirements and provided end-to-end ETL development in a BI Environment supporting Confidential 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, web services, XSLT, SOAP, WSDL, etc
• 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
• Hands on experience in Informatica IDQ
• 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
• Generated SQL and PL/SQL scripts to install create and drop database objects including tables, views, primary keys and constraints.
• 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

Confidential

Informatica Application administrator support

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

Senior ETL Developer

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

Job 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.
• Generated and maintained complex SQL and PL/SQL scripts for various requirement
• 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

Onsite Coordinator

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

Job 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

Job 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

Senior Developer

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

Job 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 number 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.

Job 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