Informatica Architect
Catalina Marketing - Saint Petersburg, FL

This job posting is no longer available on Catalina Marketing. Find similar jobs: Informatica Architect jobs - Catalina Marketing jobs

The Informatica Architect is responsible for enterprise-wide leadership and direction on ETL processes used with a variety of databases, applications, and flat files or data sources. The primary focus is developing routines to implement complex business logic, transformations and aggregations.

Job Responsibilities:
Managing Work:
Hands on development using Informatica to create initial ETL load routines and establish standards and templates

Create design pattern templates for deliverable objects

Define and implement ETL development standards and procedures

Define and implement ETL tool configuration

Ensure effective ETL functional decomposition into deliverable objects

Ensure ETL quality through inspections and knowledge sharing

Lead the design of the ETL solution; oversee the ETL low-level design and design phase deliverables; ensure that the design conforms to the overall ETL architecture

Strong analysis and design skill

Strong experience with Business Intelligence and Data Warehousing design principles and industry best practices

Deep understanding of relational design concepts and SQL programming

Plan and execute Quality Assurance testing with QA team and resolve QA defects

Plan and manage QA and production releases and assure they are deployed smoothly

Proficient in building ETL routines to load star schema models for cases such as:

Slowly changing dimensions

Late arriving facts

Late arriving dimensions

“as is/as was” reporting

Revisions to history

Surrogate keys

Helper tables

Hands on experience with Informatica

Experience with Unix/Linux environments and shell scripting

Strong database development, SQL, physical database design, and data modeling experience

Ensure adherence to architectural governance standards and practices

Develop best practices, standards of excellence, and guidelines to enforce and guide behavior

Define and validate technical and business requirements to ensure feasibility and completeness of technical solutions

Prescribe and direct prototyping activities in order to determine appropriate design option

Establish short-term and long-term strategies and implementation plans that successfully drive customer solutions

Transfer knowledge to others through teaching or sharing of ideas to include creation of industry publication, participation in industry forums, and special interest groups.

Reverse engineer and document existing data structures

Participate in creation and maintenance of an enterprise metadata dictionary and repository for data models

Actively cultivate and maintain collaborative relationships with key technical and business stakeholders to collect & disseminate knowledge

Review core applications, analyze and document data flows between systems

Work with DBAs and Application Development team to develop and maintain data standards across the enterprise

Mentor developers and DBA’s on use of enterprise ETL tools

Advise management of trends and recommend new management and ETL techniques

Other duties as required

Additional Responsibilities:
Identify areas for process improvement and provide technical guidance for implementing changes

Provide input/approval of requirements and design and participates in DBA code reviews

Provide production support for a 7x24 environment on scheduled intervals

Bachelors’ degree or equivalent experience

7+ years experience of ETL/Informatica implementations

5+ years experience using Informatica

Unix shell scripting

‘C’ programming

XML proficient

Database design and data modeling background required (minimum 5 years)

Excellent verbal and written communication skills

Strong understanding of relational database technology including data modeling (logical and physical) experience and etl tools.

Strong analytical, organizational, communication, and data management skills to provide expert knowledge of best practices enabling the team to leverage the platform as efficiently as possible

Be current with database, data modeling, and data warehousing trends and technological innovations in order to make appropriate development recommendations to support complex new systems data integration and data architecture

Gathering project requirements

Planning user interface

Designing technical specifications

Experience in building, testing, deploying, and maintaining ETL processes

Experience in all phases of the SDLC (requirements analysis, design, development, testing, and deployment)

Good understanding of SQL in accessing and manipulating data

Strong understanding of system architecture.

Application Development experience

Exposure to Business Intelligence software

Understanding of Unix, DOS and Windows operating systems

Understanding of general programming concepts

Strong data analysis, analytical and problem solving skills

Experience with some of the following software:
Current Data Warehousing Environment


Oracle Exadata




ERwin Entity Relationship Diagramming Tool

AutoSys Job Scheduling

SyncSort for Unix

‘C’ Programming

Unix shell scripting

Brio Query (Hyperion Interactive Reporting Studio) ad hoc query and reporting tool

Experience with different modeling techniques, including data modeling, UML and business process modeling

Experience with several modeling tools: CASE, ETL, EAI

Knowledgeable in most aspects of designing and constructing data architectures

Excellent written and verbal communications skills

Good organization skills

Excellent presentation skills

Able to effectively communicate technical matters to executive management

ABOUT CATALINA: The world is changing, consumers are changing and so is Catalina- we are becoming a consumer-centric, multi-channel, loyalty company, committed to helping manufacturer and retail brands deliver unprecedented performance by unleashing the power to know, engage and empower the world’s consumers. With integrated in and out-of-store marketing platforms, Catalina pioneers breakthrough consumer loyalty solutions that transform the shopping experience. We have the unique ability to listen, understand and respond to consumers over time, and we are creating ways to connect with her whenever, wherever, and however she chooses on her path to purchase.
Catalina leverages the world's largest, transaction-level, shopper-data warehouse to develop, deliver, and measure consumer and patient-driven engagements. With average promotional response rates of 6.8% - one of the highest in the industry, only Catalina knows the evolving buying decisions and individual needs of shoppers. Catalina uses this understanding to create customized, measurable campaigns that motivate high-value consumers to try new products, increase consumption and stay loyal to brands. Catalina Health adopts similar methodologies working to improve behaviors one health consumer at a time—with highly relevant and personalized messages.
At Catalina, we have the privilege of helping people make the best choices for themselves and their families. This purpose is at the heart of Catalina’s transformational change. Catalina is based in St. Petersburg, Florida, with operations in the US, Europe and Japan. To learn more, please visit

The intent of this job description is to describe the major duties and responsibilities performed by incumbents of this job. Incumbents may be required to perform other job-related tasks other than those specifically presented in this description. All duties and responsibilities are essential job functions and requirements and are subject to possible modification to reasonably accommodate individuals with disabilities. We are proud to be an EEO employer M/F/D/V. We maintain a drug-free workplace and perform pre-employment substance abuse testing.

Catalina Marketing - 24 months ago - save job - block
Recommended Jobs
IT Systems Integration Architect (R-06941)
VeriFone - Clearwater, FL
Verifone - 15 days ago

urgent need - Informatica MDM Technology Arch...
Axius Technologies Inc - Tampa, FL
Axius Technologies Inc - 13 days ago

Applications Development Manager - Paymentech...
JPMorgan Chase - Tampa, FL
JPMorgan Chase - 28 days ago
About this company
20 reviews
To reach shoppers when they are shopping, consumer packaged-goods manufacturers call on Catalina Marketing. The company's network,...