System Engineer Resume

SUMMARY

Pursuing Masters in Information Science with four years of experience in designing, developing, unit and functional testing of Interfaces for Enterprise Application Integration using middleware and data warehouse using Informatica, Oracle SQL, Unix Shell Scripting and Informatica Data Quality (IDQ) actively seeking for Summer Internship

TECHNICAL SKILLS

ETL Tool: INFORMATICA9.X, MR

Testing Tool: APPLICATION LIFECYCLE MANAGEMENT

RDBMS: ORACLE 11i

Reporting Tool: TABLEAU

Unix Tool: PUTTY,SVN,WinSCP

Statistical Tool: R

Language: JAVA

Analytical Tool: GOOGLE ANALYTICS

PROFESSIONAL EXPERIENCE

System Engineer

Confidential

Responsibilities:

Experienced in working with business to understand requirements and translate them into ETL code during Requirement Analysis Phase.
Worked as an ETL developer for generating Access Statement in My Account Portal under teh client Confidential .
Worked as an ETL developer in various projects such as UCM Self Service, PeopleSoft to GFA and IBS and Life Science Harmony for teh client GE Healthcare.
Worked on Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modelling (Star Schema and Snow Flake Schema).
Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
Worked on pre and post validation checks at mapping level using scripts and mappings.
Worked on backend data to generate quarterly and monthly Business Intelligence report for customers .
Developed a self-service capabilities for EIKON customers across strategic products, so they can manage their own orders, accounts and users, and thus making easier for them to do business with Confidential .
Developed Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator) and Mappings using Informatica Designer .
Developed Unix scripts for minimizing teh time taken to transfer XML files from Informatica to EAI server which reduced teh overall process time by 50%.
Automated scripts to reduce teh dependency on schedulers and scripts for file transfers to remote servers and job scheduling . Involved in Unit testing, System testing to check whether teh data loads into target are accurate.
Monitored teh data flow between various system such as SAP, SIEBEL and SFDC.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship