- The Data Engineer performs design, development and implementation of integration processes for both the Enterprise Data lake, Data Warehouse and Applications
- Analyzes requirements and existing resources to create efficient database and integration designs that meet company IT standards.
- Works with project and business analyst leads to develop and clarify in-depth technical requirements.
- Participates in all phases of the integration development lifecycle, including unit testing, quality assurance (QA) and ongoing support.
- Helps with Production support as needed
- Helps define and adheres to team working agreements
- Daily attend team standups and agile ceremonies
- Collaborate and work closely with other teammates
- Have a “test-first” attitude with a focus on automation
- Employ best practices around observability, monitoring, and system resilience
Desired Qualifications & Experiences:
- Nine years of experience in software engineering.
- Five or more years’ experience in large scale RDBMS environments or Google BigQuery
- Three or more years of Exadata experience OR Google BigQuery
- Four or more years’ experience with Informatica PowerCenter or IICS
- One or more years experience in Erwin
- Experience in code automation (e.g. pattern based integration)
- Experience in advanced SQL and PL/SQL techniques
- Experience in building re-usable Utility packages
- Experience with testing the code
- Experience in Unix shell and Python scripting
- Integration design & data modeling skills in Data lake and Data Warehousing environments
- Exposure to both on-prem and cloud Integration solutions
- Familiarity with non-relational DB technologies is a plus
- Experience with automated testing
- Experience with both batch and real-time patterns for integrations
- Ability to build and analyze complex integration workflows from heterogeneous data sources
- Experienced in large Enterprise Data Warehouse & Integration projects.
- Strong background in full lifecycle development using multiple platforms or languages.
- Ability to interact at a technical and non-technical level with Infrastructure, Network, Development, BA and QA teams.
- Development experience in high transaction/high availability systems.
- Experience with analyzing and recommending solutions for Production issues short-term and long term