Data Engineer-II
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
- 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.