We provide IT Staff Augmentation Services!

Informatica Architect Resume

3.00/5 (Submit Your Rating)

Pittsburg, PennsylvaniA

SUMMARY:

  • Senior Business Intelligence professional with 20+ experience in architecture, designing, developing, testing, and deploying highly effective and scalable data warehouse solutions.
  • Early project experience concentrated on complex ETL development, which translated into designing and developing data models to support business reporting and analysis requirements.
  • Well versed in proven Business Intelligence methodologies that have honed agile skills in constructing useful information systems. Integration of data quality and effective metadata strategies are the central points to delivering a viable solution.
  • Effective communicator with excellent knowledge transfer capabilities.
  • Deep experience working on large and small scale data warehouse projects holding rolls such as Business Analyst, Data Architect, Data Modeler, Tech Lead, Hands on Developer, Report Developer, and Delivery Manager.

TECHNICAL SKILLS:

BI Tools: Erwin, Toad, ORACLE Designer, Informatica DQ, Informatica MX

Reporting: 4/01, PowerPlay Administrator 6.6, Impromptu Administrator 6.0, Report Net 8.3

Business Objects: Reporter II & III - 9/00

LANGUAGE EXPERIENCE: PL/SQL, SQL, K Shell, Bourne Shell, COBOL, COBOL II, JCL, Powerbuilder 4.0Visual Basic 4.0, JAVA, HTML, XML

DATABASE SYSTEMS: ORACLE, Teradata, DB2, DB2 UDB, INFORMIX, IMS, MS SQLServer2000/2005, Lotus Notes

OPERATING SYSTEMS: UNIX, AIX, AS400, MVS, NT4.0, XP, Windows 7

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburg, Pennsylvania

Informatica Architect

Responsibilities:

  • Installed PowerExchange 10.2 in test and prod environment
  • Created LDAP group design for Axon
  • Assisted in MDM v10.2 Installation
  • Assisted in PIM v7.1.02 Installation. Imported rule set packages.
  • Collaborated on EDC security design, install, and configuration
  • Documented Informatica Onboarding procedures for new business groups to follow when adapting to new BI tools
  • Responded to PowerCenter admin issues for developers
  • Provided troubleshooting assistance to issues related to PowerCenter, BDM, and EDC development

Confidential, Richmond, Virginia

Solution Architect

Responsibilities:

  • Collaborated with BA liaisons on translating business requirements to offshore development teams.
  • Produced Solution Design Documents to serve as a guide to development team
  • Participated in Change Control Board meetings for deployment approval
  • Provided method process enhancement by suggesting the use of metadata analytical tools to help improve system design, development, and overall communication on system coding structures.
  • Lead a software evaluation of Informatica Metadata Manager against success criteria KPIs
  • Worked with development team on solving logic errors and hands - on development design.
  • Introduced Data Governance principles and began foundation discussions around creating new Data Governance policies.
  • Completed critical analysis for emergency Service Requests that had direct impact on revenue stream.

Confidential, Columbus, OH

Metadata and MDM Solution Architect

Responsibilities:

  • Created Business Requirements and Use Cases
  • Established policies and procedures to onboard new resources to metadata repository
  • Established best practices and guidelines to creating custom meta models.
  • Designed/Developed two custom meta models within Metadata Manager v10.1 for SAP BODS from tools spec-sheet and a multiuse cross reference model to link line of business terms to staging areas.
  • Harvested metadata from multiple resource types (Oracle, SQLServer, Teradata, Erwin, Data Architect, Guidewire, BODS, Salesforce, PowerCenter, Cobol Copybooks, and IBM Governance XML)
  • Configured Informatica MDM Hub v10.1 to demonstrate views of interactions
  • Configured PIM to demonstrate possible usage for Policy golden records. Create merge/match processes to eliminate duplicate records from different business group policy/rider databases. Worked with Product Manager.
  • Designed/Created PIM IDQ mappings. Created data quality checks based on various implementation channels
  • Collaborated with Data Governors and produced department compliance documents.
  • Populated data governance spreadsheets for insert into Informatica Analyst DG tool.
  • Participate in Agile project management style
  • Identified and Documented new MDM Strategies
  • Designed/Developed solution architecture with UCM and DRM systems.
  • Structured management reports related to data cleansing and classification tasks
  • Knowledge transfer sessions for DPS team for future development.

