We provide IT Staff Augmentation Services!

Informatica Lead Developer/administrator Resume

SUMMARY:

  • Senior Confidential Administrator with eight years of experience.
  • Twenty - two years of total IT experience spanning a broad range of information technology disciplines.
  • Senior level expertise in database development and database administration.
  • Seven years of experience in database design, development, and administration with SQL Server 6.5, 7.0, 2000, and 2005.
  • Seven years of experience working with Oracle 8.0, 8i, 10g, and 11g.
  • Work history also includes field experience in network and operating system administration, hardware troubleshooting and tuning, software optimization and configuration, integrated business systems modeling, and others.
  • Skill set also includes business analysis, solution design, technical training, course development, and experience in Windows and UNIX environments.
  • Excellent problem solving, communication, and interpersonal skills.

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Lead Developer/Administrator

Responsibilities:

  • Create ETL code base to support movement of meter reading data from the transactional system into a decision support data warehouse with Type 2 slowly changing dimensions
  • Install PowerCenter Standard Edition 10.1 into a new Windows 2012 R2 environment with Microsoft SQL Server 2014 repository database
  • Create scheduled jobs to back up domain, repository, update statistics on repository table indexes, export ETL code, and others
  • Create users, groups, roles, folders, connections, etc.; apply hotfixes; maintain security in the Informatica environment
  • Deploy PowerCenter ETL code from development to test and production environments
  • Identify root cause and implement resolution for production data processing issues

Confidential, Nashville, TN

Senior Developer

Responsibilities:

  • Develop Informatica workflows using PowerCenter 9.6.1, SSIS (SQL Server Integration Services) packages, and other SQL code in order to satisfy business requirements
  • Generate ETL code using sources and targets such as Oracle, SQL Server and flat files
  • Work with Analysts, Architects, and Management to ensure SDLC integrity and SOX compliance
  • Develop SQL Server SSIS packages using various versions of Visual Studio, SQL Server Data Tools, and SQL Server Management Studio on a daily basis
  • Work extensively with SQL Server versions 2012 and 2014
  • Develop scripts for code migration from development to test, QA, and production environments
  • Develop and run unit tests for SQL Server and Informatica and PowerCenter code

Confidential, Portland, ME

Senior Informatica Administrator

Responsibilities:

  • Monitored production data loads in an Informatica Enterprise Grid environment, versions 8.6 and 9.5; configured and ran data loads as required to backfill production financial data
  • Migrated PowerCenter ETL code and UNIX shell scripts from development to test, QA, and production environments
  • Participated in code reviews; assisted developers in troubleshooting PowerCenter ETL code
  • Developed PL/SQL queries for troubleshooting data load issues, inserting and updating existing data to resolve data load issues
  • Trained new ETL Administrators; reviewed existing documentation and created new documentation for operational procedures

Confidential, Little Rock, AR

Solutions Architect

Responsibilities:

  • Translated business requirements into technical specifications for marketing solutions designed to enhance customer recognition and prospect marketing campaigns
  • Provided solution architectures to developers; prepare project design documents, assist with QA testing
  • Responsible for coordinating with developers, database administrators, and others to plan and implement Informatica software upgrades
  • Advised Confidential management of potential sales opportunities
  • Interfaced directly with customers to clarify requirements, provide progress reports, coordinate deliverables, and meet other customer needs

Confidential, Houston, TX

Senior ETL Administrator

Responsibilities:

  • Primary administrator for Tidal Enterprise Scheduler version 5.3.1 on Solaris 5.10 platform; responsible for server configuration and troubleshooting, user and workgroup creation, Tidal agent installations on Windows and UNIX servers, java installations, code migration using Transporter 5.3.1, and others
  • Provided problem resolution for Tidal Enterprise Scheduler jobs, including Confidential, Business Objects, FTP / SFTP, Oracle, and other job types
  • Planned and implemented upgrade to Tidal Enterprise Scheduler 6.0.3; coordinated maintenance outages; diagnosed and corrected problems with data transfers to customers' sites; installed and configured Oracle Server 11g databases to serve as Tidal repositories and Client Manager databases; coordinated proofs of concept and new product demonstrations with vendors and resellers
  • While working in this capacity, also provided secondary administrative support for Confidential 9.5, Oracle 11g, and SAP Business Objects version 12.1.0

