Solution Architect (Data Mart Migration)
Seattle, WA 
Share
Posted 14 days ago
Job Description

We are Cognizant Artificial Intelligence

Digital technologies, including analytics and AI, give companies a once-in-a-generation opportunity to perform orders of magnitude better than ever before. But clients need new business models built from analyzing customers and business operations at every angle to really understand them.

With the power to apply artificial intelligence and data science to business decisions via enterprise data management solutions, we help leading companies prototype, refine, validate and scale the most desirable products and delivery models to enterprise scale within weeks

*You must be legally authorized to work in United States without the need of employer sponsorship, now or at any time in the future *

This is an Onsite position open to any qualified applicant in the United States

Job Title: Solution Architect (Data Mart Migration)

Overview

We are seeking an experienced Solution Architect to lead the migration of data marts from Oracle Exadata to Azure Databricks using Informatica IDMC. As a Solution Architect, you will play a critical role in designing and implementing the migration strategy, ensuring seamless data transfer, and optimizing performance in the new environment.

Responsibilities

  • Data Modeling and Design:
    • Collaborate with business stakeholders and technical teams to model the existing data mart for migration.
    • Define the target architecture on Azure Databricks, considering scalability, security, and performance.
  • Data Migration:
    • Lead the migration process from Oracle Exadata to Azure Databricks using Informatica IDMC.
    • Utilize Azure Data Factory (ADF) or other suitable tools to efficiently extract data from Oracle.
    • Implement incremental data capture strategies to track changes in the source system.
  • Code Migration:
    • Convert existing ODI code to PySpark or Spark SQL.
    • Leverage open-source Python for ETL workloads.
    • Address complexities related to Oracle-specific features during code conversion.
  • Job Orchestration:
    • Design and implement job orchestration workflows for data processing.
    • Ensure smooth execution of ETL jobs in the new environment.
  • Performance Optimization:
    • Optimize data pipeline performance by leveraging Azure Databricks capabilities.
    • Monitor and fine-tune the system to meet performance requirements.
  • Documentation and Training:
    • Create detailed documentation for the migration process, including architectural diagrams, data flow, and code samples.
    • Provide training to the technical team on Azure Databricks best practices.

Qualifications

  • Proven experience as a Solution Architect, specifically in data migration projects from oracle to Azure.
  • Strong expertise in Oracle Exadata, Azure Databricks, and Informatica IDMC.
  • Proficiency in PL/SQL, PySpark, and Spark SQL.
  • Excellent communication and collaboration skills.
  • Relevant certifications (e.g., Microsoft Certified: Azure Solutions Architect Expert) are a plus.

Salary and Other Compensation:

Applications will be accepted until 04/17/2024.

The annual salary for this position is between $110,000 - $170,000 depending on experience and other qualifications of the successful candidate.

This position is also eligible for Cognizant's discretionary annual incentive program, based on performance and subject to the terms of Cognizant's applicable plans.

Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:

* Medical/Dental/Vision/Life Insurance

* Paid holidays plus Paid Time Off

* 401(k) plan and contributions

* Long-term/Short-term Disability

* Paid Parental Leave

* Employee Stock Purchase Plan

*

Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.

#LI-EV1 #CB #Ind123

Employee Status : Full Time Employee

Shift : Day Job

Travel : No

Job Posting : Apr 18 2024

About Cognizant

Cognizant (Nasdaq-100: CTSH) is one of the world's leading professional services companies, transforming clients' business, operating and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant is ranked 185 on the Fortune 500 and is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at or follow us

Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.

Cognizant is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.

If you have a disability that requires a reasonable accommodation to search for a job opening or submit an application, please email with your request and contact information.

 

Job Summary
Start Date
As soon as possible
Employment Term and Type
Regular, Full Time
Required Experience
Open
Email this Job to Yourself or a Friend
Indicates required fields