Confidential, Miramar, FL

PowerCenter Designer/Developer

Responsibilities:

  • Analyzed existing SOAP webservice calls within .NET code to reverse engineer business rules to determine email response type.
  • Designed template PowerCenter v10.1 mappings to dynamically handle SOAP request calls to various third party webservices. Such as Oracle Responsys, 15 Below, Navitaire, Hertz, Travel Guard, and Tricept
  • Replicated PowerCenter mappings into Informatica Cloud (IICS) integrations.
  • Developed a SOAP PowerCenter webservice to accept JSON strings that were converted to XML SOAP request to email campaign software. Compared performance to that of data integrations developed in Informaitca Cloud (IICS).
  • Utilized webservices tools SOAP UI and Postman to test webservice
  • Communicated to IT Director the benefits of using Metadata Manager to understand the lineage of current system processing
  • Connected to AWS API Gateway for Mobile services.
  • Developed Unstructured data objects in Informatica Developer IDQ then migrated to PC.
  • Created reusable IDQ objects for Big Data Quality absorption within Hadoop Environment.
  • Assisted in Informatica MDM install and created KPI documentation for POC.
  • Designed audit and control processing subsystem for failed email attempt reprocessing.
  • Utilized Informatica Cloud (IICS)to interface with Soap and Rest APIs for web integration, Salesforce objects as well as Amazon Web Services

Confidential, Charlottesville, VA

Metadata Solution Architect

Responsibilities:

  • Designed/Developed Informatica Cloud ETL mappings to organize security access hierarchy user structure in MySQL DB
  • Installed and configured MM9.6.1HF3 and Informatica Analysts. Migrated Business Glossary from Data Cookbook and organized business term structures and grouping from logical discussions about commonly used terminology.
  • Created metadata resources for all BI tools at UVA.
  • Designed/Developed Custom Meta Model for QlikView within Metadata Manager. Collaborated with QlikView developer to create metadata extractor scripts that pull information from Qlik QVWs. Custom model produced inner QlikView lineage as well as connections to all other BI tools.
  • Developed QlikView Dashboards for .QVW testing of internal data lineage processing
  • Develop Metadata Manager XML Rule based links.
  • Developed Informatica process to create Omit Field Level security file for attribute level user security.
  • Established Metadata manipulation best practices and procedures.
  • Set the foundation for Data Governance policies and Informatica Analyst DG tools.

Confidential, Jacksonville, FL

Application Architect

Responsibilities:

  • Worked with Business Analysts, Enterprise Architects, and SQL Technical developers to develop a customized data quality metrics data model. Used SAP PowerDesigner v16 to design and distribute a DQI Data Model.
  • Worked with Big Data Management on data governance compliance and for large structured data warehouses. Insured that data was at a high quality per specifications for analytic applications.
  • Developed complex Teradata SQL modules for data quality measurement to be stored in DQI Model
  • Coordinated with BI team to satisfy all stringent system documentation requires and metadata gathering.
  • Designed and delivered comprehensive system architecture diagrams for knowledge transfer and system documentation purposes.
  • Designed and developed Scorecard and Reporting Dashboards using Tableau 8.2
  • Conducted code reviews and analysis walkthroughs of BI work products
  • Maintained highly sensitive and confidential DW Quality distribution reports.

Confidential, New York, NY

Metadata Architect

