We provide IT Staff Augmentation Services!

Etl Onsite Technical Lead For Support And Development Resume

Research Triangle Park, NC

OBJECTIVE:

To constantly learn and evolve in a highly professional work environment while acting as a key player and to make a profound contribution to the organization.

EXPERIENCE SUMMARY:

  • Assistant Consultant with over all 8+ years of experience in IT industry. Currently working with Life Science Domain giant as an onsite Technical Lead for Development as well as for Support with hands - on experience on Informatica PowerCenter Administrator/Development/Support, IBM DataStage Development/Support and PL/SQL Development/Support
  • Expertise in Data Migration and Data Integration activities using various market leading ETL tools and effective handling of databases using PL/SQL tools like Oracle SQL Developer and MS SQL Server Management studio.
  • Experience in complete software development life cycle using AGILE development methodology and technical documentation like Functional Requirement Specifications (FRS) and software design document / High level design which comply with the international regulatory standards.
  • Expertise in enterprise level Informatica PowerCenter architecture and Setup, Administration, Development and Support.
  • Expertise in ETL Development and Support using DataStage ETL Tools.
  • Expertise in uninterrupted organization ETL support activities like Deployment, Patching, upgrade and day today Production support for Informatica PowerCenter and DataStage projects.
  • Decent Unix scripting skills required for managing Informatica PowerCenter administration, development and support activities.
  • A systematic, organized, hardworking, punctual, optimistic and dedicated individual with an analytical bent of mind, determined to be a part of a growth-oriented organization.

PROFESSIONAL EXPERIENCE:

Confidential, Research Triangle Park, NC

ETL Onsite Technical Lead for Support and Development

Responsibilities:

  • Actively involved in production environment requirement/issue details gathering from customer and providing precise solution to the issues in a crisp time frame
  • Driving Kanban call on daily basis to assign tasks to team members and gather the status of the on burning issues
  • Maintenance of various environments of Informatica PowerCenter which includes administration activities like installation, upgrade and patching activities via Linux operating system. Various environment includes both validated and non-validated environments such as Sandbox, Dev, Test, UAT and Production
  • Carrying out disaster recovery activities through ITCP (IT Continuity plan) document
  • Informatica PowerCenter servers Performance fine tuning
  • New service set up and maintenance of various Informatica PowerCenter services through Informatica PowerCenter administration console.
  • Outage period activities like Informatica PowerCenter Nodes start up and shutdown for various environments and un-scheduling/scheduling ETL jobs
  • Tomcat clean-up activities for Informatica PowerCenter servers periodically across all environments
  • Maintaining and upgrade/update/applying of informatica PowerCenter Licenses
  • Automating the mail notification to admin team in case of informatica PowerCenter Node and services are down
  • Carrying out various PoC’s using informatica PowerCenter tool for new connectors and requirements in Lower environments
  • Authoring access management plan and managing access for all informatica users
  • Project set up activities for newly introduced projects in Informatica PowerCenter
  • Resolving administration related issues being faced by Informatica users during the project execution phase
  • Automation of day today ETL jobs monitoring of various projects running in production environment
  • Authoring project specific Technical Installation Plans and Deployment Plans
  • Deployment of ETL Jobs from lower environment to higher environment through Informatica PowerCenter repository Manager tool
  • Automating the mail notification and remedy ticket generation to support team and users in case of any ETL job failure
  • Identification of root cause for the ETL job failure by accessing the session and workflow logs and rectifying the issue following the regulatory process without breaching SLA hence not impacting users
  • Performed unit testing and system integration testing in lower environments prior implementation of solution to production.

Solution Environment: Windows 2008 servers & Linux servers/Windows 7

Tools: Informatica PowerCenter 10.1.1 Hotfix1, Informatica PowerCenter 10.1.1 Hotfix2, Informatica PowerCenter 10.2, DataStage 11.5.0.2, Oracle SQL Developer, Composite, Putty (for Redhat Linux), WinSCP

Confidential, Research Triangle Park, NC

