We provide IT Staff Augmentation Services!

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.

Hire Now