Senior ETL Developer and support Resume

SUMMARY:

Overall 10+ years of Total Experience in the IT Industry, and 7 year 9 months of Experience in Syntel.
More than 10 years of experience in the Information Technology industry.
Have work experience in various projects like development, Migration and production support.
Hands on experience of Informatica Power Center along with IDQ tool
Extensive experience in extraction, transformation and loading of data from Heterogeneous source systems like flat files, Oracle, Mainframe, DB2, MQ and MS SQL
Proactively identify opportunities to automate the manual monitoring to prevent Human errors and ensure application availability targets are met.
Hands on experience of databases like DB2, Oracle and UNIX.
Extensive experience in UNIX Shell Scripts to perform data warehousing tasks.
Proven hands - on experience with the complete Software Development Life Cycle.
Expertise with the implementation of Data warehousing methodologies on single and multi-dimensional Data warehousing applications.
Provide leadership in production support services including problem analysis, solution design, testing and implementation, by ensuring system/business requirements and interface dependencies are met in a timely manner with resilient high quality solutions.
Involved in Informatica admin activities.
Extensive knowledge in performing the DR exercise at infrastructure level.
A highly motivated, energetic, professional, hardworking, and result oriented team player with excellent analytical, problem solving, communication, and interpersonal skills.
Expertise in analyzing and resolving the incidents/problems in Servicenow within the specified time sticking to the SLA and giving immediate solutions to client.
Expertise in incident management and problem management activities.

TECHNICAL SKILLS:

Data Warehouse Tools: Informatica Powercenter- 7/8/9 Informatica Power exchange Ab-Initio GDE

Database: Oracle - SQL/PL-SQL, DB2 TOAD, PL/SQL Developer

Operating System: Windows, UNIX and Linux

Other Technologies: Putty, Control-m, Autosys, Servicenow, Splunk, Dynatrace

PROFESSIONAL EXPERIENCE:

Confidential

Senior ETL Developer and support

Environment: Informatica Powercenter 9.6.1, DB2, Control-m, UNIX

Involved in Design Specifications and technical Sessions. Understood the Business point of view to implement coding using Informatica Powercenter, UNIX and DB2.
Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregators, filters, router and lookup and update strategy transformations.
Integrated all jobs using complex Mappings including Mapplets and Workflows using Informatica Powercenter designer and workflow manager.
Experience on Performance tuning to increase the throughput for both mapping and session level and SQL Queries Optimization as well.
Enhanced performance for Informatica session using large data files by using partitions, Increasing block size, data cache size, sequence buffer length and target based commit interval
Sourced large volumes of data from multiple data sources (Relational and Flat File) such as Relational Table and Flat File into staging area using Informatica Powercenter.
Source data from IBM WebSphere MQ tool for real time usage.
To provide 24x7 production support.
Solving day to day Production Support problems which includes M/F job Abends, UNIX cron-jobs, re-transmission of data to DC's and Vendors depending upon the adhoc requests, set up issues and updates to TLE and DB2 databases etc Involved in Solving Day to Day business problems of the Clients logged in Service Centre
Involved in Analysing and resolving the incidents/problems in Servicenow within the specified time sticking to the SLA and giving immediate solutions to client.
Involved in tuning the programs to perform better.

Confidential

Environment: Informatica, Oracle/PLSQL Developer, UNIX.

Senior ETL Developer

Designed and developed complex mappings using various transformations in Designer to extract the data from sources like Oracle, SQL Server and flat files to perform mappings based on company requirements and load into Oracle tables.
Extensively worked on various source like flat files, Databases and XML.
Error checking & testing of the ETL procedures & programs using Informatica and Oracle.
Performance Tuned Informatica Targets, Sources, mappings & sessions for large data files by increasing data cache size, sequence buffer length and target based commit interval.
Responsible for production support i.e. monitoring production jobs, creating and working on production incident requests etc.
Any issues with the daily running jobs, find out the errors and fix them within time limit
Any problem with the ETL codes, prime responsibility was to test in Integration Environment before loading in Production.
Optimized mappings having transformation features like Aggregator, filter, Joiner, Expression and Lookups.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship