We provide IT Staff Augmentation Services!

Etl Consultant Resume

SUMMARY

  • 5 years and 10 months experience in Data Warehousing(ETL), Data Migration and Business Intelligence(reporting) at both offshore and onshore locations with prominent experience in Banking, Financial and Insurance domains. Has been involved in whole SDLC life cycle for various development and maintenance/enhancement projects and has worked on ETL job development, code migration/deployment, scheduling and production support etc.
  • Worked extensively on IBM Datastage, Actuate erdPro and Actuate BIRT, PL - SQL, UNIX scripting and scheduling tools
  • Expertise in Data Requirement Analysis, Design, Development of ETL process using IBM DataStage
  • Extensively worked on various DataStage Stages like Transformer, Join, Lookup, Pivot, Merge, Sort, Filter, Aggregator, Copy, Remove duplicates, Funnel, Change capture, Data Set, Sequential File etc.
  • Has been involved in whole SDLC life cycle for various development and maintenance/enhancement projects
  • Has played various roles like developer, onsite coordinator, ETL designer etc.
  • Experience in analysis, requirement gathering, design, development, deployment and testing of ETL jobs
  • Strong knowledge of data warehousing concepts like schemas, data marts, data load, facts and dimensions etc.
  • Understanding of business process and data models

TECHNICAL SKILLS

Business Domain: Banking and Finance Domain and Insurance Domain

Programming Languages: SQL and PL/SQL, Shell Scripting

Operating System: Windows 7/XP/2000, UNIX

Tools: /DB /Packages: DataStage 8.0/8.5, Actuate erdPro, BIRT, DB2, Oracle SQL, PL/SQL, AbInitio (Trained), QlikView(Trained), Khalix(Trained)

Technical Domain: Business Intelligence and Data Warehousing

PROFESSIONAL EXPERIENCE

Confidential

ETL Consultant

Responsibilities:

  • Member of Confidential ’s project team and clearly understands and aligns with the development goals, project goals, deliverables and commitments
  • Transforming and providing source data to agents in required formats using Datastage
  • Responsible for developing new DataStage jobs, re-designing and simplification, performance tuning and upgrade activities
  • Contributes to both DataStage development and Support activities
  • Manage and control workload, maintain quality of deliverables, control schedule and cost for DataStage support
  • Providing support to code deployment process
  • Coordinates with both onsite and offshore team
  • Support Guidewire Policy/Billing center issues

Confidential

Senior DataStage Developer

Responsibilities:

  • Member of Munich Re’s project team and clearly understands and aligns with the development goals, project goals, deliverables and commitments
  • Contributes to both DataStage development and Support activities
  • Manage and control workload, maintain quality of deliverables, control schedule and cost for DataStage support
  • Responsible for DataStage jobs re-designing and simplification, performance tuning and upgrade activities
  • Providing end to end support for Datastage ETL jobs
  • Transforming and providing source data to ISyCl application based on client requirement
  • Providing support to code deployment process

Confidential

Project Member

Responsibilities:

  • Analyze the ETL sequence for the scope of Improvement
  • Understanding the business reporting requirements
  • Design and development of jobs for data load as per the requirement
  • Verifying the loaded data through PL/SQL scripting
  • Maintaining quality processes for the projects
  • Applying appropriate Null Handling in the existing ETL jobs
  • Involved in performance tuning activities
  • Quality Center used as defect and requirement repository

Confidential

Project Member

Responsibilities:

  • Development of reports using Actuate8.
  • Testing and Defect Analysis of the application.
  • Deploying Code to UAT and Production
  • Incident Tickets resolving
  • Coordinate with Database and Actuate Reports
  • Making the Metadata entries in the Database and monitoring them
  • Attending regular team meeting to discuss the status of the work

Confidential

Project Member

Responsibilities:

  • Development of reports using Actuate BIRT
  • Testing and Defect Analysis of the application
  • Deploying Code to production

Hire Now