Data Engineer

5+ year experience in software engineering. 5+ year experience in large scale RDBMS environments or Google BigQuery 2+ years of Exadata experience OR Google BigQuery 4+ year 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 Focus on continuous improvement Experience in Unix shell and Python scripting Integration design & data modeling skills in Data Lake and Data Warehousing environments Experience with Streaming technologies is a plus(STRIIM, Kafka, etc) Experience with other Informatica tools is plus e.g., Metadata manager, Analyst, DVO, Data Quality 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 Excellent communication skills (both verbal and written) Proven ability to provide strong problem-solving skills. Must be self-motivated and know when to seek guidance Must be flexible, be able to change priorities quickly, and handle multiple tasks concurrently Individual must be self-starter and capable of working independently as well as part of a team Capable of learning new tools and technologies Roles & Responsibilities:

ETL Engineer performs design, development and implementation of integration processes for both 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

#LI-RJ2

Salary Range - $90,000-$120,000 a year