Netezza_Data Engineer
IBM
- Mumbai, Maharashtra
- Permanent
- Full-time
Software Developers at IBM are the backbone of our strategic initiatives to design, code, test, and provide industry-leading solutions that make the world run today - planes and trains take off on time, bank transactions complete in the blink of an eye and the world remains safe because of the work our software developers do. Whether you are working on projects internally or for a client, software development is critical to the success of IBM and our clients worldwide. At IBM, you will use the latest software development tools, techniques and approaches and work with leading minds in the industry to build solutions you can be proud of.Your Role and Responsibilities
As an Netezza Engineer, you would be responsible for:
- Working closely with Database Administrator’s and BI architects, Infrastructure Architects to implement Netezza solutions.
- Actively participate in business requirements gathering sessions and understand client requirements.
- Assist PM in planning and driving low level project tasks.
- Mentor team of technical consultants and oversee their work items.
- Create deployment documents for design database, backup strategy and Maintenance windows.
- Debug critical technical issues and provide prompt resolutions and work with IBM Support for hardware maintenance.
- Highlight technical issues and challenges and propose creative solutions.
- Train junior technical resources in Netezza and other replication technologies.
- Manage Platform Migrations projects from other technologies to Netezza.
- Create backup and recovery strategy.
- Should be able to design deploy Netezza Replication Services.
- 12+ years of experience in software services.
- 7+ years of experience implementing solution on Netezza.
- Good understanding of data modelling and ability of writing SQL queries
- Very good Understanding of Netezza tools
- Very good Understanding of Netezza Metadata tables
- Expert with SQL Tuning and understanding JOIN Processing
- Export with writing Procedures.
- Export of planning data distribution.
- Excellent verbal and written communication skills are essential.
- Must have deep understanding of methods to tune SQL queries performance.
- Must have deep understanding of Workload scheduling for Netezza.
- Must have good understanding regarding data ingestion flows.
- Must have clarity of Data Warehouse Concept and data model patterns like snowflake, star schema, OLTP.
- Should be able to work on backup and recovery of database.
- Manage higher availability of the database on Netezza.
- Schedule Maintenance windows for optimal platform usage.
- Should be able to work on backup and recovery of database.
- Manage higher availability of the database on Netezza.
- Schedule Maintenance windows for optimal platform usage.
- Good to have Knowledge: Strong DBA exposure, Data Modelling, and good exposure of Operating system.
- Knowledge of competitive platforms.
- Help team capturing overall requirement, generate concept, design and drive solution implementation