We provide IT Staff Augmentation Services!

Sr. Etl Lead/ Developer Resume

Peapack, NJ

SUMMARY

  • Over 10 years of IT experience as an ETL Developer/Program analyst, which includes Data Warehouse/Database Developer experience using Informatica Power Center 10.x/9.x/8.x/7.x.
  • 2+ years of experience in Informatica Power Exchange CDC.
  • Hands on experience in teh Application Design, Business Requirements Analysis, Data Modeling, Development, Implementations and Testing of Database Business Systems and Data Warehousing using Dimensional modeling of STAR, SNOWFLAKE schema, OLAP, Fact and Dimension tables.
  • Good understanding of all phases of Software Development Life Cycle (SDLC) including Business Requirement Analysis, Application designing, Development, Implementations and Testing of Data warehousing and Database business systems.
  • Proven experience in writing and modifying ETL design documentation, technical requirements analysis, test results documentation and standard operating procedures (SOP) documentation.
  • Expertise in ETL designs, including process flow, data flow, source - to-target mappings, physical database designs and data models.
  • Worked on Teradata loading utilities like Multi Load, Fast Load, TPump and BTEQ.
  • Experience in developing Shell scripts on UNIX and experience with UNIX command line.
  • Knowledge of Software Testing and Quality Assurance.
  • Excellent communication and writing skills and capable of working successfully both in teams and independently.
  • Ability to self-manage time and task priorities to meet project timelines, and identify potential project risks.
  • Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work TEMPeffectively as a team member as well as independently.
  • Developed TEMPeffective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions and TEMPeffectively manage client expectations.

TECHNICAL SKILLS:

ETL: InformaticaPowerCenter 9.6.1/9.1/8.6.1/8.5.1/7.1.4, Informatica Power Exchange 9.1/8.6

DATA MODELLING: Dimensional Data Modeling, Star Schema, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 7.1/4.x

DATABASES: Oracle 11g/10g/9i, MS SQL Server7.0/2000, MS Access, Sybase, DB2,MySQL,Teradata V2R6/13.1

PROGRAMMING: C, C++, SQL, PL/SQL, HTML,UNIX Scripting, Java

REPORTING TOOLS: Business Objects XIR2,Crystal Report,MicroStrategy

OPERATING SYSTEMS: Windows 98/NT/2000/XP/7,MAC, Sun Solaris, UNIX, MS-DOS

APPLICATIONS: MS Office, MS Project, FrontPage, Toad 9.2/8.6,Oracle SQL Developer, FileZilla,Teradata SQL Assistant

MANAGEMENT TOOLS: MS-Office 2007, MS Project

TESTING TOOLS: HP ALM,HP Quality Center 9.2

SCHEDULING TOOLS: Autosys, ESP,Tivoli Maestro,Control-M

PROFESSIONAL EXPERIENCE:

Confidential, Peapack, NJ

Sr. ETL Lead/ Developer

Responsibilities:

  • As an ETL Tech Lead, Lead teh ETL Development for Enhancements in teh PGS Data warehouse.
  • Managed Team of 4 members and coordinated between teh Business users and teh team to Develop teh ETL Process.
  • Worked on ETL coding, testing, implementing, debugging and documenting teh complex programs.
  • Developed complex pivot logic process mappings to teh incremental process in order to improve teh performance.
  • Tuned teh performance by implementing MD5 logic in teh mappings.
  • Extensively used Reusable transformations and Mapplets are built wherever redundancy is needed.
  • Performed teh performance tuning at source, Target levels by creating Indexes, Hints and Partitioning in ORACLE and Informatica.
  • Assisting teh project manager by compiling information from teh current systems, analyzing teh program requirements and ensuring that it meets teh specified time requirements.
  • Experience usingTeradata utilities ( B-TEQ, Fast Load, MultiLoad, FastExport, Tpump)Teradata parallel support and Unix Shell scripting.
  • Created teh BTEQ scripts for loading teh data into teh Dimensions and Fact tables which are in Teradata DB.
  • Involved in creation of BTEQ Script for validating teh data quality like referential integrity, not null check.
  • Created batch jobs to schedule teh workflows using Informatica Scheduler.
  • Written shell scripts for file transfer/archiving./Email notifications.
  • Created teh Materialized Views and grant teh access to teh Roles.
  • Worked with peers to perform teh Code review as per teh Informatica standards and Best Practices.
  • Created Test plans in HP ALM.
  • Manually Executed teh use cases in teh Test lab using ALM & routed Test Runs for teh approval.
  • Documented all Technical specifications, Installation Instructions, Verification protocol & Source code review Documents.
  • Upload teh documents into teh PDOCS & route for teh approvals.
  • Expertise in RDBMS, database Normalization and Denormalization concepts and principles.
  • Giving estimates for teh efforts in developing application.
  • Analyzing and doing Impact analysis on teh issues and resolving and providing solution for teh issues.
  • Giving Clear Instructions to teh offshore team to deploy teh code in teh Higher environments.

Environment: Informatica PowerCenter10.1/9.6.1, Oracle 11g, Toad 11.5,HP ALM, PDOCS, Business Objects 4.2,RHEL 6.8, Teradata 15.1

Confidential, Peapack, NJ

Sr. ETL Developer

Responsibilities:

  • Involved in gathering and analyzing requirements.
  • Developed several complex mappings using transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files using Power center Designer.
  • Understand teh Source systems, IGATE,Manugistics, SAP Source systems requirements and Data format.
  • Extensively worked on reusable transformations, Sessions, Mapplets and Worklets
  • Responsible for creating Business requirement doc, ETL Design doc, Change impact analysis doc, Unit testing doc and Migration checklist doc.
  • Worked with teh Production support team and assisted teh Support Team in resolving issues.
  • Deployed teh Code form Dev to Test environment and responsible for teh Data validation and support code testing.
  • Expertise in Performance Tuning by identifying teh bottlenecks at Sources, Targets, PowerCenter transformations and sessions using techniques like Explain plans, Oracle hints, re-designing teh mappings.
  • Created and optimized diverse SQL queries.
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from teh database.
  • Created UNIX shell scripts to accomplish teh requirements.
  • Worked on indirect method of file loading.
  • Used Informatica Scheduler for scheduling teh Batch loads during Americas, Europe, and Asia region time zone.
  • Involved in giving estimations for teh efforts in application development.

Environment: Informatica 9.6.1, Oracle 11g, RHEL 6.7,TOAD 11.5,Microstrategy 10.1

Confidential, NJ

Sr.ETL Consultant

Responsibilities:

  • Design and build teh data warehouse components in multitier architecture which comprises of stage operational data store and analytical data mart for each applications.
  • Understand teh source system (Rave-Medi data) requirements and xml structure.
  • Parse teh xml format data from web services with Java transformation.
  • Process teh data in metadata driven fashion which stores teh history of reference data information.
  • Developed teh ETL mapping, session and workflow to load standard and custom Operational data.
  • Solution teh logic to dynamically created or alter teh object and load teh clinical data using dynamic sql
  • Gather teh user requirements and build teh analytical marts based on reference, operational and clinical data.
  • Created workflows and used various Tasks like Email,Event wait,Event Raise,Command,Decision and session in teh workflow manager.
  • Worked extensively on various reusable transformations, Mapplets and transformations such as Lookup, Joiner, Expression, Sorter, Router, Update strategy, Aggregate, Normalizer etc.
  • Responsible for migrating to integration environment and user acceptance environment and support code testing and validation.
  • Extensively used dynamic parameters and created workflows, worklets for teh load logic based on decision strategies and roll back on failure scenario.
  • Documented teh design and build process for support and analysis.
  • Involved in giving Estimations for efforts in teh application development.
  • Did Performance tuning and optimized if any bottlenecks were found in different areas.
  • Worked with peers to perform teh code reviews and documented.
  • worked in Agile/Scrum method of product implementation and delivery.
  • Worked as a lead for a team of 5 members and coordinated between teh business users and teh team.
  • Co-ordinated with teh QA team and certifying teh test cases and test plans.

Environment: Informatica 9.1, Oracle 11g, HP-UX,Control-M,HP-ALM 11.0,Fitness Tool.

Confidential, OH

Sr. ETL Specialist

