01Overview
Job Requirements
- The CDP ETL & Database Engineer will be well versed in the following areas:
- Relational data modeling
- ETL and FTP concepts
- Advanced Analytics using SQL Functions
- Cloud technologies - AWS, Snowflake
- Able to decipher requirements, provide recommendations, and implement solutions within predefined timeframes.
- The ability to work independently, but at the same time, the individual will be called upon to contribute in a team setting.
- The engineer will be able to confidently communicate status, raise exceptions, and voice concerns to their direct manager.
- Participate in internal client project status meetings with the Solution/Delivery management teams.
- When required, collaborate with the Business Solutions Analyst (BSA) to solidify requirements.
- Ability to work in a fast paced, agile environment; the individual will be able to work with a sense of urgency when escalated issues arise.
- Strong communication and interpersonal skills, ability to multitask and prioritize workload based on client demand.
- Familiarity with Jira for workflow mgmt., and time allocation.
- Familiarity with Scrum framework, backlog, planning, sprints, story points, retrospectives etc.
Required Skills
- ETL ETL tools such as
- Talend (Preferred, not required)
- DMExpress Nice to have
- Informatica Nice to have
- Database - Hands on experience with the following database Technologies
- Snowflake (Required)
- MYSQL/PostgreSQL Nice to have
- Familiar with NOSQL DB methodologies (Nice to have)
- Programming Languages Can demonstrate knowledge of any of the following.
- PLSQL
- JavaScript Solid Plus
- Python - Strong Plus
- Scala - Nice to have
- AWS Knowledge of the following AWS services:
- S3
- EMR (Concepts)
- EC2 (Concepts)
- Systems Manager / Parameter Store
- Understands JSON Data structures, key value pair.
- Working knowledge of Code Repositories such as GIT, Win CVS, SVN.
- Workflow management tools such as Apache Airflow, Kafka, Automic/Appworx
- Jira .
