SUMMARY:

• Over 10 years of IT experience in all phases of Software Development Life Cycle (SDLC) which includes User Interaction, Business Analysis/Modeling, Design, Development, Integration, Planning and testing and documentation in data warehouse applications, ETL processing’s & distributed applications
• Strong expertise in using ETL Tool Informatica Power Center 8.6 /9.1/9.5 (Designer, Workflow Manager, Repository Manager, Data Quality (IDQ) and ETL concepts.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ).
• Worked with Informatica Data Quality (IDQ) Developer/Analyst Tools to remove the noises of data using different transformations like Standardization, Merge and Match, Case Conversion, Consolidation, Parser, Labeler, Address Validation, Key Generator, Lookup, Decision etc.
• Experienced in Teradata SQL Programming.
• Extensive experience with analysis, design, development, customizations and implementation of Data Warehousing applications.
• Worked in execution of all phases of BI/DW project development Life Cycle such as Requirement Analysis, Developing the High Level Designs, participating in designing the data model, Low Level Design Documents, Coding & Unit testing, ST (System Test), SIT (System Integration Test), UAT (User Acceptance test), Bug fixing, Performance Tuning, Deployment and Production.
• Data Modeling: Data modeling knowledge in Dimensional Data modeling, Star Schema, Snow - Flake Schema, FACT and Dimensions tables.
• Involved in the development of Informatica mappings and also tuned for better Performance.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate data sources like Multiple Relational Databases, VSAM, XML and Flat Files
• Coordinating with Business Users, functional Design team and testing team during the different phases of project development and resolving the issues.
• Applied various techniques at both database level and application level to find the bottle necks and to improve performance.
• Good skills in defining standards, methodologies and performing technical design reviews.
• Involved in conducting trainings to Graduate hires and experienced professionals on Data warehousing concepts and the ETL tool Informatica.
• Experience in working with big data hadoop stack tools like HDFS, hive, pig, sqoop.
• Expert in importing and exporting data into HDFS and Hive using Sqoop.
• Good hands on experience in writing UNIX shell scripts to process Data Warehouse jobs.
• Proficient in analyzing and translating business requirements to technical requirements.
• Extensive experience in Extraction, Transformation and Loading of data directly from heterogeneous source systems like flat files, TeraData, Oracle.
• Executed software projects for Insurance and Banking services.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5/9.1/8.6(PC and IDQ)

Languages: SQL, PLSQL,UNIX

Methodology: Agile RUP, SCRUM, Waterfall

Databases: Oracle, DB2, SQL SERVER

Operating Systems: Windows, UNIX, Linux and Solaris

IDEs: Eclipse, PL/SQL Developer, TOAD, Teradata SQL Assistant

Reporting Tools: Tableau, SSRS Report Builder, Risk Assessment Toolbox(Program Risk Review Tool, Risk Ranking Tool and Risk Ranking Tool Webinar)

Scheduling Tools: Control-m, Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Monterey Park, CA

Sr Informatica Developer/Lead

• Design & Development of ETL mappings using Informatica 9.5
• Provide technical support to ETL applications on Informatica 9.5, unix and Oracle
• Preparation and Review of Project Macro & Micro design based on the LM solution outline document.
• Involved in designing the Mapplet and reusable transformation according to the business needs.
• Effectively used various tasks (Reusable & Non Reusable), Command, Assignment, Decision, Event Raise, Event wait, Email…..etc.
• Used different IDQ transformations in the Developer and created mapping to meet business rules.
• Involved in Data analysis, data cleansing, data matching, exception handling, reporting with capabilities of IDQ.
• Implement Data Quality Rules using IDQ to check correctness of the source files and perform the data cleansing/enrichment
• Migrated IDQ Mapplet to Informatica power center Repository for rest of the Dev team
• Identified of performance bottlenecks, tuning queries, suggesting and implementing alternative approaches like range partitioning of tables.
• Coding & testing the Informatica Objects & Reusable Objects as per Confidential BI standards.
• Attend Technical meetings & discussions.
• Prepare High Level and Low Level Design Documents
• Attending onsite/offshore team meetings.

Environment: Informatica 9.5, Oracle 11g, Toad 12.7, Autosys, Unix, wherescape RED 6, Greenplum DB

Confidential

Sr Informatica Developer/Lead

• Coordinating with Onsite Team and client for Requirements gathering and analysis.
• Understanding and developing the State Farm ETL framework for informatica objects as per coding standards.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ)
• Involved in Data analysis, data cleansing, data matching, exception handling, reporting with capabilities of IDQ.
• Implement Data Quality Rules using IDQ to check correctness of the source files and perform the data cleansing/enrichment
• Coding & testing the Informatica Objects & Reusable Objects as per Confidential BI standards.
• Participating in peer review of informatica objects.
• Estimating volume of work & Deriving delivery plans to fit into overall planning
• Prepared ETL Build Peer Review Checklist’s and Unit Test Case Templates for different work packages.
• Involved in Unit Testing, Integration Testing and System Testing.

Environment: Informatica 9.1(PC & IDQ), TeraData, Oracle 10g, Unix, Citrix, Teradata SQL Assistant, SQL Developer and Risk Assessment Toolbox.

Confidential

Sr Informatica Developer

• Co-coordinating the onsite and off-shore teams on a daily basis
• Developing maps and workflows in Informatica to load data into TeraData.
• Unit Testing the maps & workflows.
• Coding & testing the Informatica Objects & Reusable Objects as per City Bank BI standards.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Attend Technical meetings & discussions.
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Maintaining documentation.

Environment: Informatica 9.1, TearaData, Unix, Oracle 9i, SQL Developer, Teradata SQL Assistant.

Confidential

Informatica Developer

• Co-coordinating the onsite and off-shore teams on a daily basis.
• Profiled the data using Informatica Data Quality (IDQ) and performed Proof of Concept
• Developing maps and workflows in Informatica to load data into final target tables.
• Unit Testing the maps & workflows.
• Coding & testing the Informatica Objects & Reusable Objects as per Merck BI standards.
• Developed complex mappings/sessions using Informatica Power Center for data loading.
• Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows, tasks.
• Attend Technical meetings & discussions.
• Maintaining documentation.

Environment: Informatica 9.1(PC & IDQ), Oracle, Unix, Citrix, TOAD, SQL Developer

Confidential

Informatica Developer

• Co-coordinating the onsite and off-shore teams on a daily basis.
• Profiled the data using Informatica Data Quality (IDQ) and performed Proof of Concept
• Developing maps and workflows in Informatica to load data into final target tables.
• Unit Testing the maps & workflows.
• Coding & testing the Informatica Objects & Reusable Objects as per Pfizer BI standards.
• Developed complex mappings/sessions using Informatica Power Center for data loading.
• Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows, tasks, shell scripts.
• Attend Technical meetings & discussions.
• Maintaining documentation.

Environment: Informatica 9.1(PC & IDQ), Oracle, Unix, Citrix, TOAD, SQL Developer

Confidential

Informatica Developer

• Involved in creating Detail design documentation to describe program development, logic, coding, testing, changes and corrections.
• Extensively involved in writing ETL Specifications for Development and conversion projects.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.
• Involved in requirement definition and analysis in support of Data Warehouse.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc.
• Defined and worked with mapping parameters and variables.
• Performed the performance evaluation of the ETL for full load cycle.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Created test cases for unit testing and functional testing.
• Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.

Environment: Informatica Powercenter7.1, Teradata, Oracle, UNIX, Citrix, TOAD, SQL Developer