About the job
The purpose of this role is to oversee the development of our database marketing solutions, using database technologies such as Microsoft SQL Server/Azure, Amazon Redshift, Google BigQuery. The role will be involved in design, development, troubleshooting, and issue resolution.
The role involves upgrading, enhancing, and optimizing the technical solution. It involves continuous integration and continuous deployment of various requirements changes in the business logic implementation. Interactions with internal stakeholders and/or clients to explain technology solutions and a clear understanding of client’s business requirements through which to guide optimal design/solution to meet their needs.
The ability to communicate to both technical and non-technical audiences is key.
Must Have Skills:
- Database (SQL server / Snowflake / Teradata / Redshift / Vertica / Oracle / Big query / Azure DW etc.
- ETL (Extract, Transform, Load) tool (Talend, Informatica, SSIS, DataStage, Matillion)
- Python, UNIX shell scripting, Project & resource management
- Workflow Orchestration (Tivoli, Tidal, Stonebranch)
- Client-facing skills
Good to have Skills:
- Experience in Cloud computing (one or more of AWS, Azure, GCP) . AWS Preferred.
- Key responsibilities:
- Understanding and practical knowledge of data warehouse, data mart, data modelling, data structures, databases, and data ingestion and transformation
- Strong understanding of ETL processes as well as database skills and common IT offerings i.e. storage, backups and operating system.
- Has a strong understanding of the SQL and data base programming language
- Has strong knowledge of development methodologies and tools
- Contribute to design and oversees code reviews for compliance with development standards
- Designs and implements technical vision for existing clients
- Able to convert documented requirements into technical solutions and implement the same in given timeline with quality issues.
- Able to quickly identify solutions for production failures and fix them.
- Document project architecture, explain detailed design to team and create low level to high level design.
- Perform mid to complex level tasks independently.
- Support Client, Data Scientists and Analytical Consultants working on marketing solution.
- Work with cross functional internal team and external clients.
- Strong project Management and organization skills. Ability to lead/work 1 – 2 projects of team size 2 – 3 team members.
- Code management systems which include Code review and deployments