Responsibilities:

  • Developed custom meta models in Informatica Metadata Manager (IMM) for ETL Tool engines Pentaho, SSIS, DataStage, Custom SQL, and PeopleSoft trace files.
  • Created design documents and provided logical direction to Talend developers to create java executable objects that propagated metadata from the respective ETL repositories to IMM repository.
  • Used new metadata tool called AnalytixDS Mapping Manager to be the hub of all metadata from the different ETL Metadata Repositories.
  • Maintained MSProject project plan and communicated project status to client and Application heads.
  • Developed multiple Business Glossaries within IMM to serve as the initiation point for all Data Lineage diagrams.

Confidential, Springfield, IL

Metadata Architect

Responsibilities:

  • Worked with Business Analysts, SMEs, and developers to gather business metadata artifacts to establish a baseline collection of resource information.
  • Configured Informatica Metadata Manager & Business Glossary’s to support a multi-business user multi-tiered security model. Used Informatica Admin Console to implement security model.
  • Designed and documented a best practices ETL coding standards methodology for developers to adapt. Conducted at length discussions evangelizing documentation techniques and a detailed survey of Informatica v9.1 Mappings and workflows.
  • Instructed classes and mentored business and technical users/developers on metadata creation tools, documentation style and efficiency. Key focus on proposed business term publication procedures and standards.
  • Mentored junior developers on key technical and concept based issues.
  • Used CA Erwin v7.0 to reverse engineer all subject area Teradata v14.1 databases and create a reclassification logical model scheme of every column from every table within the EDW.
  • Suggested and assisted an Informatica v9.1 to v9.5 migration.
  • Migrated all subject area business terms and validated all data lineage reports to be valid and accurate.
  • Installed Informatica MDM and configured hub for State Wide Baby Health Data.
  • Data Cleansing analysis for marriage and divorce data

Confidential, Coral Gables, FL

BI Architect

Responsibilities:

  • Installed OBIEE 7.9.6.4 / Informatica 9.1 and all other tools for R12 environment.
  • Installed OBIEE Financial Analytics Package
  • Guided business stake holders through GL codes exercise to set global environment variables
  • Implemented design and coding standards for ETL processing
  • Created DW Attribute Data Lineage Document using Metadata Manager
  • Migrated ETL mappings from Oracle Data Interfaces (ODI) to Informatica v9.1
  • Coded Informatica template mappings that were replicated throughout ETL environment
  • Translated legacy ‘Points System’ written in SSIS code to PowerCenter mappings
  • Mentoring of team members on best practices and issue resolution
  • Facilitated production deployment

Confidential, Miami, FL

ETL Architect / Analyst/ Data Modeler

Responsibilities:

  • Was responsible for a strategic advisement to focus more on design when embarking on adding new staging areas. It was estimated that spending 30% more time on design and team colaboration, 60% less was spent on development and rework.
  • Designed and developed ETL control and audit process
  • Constructed POC using Pentaho
  • Created Informatica mapping templates for engine fault code processing. Large amounts of truck code tracking data. Used to analyize truck systems to anticpate repairs to minimize costs.
  • Data modeled a star schema for Fault Code data using Erwin r7.
  • Initialized (installed/connected) the use of Metadata Manager and expressed to PM the advantages of the use of metadata for a cleaner ETL environment.
  • Sourced Netezza and targeted Greenplum and SQLServer.
  • Used Greenplum GPLoad bulk laoder utility
  • Provided tech lead support to other team members

Confidential, Miami, FL

ETL Developer

Responsibilities:

  • Designed and developed Informatica 9.1 ETL processing.
  • Reversed engineered Pentaho ETL mappings into PowerCenter
  • Worked within a team to extract CDC data from Progress and Mincron databases to populate a Sybase IQ target.
  • High entisive work environment with complex transformations on very wide target tables. Tedious work within a very short timeframe.

Confidential, Highstown, New Jersey

ETL Architect/Design/Developer/Data Modeler

