Profile Page

Nagamuthu R, ETL Informatica Architect
Scottsdale Insurance

resume icon
The Contractor's Resume  

Availability Date: 08/24/2015
Telephone Numbers: 703 953 2535 x104

Current Address:
    Phoneix   Arizona   USA 005

E-Mail Address:

Additional Contract Information:

  • Over 11 years of software experience in System Analysis, Application Design, Development, Implementation and ETL, Reporting for Data Warehousing.
  • As a ETL Architect, designed and implemented Data Mart / Data Warehouse applications using Informatica Power Centre 9.x/ 8.x / 7.x / 6.x (Designer, Workflow manager, Workflow monitor and Repository Manager).
  • Experienced in requirements gathering, project estimating, planning design, build, maintenance, report design, user navigation design, testing and implementation. Good knowledge on SDLC (software development life cycle) and good experience with unit testing and integration testing.
  • Worked with Informatica Power Center to create complex mappings using expressions, Routers, Lookups, aggregators to develop and to move data to multiple databases.
  • Experience in working on Entity-Relationship concepts, Operational Data Store (ODS), Facts and dimensions tables, slowly changing dimensions, Dimensional Modeling (Star Schema and Snow Flake Schema), Normalization and De normalization Concepts
  • Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM hub implementation.
  • Experience in integration of various data sources definitions like SQL Server, Oracle, Flat Files, XML.
  • Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Worklets and Workflows for data loads.
  • Created Mappings in Mapping Designer to load data from various sources using complex transformations like transaction control, Lookup (Connected and Un-connected), Joiner, sorter, Aggregator, Update Strategy, Filter and Router transformations.
  • Experience in identifying and resolve ETL production root cause issues. Experience in maintenance, enhancements, performance tuning of ETL code.

·         Expertise in working in Teradata V2R12.x systems and used utilities like MultiLoad, FastLoad, FastExport, BTEQ, TPump, Teradata SQL

·         Fine-tune the existing scripts and process to achieve increased performance and reduced load times for faster user query performance

·         Writing Teradata BTEQ scripts to implement the business logic

  • Experience in handling of all the modules of Business Objects Supervisor, Designer, Reporter, Business objects Xir2 Desktop intelligence, CMC Web Intelligence Xir2, Business objects Voyager, BO SDK Crystal Xcelsius.
  • Good experience in Reporting tools like Business Objects, Web Intelligence and Crystal.
  • Good experience with Business Objects Report Migration & Conversion from Full Client report to Thin Client report.
  • Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant and Unix shell scripting.
  • Good experience in creating and review of Requirements/System Impact Specifications, Data Flow Diagrams, Effort estimation and Implementation Plan.

checkbox Willing to work over the internet
checkbox Willing to Relocate
checkbox Work Offsite ONLY
Citizenship: USA

Years of experience:
List of Skill sets: (premium service)

Acceptable Contract arrangements:
checkbox I do use contract agents/recruiters.
checkbox I am an Independent Corporation.
checkbox I am a Limited Liability Company (LLC).
checkbox I use an Umbrella company as employer of record.
checkbox I am an Independent Sole Proprietor (1099).
checkbox I can be an Employee of an Agent (W2).
checkbox I can be convertible to Employee of Client.
checkbox I am also looking for part-time work.
checkbox I will also bid fixed price work.

Scguild logo Member number: 10996,   since: 08/13/2015
Last Updated: 08/24/2015   Last Login: 08/24/2015
Current Membership Status: Listed
Premium Membership expires: 08/13/2015 (EXPIRED)
Listing will be deleted: 08/24/2017 (2 yrs after last update)
Hit Statistics:
      Profile Page

The Legal Disclaimer.

To pay dues to qualify for premium services, log in at the top of this page.

Copyright(c) 1995 - 2021 Software Contractors' Guild , 9725 Richland Hills Ln, Bakersfield CA 93306