We provide IT Staff Augmentation Services!

Etl Engg And Support Resume

SUMMARY

  • Possess 17+ years of professional experience in the Information Technology Administration, Analysis, Design, and Development, testing with focus on ETL applications, Data Base development and Reporting.
  • Possess ETL Administration and Development skills. Administration skills in Informatica, Informatica MDM and development and admin skills in Abinitio.
  • Experience with Informatica installs, upgrades patches and application of EBF’s in the SDLC environment. This includes creating and configuring the several services in Informatica like PowerCenter Repository and Integration Services, Model Repository and data Integration Services, Web Services Hub, Data Analyst, Metadata manager management services, etc.
  • Involved in Informatica and Abinitio platform certification.
  • As Administrator helped troubleshoot issues related to Informatica processes, engineering, configuration and development etc.
  • Stopped, Started and recycled services when needed especially during server re - starts. Took Infalogs and Infadumps and other logs and dumps for Informatica support to help trouble-shoot issues. Ran backups of the Repositories using Command line and Admin Console whenever needed especially when running upgrades.
  • As Informatica administrator worked on day to day activities like creating folders in PowerCenter Repository, projects in Developer etc. Added AD-groups, made password changes of the Domain and database schemas where repositories are created. Monitoring the loads scheduling and handling outages.
  • Performed code migration and validating the workflows, sessions, mappings in case of errors. Maintaining code integrity, creating folders and user accounts and managing folder permissions and access privileges to the users. Created/Added DB connections and configured ODBC connections.
  • Worked and validated complex mappings involving Filter, Router, Expression, Lookup, Update Strategy, Sequence generator, Joiner and Aggregator etc. transformations.
  • Developed and tested job and schedule scripts for Maestro jobs and jil files for Autosys.
  • Experience in writing UNIX Shell Scripts for Korn and Bourne shells as wrappers.
  • Installed Informatica MDM, the software in the Linux Environment using JBoss and setup the software by registering different ORS onto the domain.
  • Exceptional knowledge of Databases having worked on Oracle, Sybase, Teradata, MS SQL Server and MS Access.
  • Good experience in Data Modeling, Data Extraction, Data Migration, Data Integration, Data Testing and Data Warehousing using Abinitio, Informatica and Oracle Data Integrator.
  • Good hands-on experience in Abinitio (GDE and Co>Operating System) and Informatica. Solid experience in Extraction, Transformation and Loading (ETL) mechanism using Abinitio. Knowledge of full life cycle development for building a data warehouse.
  • Configured Abinitio graph parameters, sandbox parameters, environment variables, EME Repository environment for Production/Testing/Development and performance tuning.
  • Proficient with various Abinitio parallelism techniques and implemented number of Abinitio Graphs using Data parallelism and Multi File System (MFS) techniques.
  • Tuned Abinitio graphs by adding components or removing unnecessary components and splitting the processes into phases to enhance the performance.
  • Wrote Abinitio continuous graphs to perform real-time messaging using MQ messaging. Ran messages to Mainframe using Abinitio queues and used TIBCO queues and for Database refreshes.
  • Used Abinitio components like Sort, Scan, Reformat, Denormalize, Normalize, XML Read, XML Write, XML Split, XML Combine, Throttle, Replicate, Read Separated Values, Read Excel etc.
  • Maintained the logical and physical organization of the database, like organization of database into different table spaces.
  • Excellent project management, scoping, development life cycle and implementation experience. Good experience in reviewing and monitoring project progress, planning & managing dependencies and risks, Resource Planning, Project Tracking and Forecasting.
  • Excellent Client interaction skills and proven experience in working independently as well as in a team.
  • Possess excellent communication, presentation and interpersonal skills to reach the precise target.
  • Experience with Agile’s Scrum (RAD) meetings and development approach.
  • Experience in writing different design documents.
  • Possess the ability to co-ordinate effectively with other development teams, business partners, end users and management.
  • Possess excellent understanding and capability to troubleshoot common issues faced during the development lifecycle including coding, debugging, testing and finally production roll-out.
  • Experience with offshore/onshore model for design, development and testing.
  • Self-motivated, excellent written and oral communication skills.
  • Possess strong analytical & problem-solving skills
  • Team player.

TECHNICAL SKILLS

ETL Tools: Informatica 10.2x/9.x/8.x, Abinitio (GDE 3.03/1.15/1.13.1/1.11.15/1.10.9.3 Co>Operating System 2.15/2.13/2.11.8/2.10.15 ), Oracle Data Integrator (10.1.3). DMExpress 6.2

Operating Systems: UNIX: AIX, Sun Solaris; Linux: RedHat/SuSe; DOS/Windows 95/98/2000/NT/XP/Win 7/Win 8/Win 10.

Languages: C, C++, SQL, PL/SQL, SQL, UNIX Shell Scripting, COBOL

