CDP ETL & Database Engineer

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 Strong 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