SUMMARY:

I am an ETL/Informatica developer with over 9 years of professional experience in the banking, financial, and pharmaceutical and retail industries. I have experience with many different software methodologies such as the waterfall and Agile models. Good experience with Informatica Real time integration and Salesforce Integration.

TECHNICAL SKILLS:

ETL Tools: Information PowerCenter versions 7.x through 9.x

Databases: Oracle 8.x/9.x/10g/11g, SQL Server 2008/2005/2003/2000 , DB2 UDB 7.2, Mainframe, MS - Access.

Editors: SQL Navigator, Toad

Oracle Tools: Oracle Enterprise Manager, Quest TOAD, SQL*PLUS, SQL*Loader, SQL*Net, SQL Navigator Export/Import

Microsoft Office: MS Word, Excel, PowerPoint

Operating systems: UNIX, Windows ME/2000/2003/NT/XP, IBM AIX

Scripting/Querying Skills: UNIX Shell scripting, SQL, SQL*PLUS, PL/SQL

Data Modeling Skills: ERWIN

Scheduling Tool: Control M, Autosys

Defect Tracking: JIRA, HP QC/ALM

EXPERIENCE:

Lead Informatica Developer

Confidential, Manhattan, NYC

Responsibilities:

• Responsible for creating mapping,sessions,workflows and worklets.
• Developed standard and reusable Mappings and Mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup (connected/unconnected), and filter
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from Oracle
• Worked with business analysts, technical analysts, and DBAs to understand the data, the expected formats, data hierarchies and the functional hierarchies of various datasets
• Involved in unit testing, system testing, and integration testing to check whether the data loaded into the target is accurate
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors
• Fine tuned ETL code to improve performance by identifying bottlenecks and taking corrective measures
• Used Pushdown optimization to improve performance on loading data to Target.
• Utilized Netezza Bulk writer to load billions of rows quickly.

Technical Environment: InTechnical Environment: Informatica 9.6.1, Netezza, MS SQL Server, Windows 7, Linux, Tidal Job scheduling tool

Lead Informatica Developer

Confidential, Jersey City, NJ

Responsibilities:

• Responsible for leading the Trades team and directing Informatica developers onsite and offshore
• Developed standard and reusable Mappings and Mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup (connected/unconnected), and filter
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from Oracle
• Worked with business analysts, technical analysts, and DBAs to understand the data, the expected formats, data hierarchies and the functional hierarchies of various datasets
• Wrote various SQL queries for better performance in Source Qualifier.
• Wrote SQL queries for each asset class for Trades stream ABORLite Delta processing.
• Troubleshoot and fixed issues in ABORLITE for Trades including Data match rate differences and data issues.
• Worked on troubleshooting/debugging/fixing PL/SQL packages,functions and procedures.
• Deployed PL/SQL packages to higher environments.
• Involved in unit testing, system testing, and integration testing to check whether the data loaded into the target is accurate
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors
• Converted ETL mappings into SQL queries to run for each Security class for Delta run.
• Fine tuned ETL code to improve performance by identifying bottlenecks and taking corrective measures

Technical Environment: InTechnical Environment: Informatica 9.5, Oracle 11g, PL/SQL, MS SQL Server, Windows 7, Linux

Senior Informatica Developer

Confidential, Brooklyn, NYC

Responsibilities:

• Involved in understanding and preparing technical requirements and acquiring application knowledge from Business Managers & Application Owners
• Performed extensive data analysis along with subject matter experts, identified source data and implemented data cleansing strategy
• Prepared mapping documents for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards
• Used PowerExchange to capture changes and load data continuously into Oracle tables
• Responsible for creating Real time web service mappings using web service consumers to consume the SOA services in giving a proper response
• Created mapping for loading data into Salesforce tables via Informatica for Salesforce Integration
• Prepared a Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information required for the maintenance and operation of the application
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community

Technical Environment: Informatica 9.5, Informatica Real time Integration, Oracle 11g, Web services, Salesforce Integration, CDC PowerExchange for Oracle, SQL Developer, UNIX, Erwin Designer 4.1.

Informatica Developer

Confidential, Parsippany, NJ

Responsibilities:

• Involved in the full development lifecycle from requirement gathering through designing, building, QA, deployment and providing support using Informatica Power Center and SQL Server objects
• Resolved source system data issues (XML files and XSD schema) with Source System Owners
• Worked closely with business analysts to gather functional specifications and turn them into technical specifications
• Co - ordinated and monitored the Data Feed loads from offshore team
• Worked on data profiling, data transformation, and data cleansing
• Worked on Informatica tools Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer and Transformation Developer.
• Built Workflows and Worklets to schedule, sequence and parameterize different ETL tasks.
• Designed and wrote Unit Test Plans.
• Prepared and executed test cases
• Built, maintained, and fine-tunes ETL mappings to load data from XML source to Relational Pre-Staging, then from Pre-Staging to Staging, then from Staging to Data warehouse using Informatica Power Center.

Technical Environment: Informatica Power Center8.x, Oracle 10g, PL/SQL, Visio, Erwin, Windows, UNIX Shell Scripts, AIX.

Informatica Developer/Tester

Confidential, Wilmington, DE

Responsibilities:

• Responsible for gathering test requirements and creating and scoping out the test plan.
• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Responsible for anayzing business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica, Shell Scripting.
• Created and maintained test reports, identified bugs and reported findings using Quality Center
• Prepared testing strategy, testing schedule, test Cases depending upon the Requirement documents for integration and system testing.
• Defect management, bug tracking and bug Reporting using Quality Center.
• Queried databases using SQL queries in TOAD and SQL Server Management Studio to validate the data loaded into target tables.
• Tested Informatica mappings and workflows, and worked extensively with Informatica for data sourcing, data transformation and data loading.