SUMMARY:

• Around 9 Years of IT experience in Data Analysis, ETL Design, Development, Programming, Testing, Performance tuning, Implementation and Troubleshooting & error handling in the field of Data warehousing and gathering Business User Requirements.
• Hands on Experience identifying and resolving performance bottlenecks in various levels like sources, using Extract Transform and Load (ETL) and strong understanding of OLAP,OLTP concepts.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using Informatica Power Center.
• Solid experience in writing SQL queries, Stored Procedures, Cursors, Indexes, Views, Sequences and Triggers. Hands on experience in resolving the production issues in 24/7 environment.
• Experience on post - session and pre-session shell scripts for tasks like merging flat files after creating, deleting temporary files, changing the file name to reflect the file generated date etc
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Data warehousing experience specializing in RDBMS, ETL Concepts. Also performed ETL procedure to load data from different sources into data warehouse using Informatica Power center 10.2, 9.6 (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Good knowledge on ETL Tool, Informatica power center. Have good experience in working with various Power Center Transformations using Designer Tool.
• Efficient in in corporation of various data sources such as ORACLE 11g/10g, MS SQL Server, and DB2, XML and Flat files into the staging area.
• Strong Data analysis to ensure accuracy and integrity of data in the context of Business functionality.
• Understanding of Ralph Kimball Data Warehouse methodologies and knowledge on the various data design models like Star Schema and Snowflake models
• Good knowledge and experience in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files.
• Experience in designing and developing complex mappings from varied transformations logic like Unconnected and Connected lookups, Normalizer, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Implemented data warehousing methodologies for Extraction, Transformation and Loading using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console.

TECHNICAL SKILLS:

ETL Technologies: Informatica Power Center 10.2/9.6/9.5 , IDQ/IDE 9.x, SSIS

Databases: Oracle 12C/ 11g/10g, SQL Server 2008/2012/2014 , DB2.

Operating Systems: Windows 10/8/7XP, UNIX, Linux.

Languages: SQL, PL/SQL, C, C++.

DB Tools: SQL Developer, SQL plus, MY SQL, PL/ SQL, DB2

Data Modeling: Data Modeling, Dimensional Data Modeling (Star, Snowflakes Schema Modeling), Physical and Logical Data Modeling

Reporting Tools: Business Objects XIR2/6.1, Oracle Analytics.

PROFESSIONAL EXPERIENCE:

Confidential, Durham, NC

Lead Informatica Developer

Responsibilities:

• Reviewed Functional Requirement Documents (FRD) and Technical Specifications Documents (TSD) and communicated with the concerned users. Conducted Impact and feasibility analysis.
• Worked on Subject Areas like MEMBERSHIP, CLAIMS and PURCHASES.
• Created mappings using the Transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Created Mapplets, reusable transformations and used them in different mappings.
• Involved in designing mappings using Mapping Parameters and Mapping Variables.
• Used Informatica Debugger for debugging mappings.
• Implemented Slowly Changing Dimensions - Type II mappings as per the requirements.
• Successfully Loaded Data into different targets from various source systems like Flat files, SQL Server into the target database Oracle and Flat files.
• Created views, functions and stored procedures as per the requirements and debugged them.
• Involved in Unit testing of database objects such as views and stored procedures.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Used Informatica Workflow Manager to create workflows.
• Worked with Pre-Session and Post-Session SQL scripts.
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean-up and update purposes.
• Workflow Monitor was used to monitor and run workflows.
• Involved in production support which also includes trouble shooting issues.
• Worked closely with testing team and assisted them in creating test cases.
• Involved in designing mappings with Mapping Parameters and Mapping Variables.
• Worked with DBA to fine tune SQL queries for better performance.
• Created deployment groups for deploying the mapping from one environment to another.

Environment: Informatica-Power Center 9.0.1, 8.6.1, Intormatica Data Explorer, Power Exchange, Metadata Manager, Web Services, Oracle 11g, Teradata 14.0, WLM Scheduler

Confidential, PA

Sr. Informatica Developer

Responsibilities:

• Created Dimension Tables and Fact Tables based on the warehouse design .
• Involved in creating Logical and Physical design of databases using Erwin.
• Participated in build of the Data Warehouse, which includes the Design of Data mart using Star Schema. Created Repository using Informatica Power Center - Repository Manager.
• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Developed and supported the extraction, transformation and load process (ETL) for a Data.
• Used Teradata utilities like Multiload, and Fast Load to load data into Teradata data warehouse from Oracle and DB2 databases .
• Lead a team of Developers to Develop, Unit Test, Test cases and Result Preparation Related with Loading Scripts and other deliveries related with Teradata scripts.
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse.
• Created reusable transformations and Mapplets and used them in mappings. Extensively used Shell scripts to automate the Pre-Session and Post-Sessions processes.
• Performed data manipulation using basic functions and Informatica Transformations .

Environment: Informatica 9.1 , Oracle 9i, SQL Server, Erwin 3.5, Business Objects, UNIX (AIX), Windows, Teradata V2R6, Teradata SQL Assistant, BTEQ, FLOAD, MLOAD.

Confidential, CA

Informatica IDQ/ETL Developer

Responsibilities:

• Worked on CRDW (Credit Risk Data Warehouse), AQR (Asset Quality Review), Tagetik Decoupling projects
• Analyze, design, develop and test business software based on the needs of business users.
• Design application and plan how different applications work together
• Create a variety of models and flowcharts needed for an application development
• Document every aspect of the application as a reference for future maintenance and upgrades.
• Ensure that the application continues to function normal during software maintenance and Testing
• Worked on building the ETL architecture and source to target mapping to load data into data warehouse.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, and Sequence Generator transformations. Developed Rules using IDQ thin and thick clients.
• Supporting production and involved in performance tuning
• Responsible to create Profiles and run profile applying rules and filter conditions.
• Responsible to create Scorecards, generate and to report to the business.
• Responsible to interact with the business and to gather business requirements.
• Worked on Informatica Power Center tools- Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor
• Worked on Informatica Developer tools - Informatica Data Analyst, Informatica Developer tool
• Developed ETL mappings, mapplets sessions, workflows, developed rules, LDO's, PDO's, profiles, Scorecards in IDQ and automated the process to generate reports
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• The finance team at bank has the system implemented for GL and regulatory data processing and reporting. Because of the system limitations it requires lot of manually compiled sources, edits and adjustments to the data.
• The main objective of the project was to build the ETL process to extract the data from the ultimate source systems and load into Data warehouse and provide the finished data sets to load it into finance systems. Part of the project the finance models were built in the data warehouse. The ETL processes were built to load the data from multiple source databases and business files in to data warehouse before the data delivered to load into finance system. The ETL and data models were built for the following subject areas.

Environment: Informatica PowerCenter 10.2, Oracle12C, Informatica Data Quality 9.6.1, UNIX, Windows 7, Windows 10, Power BI, SQL Server.

Confidential, WI

ETL/Informatica Developer

Responsibilities:

• Analyzed the specifications and identified the source data that needs to be moved to data warehouse.
• Gathering requirements, conducting a design overview, detailing ETL specifications, data analysis/troubleshooting, implementation tasks, and general mentoring.
• Actively involved in meetings with the SME’s for business requirements gathering and analysis of source systems data to comprehend their processing patterns.
• Developed the ETL logic to load data from various heterogeneous systems such as DB2, Flat files, Oracle 11g/12c.
• Created complex and robust mappings, workflows using workflow manager. Monitored tasks using workflow monitor.
• Used various transformations like Source Qualifier, Unconnected lookup, connected lookup, Expression, Joiner, Filter, Router, Update Strategy etc.
• Enhanced session and workflows performance by applying performance tuning on targets, sources, mappings and sessions.
• Worked on Informatica Power Center tool -Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets , Transformations, Work Flow Manager and Work Flow Monitor . Developed Workflows containing different Tasks like Sessions and command tasks.
• Coordinated with the operations team for scheduling the Work Flows.
• Worked extensively with designer tool to develop Mappings, Mapplets , and Reusable transformations to extract, transform and load the data.
• Created and used parameter files to provide values to the variables used across sessions and workflows of Informatica.
• Involved in process of enhancing the existing Informatica and PL/SQL code and bug fixing .
• Created and executed Unit Test Plans for the various Mappings.
• Created new Unix Scripts and modified the existing scripts for enhancing the performance (optimizing)of the ETL jobs, Database updates, Automate the process, File handling .
• Coordinated with the QA team and production team during migration phase.
• Designed the framework Model, Report Structure for various subject areas based on their process and data analysis.

Environment : Informatica Power Center 9.6, Oracle 11g/10G, PL/SQL, SQL Server 2014, Shell scripting, MS Office tools.

Confidential, Deerfield, IL

Informatica Developer

Responsibilities:

• Identified business rules for data migration and analysed the business requirements.
• Worked with pre-and post-sessions, and extracted data from Transaction system into Staging area.
• Extensively worked with Informatica Tools - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Informatica Server.
• Created workflows with the event wait task to specify when the workflow should load the tables.
• Used PL/SQL to write store procedures to increase performance.
• Extensively used Debugger Process to test Data and applied Breakpoints.
• Loaded data from various sources using different transformations like Source Qualifier, Joiner, Sorter, Aggregator, Union, and Update Strategy to load data into the target.
• Worked on Data Cleansing, Data Conversion Process implementation.
• Perl Scripting for backup and monitoring of databases.
• Provided daily support to clients including data research and test environment data refreshes.
• Monitored the processes to identify potential issues and apply preventative and correction actions. Designed the slowly changing dimension strategy for warehouse.
• Responsible for dealing with the problems, bug fixing and trouble shooting.
• Provided production support.
• Coordinated between Development, QA and Production migration teams.

Environment: Informatica Power Center 9.1, Oracle 11g/10g, MS Access, PL/SQL, Toad 9.6.1.1.

Confidential

ETL Developer

Responsibilities:

• Involved in different phases of SDLC from requirements, design, development, testing, training and rollout to the field user and support for production environment.
• Worked with Informatica Power Center client tools and SAP Business Objects Data Services / BODS.
• Created source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Developed source to target mappings and scheduling Informatica Sessions.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Worked on Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, created database objects like Tables, Indexes, Synonyms, and Sequences etc., closely worked with DBAs to create Physical Databases.
• Involved in designing the Data Mart and entire data warehousing life cycle.
• Involved and worked with DBA to build Dimension Tables and Fact Tables.
• Interacted extensively with user and Involved in gathering requirements, prototyping and prepared various documents like Interface Requirement Document, Customer Requirement document, Integration test plan, Unit test plan Release notes etc.

Environment: Informatica Power Center 8.1, UNIX, PL/SQL, Oracle 9i/10g, Linux and OS.