Database Engineer - SQL/T-SQL (4-6 yrs)

Foreword :

At iGreenTree, we're passionate about empowering energy and utility providers with innovative IT solutions. With deep domain knowledge and a dedication to innovation, we help our clients stay ahead of the curve in a rapidly changing industry.

Whether you need IT consulting, application development, system integration, or digital transformation services, our team of experts has the expertise to deliver the right solution for your business.

Partner with iGreenTree to unleash the power of technology and achieve sustainable growth in today's dynamic landscape.

Who We Are Looking For :

An ideal candidate who must demonstrate in-depth knowledge and understanding of RDBMS concepts and experienced in writing complex queries and data integration processes in SQL/TSQL and NoSQL. This individual will be responsible for helping the design, development and implementation of new and existing applications.

Roles and Responsibilities :

- Reviews existing database designs and data management procedures and provides recommendations for improvement.

- Responsible for providing subject matter expertise in design of database schemes and performing data modeling (logical and physical models), for product feature enhancements as well as extending analytical capabilities.

- Develop technical documentation as needed.

- Architect, develop, validate and communicate Business Intelligence (BI) solutions like dashboards, reports, KPIs, instrumentation, and alert tools.

- Define data architecture requirements for cross-product integration within and across cloud-based platforms.

- Analyze, architect, develop, validate and support integrating data into SaaS platforms (like ERP, CRM, etc.) from external data source; Files (XML, CSV, XLS, etc.), APIs (REST, SOAP), RDBMS.

- Perform thorough analysis of complex data and recommend actionable strategies.

- Effectively translate data modeling and BI requirements into the design process.

- Big Data platform design i.e. tool selection, data integration, and data preparation for predictive modeling.

Required Skills :

- Minimum of 4-6 years of experience in data modeling (including conceptual, logical and physical data models.

- 2 to 3 years of experience in Extraction, Transformation and Loading ETL work using data migration tools like Talend, Informatica, DataStage, etc.

- 4 to 6 years of experience as a database developer in Oracle, MS SQL or other enterprise database with focus on building data integration processes.

- Candidate should have any NoSQL technology exposure preferably MongoDB.

- Experience in processing large data volumes indicated by experience with Big Data platforms (Teradata, Netezza, Vertica or Cloudera, Hortonworks, SAP HANA, Cassandra, etc.

- Understanding data warehousing concepts and decision support systems.

- Ability to deal with sensitive and confidential material and adhere to worldwide data security and Experience writing documentation for design and feature requirements.

- Experience developing data-intensive applications on cloud-based architectures and infrastructures such as AWS, Azure, etc.

- Excellent communication and collaboration skills.