12 Jun
Sr Data Warehouse Engineer
Vacancy expired!
Send your responses to Radhika @ or call
Job Title: Sr Data Warehouse EngineerJob Type: ContractorDuration: 6+ monthsHours & Location: M-F, 40 hours/week US-AZ Time. This role will be remote while COVID restrictions are in place.Work Authorization: Must be authorized to work for any employer in the US. Education: Bachelor’s or Master’s Degree in Statistics, Math, Computer Science, ManagementInformation Systems, Data Analytics or another quantitative discipline, or equivalent work experience Requirements:- 10+ years of proven experience in multiple database platforms, including Oracle, SQL Server, Teradata and Postgres.
- 10+ years of experience in design, development, deployment and support activities using ETL tools Informatica, Pentaho, Talend or SSIS.
- 5+ years of experience in DW production support, troubleshooting and resolving data load errors.
- Minimum 2 years of experience in consuming data from REST API’s and Kafka events.
- Minimum 2 years of experience with JSON, XML and CSV sources
- Strong Analytical and dimensional modeling background is required.
- Demonstrated ability to take initiative, solve complex data problems and make sound decisions.
- Advanced experience with Data visualization tools (Tableau, Power BI)
- Experience in designing highly available Data Warehouse architecture, including identifying and deploying appropriate replication and monitoring capabilities for operational effectiveness.
- Demonstrated experience in all phases of software development including requirements analysis, design, coding, testing, debugging, implementation, and support
- Demonstrated expertise in designing and implementing ETL/ELT processes using established industry best practices
- Strong experience in Relational Data Modelling and Dimensional Data modeling (starschema) and slowly changing dimensions.
- Advanced experience in writing ad-hoc complex SQL Queries (Oracle and Postgres). Query optimizations and performance improvements.
- Minimum 5 years of experience with Database procedural languages(PL/SQL, PG/SQL)
- 5+ years’ experience with the analysis of business processes, workflow, data mapping and cross-data integration in a complex data warehouse environment.
- In depth understanding of data cleansing, data auditing, data profiling, data modeling, entity-relationship modeling and dimensions modeling.
- Experience in Java, python programming.
Vacancy expired!