We provide IT Staff Augmentation Services!

Etl Developer And Support Resume

SUMMARY:

  • Overall 9 years of Total Experience in the IT Industry, and 8 years of Experience with relevant to Informatica.
  • More than 8+ 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 (SDLC)
  • 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.
  • Expertise in using Splunk, App dynamics for log monitoring and analyzing the production issues.

SOFTWARE SKILLS:

Informatica Powercenter: 7/8/9/10, Informatica Power exchange

Ab: Initio GDE

Oracle SQL/PL: SQL, DB2 TOAD, PL/SQL Developer, AZURE SQL Server, Teradata, mongo DB

Operating System: WindowsUNIX and Linux

Putty, Control: m, Autosys, Servicenow, Splunk, Dynatrace, Jira

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer and support

Environment: Informatica Powercenter 10.2.0, Oracle, Azure SQL server, Mongo DB, Teradata, UNIX, Jira

Responsibilities:

  • Maintenance and enhancement of legacy Lifelock system and migration to Azure SQL server.
  • Involved in optimizing the ETL process for bringing in data from Teradata (CDC) and Oracle (LLDW) into Azure SQL server (Sapphire).
  • Analyzing the incremental data and fixing existing data issues in Azure.
  • Analyzing and reporting any Tech Overhaul issues of bringing in unstructured data from Mongo into Oracle.
  • Supporting Data scientist with their data needs using temporary and permanent solutions
  • Fixing the production issues in both Azure and Oracle and make the data available for reporting with in SLA.
  • Keeping the lights on for the production system.
  • Accepting and tracking the Jira tickets that is being assigned to me.
  • Participating in groom calls.

Confidential

ETL Developer and support

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

Responsibilities:

  • 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.
  • Involved in day to day MSTR reports.
  • 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 Analyzing 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.
  • Created dashboards using splunk and used for monitoring the application logs and analyzing.

Confidential

Environment: Informatica, Oracle/PLSQL Developer, UNIX

Senior ETL Developer

Responsibilities:

  • 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.
  • To provide 24x7 production support

Confidential, Carlsbad, CA

Environment: Informatica, Oracle, UNIX

ETL Informatica Developer

Responsibilities:

  • Used Informatica as ETL tool to pull data from source systems, cleanse, transform, and load data into databases.
  • Worked with multi-file data for parallel processing and deployed jobs onto test staging area.
  • Wrote scripts to update databases, performed archiving, and other functions.
  • 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.
  • To provide 24x7 production support.

Hire Now