We provide IT Staff Augmentation Services!

Sr. Informatica Architect/developer Resume

5.00/5 (Submit Your Rating)

Roseville, CA

TECHNICAL SKILLS:

System: Unix, Linux, Windows

Database: Oracle 11g, Netezza, MS - SQLServer, MySQL, Teradata on NCR, Informix 8.x, Vertica

Languages and BI Tools: Informatica PowerCenter 9.x, Netezza SQL, Oracle PL/SQL, utPL/SQL, T-SQL, K-shell w/vi editor, Business Objects Web-Intelligence (WEBI), Business Objects Universe Designer, Tableau 8Control-M, Maestro TWS, ERWin, TOAD, AquaData Studio, ServiceNow, Rational ClearCase, Rational ClearQuest, MicroFocus Cobol. IBM Mainframe, CICS, DB2, Cobol II, JCL.

EMPLOYMENT HISTORY:

Confidential, Roseville, CA

Sr. Informatica Architect/Developer

Responsibilities:

  • Develop complex Informatica Mappings/Workflows
  • Informatica 9.x Data Integration Design, Development, Maintenance
  • Linux Shell-Scripting
  • Develop Functional, Technical, Test Plan documentation
  • Troubleshoot failed data transport interfaces

Confidential, Costa Mesa, CA

Sr. Informatica Specialist

Responsibilities:

  • Informatica 9.x Data Integration Design, Development, Maintenance
  • Support Confidential ’s Brazil “Me Prejora” DOS. Nightly Load to
  • Develop Functional, Technical, Test Plan documentation
  • Troubleshoot failed data transport interfaces
  • Support DataMigration SQL-Server to Netezza

Confidential, Los Angeles, CA.

Sr. Informatica Specialist

Responsibilities:

  • Informatica 9.x Data Integration Design, Development, Maintenance
  • Support EAI Framework components within the company to facilitate data transport middleware infrastructure
  • Make use of SAP BAPI/RFC Informatica Transformations
  • Develop Functional, Technical, Test Plan documentation
  • Troubleshoot failed data transport interfaces

Confidential, Ogden, UT

Sr. Informatica Specialist

Responsibilities:

  • Informatica 9.x Data Integration Design, Development, Maintenance
  • Developed an Informatica ‘Continuous Integration’ process that in corporate Informatica command-line utilities, Rational ClearCase command-line utilities, utPL/SQL, shell-scripting in order to support a continuous and synchronized Informatica Unit Test environment with multiple release versions and the flexibility to select from several release versions for promotion to the Informatica SAT (System Acceptance Test) environment.
  • Developed Informatica Based automated unit test process for executing sessions and scoring results based on business rules stored as parameter variables. Results are versioned for reference when needed as part of a build release.
  • Developing a solution for Dynamic Source definitions.

Confidential, San Diego, CA

Sr. Business Systems Analyst

Responsibilities:

  • Gather, understand, procure approval of Business System requirements
  • Business Objects 3.1 Universe Design, Develop, Maintenance
  • Business Objects WEBI XI Report/Dashboard Design, Develop, Maintenance
  • Informatica 9.1 Data Integration Design, Develop, Maintenance
  • Informatica Cloud with Salesforce Integration
  • Translate SSIS mappings to Informatica mappings.
  • Design, Develop, Test and Deliver Business Intelligence Solutions to various BUs
  • SDLC
  • Manage customer engagement
  • Big Data exploration - Intro to Hadoop, NoSQL, Pig, Hive, ODBC Business Intelligence layer
  • Predictive Analysis initiatives.

Confidential, San Diego, CA.

Contract Consultant

Responsibilities:

  • Informatica 8.6.1 ETL (Extraction-Transform-Load) Architect, Design, Code, Test, Implement, and support mappings and workflows.
  • Oracle 11g PL/SQL Development within ETL
  • Data Warehouse Design, Star Schema, including dimensional modeling.
  • Production Support. - Rotating Support of Informatica Batch DW Loads

Confidential, San Diego, CA.

Contract Consultant

Responsibilities:

  • Design and develop Netezza SQL Analysis on over 8T and growing database
  • Familiarized with internal processes to quickly identify and resolve filer issues with software releases so that customer relationships can be improved.
  • Predictive Analysis initiatives.

Confidential, San Diego, CA.

Sr. ETL Architect/Programmer/Analyst

Responsibilities:

  • Informatica 8.6.1 ETL (Extraction-Transform-Load) Architect, Design, Code, Test, Implement, and support mapping and workflows.
  • Oracle 10g PL/SQL Development within ETL
  • Data Warehouse Design, Star Schema, including dimensional modeling.
  • Data Warehouse Design, Star Schema, ER-Win.
  • Control-M Development and Support
  • Production Support. - Rotating Support of Informatica Batch DW Loads

Confidential, Lake Forest, CA

Sr. Data Warehouse Analyst/Architect