ETL Development onsite Technical Lead

Responsibilities:

  • Gathering and analysing end user’s requirements to design, develop and implement ETL jobs using informatica PowerCenter to interface the applications
  • Designing, developing and implementing ETL jobs to integrated DMW Integration utility web application and with its interfaces in Development environment and deploying the same into Test, UAT and Production environment.
  • Developing ETL Jobs for data integration between various source systems and DMW MDR application which in turn includes data migration activities like data cleansing, data verification, data profiling, data enrichment and data transformation.
  • Developed complex Informatica PowerCenter mappings involving transformations like XML Parser, Expression, SQL, Router, Normalizer. Creation of different tasks like Session, command and Email task and generating workflow/worklets
  • Usage of email task to generate automatic mail to distribute list after successful/failure of session using post session properties.
  • Expertise in developing various Unix scripts, SQL Procedures and SQL Queries to meet the requirements and calling the same in Informatica jobs in various sessions
  • Provide post Go-Live Support and Maintenance.

Solution Environment: Windows 2008 servers & Linux servers/Windows 7

Tools: Informatica PowerCenter 10.1.1 Hotfix1, Oracle SQL Developer, SQL Server Studio 2008, Composite, Putty (for Redhat Linux), WinSCP

Confidential, Research Triangle Park, NC

ETL Development onsite Technical Lead

Responsibilities:

  • Gathering and analysing requirements from the users during the design phase
  • Designing, Developing and implementation of ETL jobs using Informatica PowerCenter as data integration solution based on the user requirements.
  • Responsible for managing, scheduling and monitoring the workflow sessions.
  • Involved in Performance tuning of sessions, mappings, ETL procedures, processes for better performance and support integration testing
  • Implemented Error Handling Strategy in ETL mappings and route the problematic records to exception tables
  • Performed debugging by checking the errors in the mapping using Debugger utility of the Designer tool and made appropriate changes to generate the required results
  • Involved in performing regular system audits to ensure accuracy of the various environments and applications
  • Automation of monitoring of all ETL job statuses and sending alerts/notification to support team in case of ETL job is in hung status, prolong running status or any other status apart from success status by using UNIX script
  • Provide support for Informatica workflows/mappings developed using 10.1.1 which are running into production environment

Solution Environment: Windows 2008 servers & Linux servers/Windows 7

Tools: Informatica PowerCenter 10.1.1 Hotfix1, Oracle SQL Developer, SQL Server Studio 2008, Composite, Putty (for Redhat Linux), WinSCP

Confidential, Research Triangle Park, NC

Informatica PowerCenter Administrator

