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 asTalend (Preferred, not required)DMExpress – Nice to haveInformatica – Nice to haveDatabase - Hands on experience with the following database TechnologiesSnowflake (Required)MYSQL / PostgreSQL – Nice to haveFamiliar with NOSQL DB methodologies (Nice to have)Programming Languages – Can demonstrate knowledge of any of the following.PLSQLJavaScript Strong PlusPython - Strong PlusScala - Nice to haveAWS – Knowledge of the following AWS services :S3EMR (Concepts)EC2 (Concepts)Systems Manager / Parameter StoreUnderstands 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 / AppworxJiraSkills Required
Aws, Git, win cvs , Apache Airflow, Kafka