PROFESSIONAL SUMMARY:

• 8 years of strong experience as an ETL Informatica Developer in System Analysis, Design, Development and Testing fields of Data Warehousing, Client server technologies.
• Strong experience in integration of various data sources like Oracle, Teradata, MS SQL Server, DB2, Mainframe, SAP, Salesforce, Web Services and Flat Files.
• Proficient in warehouse designs based on Ralph Kimball and Bill Inman methodologies.
• Extensive noledge in architecture design of Extract, Transform, Load environment using Informatica Power Center.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and Union Transformation
• Highly experienced in developing mappings using Parameters and Variables. Extensively used parameter file to pass mapping and session variables.
• Proficient in developing Slowly Changing Dimension Mappings of type I, II and type III.
• Expert in loading data in to Teradata using FASTLOAD, MLOAD, TPUMP, BTEQ and Teradata Parallel Transporter (TPT) tools.
• Extensively played with Performance Tuning at Informatica and Database (Oracle) Level.
• Excellent hands on experience in writing, testing and implementation of teh PL/SQL programs, Stored procedures, Functions, Triggers, Views, Materialized Views, Packages, DTS and performance tuning of SQL queries.
• Strong experiences in UNIX shell scripting. Created scripts for calling pmcmd command, file watcher, FTP and file archiving scripts.
• Strong practical understanding of Star Schema and Snowflake Schema Methodology, using Data Modeling tool Erwin.
• Extensive experience in Unit testing, System testing and User Acceptance Testing.
• Highly adaptive to a team environment and proven ability to work in a fast paced teaming environment with excellent communication skills.

TECHNICAL SKILLS

• Informatica Power Center 9.6.1/9.1/8.x/7.1/6.x
• Power Exchange 8.x
• Informatica Data Quality
• Jasper PRO 4.2
• SAPSalesforce
• Data Modeling Tools Erwin 7.0/4.1/5.1
• SSIS/DTS
• Business Objects XI
• OBIEE 10g
• Composite 6/5
• Oracle PL/SQL
• T - SQL
• DB2Shell Scripts
• Oracle 11g/10g/9i/8i
• MS SQL Server 2012/08/05/00
• Teradata 13/V2R6/5
• DB2 8.1
• MYSQL
• CJAVA
• XML
• QC 10
• JIRA
• OS Sun Solaris 8/9/10
• Linux
• IBM AIX 4.3/5.2
• Autosys R11
• Cybermation Espresso
• Toad.

PROFESSIONAL EXPERIENCE

Confidential, New York

Sr. ETL DEVELOPER

Responsibilities:

• Analyze business requirements and document functional requirements.
• Worked on technical specifications, design and development ofinformaticamappings and workflows for data centric applications.
• Managed Functional modules independently and merge work as required per release schedule.
• Managed and coordinate work items and deliverables across team’s located onsite or offshore.
• Used Mapplets and Reusable Transformations prevent redundancy of transformation usage and maintainability.
• Used UNIX scripts to perform sanity checks like data files availability, check header/trailer records, row counts, logging in processing status to status tables.
• Developed UNIX Scripts performing keyless SFTP.
• Worked/created AUTOSYS jobs for scheduling and automating teh process.
• Providing L3 support for Cost Basis, Business Control, Broker Audit and regulatory Reporting.
• Created dynamic stored procedures to work across Dev/Uat/Prod environments to generate XML feed via SSMS.
• Teh XML feeds are transmitted from Stifel server to SS&C via sftp.
• Written and tested teh test scenarios for various IR’s, CSA’s, Branch Managers and Fund Administrators.

Hardware/Software: Informatica 9.6/9.1, MS SQL Server 2012/2008 R2, Oracle 11g, SSIS, DB2 v8.2, Composite 6, Rapid SQL, Windows Server 2008, UNIX/LINUX, Shell Scripting, OBIEE 11g, Autosys R11.

Confidential, Rockaway, NJ

ETL Developer

Hardware/Software: Informatica 9.1, Teradata 13, Oracle 11g/10g, Siebel, Oracle DAC, OBIEE 10g, Windows Server 2008.

Responsibilities:

• Involved in extracting teh data from teh Flat Files and Siebel data into staging area.
• Implementing Slowly Changing Dimension (SCD type I,II) design for teh Data Warehouse
• Developed several Complex Informatica Mappings, Mapplets and Reusable Transformations for other mappings.
• Developed PL/SQL procedures for processing business logic in teh database and use them as a Stored Procedure Transformation
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching teh business requirements in Teradata RDBM.
• Extracted data from source systems to a staging database running on Teradata using utilities like MultiLoad and FastLoad.
• Extensively worked in teh performance tuning of programs, ETL procedures and processes. Error checking and testing of teh ETL procedures and programs using Informatica session log
• Involved in fixing invalid Mappings, Unit and Integration Testing of Informatica Tasks, Workflows and teh Target Data.
• Created and scheduled Sessions, Jobs were scheduled in DAC based on demand, run on time and run only once.

Confidential, Jersey City, NJ

ETL DEVELOPER

Responsibilities:

