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.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship