As part of the Data Integration team, the Senior Data Integration Developer position is the glue that will bring RN’s data, analytics and systems together to accomplish major initiatives such as integrating with a real-time data platform, integrating with machine learning capabilities and implementing large-scale data analytics initiatives. This role is a deep technical expert in the Informatica PowerCenter and Informatica Cloud platform and will collaborate with the broader data team (dba, analysts, and developers) to architect, design and implement critical and highly scalable data integration solutions. There are three primary areas of focus for this integral role: 1) Architecture, design and development of Informatica based processes, 2) operational support of integration processes and platform, 3) administration and maintenance of the Informatica platform.

 Essential Duties and Responsibilities

Perform responsibilities specific to data integration competencies as follows:

•Responsible for architecting, designing, developing and maintaining data integration solutions using the Informatica PowerCenter and Informatica cloud platforms

•Apply industry and tool specific design practices to Informatica design, such as using reusable or shared objects, restart-ability, caching and other design and architecture standards

•Communicate integration solution progress and updates with business users and stakeholders

•Collaborate with the data team to monitor and tune Informatica processes and mappings for performance 

•Collaborate with business analysts, data analysts, data scientists and development team members to understand the technical and data design requirements and develop the optimal integration solution

Informatica ETL Development:

•Primary resource in designing and developing the necessary code for complex applications including databases, business applications, web interfaces to multiple data repositories, data transfer between heterogeneous systems and other software systems for all internal and external business processes delivering a solid robust application, utilizing coding standards and source code development 

•Design, develop, code and test ETL code. 

•Develop integrated data sets to internal and external systems from an integrated data source 

•Document technical and architectural designs for integration processes

•Design and define test cases based on user stories and acceptance criteria

•Conduct analysis of data sources and targets and appropriate data models 

•Maintain detailed and accurate documentation per code standards 

•Coordinate the migration of all code to the various environments (QA, Production)

Operational support, platform administration and maintenance responsibilities:

•Provide 1st Level Support for the Informatica platform and operational support requests (on-call rotation)

•Proactively identify and implement technical and operational improvements to the Informatica platform and processes

•Coordinate Informatica support processes with infrastructure maintenance processes to minimize impacts to ETL jobs

•Provide development, administration and support for the Informatica Cloud-based services, including data synchronization, replication and task scheduling

•Administer Informatica software upgrades and patches

•Monitor and manage the Informatica platform (monitor operations, jobs and processes)

Position Requirements

•Bachelor’s or advanced degree in Information Technology, Math, or science discipline

•7-8 years previous data integration experience using the Informatica toolset

•7+ years Informatica PowerCenter (v9+) experience architecting, designing and developing integration solutions

•3+ years Informatica platform administration for PowerCenter and PowerExchange 

•2+ years Informatica Cloud Data integration experience

•4+ years programming in a SQL based database environment 

•Expertise with Microsoft SQL Server (Advanced TSQL/SQL writing ability) is required

•Expertise designing scalable data architectures for high-volume analytics and warehousing solutions is required 

•Experience with data warehousing, data profiling, data cleansing, data quality validation and testing is required

•Experience with data quality and data validation processes is required

•Expertise with data modeling methodologies (STAR,SnowFlake, Data lakes) is a plus 

•Experience with data science tools such as R, Python is a plus 

•Exposure to BI/analytics tools, such as MicroStrategy/tableau is a plus 

•Exposure to Salesforce CRM is a plus

•Experience with High Availability/Grid options of Informatica is a plus

•Knowledge of restaurant industry, marketing or loyalty programs is a plus

We connect diners to fantastic restaurant experiences by offering unique card-linked offers thanks to our ability to leverage advanced technology and powerful data analytics, while simultaneously providing value to our strategic partners' overall loyalty programs.

We work alongside our restaurant partners every day, sharing in the ebbs and flows of their business while helping them achieve their dreams. We provide marketing and financing that work with their business and are truly pay-for-performance. We help them increase revenue, traffic, and customer engagement. Importantly, our services do not require the merchant to discount or give away their products.

Even more, we enhance our partners' loyalty programs by offering a turn-key, scalable dining rewards program that is right for their business model and leverages their unique brand to help increase the value proposition for their customers.

Finally, we connect our millions of members to our participating restaurants, allowing them to earn the rewards they desire when dining out.

Rewards Network is an Equal Opportunity Employer (EOE). We encourage and strongly support workplace diversity.