• Involved in meeting with business to gather requirements.
• Reviewing data models and doing code reviews.
• Creates and maintains teh overall and detailed project plan(s) and supervise teh D/W ETL processes.
• Using teh Informatica Designer to develop mappings and workflows for extracting, transforming, integrating, and loading data to data warehouse.
• Worked on IDQ to complete initial data profiling and removing duplicate data.
• Created Informatica mappings using various transformations like Web Services consumer, XML, HTTP transformation.
• Design, configuration of Informatica web services to automate teh IR requests using web services consumer transformation.
• Using Key Management functions Surrogate Keys were generated for composite attributes while loading teh data into Data Warehouse.
• UNIX Shell Scripts for automating Extraction, Transformation and Loading process for various feeds and enabling teh execution of jobs in Production environment using Autosys.
• Designed and developed monthly reports using Oracle Reports for teh analysis of teh data

Confidential, Redmond, WA

ETL Developer/Data analyst

Hardware/Software: Informatica 9.0.1, MS SQL Server 2008 R2, Workflows, XML, Windows Server 2008.

Responsibilities:

• Business process analysis and description
• BRS preparation
• Contact with developer
• Monitor and control of system development
• Test campaign preparation and execution
• New functionality roll-out

Confidential, Minnetonka, MN

ETL Developer

Hardware/Software: Jasper ETL Pro 4.2, MSSQL Server 2008, SSIS (SQL Server Integrations Services), Informatica PowerCenter 8.6.1, Oracle 9i, SQL, PL/SQL, Windows, Toad 8.6

Responsibilities:

• Designed and developed ETL Processes based on business rules using Jasper ETL.
• Created teh SQL Server Bootstrap Scripts for Loading teh data from migrate databases to data warehouse for Jaspersoft Report generation
• Extensively worked on creating Jasper ETL mappings to load teh data from load environment to migrate (staging) and tan to data warehouse.
• Created batch scripts and used to call them from command prompt to load teh data warehouse Facts.
• Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregators, filters, lookup and update strategy transformations
• Compared actual results to expected results and suggested changes to mappings owned by others
• Worked on Jasper ETL Performance tuning by identifying teh bottlenecks in sources, targets, mappings and transformations
• Enhanced performance for Informatica session using large data files by using partitions, Increasing block size, data cache size, sequence buffer length and target based commit interval
• Developed a number of Complex Informatica Mappings, Mapplets and Reusable Transformations for other mappings by comparing teh Jasper ETL mappings.
• Informatica workflow manager was used to do teh loading of teh transformed data on to teh multi-dimensional schema.

Confidential, Minneapolis, MN

Informatica Developer

Hardware/Software: Informatica PowerCenter 8.6.1, IDQ, Oracle 10g/11g, PL/SQL, Confidential SQL Server 2008, Teradata, SAP, MS Visio, Crystal Reports 9.0, Cybermation Espresso, Windows NT.

Responsibilities:

• Involved in every step of teh SDLC. Involved in customer requirements, Data analysis, process flow design, data modeling for atomic and Datamart.
• Helped Architect in design and development of Conceptual, Logical, and Dimensional Data Models for teh Data Warehouse.
• Analyzed source data and formulated teh transformations to achieve teh customer requested reports.
• Created Informatica mappings to load data into Salesforce objects.
• Developing code using Teradata BTEQ Scripts, Informatica mappings, workflows and sessions as per ETL specifications and implemented CDC (Change Data Capture) scripts wherever required.
• Performed teh data profiling and analysis making use of Informatica Data Quality
• As teh requirement is to maintain teh history of every change for all columns, I have implemented teh slowly changing dimension type 2 with TEMPeffective start and end date of teh record.
• Extracted data from SAP R3 using SAP BCI extractors.
• Designed and coded teh Espresso job flow, which is for job scheduling.
• Involved in project planning and coordinating business, source and development teams to meet teh project deadlines.
• Data analysis is done to see teh impacts of change in source system to teh existing Informatica maps, Oracle PL/SQL packages to feed data into existing Datamart.
• Formulated teh business rules for changes identified in teh analysis and modified Informatica maps, PL/SQL packages and Espresso flow to handle teh load time of each regular cycle run.
• Key person in working for system performance improvement for teh datamart loading and reporting.

Confidential, Dublin, CA

ETL Developer

Hardware/Software: Informatica PowerCenter 8.1/7.1.4/6.x, DataStage, Oracle 10g/9i, Autosys Scheduler, UNIX, Cognos 7.0

Responsibilities:

• Worked extensively on Normalizer, Source Analyzer, Mapping Designer, and Warehouse Designer.
• Developed several Maps and Mapplets using corresponding Source, Targets and Reusable Transformations.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Responsible for performance tuning at various levels like mapping level, session level, and database level.
• Set up Batches and Sessions to schedule teh loads at teh required frequency using Server Manager
• Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs.
• Developed Re usable Transformations, and Re-Usable Mapplets
• Transferred data using Teradata utilities like Teradata Parallel Transporter (TPT), BTEQ, Fast Export and Fast Load
• Worked with Shortcuts across Shared and Non Shared Folders
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Involved in Performance Tuning of Complex Maps having multiple Lookups and Target Tables.
• Used teh command line program Pmcmd to communicate with teh Informatica Server.
• Uploading teh Data files into teh tables of teh Oracle database in teh server running on UNIX with teh halp of a scheduled Cron job.
• Performed activities including design of exception handling strategy and performance tuning of custom stored procedures in PL/SQL.