SUMMARY

• Over 9 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 (Designer, Workflow Manager, Repository Manager, Data Quality (IDQ) and ETL concepts.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ).
• Experienced in Teradata SQL Programming.
• Worked with Teradata utilities like BTEQ, FastLoad and MultiLoad and Tpump and Teradata Parallel transporter.
• Loaded the data into the Teradata database using Load utilities like (Fast Export, Fast Load, MultiLoad, and Tpump)
• 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.
• 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.
• 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.
• 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.1/8.6/7.1(PC and IDQ), DataStage 8.7

Languages: SQL, PLSQL,UNIX

Methodology: Agile RUP, SCRUM, Waterfall

Databases: TeraData, Oracle, DB2, SQL SERVER

Operating Systems: Windows, UNIX, Linux and Solaris

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

Reporting Tools: Tableau

Scheduling Tools: Control-m, Autosys

Big Data Technologies: Hadoop, HDFS, Map Reduce, Hive, Pig, HBase, Sqoop

PROFESSIONAL EXPERIENCE

Confidential, West Bend, WI

Sr Informatica Developer/Lead

Responsibilities:

• Design & Development of ETL mappings using Informatica 9.1
• Provide technical support to ETL applications on Informatica 9.1, 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.
• 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 Liberty Mutual BI standards.
• Attend Technical meetings & discussions.
• Prepare High Level and Low Level Design Documents
• Worked with Teradata sources/targets.
• Used Sqoop to export data from HDFS to Teradata database.
• Created Hive managed and external tables.
• Used HDFS system to copying files from local to hdfs file system
• Attending onsite/offshore team meetings.

Environment: Informatica 9.1, Teradata SQL Assistant, Oracle, Unix, Hadoop 1.1.0 and hdfs, Sqoop, hive, pig.

Confidential, Bloomington, IL

Sr Informatica Developer

Responsibilities:

• Coordinating with Onsite Team and client for Requirements gathering and analysis.
• Understanding and developing the JPMC ETL framework for informatica objects as per coding standards.
• Performed the data profiling and analysis making use of Informatica Data Quality (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 JPMC's 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

Confidential, Virginia Beach, VA

Informatica Developer

Responsibilities:

• 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 Frost 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 8.6.1, TearaData, Unix, Oracle 9i, SQL Developer, Teradata SQL Assistant

Informatica Developer

Responsibilities:

• 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 XL 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, Jersey city, NJ

Informatica Developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• Implemented various Performance Tuning techniques.

Environment: Informatica PowerCenter 8.6.1, Teradata, SQL Server, oracle, PL/SQL, SQL Developer, Toad, Unix.

Confidential

Informatica Developer

Responsibilities:

• Interacted with business analysts and translate business requirements into technical specifications.
• Using Informatica Designer, developed mappings, which populated the data into the target.
• Responsibilities included designing and developing complex informatica mappings including Type-II slowly changing dimensions.
• Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows, tasks, shell scripts.
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Developed complex mappings/sessions using Informatica Power Center for data loading.
• Extensively used aggregators, lookup, update strategy, router and joiner transformations.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.

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

Confidential

Informatica Developer

Responsibilities:

• 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