We provide IT Staff Augmentation Services!

Senior Consultant Resume

SUMMARY:

  • 9+ years of experience in providing technical leadership on Data Warehousing projects involving Analysis, Design, Development, Integration, Implementation, Maintenance, Testing, and Production Support of Applications.
  • Certified Informatica Developer.
  • Experience in Data Warehouse development working with Extraction/Transformation/Loading using InformaticaPower Mart/Power Center with flat files, Oracle, SQL Server.
  • Experience in working withInformaticaPower Center 9.1/8.6.1/8.5.1/8.1.1/7. x/6.x, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, TransformationDeveloper, Mapplet Designer, Mapping Designer,TaskDeveloper, Worklet Designer, Gant Chart, Task View, Mapplets, Mappings, Workflows, Sessions, Re - usable Transformations, Shortcuts, Import and Export utilities.
  • Have Good understanding of ETL/Informaticastandards and best practices, Slowly Changing Dimensions(SCD1,SCD2,SCD3).
  • Experience in testing coordination, writing test cases and executing test scripts, And logged defects in Quality Center (QC).
  • Got a very clear understanding of Big Data.
  • Got good knowledge on Big data components like Hadoop (Hadoop distributed File system and Map Reduce).
  • Strong skills in Informatica Power Center 9.x/8.x troubleshooting and Performance tuning.
  • Worked on different transformations like Join, Lookup, Expression, Aggregator, Update, Filter.
  • Worked on L2/L3 production support for different clients.
  • Lead and worked with teams ranging from 4 to 25 people.
  • Worked on Teradata Load utilities like (Fast Export, Fast Load, MultiLoad, and TPT) which was mainly used to refresh Stage/test Environment from Production.
  • Ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts.
  • Expert in fulfillment of data warehouse project tasks such as Planning, Requirement gathering, Identifying sources, allocation of resources and execution of projects including planning of implementation activities.

TECHNICAL SKILLS:

ETL Tool: Informatica 9.0/8.6/8.1

Database: DB2, Teradata, Oracle

Operating System: LInux 9.x, AIX, Windows XP/Vista/7

Testing Tools: HP Quality Center

Scheduling Tools: Autosys, Control-M

PROFESSIONAL EXPERIENCE:

Confidential

Senior Consultant

Responsibilities:

  • Responsible for business analysis and requirements collection
  • Created mapping documents to outline the dataflow from Source to targets.
  • Modified existing for enhancement of new business requirements
  • Used existing ETL standard to develop some mappings.
  • Unit testing and documentation.

Environment: Informatica 8.6, Oracle 9i, Unix

Confidential

Associate-Projects

Responsibilities:

  • Support for ETL jobs on shift basis (in 24x7 roaster).
  • Monitoring the PROD and SAT
  • Created sessions & workflows for all mappings.
  • Performance tuning of the Informatica mappings.
  • Used the transformations such as Normalizer, Lookup, Router, Sorter, Aggregator, Expression, Union, Joiner and Filter in Informatica mappings
  • Application, technology, product and/or domain specific specializations for a set of applications/product to ensure availability for business use as per agreed SLAs or requirements
  • Giving KT to new joinees in SAT .

Environment: Informatica 8.6.1, UNIX, TNG

Confidential

Jr. Software Engineer

Responsibilities:

  • Design, development and enhancements of the ETL jobs.
  • Used UNIX commands during support and enhancement work.
  • Unit testing and documentation.
  • Control-M job creation

Environment: Informatica 8.6, Control-M scheduler,Unix

Confidential

Jr. Software Engineer

Responsibilities:

  • Support for ETL jobs on shift basis (in 24x7 roaster).
  • Closing the remedy ticket assigned to production support.
  • Provide application, technology, product and/or domain specific specializations for a set of applications/product to ensure availability for business use as per agreed SLAs or requirements.
  • Design, development and enhancements of the ETL mappings/mapplets.
  • Used the transformations such as Normalizer, Lookup, Router, Sorter, Aggregator, Expression, Joiner, Sequence Generator and Filter in Informatica mappings
  • Created sessions & workflows for all mappings.
  • Performance tuning of the Informatica mappings.
  • Unit testing and documentation.

Environment: Informatica 8.1, DB2, UNIX, Informatica Job Scheduler Zena, Remedy User

Confidential

Jr. Software Engineer

Responsibilities:

  • The responsibilities include as Team member for Claims subject area
  • Preparing TSD documents for Pre-Stage to staging area data load.
  • Development of Informatica mappings for the mainframe files to Pre-Staging area
  • Preparing TSD and ETL specification documents for staging to EDW load.
  • Preparing Unit test cased for the scripts.
  • Testing the scripts with test data

Environment: Informatica Power Center 8.1, Teradata

Confidential

Business Associate

Responsibilities:

  • The responsibilities include as Developer
  • Involved in performing data cleansing
  • Interacting with onsite folks as well as clients regarding the status update.

Environment: Informatica 8.1, Oracle 9i,Windows XP

Confidential

Jr. Software Engineer

Responsibilities:

  • The responsibilities include as Team member for Claims subject area
  • Preparing TSD documents for Pre-Stage to staging area data load.
  • Development of Informatica mappings for the mainframe files to Pre-Staging area
  • Preparing TSD and ETL specification documents for staging to EDW load.

Environment: Informatica Power Center 6.0, Oracle, Windows XP

Confidential

Jr. Software Engineer

Responsibilities:

  • Understanding of Technical Specifications Documents, High Level Design.
  • Created mapping to load the data from staging area to data warehouse.
  • Created corresponding sessions and workflows to load the data.
  • Review of code to maintain proper logic implementation / quality standard in the Mappings.
  • Performed Unit Testing.

Environment: Informatica Power Center 6.0, Oracle, Windows XP

Hire Now