Solution Architect (Data Mart Migration)

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