Scripting: Unix, Perl, Win-PowerShell, Python

Databases: Sybase, Stratus, Oracle, MS SQL Server, DB2, MS Access 2003, Teradata V2R4.

Data Management: Informatica Master Data Management 9.5.1

Data Validation Tool: Informatica Data Validation Option 9.5, 9.6 and 10.2

Business Intelligence: Crystal Reports 11, 8.0/8.5/9.0/9.5/10.0 , Crystal Enterprise 8.0/8.5/9.0/9.5. Business Objects

Data Modeling: Embarcadero ER/Studio, Erwin, Toad

CM Tools: CM Build.

Version Control Tools: CVS, Clear Case, Visual Source Safe.

GUI Development: Visual Basic 5.0/6.0

Documentation: MS Project, MS Office, Visio 2003/2007.

Requirements Tool: Doors

Automation Tools: Maestro-Trivoli, Autosys, Control-M

File Transfer Tools: NDM, SCP, SFTP, FTP and Shared-Drive (NAS)

File Systems: NAS, NFS, CFS

File Transfer client: Samba Client

Management Tools: Remedy, Quality Center, Infoman, ServiceNow.

PROFESSIONAL EXPERIENCE

Confidential

ETL Engg and Support

Responsibilities:

  • Attend meetings to understand and modify the current state and plan the future state of the Informatica Infrastructure setup.
  • Analyzed planned and engineered using NFS to complete the setup of multi-node Informatica Grid with High Availability completed successfully.
  • Planned installed/upgraded Informatica 9.5.1 HF1 to 9.5.1 HF4 to 961HF4 and then to 10.2 on Windows and Linux environments.
  • Upgraded PowerCenter Repository, Model Repository, Content Management Service, Analyst Service.
  • Installed/applied EBF’s when needed to Informatica installs to fix issues.
  • Installed Teradata and DB2 clients on Linux for new setups.
  • Installed/Upgraded configured Informatica DVO for users to work with different environments.
  • Installed Samba Client for file movement between Linux and Windows file shares.
  • Installed/Upgraded the PowerExchange 9.5.1HF1 to PWX 9.6.3HF3 to PWX 9.6.3HF4 and then to PWX 10.2.
  • Ran backups of the Domain and Repositories using Command line and Admin Console whenever needed especially when running upgrades. Stopped, Started and recycled services when needed especially during server re-starts.
  • Added new Address Doctor datasets for address verification along with regularly renewing the licenses
  • Resolved TLS1.2 issues in Informatica 951 for SalesForce connectivity by creating a custom PC Integration Service using java version 1.8.xx
  • Helped resolve TLS1.2 for PowerExchange CDC for Sql-Server.
  • Added new Web-Server certificates to the ca-bundle.crt file
  • Created custom Integration Services in version 961 to support workflows to continue to run on 951 java libraries as they were failing when using 961 java libraries.
  • Helped developers create CDC registrations and extraction maps on the mainframe and Sql-Server.
  • Created Project folders in PowerCenter. Added roles and privileges to Informatica Domain.
  • Wrote scripts to automate the deployment/migration of code into PowerCenter.
  • Wrote script to monitor the Informatica services checking for Tomcat services, repository services and Integration services.
  • Enabled real-time alerts in Informatica Admin Console for services failure alerts.
  • Interacted with Informatica Support by creating cases for their support to plan changes to the infrastructure and help trouble-shoot issues.
  • Helped trouble-shoot and resolve Informatica infrastructure and developer related issues.
  • Worked with development teams helping code migrations and resolving issues.
  • Worked closely with DBA, SA and Infrastructure teams on DB / OS upgrades and server maintenance and patching activities.
  • Wrote run-books, documented commands which could be used for L2 Support and Operational Support.
  • Provided 24x7 on call support for Production issues and during office hours in lower environments.

Environment: Informatica 10.2.x/9.6.x/9.5.x, Informatica PowerExchange 10.2x/9.6/9.5.x, JMS 2.x/6.x, DB 2 9.7/10.1/10.5/11.1 , Sql-Server 2008/2012, Sql-Assistant, Linux Red-Hat, UNIX Shell Scripts, AutoHotKey scripts, Windows bat files, MS Office, MS Project, MS Visio.

Confidential

ETL Engg and Support

