SUMMARY:

• Around 5 years of experience in IT industry with a strong background in Analyzing, Developing, Testing and Implementing of Data Warehouse applications and BI applications in various domains such as Banking, Financial and Insurance using Informatica Power Center.
• Extensive experience in Informatica Power Center 9.x with strong business understanding and knowledge of ETL from heterogeneous source systems like Flat files, Excel, XML, Oracle, Hive and Teradata to target systems like Oracle, Teradata.
• Worked on all phases of data warehouse development lifecycle, from analyzing requirements, ETL development and implementation and supported new and existing applications.
• Highly Proficient in Informatica Designer Components like Source Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Designed Reusable Transformations and Mapplets for better usability and performance.
• Expertise in Performance Tuning of sources, targets, transformations and sessions and Query Optimization.
• Experience in writing SQL Queries and creating stored procedures, PL/SQL Packages, Triggers and Functions.
• Experience in Slowly Changing Dimensions (Type 1, Type 2 and Type 3).
• Extensive experience in UNIX shell scripting and Job scheduling like Maestro and Informatica Scheduler.
• Experience in creating pre - session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs.
• Troubleshooting and problem-solving applications with Informatica Debugger and performed code migration from Dev to Test.
• Worked in Agile methodology, participated in stand-up meetings, task out user stories using Jira & implement them.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Excellent written and verbal communication skills including experience in proposal and presentation creation.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.6.1, 9.5.1 (Power Center)

Databases: Oracle 11g/10g, Teradata, DB2, Netezza

Languages: SQL, Unix

Tools: Oracle SQL Developer, Teradata SQL Assistant 13.0

Environment: MS Windows 10/8/7/XP, LINUX, UNIX

Job Scheduling: Maestro, Autosys, Informatica

PROFESSIONAL EXPERIENCE:

Confidential, Cary, NC

Informatica Developer

Responsibilities:

• Involved in gathering and analyzing the business requirements.
• Designed and developed mappings by using Lookup, Expression, Update Strategy, Sequence generator, Aggregator, Router, Joiner transformations to implement the mapping.
• Worked with Informatica PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extracted data from Hive files and transformed it in accordance with the Business logic and loaded data into Oracle tables using ETL tool.
• Involved in creating Oracle staging table structures and modifying existing tables as per the design specifications.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica PowerCenter.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Involved in debugging Informatica mappings, Performance and Unit testing of Informatica Sessions and Target Data.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Created Unix shell scripts to execute the Informatica Workflows.
• Involved in Performance Tuning of mappings in Informatica.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Participated in weekly status meetings, conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: Informatica PowerCenter 9.6.1, Oracle 11g, SQL, SQL Developer, UNIX, Maestro, Putty

Confidential, San Diego, CA

Informatica Developer

Responsibilities:

• Imported various Sources, Targets, and Transformations using Informatica Power Center Server Manager, Repository Manager and Designer.
• Created and managed the global and local repositories and permissions using Repository Manager in Oracle Database.
• Generated completion messages and status reports using Informatica Server manager.
• Tuned ETL procedures and STAR schemas to optimize load and query Performance.
• Starting Sessions and Batches and make Event based scheduling
• Managed migration in a multi-vendor supported Server and Database environments.
• Worked along with the QA Team and provided production support by monitoring the processes running daily.
• Written SQL overrides in Source Qualifier and Lookups according to business requirements.
• Responsible for Documentation of the Test cases, completed modules and the results of acceptance testing.
• Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.
• Used Debugger to validate transformations by creating break points to analyze and monitor Data flow.
• Tuned performance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.

Environment: Informatica Power Center, DB2, SQL, Windows, UNIX, SQL Server, Oracle, Flat files, SQL *Plus, Business Objects

Confidential

Informatica Developer

Responsibilities:

• Followed Agile-Scrum methodology to design, develop, test and deliver the code.
• Modify existing business logic in Informatica ETL flows.
• Design new ETL flows as per the mapping sheets.
• Involved in designing, creating equivalent Teradata data marts to load the required staging data.
• Involved in ETL developing, creating required mappings for the data flow using Informatica.
• Used transformations like Source qualifier, Filter, Aggregator, Joiner, Expression, Lookup, Router, Sorter and Union
• Starting Sessions and Batches and make Event based scheduling
• Managed migration in a multi-vendor supported Server and Database environments.
• Involved in designing the mapplet and reusable transformations according to the data flow requirements.
• Validated the output according to the specifications.
• Enhancements in existing mappings according to the business logic.
• Attended daily scrum calls to post the required status update.
• Testing activities involve Unit Test Plan Preparation, Unit Testing, Sprint Testing, UAT and performance testing.
• Gathering reporting requirements and making enhancements to any existing logic if required.

Environment: Informatica PowerCenter, Teradata SQL Assistant, SQL, JCL, Oracle, Teradata, Unix, SQL Plus, DB2.