SUMMARY:

• 10 years' experience in Data warehousing space using Informatica 7x/8x/9.xand ETL Concepts.
• Acquired and developed skills in Requirement Analysis, Design, Coding and Testing of various software applications in Informatica.
• Having worked with different clients and various teams has helped me to effectively handle critical situations with ease.
• Ability to learn new technologies with ease, implement and deliver projects efficiently.
• Quick learner and creative problem - solver.
• Solid ETL database programming and database reporting experience and Enterprise Data Warehouse environment
• Must also have significant experience using Informatica and Oracle and a strong knowledge
• Experience with all phases of SDLC and in implementing, staging, operation data stores and dimensional data modeling preferred.
• Experience researching and staying informed of industry technical/ business information security requirements and translating those requirements to the Banks information environment.
• Make recommendations and maintain appropriate working relationships with vendors ensuring access to support, product maintenance and software updates
• Document all areas of the systems, including which clients are accessing which applications, databases and system security design
• Work with the business continuity staff to create and update system disaster avoidance and recovery plans
• Strengths include ability in meeting deadlines and deliverables while achieving excellence and quality of work.
• Used Workflow manager to create and configure workflow and session task to load data; used Informatica workflow monitor to create, monitor workflow in case of process failures; performed testing as per UTC
• Implemented optimization techniques for performance tuning and wrote pre-& post session shell scripts
• Configured the sessions using workflow manager to have multiple partitions on source data and to improve performance
• Involved in extensive performance tuning by determining bottlenecks in sources, mappings and sessions
• Possess strong problem-solving skills developed through variety of projects Expertise in creating Reports using SSRS.
• Experienced in interacting with customer and provide support as needed.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• 24 x 7 Production Database on Call Support.

PROFESSIONAL EXPERIENCE:

Informatica consultant

Confidential - Minneapolis, MN

Responsibilities:

• Perform analysis of existing code in mainframes or in ETL tools like Informatica to understand the mapping logics
• Developing the mapping documents including System of Record field names, Mapping Rules and W Target field names.
• Perform analysis of the existing W data to understand the mapping rules in the current environment
• Discussion of the W mapping document with Architects and mapping team to appropriately map 'The W' elements to the Banking Data Warehousing (BDW) Model.
• Continuous support through conference calls with mapping team and development team to provide accurate data in new environment.
• Reviewing the BDW mapping document to produce the same data in new environment as in current W.
• Transmission of the System of Record files from UNIX to new environment.
• Coding in new environment as per the mapping documents.
• Preparation of test cases to validate the output data generated using the mapping documents.
• Validation of the test cases using Quality Center tool of Bank.
• Defect tracking through Quality Center and SharePoint portal.

Environment: Informatica 9.x ORACLE, SQL Server/2008R2/2012, Jira

Technical Lead

Confidential - Minneapolis, MN

Responsibilities:

• Involved in preparing Technical Requirements Document, High Level Design document and Technical Design document.
• Complete Ownership of the application Project Accounting Data Ware House System.
• Participated in Deployment by adding objects into deployment group and moving the code from test to production.
• Deployment of Sources, targets, mappings, sessions and workflows and participated in deployment, to build efficient ETL components to meet the technical requirements.
• Ensuring smooth running of the application and facilitating improvisation as and when required.
• Monitor the changes carried out in the application as part of maintenance co coordinating and Interacting with the offshore team and resolving the issues.
• Responsible for handling the ticket raised by business user and to provide root cause and fix the issue with in time line.
• Attended weekly status meetings and provide detailed status report to the client.
• Perform unit testing at various levels of the ETL.
• Debug the sessions by utilizing the logs of the sessions.
• Involved in writing Stored Procedures and Functions to handle database automation tasks
• Analyzed database, stored procedure, and TSQL queries for optimizations and recommended enhancements
• Created procedures, functions, sequences, constraints and triggers to maintain data integrity. Applied indexes and partitions to improve performance. Created views for monitoring and reporting.
• Designed source to target mapping strategy and performed ETL to populate databases from existing dispirit data sources (text, Excel, Access etc).
• Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

Environment: Informatica 9.x ORACLE, SQL Server/2008R2/2012, CA Automation tool, Clear Quest.

Technical Lead

Confidential

Responsibilities:

