Professional summary: 

• 9+ years of increasing experience as a Senior Informatica Technical Lead / Programmer wif 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.
• Has 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 wif any new Technology
• Experience working wif agile methodologies.
• Strong Data warehousing concepts, Dimensional Star Schema
• Experience in providing estimates for initiatives based on impact analysis
• Experience working wif agile methodologies.
• Experience in converting business requirements into technical requirements.
• TEMPEffectively managing the entire development lifecycle, both independently and collaboratively, by maintaining contact and strong relationships wif the leaders in other groups.
• Collaborating wif 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 TEMPeffectively 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,9x and 10x

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, Milwaukee, Wisconcin

Sr.Informatica Developer

Responsibilities:

• Involved in the full life cycle development of the project including Analysis, design, development, and testing.
• 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 Autosys and created necessary sequential / parallel dependencies across the job groups.
• Used Version Control to check in and checkout versions of objects.
• Involved in monitoring the workflows and in optimizing the load times.
• Involved in resolving the Informatica server side problems by checking the Catalina and node log files.
• Wrote Stored Procedures, Functions and Triggers using Oracle PL/SQL.
• Wrote complex Oracle SQL queries to retrieve unique datasets using Inner and Outer Join and Analytic functions.
• Worked wif production Support to resolve issues of data processing by preparing bulk data fix scripts.
• Designed and developed different business reports using Crystal reports.
• Used SQL tools like SQL Developer, PL/SQL Developer to run SQL queries and validate data.
• Prepared all documents necessary for noledge transfer such as ETL strategy, ETL development standards, ETL processes.
• Designed and developed different business reports using Crystal reports.
• Used SQL tools like SQL Developer, PL/SQL Developer to run SQL queries and validate data.
• Prepared all documents necessary for noledge transfer such as ETL strategy, ETL development standards, ETL processes.
• Exposure to Informatica B2B Data Exchange dat allows to support the expanding diversity of customers and partners and their data wif capabilities dat surpass the usual B2B solutions
• Worked wif the B2B Operation console to create the partners, configure the Partner management, Event Monitors and the Events
• Exposure to Informatica B2B Data Transformation dat supports transformation of structured, unstructured, and semi-structured data types while complying wif the multiple standards which govern the data formats.
• Involved in Unit testing, System testing and UAT to check data consistency
• Assisted QA team to fix and find solutions for the production issue
• Interacted wif 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 me and Type II in various mappings supporting the application system

Confidential, Grand Rapids, Michigan

Sr.Informatica 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 wif 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 me and Type II in various mappings supporting the application system
• Wrote Teradata Macros and used various Teradata analytic functions.
• Excellent noledge 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 dis noledge in building MDM solutions.
• Performed match/merge and ran match rules to check the TEMPeffectiveness 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 wif Informatica Data 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 noledge 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.
• Used Version Control to check in and checkout versions of objects.
• Involved in monitoring the workflows and in optimizing the load times.
• Involved in resolving the Informatica server side problems by checking the Catalina and node log files.
• Wrote Stored Procedures, Functions and Triggers using Oracle PL/SQL.
• Wrote complex Oracle SQL queries to retrieve unique datasets using Inner and Outer Join and Analytic functions.
• Worked wif production Support to resolve issues of data processing by preparing bulk data fix scripts.
• Designed and developed different business reports using Crystal reports.
• Used SQL tools like SQL Developer, PL/SQL Developer to run SQL queries and validate data.
• Prepared all documents necessary for noledge transfer such as ETL strategy, ETL development standards, ETL processes.
• Exposure to Informatica B2B Data Exchange dat allows to support the expanding diversity of customers and partners and their data wif capabilities dat surpass the usual B2B solutions
• Worked wif the B2B Operation console to create the partners, configure the Partner management, Event Monitors and the Events
• Exposure to Informatica B2B Data Transformation dat supports transformation of structured, unstructured, and semi-structured data types while complying wif the multiple standards which govern the data formats.

Confidential, Harrisburg, Pennsylvania

Sr.Informatica Developer

Responsibilities:

• Worked heavily wif 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 dat into staging tables, Populating the Enterprise Data Warehouse by transforming the data into business needs & Populating the DataMart wif 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 wif 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 noledge 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 dat weekend data loads, end-of-month & end-of-quarter processing ran successfully and completely, transparent to user community.

Confidential, Phoenix, Arizona

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 wif business community and gatheird 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 noledge 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, halp control costs associated wif mailing lists by preventing multiple pieces of mail.
• Created SSIS Packages to migrate slowly changing dimensions. Expert noledge 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, Boston, MA

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.
• 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.