Data Engineer-II

Company Description

Greater talent distinguishes great companies from the rest. Fiddich partners with organizations across the globe to optimize talent attraction and retention.

Organizations partner with Fiddich to attain the highest levels of excellence in their talent strategies. Serving as a critical partner for organizations, we take great pride in what we do — connecting great people to great opportunities, helping businesses win!

Each day, we work to be the best talent solutions provider in the world. To us, that means developing long-lasting partnerships and caring more than any other provider. We’ll go further to understand the needs of our customers, our candidates, and our employees and to deliver on our promises. That’s what differentiates us from our competitors. 

For more information, visit https://fiddichconsulting.com 

........................................................................................................................................................................

Our client is an American electronic commerce and cloud computing company with headquarters in Seattle, Washington, looking for experienced candidates to join their team. Our client is the largest Internet-based retailer in the world by total sales and market capitalization.

...............................................................................................................................................................................

Job Description

The Data Engineer should be an expert familiar with all of the data warehousing technical components (e.g. ETL, Reporting, Data Model), infrastructure (e.g. hardware and software) and their integration. The ideal candidate will be responsible for developing overall architecture and high level design. The candidate must have extensive experience with Star Schemas, Dimensional Models, Datamarts in Traditional Data Warehouses as well as in Big Data / Advanced Analytics domains. The individual is expected to bring a methodology and lead the framework development for the next generation data warehouse by designing an efficient, flexible, extensible, and scalable ETL design and mappings and also will be working extensively on building big data environment.

Excellent written and verbal communication skills are required as the candidate will work very closely with a diverse team. The candidate will also lead a small technical teams or participate in close customer interactions while having an influencing role, and be accountable for deliverables. Ability to create and manage work plans, timelines and accommodate multiple priorities is required.


Job Responsibilities

- Applies broad knowledge of technology options, technology platforms, design techniques and approaches across the data warehouse life cycle phases to design an integrated, quality solution to address the business requirements
- Meets and collaborates with business users on requirements, objectives and measures.
- Designs the technology infrastructure across all technical environments
- Ensures completeness and compatibility of the technical infrastructure to support system performance, availability and architecture requirements
- Designs and plans for the integration for all data warehouse technical components
- Supervises the technical implementation of the data warehouse and oversees hardware/ software configuration
- Provides input and recommendations on technical issues to the project manager
- Reviews technical work of other team members
- Reviews and participate in testing of the data design, tool design, data extracts/transforms, networks and hardware selections
- Develops the implementation and operation support plans

Qualifications

BASIC QUALIFICATIONS

- 5+ years of experience with and detailed knowledge of data warehouse technical architectures, infrastructure components, ETL/ ELT and reporting/analytic tools and environments, data structures.

- 3+ years of experience in architecting data warehouse solutions and integrating technical components
- 5+ years of experience with relational and star schema data modeling concepts
- Experience in relational database concepts with a solid knowledge of Oracle, SQL and PL/SQL.
-Experience in any big data technologies - Hadoop Eco Systems, EMR, Aamazon Redshift or advanced analytics tools will be plus
- 3+ years of working with very large data warehousing environment
- Demonstrated knowledge and experience in capacity planning for hardware and storage needs

PREFERRED QUALIFICATIONS
- Experience with Informatica preferred

- Knowledge of OBIEE is preferred
- Excellent communication skills, both written and verbal
- Strong ability to interact, communicate, present and influence within multiple levels of the organization

Additional Information

All your information will be kept confidential according to EEO guidelines.