Responsibilities:

  • Attended meetings to understand and modify the current state and plan the future state of the Informatica Infrastructure setup.
  • Analyzed and planned the mount of clustered NAS file system for Grid setup.
  • Analyzed planned and engineered to complete the setup of multi-node Informatica Grid with High Availability completed successfully.
  • Created new Repositories and Integration Services for new applications.
  • Planned and upgraded older version 8.6.0(extended support ended December 2012) on servers to 9.1.0-HF6 successfully.
  • Upgraded the PowerExchange 8.6.0 to PowerExchange 9.5.0.
  • Configured max process to 100 so that concurrent processes run of workflows could be run without going on wait status.
  • Installed and configured Informatica 9.6.1 Big Data package to work with 6 node Cloudera install for Data Integration and Data Governance project.
  • Created PowerCenter Repository, Model Repository, Content Management Service, Analyst Service, PowerCenter Integration Service and Data Integration Service. Added Profiling database, Human Task database etc.
  • Setup connections for hdfs, Hbase, Hive databases.
  • Helped the POC team with moving data using Informatica to hdfs, Hbase, Hive and reverse.
  • Ran backups of the Domain and Repositories using Command line and Admin Console whenever needed especially when running upgrades. Stopped, Started and recycled services when needed especially during server re-starts.
  • Created Project folders in PowerCenter. Added roles and privileges to Informatica Domain.
  • Wrote scripts to automate the deployment/migration of code into PowerCenter. Wrote AutoHotKey (windows script) script to migrate PowerExchange Mainframe datamaps.
  • Wrote script to monitor the Informatica services checking for Tomcat services, repository services and Integration services.
  • Enabled real-time alerts in Informatica Admin Console for services failure alerts.
  • Interacted with Informatica Support by creating cases for their support to plan changes to the infrastructure and help trouble-shoot issues.
  • Worked very closely with development teams helping code migrations and trouble-shoot and resolve issues.
  • Worked closely with DBA, SA and Infrastructure teams on DB / OS upgrades and server maintenance activities.
  • Wrote run-books, documented commands which could be used for Operational Support.
  • Provided 24x7 on call support for Production issues and during office hours in lower environments.
  • Supported the SAS servers and the users.
  • Communicated with SAS support to trouble-shoot issues regarding the SAS server services issues.
  • Reset licenses on the SAS servers, stopped and restarted the SAS servers.

Environment: Informatica 8.X/9.X, Informatica PowerExchange 9.x/8.x, SAS 9.3, Oracle 10/11g, Toad, Unix Solaris, UNIX Shell Scripts, AutoHotKey scripts, MS Office, MS Project, MS Visio.

Confidential, Reston, VA

ETL Engg, Development and Admin Support

Responsibilities:

  • Performed Administrator activities for Abinitio and Informatica.
  • Installed and upgraded Informatica and Abinitio software, also applied EBF’s when available to Informatica and Abinitio servers. Also, was involved with getting the new versions or Hotfixes certified.
  • When installing a server with Informatica configured different types of services on the Domain like creating Web Services Hub, Metadata Manager Service, Data Analyst and Data Integration Service, Data Director, Model Repository etc. after creating the PowerCenter Repository with OSProfile enabled. All these configurations depended on the requirements.
  • Worked with Informatica Corporation on issue resolution and patch installation. Coordinated upgrades, patches and outages with UNIX SAs and the DBAs.
  • Provided 24x7 on call support for Production issues and during office hours in lower environments.
  • Provided timely resolution and escalation of all production issues. Raised SR’s with Informatica and Abinitio support for their help and support.
  • Worked closely with DBA, SA and Infrastructure teams on DB / OS upgrades and server maintenance activities.
  • Ran backups of the Repositories using Command line and Admin Console whenever needed especially when running upgrades. Stopped, Started and recycled services when needed especially during server re-starts. Took Infalogs and Infadumps and other logs and dumps for Informatica support to help trouble-shoot issues.
  • Wrote scripts to create folders in PowerCenter and assign group permissions to folders, added AD-groups, made password changes of the Domain and database schemas where repositories are created. Maintained code integrity, creating folders and user accounts and managing folder permissions and access privileges to the users.
  • Wrote scripts to add Roles and privileges to groups, change passwords etc.
  • Successfully upgraded the production Informatica server setup running on Unix multi-node domain, on three servers two being CFS clusters.
  • Created projects in Informatica Developer and folders in PowerCenter.
  • Attended project meetings to understand to develop/modify the Data Masking code to include Sybase and Sql-Server data as sources to redact data.
  • Analyzed and modified the Abinitio code for the data-masking functionality to use Sybase and Sql-Server databases also, as the code only supported flat-files and oracle database.
  • Wrote generic Abinitio graphs to read data from data-bases, flat files and Excel spreadsheets and load the data onto Oracle tables.
  • Wrote Abinitio graphs to audit the Remedy data that it was in sync between production and reporting databases.
  • Analyzed and modified the Abinitio code for better performance to convert the date stored in EPOC to human readable datetime, as Confidential stores Remedy data in EPOC on databases and uses in human readable datetime for reporting. This modification using Abinitio reduced the process and load time from 2 hours to 20 minutes.
  • Performed code reviews of the code that was developed by development teams before it went to production.
  • Helped run the registration and register new applications to use the Data Masking Application.
  • Installed multidomain Informatica MDM, the software in the Linux Environment using JBoss and setup the software by registering different ORS onto the domain.

Hire Now