Solution Architect (Data Mart Migration)

Seattle, Washington


Employer: Cognizant Technology Solutions
Industry: Application Development / Application Maintenance
Salary: $110000 - $170000 per year
Job type: Full-Time

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 05/19/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

Qualifications
Technical Skills

SNo

Primary Skill

Proficiency Level *

Rqrd./Dsrd.

1

Data Management Functional

PL3

Required

2

Informatica SaaS CAI

PL3

Required

3

Informatica SaaS Business 360

PL3

Required

4

D365 Integrations Logic Apps

PL2

Required

5

MDM Architecture

PL3

Required

6

Informatica SaaS CDQ

PL1

Required

* Proficiency Legends

Proficiency Level

Generic Reference

PL1

The associate has basic awareness and comprehension of the skill and is in the process of acquiring this skill through various channels.

PL2

The associate possesses working knowledge of the skill, and can actively and independently apply this skill in engagements and projects.

PL3

The associate has comprehensive, in-depth and specialized knowledge of the skill. She / he has extensively demonstrated successful application of the skill in engagements or projects.

PL4

The associate can function as a subject matter expert for this skill. The associate is capable of analyzing, evaluating and synthesizing solutions using the skill.

Created: 2024-05-16
Reference: 00058565211
Country: United States
State: Washington
City: Seattle
ZIP: 98109


Similar jobs: