Software Engineering Analyst Resume

SUMMARY

6 years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Powercenter.
Proficiency in developing SQL with various relational databases like SQL and PL/SQL.
Knowledge in Full Life Cycle development of Data Warehousing.
Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
Experience with dimensional modeling using star schema and snowflake models.
Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
Strong with relational database design concepts.
Proficiency in developing Tableau report with various relational databases like GreenPlumand Oracle
Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
Strong business understanding on Finance Vertical.
Independently perform complex troubleshooting, root - cause analysis and solution development.
Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
Comprehensive technical, oral, written and communicational skills

TECHNICAL SKILLS

ETL : Informatica 9.0.1 (Informatica Certified Developer)

OLAP Tool: Tableau desktop 9.0

Databases: Oracle 9i/10g 9(OCA Certified), Exudates,Green plum

Languages: SQL, PL/SQL and UNIX.

Operating Systems: Windows 2000/XP, Linux.

PROFESSIONAL EXPERIENCE

Confidential

Software Engineering Analyst

Responsibilities:

Working as an ETL developer.
Created mappings to pull the data from various flat & relational sources.
Created the mapping to load data into staging area and then to the target table.
Performed Unit Test Cases for mapping
Involved in the migration process of Informatica Mapping, Database change.

Confidential

ETL developer

Responsibilities:

Working as an ETL developer.
Created mappings to pull the data from various flat & relational sources.
Created the mapping to load data into staging area and then to the target table.
Performed Unit Test Cases for mapping
Involved in the migration process of Informatica Mapping, Database change.

Confidential

ETL developer

Responsibilities:

Working as an ETL developer.
Created mappings to pull the data from various flat & relational sources.
Created the mapping to load data into staging area and then to the target table.