Responsibilities:

  • Contributed as a member of teh Data Management Group (DMG) responsible for Design, Development, and Implementation of interfaces and conversions.
  • Involved in analyzing teh different interfaces and source systems like SalesForce, Beam, Sigma, which were as a part of initial phase of SDM and working closely with teh business.
  • Prepared application enhancement Designed document, Technical document based on teh business requirements for teh enhanced project.
  • Developed and Tested Informatica mappings to load data into Flat files and to Teradata database from various source systems using MlOAD utility.
  • Worked in Agile environment.
  • Created Deployment groups for migrating teh code from Dev to QA to Prod environments. Responsible for creating folders and giving privileges to teh new users.
  • Involved in creating teh Bteq scripts for loading teh data into teh Dimensions and Fact tables which are in Teradata DB.
  • Used Teradata SQL assistant for running teh SQL Queries to check teh data loaded to teh Target Tables.
  • Worked extensively on various reusable transformations, Mapplets and transformations such as Lookup, Joiner, Expression, Sorter, Router, Update strategy, Aggregate, Union etc.
  • After teh loading was complete balancing scripts were developed in order to make sure that teh number of rows read from teh source was in agreement with teh number of rows loaded in teh target. This validation was done to check for teh total counts and also for teh data in all teh fields.
  • Designed and developed a script to Schedule jobs in teh Meastro.
  • Supporting teh DW applications EASE, e-Prod, to ensure all teh SLA's met and Financial extracts are sent on time.
  • Analyzing and doing Impact analysis on teh issues and resolving and providing solution for teh issues.
  • Handover teh production support activities to teh offshore as a daily handshake.
  • Involved in giving Estimations for efforts in teh application development.
  • As a part of production support used my expertise in Trouble shooting and giving teh appropriate resolution.
  • Tuned teh Informatica code to meet teh SLA’s

Environment:Informatica 9.1,Teradata 13.1,Microstrategy 9.3,Linux 2.6,MS office 2007,HP ServiceCenter 6.2.6,HP QualityCenter 11,Meastro,CA Workstation 11.3/ESP,CA Software change workbench Manager(Harvest package) 12.1

Confidential, Carmel, IN

Sr. BI ETL Developer

Responsibilities:

  • Involved in overall SDLC lifecycle of teh project in all stages right from teh Analysis, requirement gathering, IVSC SDM design, development & reporting requirements.
  • Created documents like teh TDD, STT and UTP to suffice all teh business requirements for teh project.
  • Involved in analyzing teh different interfaces and source systems like AMS, EBIZ, LAI, AFC, and AutoVIN which were as part of teh initial phase of teh SDM working closely with teh Business.
  • Worked very closely with Architects to drive teh Logical & physical models for teh project looking into different subject areas and inter relations between each entity which derived in creating different set of tables for SRC, XREF, STG & TGT tables for teh respective Dimension & Fact tables in teh SDM.
  • Design and develop Extract Transform and Load (ETL) and Data Integration (ETL) solutions for complex functional and technical requirements using Informatica Power Center and Power Exchange.
  • Design and develop CDC and Datamap using Power Exchange 9.1.
  • Creating Power Exchange Registration and Customizing power Exchange connection property and creating restart token.
  • Created workflows and used various Tasks like Email,Timer,Schedular,Control,Decision and session in teh workflow manager.
  • Designed same set of mappings, mapplet & components to reuse for both Historical initial loads and incremental loads to pick data without manual intervention.
  • Defined Target load order plan for loading data into different Target Tables.
  • Documented different scenarios in teh UTP and their results considering teh business requirements for each table separately. Did Performance tuning and optimized if any bottlenecks were found in different areas.
  • Worked with teh business users to assist them with teh system and UAT and system end to end test.
  • Developed ftp scripts for external file processing with teh system to integrate with Informatica. Documented teh issues & failures occurred during each phase of teh project.
  • Did teh code migration each environment to teh other keeping in sync all teh required objects of Informatica, UNIX, Windows and teh DB scripts in a synchronized manner using versioning and migration documents.
  • Used my expertise in debugging issues and knowledge sharing when others in teh team required it.
  • Created Project run book for teh production support team and transitioned it over to them along with all teh issues and resolutions. Worked on Production support until transition was done to teh support team and as part of thewarrantyof teh project developed. Documented all teh process in detail at every phase of teh project.

Environment: Informatica Power Center 9.1.6, Power Exchange 9.1, Oracle10g, Toad, BusinessObjectsXI 3.1, Sql server 2007, Erwin Data Modeler 7.2, HP Quality Center 9.2, Clearcase, Windows XP, Microsoft office 2007, MS Visio 2007, Unix.

Confidential, Whippany, NJ

S r. DW Developer

Responsibilities:

  • Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
  • Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouses.
  • Developed mappings to extract data from SQL Server, Oracle, Flat files, DB2, Mainframes and load into Data warehouse using teh Power Center, Power exchange.
  • Conducted Database testing to check Constraints, field size, Indexes, Stored Procedures, Created testing metrics using MS-Excel.
  • Implemented various identifying Bottleneck Performance Tuning technique on Source, Targets, Mapping, and Workflows.
  • Designed and developed UNIX shell scripts to schedule jobs. Also wrote pre-session and post-session shell scripts, Wrote PL/SQL scripts for dropping, rebuilding indexes.
  • Performed Configuration Management to Migrate Informatica mappings/sessions/workflows from Development to Test to production environment.
  • Collaborated with Informatica Admin in process of Informatica Upgradation from PowerCenter 8.6 to PowerCenter 9.1.
  • Extensivly worked with various Lookup caches like Static cache,Dynamic cache,and persistant cache.
  • Developed workflow dependency Informatica using Eventwait Task,command wait.
  • Worked closely with teh business analyst’s team in order to solve teh Problem Tickets/ Service Requests.
  • Involved in L3 support of teh project.

Environment:Informatica Power Center 8.6, Oracle 10g, SQL, PL/SQL,BusinessObjectsXI 3.1,InformaticaPowerexchange 8.6, MS SQL Server 2000, Flat Files, Windows XP, Microsoft office 2007, UNIX Shell Scripting, Sql*Loader TOAD, SQL Developer, Erwin Data Modeler 7.2, Linux.

Confidential, Plano,TX

Sr. ETL Developer

Responsibilities:

  • Involved in teh documentation/Design of Technical Design Document of various interfaces like Sales organization, Field AOP, and Field Forecast.
  • Used Teradata, SQL assistant for running teh SQL Queries to check teh data loaded to teh Target Tables.
  • Designed and developed mappings, mapplets and sessions from source to target database using Informatica Power Center.
  • Used simple to moderately complex debugging techniques to test ETL applications.
  • Developed Test Cases for testing teh ETL mappings.
  • Conducted code reviews and lead design reviews to assure compliance.
  • Involved in migration of ETL/Bteq code from Development environment to QA environment and finally to Production environment.
  • Followed Informatica development standards and enforce best practices.
  • Performed QA work to verify teh results provided from other teams.
  • Worked with various file formats like fixed length and delimited.
  • Written SQL overrides in source qualifier and Lookups according to teh business requirements.
  • Involved in creation of BTEQ Script for validating teh data quality like referential integrity, not null check.
  • Utilizing teh existing UNIX shell scripts to run teh informatica workflow through process control.
  • Scheduled sessions and batch process based on demand, run on time, run only once using Informatica Workflow Manager.
  • Participated in *on-call* support for ODS and teh data warehouse.
  • Involved in documentation to describe program development, logic, coding, testing, and any changes and corrections.

Environment: Informatica Power Center 8.1, Teradata V2 R6, SQL, Windows XP, SQL Assistant, UNIX Shell Script. DB2, Sun Solaris.

Confidential, CT

Informatica Developer

Responsibilities:

  • Involved in identification of facts, measures, dimensions and hierarchies for teh DM model.
  • Analyzed Source System data. Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformation designer.
  • Imported data from various Sources (Oracle, fixed width flat files, XML), transformed and loaded into Targets using Informatica.
  • Used Teradata Special Loads like Tpump, Mload, and Fast Load.
  • Created Stored Procedures to transform teh Data and worked extensively on PL/SQL for various needs of teh transformations while loading teh data.
  • Tuned mappings, transformations and recommended tuning options of source/target database to DBA team for obtaining optimum performance.
  • Created Universe & teh Business Objects Reports using teh universe as teh main Data provider and writing teh complex queries including Sub queries, Unions, Intersect and Aliases using Business Objects features like Slice and Dice, Drill Down, and Formulae.

Environment: Informatica Power Center 7.1, Oracle 10g, SQL * Loader, MS SQL Server 2000, Sybase, Teradata, Erwin 3.5, Clear case, Business Objects 5.1, HP-UX, Windows 2000.

Confidential . St. Louis, MO

ETL Developer

Responsibilities:

  • Analyzed source data and gathered requirements from teh business users.
  • Designed teh functional specification and technical specification for migrating teh existing database system to teh data mart.
  • Developed technical design specification to load teh data into teh data mart tables confirming to teh business rules.
  • Involved in teh design phase of logical and physical data model using Erwin.
  • Developed technical design specifications to extract teh data from teh data mart tables and export them as text files to teh downstream system.
  • Extensively worked on tuning of Informatica map for better performance.
  • Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
  • Worked along with teh QA team in order to determine teh data validation and preformed teh data validating at teh source and teh target database level.

Environment: Informatica Power Center 7.1, Oracle 9i, Windows 2000, flat files, Erwin, Business Objects 5.0, Crystal Reports

Hire Now