Vacancy expired!
Software Guidance & Assistance, Inc., (SGA), is searching for a Data Analytics & Data Warehouse developer for a Contract assignment with one of our premier F inancial Services clients in Alpharetta, GA. 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
- 5+ Years of strong ETL (Informatica)/DWH design, design, and development experience.
- Bachelor's Degree
- 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.
- Demonstrate proficient skills in analysis and resolution of application performance problems.
- Very strong 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
- Experience with Hadoop Ecosystem is a plus.
- 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
- Masters or Bachelor's degree in Computer Science
- ID: #23502487
- State: Georgia Alpharetta 30004 Alpharetta USA
- City: Alpharetta
- Salary: USD TBD TBD
- Job type: Contract
- Showed: 2021-11-26
- Deadline: 2022-01-24
- Category: Software/QA/DBA/etc