Data Integration, Informatica – Consultant

Summary: This position presents a Mid-level Consulting role associated with the delivery of Data Integration solutions to OZ clients. This role is responsible for the development of Informatica Power Center artifacts in support of CX solutions. It works closely with practice leaders, OZ consultants, and client project team members. You’ll be yourself at work working with state-of-the-art data technology and creating a lasting impact on our clients. A hunger to succeed and the ability to work in a true and real consulting environment is key as this opportunity will offer the chance to make a name for yourself across the industry.

You need to have a hunger to work across processes/methodologies, technologies, industries and approaches to be successful in this role. We are looking for true consultants who understand the importance of delivering solutions for clients.


Strategy and Management

  • Ability to interact with OZ client’s project team members, OZ team leaders and OZ development teams to deliver solutions that transform customers’ experience, unlock insightful insights, and drive powerful business outcomes
  • Participated and contributed in the delivery of one of the following solutions: Data Integration, Data Transformation, Database Design, Data Governance
  • Able to effectively follow and adopt best practices, development guidelines and standards
  • Strong teamwork and interpersonal skills
  • Able to report results in a fast-paced growth environment
  • Ability to multi-task
  • Strong problem-solving and metadata skills
  • Good presentations skills with the ability to communicate on work performed and solutions

Solution Delivery

  • Ability to understand business needs and requirement specifications and develop appropriate computer instructions
  • Effectively work as an independent contributor following directions from leads
  • Communicate progresses and issues to Senior OZ Managers
  • Ability to work in environment that has adopted SDLC methodologies (Agile, SCRUM, RUP, other)



  • Bachelor’s Degree in Information Systems, Computer Science, Engineering, or a related field

Required Experience

  • Minimum of 2+ years of ETL development experience with INFORMATICA 10.x product
  • Well versed with Web Service Hub (WSH) exposing the workflows as web services, and it is must.
  • Well versed with power center/power exchange
  • Well versed with database concepts and integration with Oracle or any other database environment
  • Proficient in SQL including performance optimization and tuning, specifically Oracle PL/SQL
  • Experience with shell scripting, PowerShell, bash supporting pre/post-processing of input and output files
  • Work in developing Informatica ETL/data integration data mapping exercises
  • Develops custom and template-based data integrations using a proprietary ETL data integration platform
  • Good debugging skills. Validates end-to-end ETL/data integration processes to ensure performance, reliability, and data validity/accuracy
  • Generates sample outputs/files for validation throughout the integration development lifecycle
  • Leverages version control systems for SQL objects and ETL configurations
  • Assists with the creation of data packages to support various project phases (System Integration Testing, User Acceptance Testing, Go-live)
  • Develops required documentations on developed code
  • Supports go-live and transition to support activities


  • Fluent in English

Work authorization:

  • Must be authorized to work in United States

Work location

  • In OZ office location or OZ client site

Required travel:

  • Minimal travel

Apply for This Position

Please fill out the information as accurate as possible.


OZ is a leading global consulting company whose services and solutions enhance Customer Experience through digital innovation.