SUMMARY

• 9+ years of increasing experience as a Senior Informatica Technical Lead / Programmer with a strong, demonstrable background in Financial and Healthcare.
• Proficiency in using Informatica Power Center tool 8x to 9x.
• Hands on experience in handling data from various source systems such as Flat Files, XMLSource, Oracle, MS SQLServer, IBM DB2, Teradata and Excel Files
• Experience involved in Performance Tuning, Error Handling, Production Support and debugging mappings.
• Good experience in creating and using Stored Procedures, Functions, Triggers, Views and packages in Different databases.
• Extensively worked on Monitoring and Scheduling of Jobs using UNIX Shell Script and BTEQ Scripts.
• Expertise on tools like Toad, SQL*Plus and SQL Server Management Studio.
• Involved in Manual and Automated Testing of applications on UNIX and Windows Environment.
• Good exposure to the Software Development Life Cycle (SDLC) and OOAD Techniques.
• Have a clear understanding of Business Intelligence and Data Warehousing Concepts.
• Strong Technical skills in range of technologies which includes Informatica ETL, Oracle, Sybase, DB2, COBOL, UNIX, PL/SQLand Teradata.
• Flexibility to change/leverage with any new Technology
• Experience working with agile methodologies.
• Strong Data warehousing concepts, Dimensional Star Schema
• Experience in providing estimates for initiatives based on impact analysis
• Experience working with agile methodologies.
• Experience in converting business requirements into technical requirements.
• Effectively managing the entire development lifecycle, both independently and collaboratively, by maintaining contact and strong relationships with the leaders in other groups.
• Collaborating with IT and business to define a plan of execution for database based projects ranging in scope from a month to a year.
• Strong written and verbal communication skills at all levels to effectively drive buy in from Senior Executives in both IT and Business as well as maintaining the focus of the development team.

TECHNICAL SKILLS

ETL: Informatica 8x and 9x

Operating systems: Windows, Unix

Programming Languages: PL/SQL,COBOL,Perl,C,C++

Database Systems: Oracle, DB2, Sybase, Teradata

Scripting Languages: Shell scripting

Tools: RapidSQL,Autosys, IBM Clearcase

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, Pennsylvania

Sr. Informatica/Oracle Developer

Responsibilities:

• Involved in the full life cycle development of the project including Analysis, design, development, and testing.
• Having exposure on Informatica Cloud Services.
• Interacted with Business Analysts to understand the business requirements and types of reports being generated.
• Involved in the development of Data Mapping and Design Process documents for the ETL processes.
• Developed various informatica mappings to process data from flat files (.txt, Excel, and XML files) to Oracle database.
• Designed and implemented different validation mappings meeting the business requirements and data quality.
• Developed new complex mappings and modified existing mapping for transforming the source data to the target database, using different transformations using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter and Sorter transformations.
• Implemented Slowly Changing Dimensions - Type I and Type II in various mappings supporting the application system
• Wrote Teradata Macros and used various Teradata analytic functions.
• Excellent knowledge on ETL tools such as Informatica, SAP BODS to load data to Teradata by making various connections to
• Knowledge on Global Data Synchronization Network
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Experience in installation and configuration of core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ).
• Worked withInformaticaData Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Load and extract data to and from Teradata efficiently.
• Used Teradata utilities fastload, multiload, tpump to load data
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Developed mappings to load fixed width and variable length flat files from relational sources.
• Used Debugger to track the path of the source data and also to check the errors in mapping.
• Created session tasks, worklets and workflows to execute the mappings.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential, parallel, initial and Incremental Load.
• Performed Integration, regression and system testing for code changed or logic altered existing mappings
• Used Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters for tuning the performance and to meet standard processes for development.
• Migrated the data from different environments like Development to production for creating shortcuts and by creating deployment groups.
• Scheduled the Informatica jobs on Dollar universe and created necessary sequential / parallel dependencies across the job groups.
• Prepared all documents necessary for knowledge transfer such as ETL strategy, ETL development standards, ETL processes.
• Exposure to Informatica B2B Data Exchange that allows to support the expanding diversity of customers and partners and their data with capabilities that surpass the usual B2B solutions
• Worked with the B2B Operation console to create the partners, configure the Partner management, Event Monitors and the Events
• Exposure to Informatica B2B Data Transformation that supports transformation of structured, unstructured, and semi-structured data types while complying with the multiple standards which govern the data formats.

