Blog

Hi ,

Greetings from MSRCOSMOS      

Here is the Job Description for the below Job Opening

Qualifications:

• 5 or more years of hands-on experience as a Data Analyst or related technical engineering capacity. Relevant technologies and programming languages include JAVA, Spring Boot, Python, IBM MQ, Oracle Database table design, queries and optimization.

• Expertise in Database Design, Dimensional Modeling, and Data Warehousing.

• Hands-on experience with Erwin Data Modeling Tool and metadata management.

• 2 or more years of proven experience in working with Data Lake and Teradata.

• Proficiency in SQL for database querying, table creation, and data relationship management.

• Experience engineering software within an Amazon Web Services (AWS) cloud infrastructure or other prominent enterprise cloud provider.

• Demonstrable experience with DevOps principles, practices and tools.

• Understanding of the full Software Development Lifecycle, building CI/CD pipelines and practicing Test Driven Development is a requirement.

• Solid grasp of Agile Methodologies.

• Experience with source control, build tools and GIT (GitHub, Bitbucket or other) is required.

• High School diploma, GED or High School Equivalency.

Preferred qualifications:

• Bachelors Degree in Computer Science, Information Systems or related technical field.

• Experience working in an airline technology environment.

• Knowledge of AI/ML workflows is a plus.

Responsibilities:

Manage and transfer large data volumes via Data Lake and/or Teradata.

· Design and implement database structures that support efficient data storage and retrieval.

· Develop and maintain data models using Erwin Data Modeling Tool.

· Perform dimensional modeling and ensure data warehouse optimization.

· Write and optimize SQL queries (DMLs and DDLs) for querying databases, creating tables, and managing data relationships.

· Fine-tune queries to enhance performance and manage complex data relationships.

· Collaborate with cross-functional teams to meet AI/ML project requirements.

· Design and develop data, and infrastructure solutions, seek opportunities to optimize performance, maintain and troubleshoot application components as required.

· Design and develop with consideration for Non-Functional Requirements (Scalability, Reliability, Availability, Observability, Fault Tolerance)

· Ensure that the Delta methodology, standards, and procedures are adopted and implemented

· Design solutions to meet functional and technical requirements.

· Develop delivery pipelines and automated deployment scripts.

· Configure services, such as databases and monitoring.

· Assisting in the design, implementation and optimization of related approaches, tools and workflows.

· Align to Security/Compliance frameworks and controls requirements.

· Implement Service Reliability Engineering