Responsibilities:

  • Designed Global Sales Reportin mult-dimensional star schema data mart
  • Extracted data from ERP systems, JDEdwrds, SAP, Prism, and a propietary system based in China
  • Created detailed mapping specs from conversations with Business SMEs
  • Developed and test Informatica 9.1 ETL processing

Confidential

Project Manager/Designer/Developer/Architect

Responsibilities:

  • Coordinated acquisition of multimedia license from local and federal government
  • Designed wireless transmission towers for installation around city
  • Manage IT team for configuring and maintaining system
  • Manage Installers staff for mounting antennas on wireless customers roofs
  • Manage financier and accounting process
  • Main contact for customer service issues

Confidential, Orlando, FL

Designer/Developer/Advisor

Responsibilities:

  • Redesigned parts of data model to adhere more dimensionalized model to support analytical processing.
  • Designed and developed Informatica mappings/workflows that were completely developed instead of complicated SQL overrides
  • Redesigned and developed simpler and streamlined mappings that reduced the redundancy of data movement with less processing table to promote a cleaner system
  • Provided guidance to team lead on best practices on business intelligence solutions. Most importantly solution delivery methodology practices.
  • Completed detailed documentation on system processing
  • Worked closely with .NET developer for easier data access views and analysis reporting

Confidential, Burbank, CA

Data Mart / ETL Architect

Responsibilities:

  • Sole designer a hybrid multi-dimensional star schema
  • Sole designer / developer of Informatica 8.6 ETL processing
  • Created source XML feeds that various information gathering vendor websites tracking data sent as sources to Nexus Data Mart
  • Created detailed documentation that included, but not limited to: Level 1 / 2 diagrams, Application distribution diagrams, source to target mapping specs, XML layouts, data dictionary, Logical and Physical Star Schema data model diagrams.

Confidential, Minneapolis, MN

ETL Team Lead/Data Warehouse Architect

Responsibilities:

  • Developed coding standards for Informatica Applications
  • Designed and implemented a systematic code migration strategy utilizing the 255 repository license agreement between Informatica and Confidential .
  • Created and maintained PowerExchange plugins for legacy mainframe data.
  • Designed mapping specifications for a team of ETL developers. As well as developed common ETL routines to be integrated among developers processing.
  • Worked with developers during crunch time to meet aggressive deadline in standardizing existing Informatica ETL code. Mainly removing complex SQL in overrides and re-coded using Informatica transformation objects. This was done for ease in future enhancements in ETL code.
  • Coordinated business rule design sessions and how they translate to new workflow constructs for the new converged data marts.
  • Conducted code walk-thrus and enforced coding and metadata standards.
  • Served as Tech lead on technical direction for processing issues.
  • Managed deliverables
  • Tracked milestones
  • Reported status to Project Manager

Confidential, Bloomington, IL

Business Intelligence Solution Designer/Architect

Responsibilities:

  • Constructed end-to-end business intelligence (BI) solution designs to meet business functionality requirements, leveraged data assets to align to the data architecture direction. Specifically identified BO as analysis tool complete with dashboards, static and ad-hoc reporting.
  • Participated in the pre-project planning process alongside business partners, initiative teams, and component coordinators to identify the appropriate assets to meet business functionality and the high-level designs associated with the BI portion.
  • Defined iterations for moving through the BI maturity stages to support both quick time-to-market for business functionality and more efficient enterprise consumption (less cost and ease of use).
  • Produced solution design packets, (containing Level 1 and 2 diagrams and other design documents), that were implemented by project teams. All doc managed and distributed through sharepoint.
  • Served as an experienced high level BI resource, especially during the project implementation phase, to insure BIRA adherence and to assist BI Project Lead in the delivery of the solution design.
  • Served as a technical resource to business partners for developing external vendor relationships that have impact on future BI Initiatives.
  • Mentored BI Project Lead - Enabled others to develop as solution designers through guidance and growing knowledge and skills
  • Partnered component coordinator(s) and service manager to deliver Business Case and high level work estimates