Responsibilities:

  • Gathering and analysing platform setup requirements from the users during the design/architecting phase
  • Coordinating with clients in purchasing the Informatica PowerCenter License, Databases, Unix servers by educating about number of CPU Cores, RAM and size of the server needed for setting up of environments.
  • Installation and configuration of Informatica PowerCenter through UNIX box using informatica provided installation files and setting up of Informatica related services and products through administration console for pilot environment (Sandbox)
  • Repeating the installation activity for various higher environments like Dev, Test, UAT and Production.
  • Installation of Informatica PowerCenter windows client (PowerCenter client and Informatica Developer client) for accessing the Informatica PowerCenter services
  • Setting up of ITCP (IT Continuity plan) environment as a disaster recovery plan which will be activated in case of disaster incident happening with Production environment hence not impacting any users and their Jobs/Data.
  • Managing the Sandbox/DEV/TEST/UAT/PROD/ITCP environments with High Availability and GRID setup
  • Build Informatica Data Exchange/Data Transformation (DX/DT) and Data Quality environments for various POCs or setting up the environments if required
  • Developing POC ETL Jobs to connect various source connectors provided by Informatica PowerCenter
  • Perform Informatica PowerCenter 10.x System Administration including Team Based Development administration
  • Experience with creation of groups, adding users to group, creation of roles, creation of OS profiles and providing group access roles and privileges based on the system access plan defined.
  • Experience with creation of new project folder through repository manager, creation of project specific group, adding the users to group, creation of project specific OS profile to handle project specific folders, tagging the OS profile to project folder, code page setups, appropriate ETL migration activities and scheduling jobs using in built in Informatica PowerCenter scheduler or scheduling the Informatica jobs through crontab
  • Applying the incremental license to existing license when incremental license is provided from informatica.
  • Upgrading the existing Informatica version to new version by updating patches provided by Informatica
  • Liaise with Systems Administrators, UNIX, Network and DBAs, scheduling and implementing software patches and upgrades
  • Experience in automation of monitoring Informatica environments using UNIX, pmrep, pmcmd and other Informatica command line language. Even monitoring the domain, node and informatica services using in built SMPT options
  • Support development teams with performance tuning and troubleshooting issues
  • Handle day to day Informatica components migration tasks (Deployment)
  • Scheduling and Monitoring Informatica repository backups using UNIX commands
  • Authoring and review of Informatica ETL design documents and working closely with development to ensure correct standards are followed
  • Scheduling ETL jobs through informatica Scheduler and Crontab by writing crontab commands
  • Creating new repositories from scratch, backup and restore
  • Scheduling real time system jobs by developing and scheduling the polling jobs
  • Root Cause analysis for ETL job failures/Data issues raised by business
  • Design and develop automation script for node start up in case of node goes down unexpectedly
  • Testing of GRID architecture, load balancing and automatic fail over/switch over mechanism
  • On Call Support as required during the week ends and off hours and being involved in administration activities like Node shut down/Start up, jobs un scheduling/scheduling during the outage window for servers/Databases

Solution Environment: Windows 2008 servers & Linux servers/Windows 7

Tools: Informatica PowerCenter 10.1.1 Hotfix1, Oracle SQL Developer, SQL Server Studio 2008, Composite, Putty (for Redhat Linux), WinSCP

Confidential, Research Triangle Park, NC

Informatica PowerCenter developer

Responsibilities:

  • Actively involved in requirement gathering from customer.
  • Participating in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.
  • Creating ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation.
  • Designing and building integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).
  • Developing stored procedures, database triggers and SQL queries where needed.
  • Peer to peer code reviews, Unit and System Testing.

Solution Environment: Windows 2008 servers & Linux servers/Windows 7

Tools: Informatica PowerCenter 9.x, Oracle SQL Developer, SQL Server Studio 2008, Composite, Putty (for Redhat Linux), WinSCP

Confidential, Research Triangle Park, NC

Informatica PowerCenter Developer

Responsibilities:

  • Actively involved in requirement gathering from customer.
  • Participating in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.
  • Creating ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter to migrate the data from Smart Team to Smart Plant application.

Solution Environment: Windows 2008 servers & Linux servers/Windows 7

Tools: Informatica PowerCenter 9.x, Oracle SQL Developer, SQL Server Studio 2008, Composite, Putty (for Redhat Linux), WinSCP, SmartTeam, SmartPlant

Confidential

ETL Developer (Informatica PowerCenter)

Responsibilities:

  • Prepared detailed ETL design in accordance with requirements and specifications.
  • Worked on development of ETL jobs to migrate the data from Maximo 4.0, Maximo 7.0 EIS application to Infor EAM application
  • . Creating ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter to migrate the data from Maximo 4.0 & 7.0 application Database to Infor EAM Database application.
  • Travelling to onsite for carrying out the on-shore data migration in Confidential Plants. Travelled to onsite to Sri Lanka for 2 different sites (Dehiwala and Mt. Lavinia) for carrying out Data migration.
  • Peer code reviews, Unit and System Testing.

Solution Environment: Windows 2008 servers & Linux servers/Windows 7

Tools: Informatica PowerCenter 9.x, Oracle SQL Developer, SQL Server Studio 2008, Composite, Putty (for Redhat Linux), WinSCP, Maximo 4.0, Maximo 7.0, Infor EAM

Hire Now