Technical Support software engineer Resume

SUMMARY

Highly accomplished and motivated software professional with 3 years of experience on
ETL tool Informatica PowerCenter and Change Data Capture tool PowerExchange
Experience in providing technical support for Informatica customers in all aspects of the data warehousing design, mapping, development, migration and testing of data movement for the data in the IT Risk Management environment.
Extensively worked on different RDBMS for Extract - transform and Load(ETL) process
Successfully completed PowerCenter 9.x level1 developer training.
Experience in DBMS Utilities such as SQL, TOAD, SQL Server, SQL*Loader, Teradata SQL Assistant.
Skilled in ETL tool suite to design and develop work flows, transformation mappings, and UNIX scripting.
Experience with versioning and Team Based options in Informatica Power Center, Informatica Power Exchanges (SQL, Oracle, DB2, CDC), and Data Quality tools.
Proven ability to multitask, self-motivational & train group members.
Workshop on Effective Presentation skills, Effective problem solving and other personality development and leadership programs.
Good team player with excellent interpersonal, analytical and problem solving skills.
Can adapt to changes and to latest technologies with analytical, logical and innovative knowledge

TECHNICAL SKILLS

Languages : SQL, PL/SQL, Shell Scripting

Operating Systems: UNIX, Linux, Windows, SUN Solaris, HP-UX AIX, i5OS

Database: Oracle, SQL Server, DB2, Teradata, DB2/400

ETL tool: PowerCenter8.x and9.x, PowerExchange8.x and 9.x, PowerExchange for Oracle, PowerExchange for DB2, PowerExchange for MSSQL Server, PowerExchange for AS400, Informatica Data Replication and Informatica Fast clone

Applications: Microsoft office, putty

PROFESSIONAL EXPERIENCE

Confidential

Technical Support software engineer

Technology/Software : PowerCenter 8.x and 9.x and PowerExchange 8.x and 9.x,Informatica Data Replication, Informatica Fast clone

Responsibilities:

Performed root cause analysis and debugging, managed and provided support to an entire Informatica data integration platform, which included design, architecture, builds, and configuration through implementation.
Partnered with business analysts, database administrators, and developers to understand the requirements and accelerate the process to meet milestones.
Extensively worked on Informatica Administrator by creating and managing Informatica services.
Worked with the sales team on the proof of concepts (POC) to suit the customer needs by installing, configuring and executing use cases.
Reproduced the bug and provided suitable resolution, troubleshot issues related to databases, job failures, software bugs and performance bottlenecks for all incidents working with multiple cross functional teams for resolutions.
Performed defect tracking and worked with the development team for resolution.
Involved in developing test cases, test procedures and unit test strategy for the developed code by the development team and execution of the test cases to validate the results.
Quality Assurance for the enhanced code and software.
Guided developers for achieving optimum utilization of Informatica capabilities and suggest best practices.
Prepared knowledge base documentation for the problem solution and best practices for the implementation.
Performed Informatica PowerCenter and PowerExchange migration across environments (dev/prod/uat/test) and upgraded or applied patches to the product.
Provided resolution of support and maintenance tickets per established service level agreements (SLAs).
Troubleshot, optimized and tuned ETL processes.
Used Oracle as source/target database to extract or load data and worked on data capture tool which extracts the Oracle log data using data dictionaries, as well as extensive use of SQL queries for data analysis.
Extensively worked on Informatica Designer components (Source Analyzer, Warehouse Designer, Mapping Designer, Metadata Manager, Mapplet Designer and Transformation Developer), Repository Manager, Repository Server, Workflow Manager and Workflow Monitor.
Worked on both change data capture and bulk load of PowerExchange sessions.
Have Strong understanding of Informatica Powercenter/PowerExchange Architecture and Repositories.
Coordinated teams both onsite and offshore.
Conducted training and knowledge sharing sessions

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship