Description

You will design and implement complex integration workflows and data models for large-scale enterprise data warehouse and data lake environments.

Responsibilities

• Build and analyze complex integration workflows from heterogeneous data sources.
• Develop reusable utility packages and implement advanced SQL and PL/SQL techniques.
• Design integration solutions for both batch and real-time patterns across on-prem and cloud environments.
• Analyze and recommend short-term and long-term solutions for production issues.
• Collaborate with infrastructure, network, development, BA, and QA teams to deliver full lifecycle development.

Required Skills

• 5+ years of software engineering experience.
• 5+ years of experience in large scale RDBMS environments or Google BigQuery.
• 2+ years of Exadata or Google BigQuery experience.
• 4+ years of experience with Informatica PowerCenter or IICS.
• 1+ years of experience with Erwin.
• Advanced SQL and PL/SQL techniques.
• Unix shell and Python scripting.
• Data modeling and integration design for Data Lake and Data Warehousing.
• Experience in code automation and automated testing.

Preferred Skills

• Experience with streaming technologies such as Kafka or STRIIM.
• Familiarity with Informatica tools including Metadata Manager, Analyst, DV0, or Data Quality.
• Experience with non-relational DB technologies.

Key Skills

Education

Bachelor's degree