Confidential, Franklin, TN

Senior Informatica Administrator

Responsibilities:

  • Functioned as single point of administrative support for over one hundred local and offshore developers in development, test, QA, and production environments, providing problem resolution and other support as required for these applications:

Confidential

Professional Data Integration Developer

Responsibilities:

  • Upgraded PowerCenter version 7.15 to version 8.6; upgraded PowerCenter version 8.6 to version 9.1; applied Hotfixes as required
  • Installed and configured Informatica Identity Resolution to provide unique key generation to support customer search and match capability
  • Assisted PowerCenter developers in designing, creating, and troubleshooting ETL code
  • Coordinated efforts and reports with internal and external auditors to ensure that production environments remained SOX-compliant
  • Designed and implemented disaster recovery plans for Informatica and Tidal software
  • Migrated PowerCenter ETL code and UNIX shell scripts from development to test and production environments
  • Installed Informatica Data Transformation to allow the import of unstructured data such as Excel spreadsheets into the Enterprise Data Warehouse
  • Installed Informatica Data Quality and Metadata Manager; implemented Web Services Hub and PowerCenter LDAP authentication
  • Maintained daily backups of PowerCenter domains and repositories; ran scheduled jobs to update repository table index statistics and optimize repository performance
  • Developed and executed UNIX shell scripts to monitor and optimize disk space available on Informatica servers

Confidential, Franklin, TN

Senior Business Intelligence Data Warehouse Developer

Responsibilities:

  • Database design, development and optimization of database objects for business intelligence data warehouse operations
  • Using SQL Server 2000 and 2005, designed and implemented database objects including DTS packages, SSIS packages, stored procedures and user-defined functions to support ETL operations from a 9 TB transactional source database into a 400 GB data warehouse
  • Optimized load operations and reduced data warehouse load duration through logical and physical database design
  • Developed SQL logic with Common Table Expressions (CTE), recursion, table partitioning, and other SQL 2005 features to optimize data warehouse load processes
  • Developed scripts to re-generate all SQL database objects dynamically to improve existing code migration procedures
  • Developed stored procedures to create and maintain extended properties in SQL Server tables
  • Developed reports using SQL Server Reporting Services

Confidential, Nashville, TN

Programmer/Analyst

Responsibilities:

  • Database and application-level support for the company's proprietary Windows-based financial scorecard application
  • Created and maintained stored procedures, triggers, and functions to enforce business logic
  • Programmed in Visual Basic 6.0 and Visual Basic.NET
  • Designed new table structures and translated business requirements into statements of work
  • Identified and resolved problems in Visual Basic and T-SQL code

Confidential, Millington, TN

Senior Database Administrator/Developer

Responsibilities:

  • Designed, administered, and supported SQL Server 2000 databases to support the U.S. Navy’s retention web site
  • Scripted data transformations with Visual Basic Script and ActiveX VBScript tasks to draw data from Microsoft Access, Excel, and text data source files
  • Designed, created, migrated, and supported production databases; developed stored procedures, triggers, and DTS packages
  • Responsible for table indexing strategies, query performance tuning, database maintenance plans, backup and recovery
  • Developed web-based applications using Visual Studio .NET

Confidential, Nashville, TN

Content Developer

Responsibilities:

  • Developed content for simulation exams designed to assist users in achieving certification for various Microsoft, Novell, Oracle, Cisco, A+ and CIW (Certified Internet Webmaster) certification programs; researched troubleshooting and diagnostic procedures, discovering and documenting solutions to network, database, and infrastructure problems

Hire Now