We provide IT Staff Augmentation Services!

Software Engineer Resume

SUMMARY:

  • Driven software engineer with around 6 years experience in Data Warehousing technologies, RDBMS, Business Analysis and implementation. Experience working with globally - dispersed teams with.
  • Extensive experience in using Informatica Power center (8.x/7.1/6.1) for implementation of ETL methodology in Data Extraction, Transformation and Loading.
  • Extensive experience in using various Informatica Designer Tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Mapplet Designer and Workflow Manager & Workflow Moniter.
  • Designed and developed various mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Sorter, Normalizer, Sequence Generator and stored procedure.
  • Was implemented the Changed Data Capture(CDC)
  • Was responsible for developing, unit testing the code and validating the data.
  • Extracted data form different source systems like Oracle, Flat File and Main Frame using extraction techniques.
  • Extensive experience and solid understanding of Data Warehousing, Data Marts, Star, Snow Flake Schema Modeling, Dimensional Modeling, Entity-Relationship Modeling, OLTP and OLAP concepts.
  • Actively involved in Performance Tuning, Error handling on various Platforms.
  • Extensively worked on Importing and Exporting the Objects.
  • Was responsible for comparing the Old and New versions of objects.
  • Extensively worked on writing the shell commands.
  • Experience in coding using SQL, PL/SQL for Cursors, Stored Procedures/Functions, Triggers and exception handling.
  • Worked on entire life cycle of an Informatica application including design, development and testing.
  • Excellent communication & interpersonal skills
  • Well versed with complete Software Development Life Cycle (SDLC) process including Design, Development, Testing and Implementation.
  • Good Foundation in Data ware Housing Concepts, Informatica, Oracle, TeraData, Business Objects
  • Experience in System Analysis, design and documentation
  • Extensive experience Standard documentation, Unit Test cases and Processes.
  • Expertise to work in Type 11 mappings.
  • Experience in preparing the MD 120 Documentation and Job Chain Document.
  • Experience to write the BTEQ Scripts
  • Expertise to prepare the Merge Scripts.
  • Having the Corporate training on Cognos 8 Tool.
  • Involved to Prepare the ETL Specifications.
  • Expertise to follow the Six Sigma Process.
  • Expertise to maintain the Data Quality.

TECHNICAL BACKGROUND:

ETL TOOLS: Informatica Power center 8.x/7.1/6.1 (Repository manager, Designer, Workflow Manager, Workflow Monitor)

OLAP TOOLS: Business Objects 6.1, Application Foundation 6.1 and Cognos 8 (FM, Report Studio, Query Studio and Power play).

Data Modeling: Dimensional Data Modeling, Star Join and Snowflake Schema Modeling, Physical and Logical Data Modeling

Scheduling Tools: Redwood Chronicle

Databases: Oracle 9i, TeraData

Programming: Toad, PL/SQL

Operating Systems: Windows XP

PROFESSIONAL EXPERIENCE:

Confidential

Software engineer

Responsibilities:

  • Extensive experience in using various Informatica Designer Tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Mapplet Designer and Workflow Manager & Workflow Moniter.
  • Designed and developed various mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Sorter, Normalizer, Sequence Generator and stored procedure.
  • Was implemented the Changed Data Capture(CDC)
  • Was responsible for developing, unit testing the code and validating the data.
  • Extracted data form different source systems like Oracle, Flat File and Main Frame using extraction techniques.
  • Extensive experience and solid understanding of Data Warehousing, Data Marts, Star, Snow Flake Schema Modeling, Dimensional Modeling, Entity-Relationship Modeling, OLTP and OLAP concepts.
  • Actively involved in Performance Tuning, Error handling on various Platforms.
  • Extensively worked on Importing and Exporting the Objects.
  • Was responsible for comparing the Old and New versions of objects.
  • Extensively worked on writing the shell commands.
  • Experience in coding using SQL, PL/SQL for Cursors, Stored Procedures/Functions, Triggers and exception handling.
  • Worked on entire life cycle of an Informatica application including design, development and testing.
  • Excellent communication & interpersonal skills
  • Well versed with complete Software Development Life Cycle (SDLC) process including Design, Development, Testing and Implementation.
  • Good Foundation in Data ware Housing Concepts, Informatica, Oracle, TeraData, Business Objects
  • Experience in System Analysis, design and documentation
  • Extensive experience Standard documentation, Unit Test cases and Processes.
  • Expertise to work in Type 11 mappings.
  • Experience in preparing the MD 120 Documentation and Job Chain Document.
  • Experience to write the BTEQ Scripts
  • Expertise to prepare the Merge Scripts.

Hire Now