• Reporting the consolidated daily/weekly status to the PM
• Participated in the development of new systems and upgrades and updates to existing systems, throughout the entire application lifecycle: requirements analysis & definition, system design, implementation, testing, deployment, and sustainment
• Generated the Reports Weekly or Monthly wise as per the Client
• Tickets committed within the SLA period without any disputes.
• Understanding the application data & business requirement.
• Responsible for developing ETL mappings to load data using Informatica Power Center 9.x
• Develop and perform tests and validate all data flows and prepare all ETL processes according to business requirements and in corporate all business requirements into all design specifications.
• Define and capture metadata and rules associated with ETL processes
• Adapt ETL processes to accommodate changes in source systems and new business user requirements
• Provide support and maintenance on ETL processes and documentation
• Involve in all Unix System Production Support by trouble shooting customers urgent requests.
• Create and execute validation and production support scripts for custom components. Documents, review, and execute performance tuning scripts.
• Understanding data requirements for test and development
• Successfully improved the performance on our application through index analysis, removing unused indexes and analyzing stored procedures, functions and SQL scripts. One of the stored procedure tuning efforts resulted in a 2 minute duration to a few milliseconds
• Maintained database environment security for development, test and pre-production environments
• Involved in Peer review activities for Code & Testing.
• Finding the Root causes of the bugs raised
• Optimized performance by tuning the Informatica ETL code.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Used debugger to test the data flow and fix the code.
• Supporting the on call support on Quarter end and production release management deeds
• Respond to trouble shoot tickets assigned to me and fix any database issues promptly.

Environment: Informatica, SAP BO, Oracle, UNIX, Tableau, putty, winscp

Technical Lead

Confidential

Responsibilities:

• Designing, coding, benchmark testing, debugging, and documenting application features and changes
• Reviewing and assessing existing enterprise applications, to support new features, performance improvements, upgrades, and ongoing sustainment
• Proficiency with modern development toolsets including Visual Studio, SQL Server Management Studio, unit testing frameworks, source control, and task tracking such as Team Foundation Server
• Experience designing, implementing, supporting, and analyzing enterprise scale applications that perform extract/transform/load (ETL) operations with external data sources and SQL Server
• Developed and optimized SQL to implement ETL job steps using ETL tools such as Informatica, SSIS, or Metal
• Monitor, diagnose and repair all data loading and processing packages to ensure data integrity of the analysis data and also Designing & implement ETL requirements
• Involved in Peer review activities for Code & Testing, Deployment
• Reporting bugs in the Bug Tracker tool (VSTF) and following up with Business and resolving the issues by conducting meetings.
• Analyzed the performance, tuned and optimized, supported database objects to migrate to production level, executed stored procedures, index sizing
• Configured the necessary table structures in the database to collect and normalize business data
• Resolved known issues and bugs in the corporate platform interface and back end database
• Programmed user Defined Functions, Views and TSQL Scripting for complex business logic.
• Finding the Root causes of the bugs raised
• Reporting the consolidated daily/weekly status to the PM
• Expertise in generating reports like drill down, drill through reports, parameterized reports, sub reports and different types chart reports in SSRS and tableau dash boards.
• Generated the Reports Weekly or Monthly wise as per the Client Requirements.
• Rendering the Reports in the form of PDF, EXCEL and CSV.

Environment: Informatica, SSRS, SSIS, Metal, Oracle, TSQL, SQL server 2008R2\20012

Senior ETL Developer

Confidential

Responsibilities:

• Involved in various activities like project planning and documentation.
• I have guided the team members on ETL development's and design part.
• Coordinated with various businesses in DB to understand their requirements.
• Involved in generalized Architecture design of IRT tool.
• Involved in Functional and Technical level design.
• Involved in BRD document preparation.
• Design & implement ETL requirements
• Create and execute validation and production support scripts for custom components. Documents, review, and execute performance tuning scripts.
• Perform constant file manipulation using VI Editor
• Generalized component development using various transformations
• Expertise in generating reports like drill down, drill through reports, parameterized reports, sub reports and different types chart reports in Qlik View dash boards.
• Involved in Peer review activities for Code & Testing, Deployment
• Involved in Implementation

Environment: Informatica, Qlik View, Oracle, unix

Senior ETL Developer

Confidential

Responsibilities:

• Responsible for developing ETL mappings to load data using Informatica Power Center 8.1.1
• Extensively used Informatica Client Tools Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer to develop mappings.
• Used debugger to test the data flow and fix the code.
• Optimized performance by tuning the Informatica ETL code.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Perform constant file manipulation using VI Editor and UltraEdit to insure data integrity
• Prepare UNIX applications and identify UNIX issues.
• Extensive experience of Slowly Changing Dimensions
• Good knowledge in UTC, Meta Data, QA Documents.
• Writing the Unix scripting

Environment: Informatica, Oracle, UNIX, WinSCP, putty

Soft Engineer

Confidential

Responsibilities:

• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager
• Designed business rules based on client requirements and performed testing to validate successful implementation
• Supporting the on call support on Quarter end and production release management deeds
• Working on the Unix environment, debugging the issue

Environment: Informatica, Oracle, UNIX, winscp, putty