SUMMARY:

• 8+ years of experience in data warehouse development lifecycle management projects.
• Extensive experience in data profiling, data migration from various legacy sources and relational systems to OLAP and decision support target systems.
• Experience in working with business analysts to identify, study and understand requirements and translate them into ETL design.
• Exceptional skills in the analysis, design, development, customization, implementation and testing of data warehousing applications.
• Experience in Agile, Waterfall methodology.
• Strong knowledge in Business Intelligence concepts and working knowledge of Business Objects, NET.
• Good understanding of Informatica Servers, Repository Services - Installation, configuration, maintenance & administration in Dev, Test & Prod environments.
• Used Informatica real time using Web services, Salesforce.com and Change Data Capture.
• Strong knowledge in working with Informatica Power Exchange for CDC from SQL Server databases as well as Oracle databases.
• Hands on experience in Pentaho Business Intelligence Server Studio.
• Excellent understanding of business process modeling, process improvements, and developing process flows.
• Extensively used Pentaho report designer, Pentaho kettle, Pentaho BI server, BIRT report designer.
• Worked in conversion projects from Informatica to Pentaho.
• Strong Data Modeling experience and Entity-Relationship design modeling, Dimensional/Hierarchical data modeling, Star and Snowflake schema data modeling.
• Strong skills in the evaluation and recommendation of ETL best practices to various technical groups including data modelers and developers.
• Experience in integration of various data sources including Oracle, SQL server, DB2, Sybase, and MS access and non-relational sources like flat files into staging area.
• Experience in integrating SFDC sources and targets with Enterprise data marts - Oracle, SQL Server, and Teradata.
• Good Knowlegde on Big data technologies-Hadoop.
• Experience in creating data maps using Power Exchange Navigator version 5.2.2
• Experience in configuring and customizing SFDC data stores and implementing CDC from SFDC sources using Apex triggers, classes and Power Center Web Services hub.
• In-depth knowledge in Power Center web services hub configuration and maintenance.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Proficient in the use of ORACLE (PL/SQL) SQL Loader, AB Initio ETL Design and programming, Shell Scripting, TERADATA.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various aspects of the data warehouse infrastructure including but not limited to sources, targets, mappings and sessions.
• Created Perl Scripts and called in Pre session and Post session commands.
• Excellent analytical/communication skills and good team player.
• Excellent leadership skills with experience in mentoring and managing a team of developers.

TECHNICAL SKILLS:

Data Warehousing ETL: Informatica Power Center 9.5/9.1/9.0/8.1/7. x/6.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) ETL, Repository, pentaho, Metadata, Data Mart, FACT & Dimensions tables, Physical & logical data modeling, Power Connect, Power Plug, Power Analyzer, Power Exchange.

DATA MODELING: PHYSICAL MODELING, LOGICAL MODELING, RELATIONAL MODELING, DIMENSIONAL MODELING (STAR SCHEMA, SNOW-FLAKE, FACT, DIMENSIONS), ENTITIES, ATTRIBUTES, CARDINALITY, ER DIAGRAMS, ERWIN

Databases: Oracle 11g/10g/9i MS SQL Server, Teradata

Programming: SQL, PL/SQL, SQL*Plus, SQL*Loader, Unix, Web Services, Perl Scripting

Tools: TOAD, Excel, Word

Database tools: SQL*Plus, TOAD, SQL

Environment: Windows 95/98/2000/XP, UNIX, MS DOS

Scheduling tools: Autosys, control-M

PROFESSIONAL EXPERIENCE:

Confidential, Warren, NJ

Informatica Developer

Responsibilities:-

• Designed, Developed and maintaining Socrates project end to end and got best performance award, this application has high management visibility at AHM organization.
• ETL / Data Warehouse experience, preferably with SQL Server/TSQL.
• Excellent knowledge on Informatica Power Center development.
• Created various shell scripts using UNIX.
• Worked on Kimball Methodology, Star Schemas and slowly changing dimensions.
• Excellent problem solving skills.
• Worked in a multi-tasking team environment supporting multiple in-flight development projects at the same time.
• Experience in analyzing and documenting system recommendations and changes.
• Proficient in SDLC methodologies.
• Worked on SQL Server including DDL, TSQL, Stored Procedures, etc. in large-scale relational databases.
• Excellent project management abilities, worked within a large project plan and able to manage own tasks and time.
• Worked on SQL server, Oracle, Sybase databases.
• Used UNIX scripts for scheduling and executing informatica workflows.
• Worked on scheduler tools like Autosys and Control-M.
• Responsible for solving testing issues.
• Designed Work Flows that uses multiple sessions and command line objects (which are used to run the UNIX scripts).
• Worked extensively on Unit Testing and preparing efficient unit test documentation for the developed code to make sure the test results match with the client requirement.
• Designed the ETL specification documents to gather existing workflows information from different ETL teams and shared with Integration and production maintenance team.
• Designed the ETL runs performance tracking sheet in different phases of the project and shared with Production team.
• Prepared the validation report queries, executed after every ETL runs, and shared the resultant values with Business users in different phases of the project.

Environment: - Informatica 9.6.1, SQL Server 2008, Autosys, TERADATA, Shell Scripting, PL/SQL, Oracle 10g/9i, Erwin, Control-M, SQL Server 2008, DB2, UNIX

Informatica Consultant

Responsibilities:-

