Data Engineer

Position Description

We are looking for a highly motivated, hands-on Sr. Database/Data Warehouse Data Analytics developer to work at our Bangalore, India location. Ideal candidate will have solid software technology background with capability in the making and supporting of robust, secure, and multi-platform financial applications to contribute to Fully Paid Lending (FPL) project. The successful candidate will be a proficient and productive developer, a team leader, have good communication skills, and demonstrate ownership.

Responsibilities

• Produce service metrics, analyze trends, and identify opportunities to improve the level of service and reduce cost as appropriate.
• Responsible for design, development and maintenance of database schema and objects throughout the lifecycle of the applications.
• Supporting implemented solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance, and communicating functional and technical issues.
• Helping the team by taking care of production releases.
• Troubleshoot data issues and work with data providers for resolution.
• Closely work with business and applications teams in implementing the right design and solution for the business applications.
• Build reporting solutions for WM Risk Applications.
• Work as part of a banking Agile Squad / Fleet.
• Perform proof of concepts in new areas of development.
• Support continuous improvement of automated systems.
• Participate in all aspects of SDLC (analysis, design, coding, testing and implementation).

Required Skill

• 5 to 7 Years of strong database (SQL) Knowledge, ETL (Informatica PowerCenter), Unix Shell Scripting.
• Database (preferably Teradata) knowledge, database design, performance tuning, writing complex DB programs etc.
• Demonstrate proficient skills in analysis and resolution of application performance problems.
• Database fundamentals; relational and Datawarehouse concepts.
• Should be able to lead a team of 2-3 members and guide them in their day to work technically and functionally.
• Ensure designs, code and processes are optimized for performance, scalability, security, reliability, and maintainability.
• Understanding of requirements of large enterprise applications (security, entitlements, etc.)
• Provide technical leadership throughout the design process and guidance with regards to practices, procedures, and techniques. Serve as a guide and mentor for junior level Software Development Engineers
• Exposure to JIRA or other ALM tools to create a productive, high-quality development environment.
• Proven experience in working within an Agile framework.
• Strong problem-solving skills and the ability to produce high quality work independently and work well in a team.
• Excellent communication skills (written, interpersonal, presentation), with the ability to easily and effectively interact and negotiate with business stakeholders.
• Ability and strong desire to learn new languages, frameworks, tools, and platforms quickly.
• Growth mindset, personal excellence, collaborative spirit
• 
  

Good to have skills.

• Prior work experience with Azure or other cloud platforms such as Google Cloud, AWS, etc.
• Exposure to programming languages python/R/ java and experience with implementing Data analytics projects.
• Experience in Git and development workflows.
• Prior experience in Banking and Financial domain.
• Exposure to security-based lending is a plus.
• Experience with Reporting/BI Tools is a plus.

Job Responsibilities :

• Must have knowledge of at least two PHP frameworks out of Laravel, Cakephp, CodeIgniter and YII.
• Must have basic knowledge of HTML, CSS, JavaScript and jQuery.
• Knowledge of CMS architectures like Wordpress, Joomla, Drupal etc. will be an added advantage.
• Knowledge of eCommerce frameworks like WooCommerce, Magento, OpenCart etc will be an added advantage.
• Good knowledge of Object-Oriented Concepts & a strong passion for Software Development.
• Strong Interaction and Design Sense
• Familiarity with LAMP stack (Apache, MySQL and phpMyAdmin)
• Comfortable with SQL and/or Script Programming.
• Experience in Designing & Developing Database in MySQL is a MUST.

Required Skills:

• Knowledge and/or willingness to learn, highly motivated.
• Fully comfortable working in English, both in written and spoken language.

* Write “clean”, well-designed code

* Produce detailed specifications

* Troubleshoot, test and maintain the core product software and databases to ensure strong optimization and functionality

* Contribute in all phases of the development lifecycle

* Follow industry best practices

* Develop and deploy new features to facilitate related procedures and tools if necessary

Requirements:

* Proven software development experience in PHP

* Understanding of Frameworks like Laravel, CodeIgnitor, Wordpress, Yii, etc

* Demonstrable knowledge of web technologies including HTML, CSS, Javascript, AJAX etc

* Good knowledge of relational databases, version control tools and of developing web services

* Experience in common third-party APIs (Google, Facebook, Ebay etc)

* Passion for best design and coding practices and a desire to develop new bold ideas

* BS/MS degree in Computer Science, Engineering or a related subject

• Experience in developing large scale, highly available, complex front-end development using JavaScript, React.js and ReactNative.
• Strong knowledge in both web and mobile application development.
• Knowledge, skills, and experience to write detailed design documentation, and functional specifications for application development.
• Write well designed, efficient, reusable, and reliable code.
• Experience with popular React.js workflows (such as Flux or Redux).
• Work with other senior Developers to resolve/debug program errors.
• Knowledge and ability to apply OOD (Java, HTML, XML, Java Script, and Patterns) and impact to the application development process.
• Knowledge of Agile development methodologies (preferably Scrum).
• Knowledge of database design and data structure libraries,(e.g., Immutable.js).
• Developing new user-facing features using React.js.
• Strong proficiency in JavaScript, including DOM manipulation and the JavaScript object model.
• Actively aid the consulting team in different phases of the project including problem definition, effort estimation, diagnosis, solution generation, design development and deployment.
• Experience with data structure libraries,(e.g, Immutable.js).
• Contributing to team meetings, troubleshooting development.
• Good understanding of HTML CSS and front-end design technologies.

• Ability to establish and maintain effective working relationships, supporting company leadership and other team members.
• Ability to manage multiple and changing priorities/tasks.
• Must like to continuously improve code, product and process.
• Must work with a strong professional and ownership mindset.
• Strong working experience in JavaScript, ReactNative and ReactJs is required.
• In-depth understanding of Javascript, the DOM, and relevant concepts.
• Proficiency in Typescript.
• Should have hands-on experience with testing libraries like jest & enzyme.
• Must be strong in logic and coding abilities.
• Strong analytical and problem-solving skills.
• Must be passionate and self-motivated.
• Excellent team player and good communication skills.