Confidential, Chicago, IL

Project Solutions Manager / Marketing Executive / Data Warehouse Learning Series Designer

Responsibilities:

  • Responsible for generating new client project leads.
  • Manage technology partner relationship between Intersect and Informatica
  • Provide technical advice to onsite project mangers for data warehousing projects
  • Host speaking engagements that discuss topics surrounding Business Intelligence
  • Developed Internal Informatica Training Module. Consisted of ETL coding practice exercises and design methodology techniques to teach junior level consultants new skills in data warehouse design and development.
  • Designed and Documented Source to Target Mapping instruction specifications
  • Created step by step Informatica 8.5 Mapping instructions
  • Targeted SQLServer 2000/2005 and Teradata
  • Emphasis placed on metadata capture and reporting
  • Developed a POC for the uses of Informatica Business Glossary and metadata management capabilities.
  • PowerExhcange config for legacy data
  • Conducted the training class

Confidential, Auburn Hills, MI

Lead ETL Architect / Designer / Developer

Responsibilities:

  • Conducted an analysis interview session to specifically identify business requirements and enhancements to parts sales data analysis
  • Utilized UML to create architecture documentation. Business logical documents meant for explaining BI solution direction during business user review sessions.
  • Created detailed system design documentation
  • Conducted code reviews and design signoff procedures
  • Communicated project change requests to upper project management
  • Developed mappings and workflows with Informatica PowerCenter 7.1.3. Developed entire system that consisted of 40 mappings that populated both the ODS and star schema reporting database
  • Designed and documented data model with Erwin
  • Utilized push down features of Informatica for database load performance tuning.
  • Oracle target DBMS
  • Translated legacy Oracle Designer modules and Sunopsis (ODI) for documentation purposes
  • Custom PL/SQL
  • Custom UNIX/ Perl shell scripting for workflow scheduling

Confidential, Chicago, IL

Team Lead Architect / ETL Audit Control Designer / Developer / Issue Management

Responsibilities:

  • Tracking team milestones
  • Code walkthroughs and signoff
  • Status checkpoint management
  • Reporting to Upper project management
  • System Design and Knowledge Transfer documentation (Sharepoint)
  • Development with Informatica PowerCenter 7.1.3
  • Developed an instream audit and control processing system that consisted of self generating parameter files and file cleanup.
  • Migration and development with Informatica PowerCenter 8.1.1
  • Teradata was target DBMS
  • Designed and documented data model with Erwin
  • Custom PL/SQL
  • Custom UNIX/ Perl shell scripting for workflow scheduling

Confidential, Bensenville, IL

Lead ETL Manager / Developer / Business Analyst

Responsibilities:

  • Sub-project plan creation (MSProject)
  • Team member milestone tracking
  • Status reporting and documentation
  • Sharepoint Distribution
  • Issue tracking guardian
  • Designed and Developed mappings and workflows with Informatica PowerCenter 6.2. Data sourced from SQL Server, flat files, and XML files. Event based processing used with MQSeries plugin.
  • Maintained metadata and data models with Erwin
  • Utilized Informatica Metadata Exchange to sync metadata between Erwin/SQLSVR/Informatica/BO
  • SQLServer2000/2005
  • Cloned Infromatica processes with MS DTS/SSIS
  • Oracle 9i
  • Performance Tuning
  • PL/SQL
  • UNIX shell scripting

Confidential, Northbrook, IL

Data Warehouse Developer

Responsibilities:

  • Three person architecture team
  • Acted as liaison between business and IT for development and deployment
  • Translated business analyst requirements into traceable milestones
  • Project plan creation
  • Lead Developer
  • Designed and Developed star schema population mappings and workflows with Informatica PowerCenter 6.7
  • Reversed engineered Sunopsis ETL tool code to PowerCenter mappings.
  • Oracle 9
  • Oracle Designer
  • PL/SQL

We'd love your feedback!