Data Engineer-II

Fiddich Consulting; Hyderabad; On-site; INR 1,000,000 - 2,000,000; Full time

Job summary

Fiddich Consulting is seeking a Data Engineer in Hyderabad, India, to design and implement data warehouse solutions. The role involves developing architecture, working with ETL processes, and collaborating closely with business users and technical teams.

The ideal candidate will have 5+ years of experience in data warehousing, strong knowledge of SQL and Oracle, and familiarity with big data technologies such as Hadoop. Excellent communication skills are a must.

Qualifications

• 5+ years of experience with data warehouse technical architectures and ETL/ELT.
• 3+ years in architecting data warehouse solutions.
• Experience with big data technologies like Hadoop and Amazon Redshift.

Responsibilities

• Design integrated solutions across the data warehouse lifecycle.
• Collaborate with business users to gather requirements.
• Supervise the implementation of the data warehouse.

Skills

Data warehousing technical architectures

ETL/ELT

Data modeling

Oracle

SQL

Big data technologies

Informatica

OBIEE

Job description

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 participates in testing of the data design, tool design, data extracts/transforms, networks and hardware selections
• Develops the implementation and operation support plans

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, Amazon 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.