5+ year experience in software engineering.5+ year experience in large scale RDBMS environments or Google BigQuery2+ years of Exadata experience OR Google BigQuery4+ year experience with Informatica PowerCenter or IICSOne or more years experience in ErwinExperience in code automation (e.g. pattern-based integration)Experience in advanced SQL and PL / SQL techniquesExperience in building re-usable Utility packagesExperience with testing the codeFocus on continuous improvementExperience in Unix shell and Python scriptingIntegration design & data modeling skills in Data Lake and Data Warehousing environmentsExperience with Streaming technologies is a plus(STRIIM, Kafka, etc)Experience with other Informatica tools is plus e.g., Metadata manager, Analyst, DVO, Data QualityExposure to both on-prem and cloud Integration solutionsFamiliarity with non-relational DB technologies is a plusExperience with automated testingExperience with both batch and real-time patterns for integrationsAbility to build and analyze complex integration workflows from heterogeneous data sourcesExperienced 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 termExcellent communication skills (both verbal and written)Proven ability to provide strong problem-solving skills.Must be self-motivated and know when to seek guidanceMust be flexible, be able to change priorities quickly, and handle multiple tasks concurrentlyIndividual must be self-starter and capable of working independently as well as part of a teamCapable of learning new tools and technologiesRoles & 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