Responsibilities:

  • Informatica 8.6.1 ETL (Extraction-Transform-Load) Architect, Design, Code, Test, Implement, and support mapping and workflows.
  • Informatica 8.6.1 Administration - monitor system, ensure continuous availability.
  • Install, upgrade, and apply patches and version updates across Dev, QA and Prod environments.
  • SQL-Server 2008 T-SQL
  • Translate SSIS mappings to Informatica mappings.
  • Data Warehouse Design, Star Schema, including dimensional modeling.
  • Business Objects - Universe Development, Web-Intelligence Report Development and Central Management Console Administration
  • Microsoft Analysis Services - Executive Dashboard KPI cube design

Confidential, Santa Ana, CA

Sr. Data Analyst/ETL Architect

Responsibilities:

  • ETL (Extraction-Transform-Load) data integration team
  • Spearhead and contribute to data integration systems projects using Informatica 8.1.x, Informatica 7.1.x, Oracle 9i, 10g, PL/SQL
  • Design, code, test, deploy, support data integration systems and subsystems using disparate data feeds to maintain a large Customer/Account OLTP system, FEDR Data Warehouse and provide time critical DSS reports
  • Experience with Informatica 8.x Data Quality and Data Profiling modules
  • Production Support, Monitor, Troubleshoot, Recover and Tune Informatica Workflows
  • Informatica 8.x Administration - monitor system, ensure continuous availability. Install, upgrade, and apply patches and version updates across Dev, QA and Prod environments.
  • Informatica Support Liaison

Confidential, Irvine, CA.

Sr. Data Analyst/ETL Architect

Responsibilities:

  • ETL (Extraction-Transformation-Load) data integration team member
  • Spearhead data integration systems projects using Informatica 7.1, Oracle PL/SQL and BMC Control-M.
  • Design, code, test, deploy, support data integration systems and subsystems using disparate data feeds to maintain a large Customer/Account OLTP system and supply downstream systems.
  • Production Support, Monitor, Troubleshoot, Recover and Tune Informatica Workflows

Confidential, Torrance, CA

Contract Consultant

Responsibilities:

  • ETL (Extraction-Transformation-Load) development with Informatica 7.1 and Oracle PL/SQL for data integration of web-based vehicle order management system.
  • Develop K-shell scripts to invoke Informatica Sessions programmatically
  • Support TOMS database development using ER-Win
  • Support Oracle Stored Procedures and Functions to support Informatica Transformation
  • Support nightly Subset Upload production load process
  • Support Informatica production builds
  • ETL (Extraction-Transformation-Load) development with Informatica 6.x/7.x and Oracle PL/SQL for data integration of new OLTP, Object-Oriented relational database, web-based claim/warranty system. extract RDBMS data, transform it, and send it back up to VSAM Legacy environment
  • Create, Support, Monitor, Troubleshoot, Recover and Tune Informatica Sessions with Informatica Repository Manager, Designer, Server Manager.
  • Set up and execute Informatica Sessions in batch and stand-alone.
  • Develop Oracle Stored Procedures and Functions to support Informatica Transformation.
  • Develop K-shell scripts to invoke Informatica Sessions programmatically
  • ETL (Extraction-Transformation-Load) development with Informatica 5.1 and Oracle PL/SQL for large Parts data warehouse.
  • Experience with ODS (Operational Data Store), Data Mart Design, and Slowly Changing Dimensions including Data Warehousing development methodologies.
  • Create, Support, Monitor, Troubleshoot, Recover and Tune Informatica Sessions with Informatica Repository Manager, Designer, Workflow Manager.

Confidential, Brea, CA

Contract Consultant

Responsibilities:

  • ETL (Extraction-Transformation-Load) development with Informatica 5.1 and Oracle PL/SQL for Very Large CRM database
  • Design and Develop Informatica Transformation Logics and Mappings
  • Experience with ODS (Operational Data Store), Data Mart Design, and Slowly Changing Dimensions including Data Warehousing development methodologies
  • Create, Support, Monitor, Troubleshoot, Recover and Tune Informatica Sessions

Confidential, Irvine, CA

Sr. Data Warehouse Administrator/ETL Developer

Responsibilities:

  • ETL (Extraction-Transformation-Load) development with Informatica 1.6.2 and Oracle PL/SQL for Very Large (Over One terabyte) CRM database.
  • Design and Develop Informatica Transformation Logics and Mappings.
  • Experience with ODS (Operational Data Store), Data Mart Design, and Slowly Changing Dimensions including Data Warehousing development methodologies.
  • Support Monitor, Troubleshoot, Recover and Tune Informatica Sessions with Informatica Server Manager.
  • Oracle 7 and 8 DBA for Large CRM database on Sun Solaris platform. Duties include database design, creation, administration, installation, upgrades, backup and recovery, migration, tuning, space allocation, object maintenance, support liaison.
  • Support Migration of Oracle Householding DW to Teradata utilizing Informatica and BTEQ scripts.
  • Assist in design of Householding DW Structure for Teradata using ER-Win

Confidential, Pasadena, CA

Sr. Oracle DBA/Manager Business Systems Support

Responsibilities:

  • Managed a website production team consisting of Oracle DBAs and Oracle database developers.
  • Supported on-sight development and staging database as well as production and standby Oracle instances at the website in San Jose, CA.
  • Database design, creation, administration, installation, upgrades, backup and recovery, migration, tuning, space allocation, object maintenance, support liaison.

We'd love your feedback!