• Designed the target Data Warehouse using Star Schema, Involved in Extraction, Transformation and Loading (ETL) Process
• Extract data from different Data marts for creating strategic Reports
• Designed and developed mappings using Source Qualifier, Aggregator, Joiner, Lookup, Sequence Generator, Stored Procedure, Expression, Filter and Rank transformations
• Used Unix Shell script for Oracle to automate the server start and shutdown process
• Involved in creating various metadata types, including legacy source and data warehouse target data definitions and ETL jobs
• Implemented mapping for slowly changing dimensions (SCD) to maintain current data as well as historical data
• Created reusable Transformations and Mapplets and used them in mappings in case of reuse of the transformations in different mappings
• Extensively used SQL overrides at Source Qualifier and Lookup Transformations while extracting data from multiple tables
• Created parameter files with workflows and sessions
• Tuned mappings to perform better using different logics to provide maximum efficiency and performance
• Identified Bottlenecks and executed Performance tuning
• Tested the target data against source system tables by using test load

Environment: - Informatica Power Center 8.6, TOAD, Erwin 4.1, Terdata, Oracle 10g, Windows 2000, Unix,

ETL Informatica developer

Responsibilities:

• Analyzed specifications and identified source data needed to be moved to Data Mart, Participated in the Design Team and user requirement gathering meetings and Created Data Maps / Extraction groups for legacy Parent sources.
• Estimates and planning of development work using Agile-TDD Software Development.
• Designed Sources to Targets mapping from primarily Flat files to Database using Informatica Power Center.
• Developed UNIX Shell Scripts and SQLs to get data from Oracle tables before executing Informatica workflows.
• Staged Data from legacy Proclaim IMS system into Oracle 11g Master Tables.
• Performed CDC capture registrations.
• Involved in analyzing the ICD 9 and ICD 10 for the data mapping from ICD 9 - ICD 10 and ICD 10 - ICD 9 in source and target level.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Assisted in building the ETL source to Target specification documents by understanding the business requirements.
• Used SOAP UI, WebLogic ANT task to test Web Services running on WebLogic Server.
• Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various Informatica power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Extensively used Joins, Triggers, Stored Procedures and Functions in Interaction with backend database using PL/SQL.
• Used Teradata utilities like fast load, multiload, fast export, BTEQ.
• Extracted data from Teradata source systems to a flat file.
• Reusable transformations and Mapplets are built wherever redundancy is needed.
• Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput.
• Creating Jobs and Job streams in Control-M scheduling tool to schedule Informatica, SQL script and shell script jobs.
• Coordinated with developers for prioritizing and translating requirements, defects and enhancements into product feature.
• Created Post UNIX scripts to perform operations like gunzip, remove and touch files

Environment: Informatica Power Center8.6.1/9.1, Oracle 11g, SOAP UI, Agile, CDC, Teradata, Toad 10g, XML, Control-M, Mainframe (IMS), SQL, PL/SQL, Unix, Windows XP, DB2

Sr. ETL Informatica Developer

Responsibilities:

• Created Technical Design Specifications, Unit test document based on functional design specifications provided by Business Analyst
• Designed and developed ETL Processes based on business rules, job control mechanism using InformaticaPower Center.
• Handled huge volumes of data at Enterprise Data Warehouse about 25 Tera Bytes.
• Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregators, filters, Lookup, update strategy, stored procedure transformations, etc.
• Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
• Design and development of multi-layer Web Based information systems using Web Services including Java and JSP.
• Created mainframe data maps using Power Exchange Navigator for the sources and targets.
• Created and modified COBOL copybook to connect source data using Power Exchange Navigator
• Re-engineered lots of existing mappings to support new/changing business requirements.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Used Power Exchange Data Change option (CDC) to capture modified records.
• Monitored production jobs on a daily basis and worked on issues relating to the job failure and restarted failed jobs after correcting the errors.
• Developed reusable transformations, mapplets, sessions, worklets to make code very modular and reuse as required
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager. Informatica Web-services and web-portal applications.
• Used mapping variables, parameters, workflow variables & parameter files to support change data capture and automate workflow execution process to provide 24x7 available data processing unit via Informatica PC tool.
• Involved in writing UNIX shell scripts (Pre/Post Session commands) for the Sessions & wrote shell scripts to kickoff workflows, unschedule workflows, get status of workflows.
• Performed Informatica administration like user, privilesges, migrations, starting, stopping pmrep/pmserver. Backup and restore repository service.
• Supported Informatica upgrade process from 6.2.2 to 8.1.1 by validating regression testing results and providing all application details for upgrade consultant to perform application upgrade in Informatica.
• Written Teradata SQL queries to join or any modifications in the table.
• Written scripts to extract the data from Oracle and load into Teradata.
• Written Teradata BTEQ scripts to implement the business logic.
• Transfer of large volumes of data using Teradata FastLoad, MultiLoad and T-Pump.
• Performed unit testing, system integration testing, and supported user acceptance testing.
• Tuned SQL statements, Informatica mappings, used Informatica parallelism options to speed up data loading to meet defined SLA
• Compared actual results to expected results and suggested changes to mappings owned by others.
• Supported Informatica, non-informatica code migration between environments (DEV/QA/PRD)
• Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.
• Created list reports, Crosstab reports, charts reports in Business Objects. Used @Where clause, @Prompt and @Variable at Universe level.
• Used Prompts, variables at report level. Generated reports using Web Intelligence through Info view.

Environment: - Informatica PowerCenter 9.5 /9.1/9.0./8.6, Teradata, Repository Manager, Designer, Work Flow Manager, Oracle 11g/10g, SQL Server 2008/2005, DB2, Flat Files, CSV files, PL/SQL(Stored Procedure, Trigger, Packages), UNIX, Toad