ETL developer

Hybrid 3 days a week onsite (Alpharetta GA)

Senior Data Analytics & Data Warehouse Developer


Position Description

We are looking for a highly motivated, hands-on Senior Database/Data Warehouse Data Analytics developer to work at our Alpharetta 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 WM Risk Integration projects. The successful candidate will be a proficient and productive developer, 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 Risk Management 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 Skills
* 5 Years of strong ETL (Informatica)/DWH design, design, and development experience.
* Practiced experience with Reporting/BI Tools (preferably BO), Data Analytics.
* Strong Data Modeling skills - Enterprise Data Model (OLTP) and Dimensional modelling. Well versed with principles, techniques, and best practices of data modelling.
* Strong Skills in MPP Database (preferably Teradata) including database design, performance tuning, writing complex DB programs etc.
* Proficient demonstratable SQL skills in at least one DB technology i.e., Teradata or any other database like Oracle, UDB. Teradata skills are preferred
* Full understanding of the processes of data quality, data cleansing and data transformation and data modeling
* Ability to understand and analyze the data to find patterns and valuable Business Insights
* Ability to write complicated yet efficient SQL queries and stored procedures
* Hands on experience with Hadoop Ecosystem is a plus.
* Demonstrate proficient skills in analysis and resolution of application performance problems.
* Detail oriented, organized, self-motivated, and ability to work independently as well as in a team environment.
* Strong familiarity with Agile project management software/tools (e.g., JIRA, etc.).
* Ability to communicate in a clear and concise manner, individually or in front of a group.

Desired skills
* Knowledge of different financial instruments like Equities, Options, Futures, etc. is a huge plus.
* Exposure to Hadoop ecosystem.
* Prior experience in financial firms is a huge plus

Education:
* Bachelor's degree in computer science engineering or a related discipline, or equivalent work experience required