Confidential, Phoenix, Arizona

Sr. Informatica/ Oracle Developer

Responsibilities:

• Worked heavily with Business Analyst to understand the business and to design the HLD'S and LLD'S.
• Designed the metadata tables and created mappings to populate the same. These tables were used to generate the parameter files.
• Having exposure on Informatica Cloud Services.
• Created mappings to perform the tasks such as cleaning the data and populate that into staging tables, Populating the Enterprise Data Warehouse by transforming the data into business needs & Populating the DataMart with only required information.
• Created reusable transformations to clean the data, which were used in several mappings.
• Worked on power exchange to create data maps, pull the data from mainframe, and transfer into staging area.
• Developed and tested stored procedures, functions and packages in PL/SQL
• Extracted data from various sources like MS SQL Server 2008, DB2, flat files, Excel spreadsheets, Oracle and XML files and loaded into the oracle database.
• Involved with Informatica team members in Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Planned, created and executed packages to integrate data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads.
• Designed and implemented stored procedures and triggers for automating tasks in SQL Server 2008/ Oracle 10g.
• Wrote Teradata Macros and used various Teradata analytic functions.
• Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Designed Mappings using B2B Data Transformation Studio.
• Experience in Systems Integration using Informatica B2B Data Exchange.
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Wrote Teradata Macros and used various Teradata analytic functions.
• Extensively worked on Performance tuning by using Explain plans and various hints.
• Worked on table partitioning (Range and List) and deploying local indexing on portioned tables.
• Used Oracle 9i features such as merge for various transformations.
• Used UNIX Shell scripts (KORN) for Extracting and Parsing data from the files.
• Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.
• Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
• Created Stored Procedures, functions and Packages in Oracle 9i using SQL and PL/SQL for the Audit Trail using Oracle 9i as backend.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Ensured that weekend data loads, end-of-month & end-of-quarter processing ran successfully and completely, transparent to user community.

Confidential, Boston, MA

Informatica/Oracle Developer

Responsibilities:

• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouses.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Developed strategies for Incremental data extractions as well data migration to load into the Teradata. And also assisted in designing Logical/Physical Data Models.
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Wrote Teradata Macros and used various Teradata analytic functions.
• Developed mappings to extract data from SQL Server, Oracle, Flat files, DB2, Mainframes and load into Data warehouse using the Power Center, Power exchange.
• Informatica Data Quality (IDQ 8.6.1) is the tool used here for data quality measurement.
• Identified and eliminated duplicates in datasets thorough IDQ 8.6.1 components of Edit Distance, Jaro Distance and Mixed Field matcher, It enables the creation of a single view of customers, help control costs associated with mailing lists by preventing multiple pieces of mail.
• Created SSIS Packages to migrate slowly changing dimensions. Expert knowledge SQL Queries, Triggers, PL/SQL Procedures, Packages to apply and maintain the Business Rules.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, Created testing metrics using MS-Excel
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Designed and developed UNIX shell scripts to schedule jobs. Also wrote pre-session and post-session shell scripts, Wrote PL/SQL scripts for dropping, rebuilding indexes.
• Performed Configuration Management to Migrate Informatica mappings/sessions/workflows from Development to Test to production environment.
• Create & maintained cron jobs using Shell Scripts.
• Part of performance tuning team, tuned PL/SQL code and SQL queries using Execution plan and TOAD.

Confidential, Atlanta, GA

Oracle Developer

Responsibilities:

• Involved in the maintenance and enhancement of the application.
• Used the technical document to design the database tables.
• Involved in designing the database using ERWIN.
• Writing SQL*Loader Scripts to load huge data into tables.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Communicate issues and progress to project manager.
• Developed PL/SQL coding standards.

Confidential

Oracle Developer

Responsibilities:

• Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.
• Used DDL and DML to create and manipulate data
• Developed Control scripts and loaded existing data using SQL * Loader.
• Developed stored procedure using PL/SQL to update payment info into Bills.
• Developed Database Triggers to enforce security.
• Generate reports, day-to-day administration jobs.
• Developed Forms /Reports using Forms 4.5i and Reports 4.5i and solved Numerous Problems in Reports.