We provide IT Staff Augmentation Services!

Data Integration Administrator Resume

4.00/5 (Submit Your Rating)

Columbus, GA

SUMMARY:

  • A proactive potential with 14 solid years of IT experience in administering, designing, supervising and implementation of Data Warehouses & Data marts with ETL & OLAP Tools, expertise in System Administration, Application Architecture, Administration, Data Management, Business Intelligence, Infrastructure, Integration, Automation, Life - Cycle Refresh, Migrations and Solutions.
  • Expertise in Informatica/ETL Architecture, Design, Development, Administration, OS migrations, Upgrades, Installations, refresh projects (Life Cycle Refresh), environment infrastructure design and setups, Configurations, and Managing the Infrastructure .
  • Expertise in Informatica High Availability (HA) and Grid Architecture.
  • Expertise in overall System Administration (Windows, UNIX, SQL and Oracle Database, and ETL Administration)
  • Establishing the process, naming conventions, enterprise standards at all the phases of a Data warehouse.
  • Excellent knowledge and experience in data warehouse development life cycle, requirement analysis, Repository management and administration.
  • Expertise on Informatica client tools Admin Console, Developer tools, Command Line Utilities, Mapping Designer, Workflow Manager, Repository Manager and Workflow Monitor. Experienced in overall Data Warehouse, Database, ETL and performance tuning.
  • Hands on experience with Creating folders, Groups, Roles, Users in Admin console and granting them permissions.
  • Good experience with change management, deploying code from DEV to TEST and PROD - using deployment groups and using XML deployment in Informatica Repository Manager.
  • Quick understanding of Relational Source Database Systems and data models to provide optimal solutions in architecture, which can be used in Data Migration and Data Integration.
  • Proficient in applying performance-tuning concepts to Informatica Mappings, Session properties, and database.
  • Experience in working with directorial and managerial leadership, DB and System Admins to co-ordinate with new implementations, partnerships, performing POCs, and decision-making.
  • Support the Testers, Developers and KT to the Team about the best practices and standards and often act as SME.
  • Exclusively worked on different flavors of UNIX and Windows Operating Systems and good experience in UNIX shell scripting(Korn/bash).
  • Thorough understanding of end-to-end Software Development Life Cycle ( SDLC ) including requirements analysis, system analysis, design, development, documentation, training, automation, disaster recovery, implementation, and post-implementation review .
  • Experience in analysis of Source Systems and Warehouse systems.
  • Implemented the Change Data Capture (CDC) capturing from data sources like Power Exchange DB2 for zOS and VSAM data sets and integrated with the Power Center.
  • Extensive experience in upgrading the infrastructure, configuring the Informatica Servers with various versions of Informatica Power Center 5.0/5.1/6.0/6.1/6.2/7.1/8.0/8.5/8.6.1/9.0.1/ 9.5.1/9.6.1 /10.1/10.2 BDM/BDE/B2B/IICS versions. with OS migration from Unix (AIX) to Linux (RHEL).
  • Expertise in a wide variety of Informatica products like (Power Center Real-Time and Batch, Grid and Single Node, B2B, MDM, BDM/BDE, IICS (Cloud), Axon, PMPC, DVO, Secure@Source, IMM, IDQ(IDE), EDC and Power Exchange.
  • Expertise in Real-Time and Traditional Batch Informatica Architecture implementation.
  • Expertise in building the ETL, system, application infrastructure from the ground up.
  • Team player with good interpersonal and problem-solving skills, ability to work in team and individually.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 5.0/5.1/6.0/6.1/6.2/7.1/8.0/8.5/8.6.1/9.0.1/ 9.5.1/9.6.1 /10.1/10.2 /BDE Informatica Power Exchange 9.5.1, Informatica Cloud Services, Informatica Metadata Manager(IMM), Informatica Master Data Management(MDM), Informatica Data Quality Tool(IDQ), Informatica Developer Tool, Informatica Data Explorer(IDE), Informatica Proactive Monitoring Tool for Power Center (PMPC -Operations & Governance), Informatica Data Validation Option (DVO), Secure@source, Informatica AXON, Enterprise Data Catalog (EDC)

Performance Management and Monitoring: DynaTrace, Spotlight, Proactive Monitoring for Power Center.

BI Tools: Business Objects Designer 6.1/XI, Business Objects Supervisor, Business Objects Reporter, Crystal Report 8.0, Cognos, OBIEE

RDBMS: Oracle 11g/10g/9i/8i/7.x, UDB DB2 EE & EEE 7.2/8.1/8.2 DB2 MVS7 MS SQL Server 2000/ 2005/2008/2012 /2016, Teradata, mySQL, MS Access

Scheduling Tools: Control M, Autosys, Tidal, Tivoli Alerts

Data Modeling: Erwin, E/R Studio

Scripting: Unix Shell scripting, Korn Shell Scripting (Kshell), Perl.

Programming Languages: Java, C, C++, SQL, PL/SQL

Operating Systems & Application Servers: Windows Server 95/98/2000/2008 &R2/2012&R2/2016, RHEL, UNIX (AIX, HP and SUN), Apache Tomcat, Tomcat Websphere/Weblogic/JBoss

Tools: Rapid SQL, SQL*Loader, SQL-Programmer, MS Visio, PL/SQL Dev, SQL Dev, Toad, SNOW (IT Service Management), JIRA.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, GA

Data Integration Administrator

Responsibilities:

  • What started as a single project, and ended up being solely responsible for setting up two brand new Real-Time Informatica B2B Infrastructures from ground up in a highly agile environment. Involves setting up servers, databases, designing the data integration components based on the use case, getting licenses, capacity planning, installations, designing and setting up security, user access, creating guidelines, DR, testing, code elevation process, interviewing and onboarding DEV team, everything from the ground up and even performed a successful upgrade recently.
  • Primarily responsible for a successful integration project to consolidate multiple environments to a single environment, converting the single node domain into the HA/Grid environment, integration B2B, MFT components, migrating them from different zones, setting the security up, co-ordinating with multiple project teams, and on boarding them to the new environment and making it a functional multi layered, diverse platform that can host several projects with a scope of expansion and scalability.

Environment: Informatica PowerCenter 10.1/10.2, Informatica B2B Data Exchange 10.1/10.2.2/10.2.3, Informatica MFT 10.1/10.2, Informatica Metadata Manager, Analyst Tool(Data Quality), Informatica Data Quality, SQL Server 2012, IT ServiceNow Management, VersionOne, MongoDB, ActiveMQ, Windows 10, Flat files.

Confidential ., Atlanta, GA

Senior Data Integration Solution Advisor

Responsibilities:

  • Design, implement, configure, administer, support and operating Data Integration Infrastructure.
  • Worked on planning, design and implementing the standards, guidelines and best practices.
  • Planned and Upgraded Informatica from 10.1.1 to 10.2.0 on 5 applications (25 servers)
  • Designed, planned and built an entirely brand new highly-available Informatica application on Grid with 5 servers, which includes installations, configurations, FTP setup, installation of supporting applications, working with Midrange, Control-M, teams, automation of scripts for migration, backup, truncate, health monitoring of servers, shared storage monitoring, until the release of the application.
  • Upgraded Informatica IDQ and DVO components.
  • Automated bulk verification and validation tasks in UNIX and Linux.
  • Automated statistic collection report generation for the server’s health monitoring.
  • Did a POC on a new application called Analytix DS.
  • Setup SFTP connections using RSA, DSA protocols, and worked with bridge team when there are issues with transfers.
  • Setting up the ssh keys for SFTP transfers, guide project teams on the process.
  • Application validations, and through testing of applications post the upgrades, patching and working with Informatica to get the things completed in given SLA.
  • Updated and maintained Certificates for Informatica Domains using the Anthem Internal process.
  • Personally, installed components like Oracle, Netezza, Sybase, Greenplum.
  • Worked with various teams including DBAs, Production Office, Security Administration, Architects to setup and design the data integration environments.
  • Created a very useful and creative inventory for Anthem, and integrated it into SQL Server for easy access. It has now become a daily handy tool for the team now to use the inventory.
  • Extensively worked in design, configure and upgrade Informatica PowerCenter services - Repository Service, Integration Service and Web Service Hub, Data Quality services - Model Repository Service, Data Integration Service, Analyst Service, Content Management Service and Search Service along with Metadata Manager.
  • Provided day to day on call support for ETL services. Participated in SWAT calls for highly critical Production Outages, and managed to work with various teams to the resolution of issue.
  • Able to handle, lead, co-ordinate critical outages and SWAT calls to the resolution especially when 30 plus people are on the call, and when topics get deviated. With the understanding, and expertise of ETL Administration, able to bring the right people, assign work on the fly, and make sure that the issue gets resolved ASAP.
  • Responsible to monitor and keep the health of Informatica services and Informatica servers.
  • Responsible for day-to-day admin activities including creating/changing/managing folders, users, roles, groups, privileges, connection objects, promoting/rollback of deployment groups from development to QA and to production environment, domain management tasks (including backup and restore), configuring DB connections etc.
  • Responsible to setting up the new SQL server platforms for the enterprise usage within the Data Integration area.
  • SQL Server database management including backups, recovery and maintenance like installing service packs and updates.
  • Database management for export, import and mass data loads.
  • Regular functions like configuring and manage SQL Security settings, making system design recommendations according to Microsoft SQL Server best practices, managing database backup & recovery & DR planning in collaboration with IT manager and System Engineers, to create, modify, and optimize SQL Server Agent jobs and maintenance plans and proactively monitoring SQL Server maintenance tasks, troubleshooting failed jobs and resolve issues in a timely manner.
  • Analyzing and generation of all tables and index statistics
  • Co-ordinate with other support groups in case of planned/un-planned down time.
  • Supporting the IDQ team with the product functionality, issues, Address Doctor usage, and act as one of the SMEs for the IDQ platform at Anthem.
  • Created on-demand rules to monitor jobs, workflows, patterns etc to provide a proactive monitoring system using the Informatica Proactive Monitoring Console (PMPC) to help the Production Support process.
  • Created Service requests with Informatica support for unknown errors and coordinate.
  • Created Incident Tickets, Change Tickets, and service requests in Service Now,
  • Maintenance of Informatica Repository, backups, restore, and purging/archival of logs on Informatica servers.
  • Configuration and management of application services, license service etc.
  • Applying patches, Hot Fixes to the Informatica Applications.
  • Worked with various types of relational and applicational sources and targets in Informatica such as Oracle, DB2, mainframes, MS SQL Server, Teradata, XMLs, Flatfiles, WebServices consumer, Power Exchange channels, Salesforce and Hadoop connectors.
  • Create and manage users, and troubleshooted various issues at Informatica Master Data Management (MDM) platform on a day to day operations.
  • Responsible for creating connections, managing the secure agent, deploying the objects, managing users and security in Informatica Cloud Platform.
  • Provided the support for creating, organizing and analyzing metadata and provided support using Informatica Metadata Manager (IMM). Created relationships, providing various types of on-demand reports and worked extensively with business glossary and catalog.
  • Setting up RSA keys among various hosts and ensuring the security protocols for file transfers.
  • Troubleshooting issues related to databases, job failures, software bugs and performance bottlenecks to all incidents working with multiple cross functional teams like DBA, Unix Server Administrators, Informatica Global Support and work on problems and drive them to resolutions from DEV to PRD.
  • Worked with Informatica for software licenses, EBFs, Informatica bugs, issues etc.
  • Provided technical documentation as a part of any support/upgrade/maintenance.

Confidential, Detroit, MI

Senior Informatica/ETL Administrator - Data Integration Consultant

Responsibilities:

  • Design, implement, configure, administer, support and operating Data Integration Infrastructure.
  • Worked on planning, design and implementing the standards, guidelines and best practices.
  • Worked with various teams including DBAs, Production Office, Security Administration, Architects to setup and design the data integration environments.
  • Extensively worked in design, configure and upgrade Informatica PowerCenter services - Repository Service, Integration Service and Web Service Hub, Data Quality services - Model Repository Service, Data Integration Service, Analyst Service, Content Management Service and Search Service along with Metadata Manager and still acting as a SME.
  • Provided day to day on call support for ETL services.
  • Responsible to monitor and keep the health of Informatica services and Informatica servers.
  • Responsible for day-to-day admin activities including creating/changing/managing folders, users, roles, groups, privileges, connection objects, promoting/rollback of deployment groups from development to QA and to production environment, domain management tasks (including backup and restore), configuring DB connections etc.
  • Reviewing the code with developers and architect.
  • Co-ordinate with other support groups in case of planned/un-planned down time.
  • Doing POC’s for new functionalities being used for first time (IDQ, PMPC, and Informatica Big Data Edition).
  • Had a hands-on experience on Informatica Big Data Edition and provided the support as an administrator for a brief period.
  • Supporting the IDQ team with the product functionality, issues, Address Doctor usage, and act as one of the SMEs for the IDQ platform at Blue Cross.
  • Created on-demand rules to monitor jobs, workflows, patterns etc to provide a proactive monitoring system using the Informatica Proactive Monitoring Console (PMPC) to help the Production Support process.
  • Create service requests with Informatica support for unknown errors and coordinate.
  • Maintenance of Informatica Repository, backups, restore, and purging/archival of logs on Informatica servers.
  • Configuration and management of application services, license service etc.
  • Applying patches, Hot Fixes to the Informatica Applications.
  • Worked with various types of relational and applicational sources and targets in Informatica such as Oracle, DB2, mainframes, MS SQL Server, Teradata, XMLs, Flatfiles, WebServices consumer, Power Exchange channels, Salesforce and Hadoop connectors.
  • Upgraded several components of the Informatica Infrastructure (8.6.1 to 9, 9.5.1 to 9.6.1, and 9.6.1 - 10.2) along with OS migration from UNIX to LINUX as a part of Life Cycle Refresh.
  • Delivered the Life Cycle refresh Project successfully while resolving various script compatibility issues between the OS migration and Infrastructure upgrade, without a single ‘priority 1’ ticket.
  • Create and manage users, and troubleshooted various issues at Informatica Master Data Management (MDM) platform on a day to day operations.
  • Responsible for creating connections, managing the secure agent, deploying the objects, managing users and security in Informatica Cloud Platform.
  • Provided the support for creating, organizing and analyzing metadata and provided support using Informatica Metadata Manager (IMM). Created relationships, providing various types of on-demand reports and worked extensively with business glossary and catalog.
  • Setting up RSA keys among various hosts and ensuring the security protocols for file transfers.
  • Troubleshooting issues related to databases, job failures, software bugs and performance bottlenecks to all incidents working with multiple cross functional teams like DBA, Unix Server Administrators, Informatica Global Support and work on problems and drive them to resolutions from DEV to PRD.
  • Worked with Informatica for software licenses, EBFs, Informatica bugs, issues etc.
  • Provided technical documentation as a part of any support/upgrade/maintenance.

Environment: Informatica PowerCenter (Advanced Editions) 8.1/8.6.1/9.1/ 9.5.1/9.6.1 /10/ BDE, Informatica PowerExchange 8.x/ 9.5.1/9.6.1, Informatica ProActive Monitoring, Informatica Metadata Manager, Analyst Tool(Data Quality), Informatica Developer Tool, Informatica Data Explorer, SQL Server 2005/2008/2012, Oracle 9i/10g/11g, IBM Tivoli, PL/SQL, SQL Navigator, Java JEE, MS Access, UNIX AIX5.x/6.1, Red Hat Linux 4.4., Tomcat Apache, Tomcat Jboss/Weblogic/websphere, Windows 7, Flat files. Harvest SCM Versioning, Cognos.

Confidential, Parsippany, NJ

Sr. ETL/Informatica Developer & Administrator

Responsibilities:

  • Involved in Analysis of the specifications provided by the clients.
  • Design of the ETL mappings as per the Users requirement.
  • Used various transformations like Source Qualifier, Expression, filter, Aggregator, Lookup and SQL stored procedures.
  • Wrote Unix Shell scripts.
  • Created transformations, sessions and workflows.
  • Used Oracle as the Database and loaded the data for Analysis.
  • Scheduling of the Informatica workflows and sessions.
  • Maintained the Data Model using Star schema which was developed from Erwin tool.
  • Involved in Debugging and Performance Tuning of mappings and sessions.
  • Involved with the reporting team and created OLAP reports using Business Objects and Cognos.
  • Configuration and Management of Users/Groups/Roles in PC.
  • Configuration of security domains and Scheduling Synchronization of the users/group with LDAP directory service.
  • Managing the deployments (Labels, folder, deployment groups) and conflict resolutions.
  • On call support for Informatica services.
  • Responsible to monitor and keep the health of Informatica services and Informatica servers.
  • Responsible for day-to-day admin activities including creating/changing/managing folders, users, roles, groups, privileges, connection objects, promoting/rollback of deployment groups from development to QA and to production environment, domain management tasks (including backup and restore), configuring DB connections etc.
  • Reviewing the code.
  • Co-ordinate with other support groups in case of planned/un-planned down time.
  • Environment: Informatica - PowerCenter 8.6.1 (PC 8.6.1), Power Exchange, DB2 9.5, SQL, Oracle 10G,XML, UNIX Shell Script, Data stage TX 8.1, Windows NT/2000/XP, E/R studio, Erwin, Business Objects, SQL Server 2008, IBM Clear Case.

Confidential, Dover, NH

Sr Informatica Developer & Consultant

Responsibilities:

  • Responsible for requirement definition and analysis in support of Data Warehousing efforts.
  • Performed data analysis on the source data coming from point of sales systems (POS) and legacy systems.
  • Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
  • Extensively used ETL Tool Informatica to load data from XML, Flat Files, Oracle, SQL Server, and DB2.
  • Used various transformations like lookup, update strategy, router, filter, sequence generator, source qualifier, joiner on data extracted according to the business rules and technical specifications.
  • Worked on XML Transformations and loaded the data into target database tables.
  • Developed data Mappings between source systems and warehouse components using Mapping Designer.
  • Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
  • Extensively worked with the Debugger for handling the data errors in the mapping designer
  • Worked extensively on different transformations like source qualifier, Expression, Filter, Aggregator, Router, Update strategy, lookup, Normalizer, Stored procedure, Mapping Variables and Sequence generator and java.
  • Worked on Migration Strategies between Development, Test and Production Repositories.
  • Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads
  • Developed Logical and Physical data models that capture current state/future state data elements and data flows using Erwin / Star Schema.
  • Used workflow manager to develop and manage tasks, manage connections and scheduling workflows.
  • Experience in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions. This led to better session performance.
  • Expert with the Teradata utilities BTEQ, FASTLOAD, BULKLOAD, MULTILOAD and TPUMP.
  • Queried target database using Teradata BTEQ to validate the data in the Data Warehouse.
  • Developed scripts to perform both unit as well as system integration testing.
  • Experience in the migration of the project from development to production.
  • Extensive experience in monitoring the workflows and optimizing the load times.
  • Extensively used Informatica debugger to validate mappings and to gain troubleshooting information about data and error conditions.
  • Documenting the entire process. The documents included the mapping document, unit testing document and system testing document among others.
  • Worked on the UNIX AIX4.3 to connect to the Oracle database and run PL/SQL scripts.
  • Used pmcmd command to schedule sessions and batches and to recover the sessions.
  • Assisted in creating universe, classes and objects using Business Objects Designer tool.
  • Extensively used calculations, variables, breaks, sorting, drill down, slice and dice, alerts for creating Business Objects reports.
  • Worked in production support for Informatica Mappings.
  • Responsible for tuning ETL procedures to optimize load and query Performance
  • Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
  • Experience in Writing Shell scripts to automate the Pre-Session and Post-Sessions Processes.
  • Extensively Used Informatica Power Exchange tools to capture the data change (CDC) for DB2.

Environment: Informatica - PowerCenter 8.1, 8.6.1 (PC 8.6.1), Power Exchange, DB2 9.5,, Oracle 9i/10G,XML, UNIX AIX4.3, Data stage TX 8.1, Windows NT/2000/XP, E/R studio, Erwin, SQL Server 2005, SQL Server 2008, IBM Clear Case, Teradata, ERWIN, PL/SQL, SQL Navigator, MS Access, Win XP, Flat files. Business Objects XI, BizTalk, Control-M.

Confidential

Dw Etl Informatica Developer

Responsibilities:

  • Involved in Analysis of the specifications provided by the clients.
  • Design of the ETL mappings as per the Users requirement.
  • Used various transformations like Source Qualifier, Expression, filter, Aggregator, Lookup and SQL stored procedures.
  • Wrote Unix Shell scripts.
  • Created transformations, sessions and workflows.
  • Used Teradata as the Database and loaded the data for Analysis.
  • Scheduling of the Informatica workflows and sessions.
  • Maintained the Data Model using Star schema which was developed from Erwin tool.
  • Involved in Debugging and Performance Tuning of mappings and sessions.
  • Involved with the reporting team and created OLAP reports using Business Objects and Cognos.

Environment: Informatica 5.x, Business Objects 6.5, Cognos, Oracle 8.x/7.x, Teradata, ERWIN, Toad and Unix Shell Scripting

We'd love your feedback!