Systems Engineer Resume

SUMMARY

Having 3yrs+3months of experience in the field of Data Warehousing with Informatica as an ETL tool.
Have comprehensive knowledge on Teradata - SQL.
Proven ability to analyze, resolve issues and provide effective solution
Hard working, detail oriented and able to work well in both team environment and individual environment.
Good Communication & Presentation skills.
Good analytical and Administrative skills.

TECHNICAL SKILLS

Languages: Teradata - SQL, Basics of UNIX shell scripting

Database: Teradata 12.0

Tools: Informatica PowerCenter 9.1.0 & 8.6.1,Teradata SQL Assistant 12.0, Filezilla, Starteam, Appworx, Winscp

Software Products: Putty, Telnet, MS-Office, OpenOffice3.3

Operating Systems: Windows XP, Windows 2002/2003, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Systems Engineer

Database:Teradata 12.0

Tools: L: Informatica PowerCenter 9.1.0 & 8.6.1, Teradata SQL Assistant,Putty, Starteam, Appworx, Winscp

Responsibilities:

Analyze the requirements sent by the Data Architects & understand it from business perspective.
Communicate with the client on the estimated SLA for a particular requirement.
Prepare the design document for a particular requirement.
Develop mappings/sessions/workflow or any BTEQ/Unix Script/parameter file & process the data.
Prepare the Test cases as per the requirements & validate the source data against the data that is processed.
Deploy the code in Integration Environment.
Provide support in UAT phase & work on the findings if any.
Prepare a PROD Move Checklist describing the details for Production Deployment.
Provide a walkthrough on the change to the Support team for Production Move.
Provide First Run Support for the change after the Production Move & resolve issues if any in the production environment.
Worked on Informatica Push down Optimization (PDO) for Performance tuning & analyzing the use of Teradata Parallel Transporter(TPT) with Informatica for the same.
Worked with Informatica Parameter files & Parallel Execution of Workflows.
Worked on Slowly Changing Dimensions (Type 1 & Type 2) & Star schema model.