DATABASE DEVELOPER

Role: Database Developer/Data Analyst

Location: Rutherford NJ (3 days onsite - Hybrid) Duration: 12 months

Senior Data modeler / Database developer position. Candidate will be leading a team of data modelers, data analysts and database developers to design, build and maintain relational and dimensional databases supporting multiple business initiatives / work streams.

Key Responsibilities include.

• Design, build and maintain the transactional / operational and analytical data stores

• Maintain the existing data warehouses and Design subject area wise data marts / cubes to facilitate aggregation, slicing and dicing of data by reporting tools such as Tableau and Micro Strategy

• Undertake extraction, transformation and population of the data warehouse and data mart.

• Evaluate new data sources for adherence to the organization's quality standards and ease of integration.

• Interface with Data governance teams to leverage central data repositories

• Interface with Business and technical teams on Requirements and functional analysis

• Providing expertise in technical analysis and solving technical issues during project delivery

• Provide Technical Leadership to a team of developers, modelers and analysts

• Work proactively & independently to address project requirements, and articulate issues/challenges with enough lead time to address project delivery risks

• Support the Quality Assurance team during Product Test phase

• Provide bug fixes and level-3 support to troubleshoot Production problems whenever needed

• Application Database Performance tuning

Job Skills/Qualifications

• 10+ Years of project experience as database modeler / Data warehouse architect within a distributed, service-based enterprise environment for financial institutions

• Demonstrated experience creating conceptual, logical and physical models. (ERD, normalized and dimensional models)

• Previous experience w/Metadata management strategies and implementation

• Demonstrates expertise in a variety of data warehousing and business intelligence concepts, practices, and procedures.

• Hands-on experience with ETL design and development best practices.

• Experience with Tools like ERwin Data Modeler tools/Power Designer

• Hands-on experience with implementing Big Data storage Technologies

• Experience with systems / applications in Risk and Controls technology for financial institutions is preferred

• Previous experience conducting requirements gathering and design sessions with customers.

• Previous experience producing written deliverables for technical designs.

• Understanding of indexing, partitioning and data design performance considerations for industry standard DBMS

• Strong understanding of software development life cycle and Release Management

• Ability to design, organize, and implement module, perform system testing, plan and automate tasks to maintain existing system

• Ability to research and trouble-shoot application problems

• Highly motivated team player, Excellent communication and interpersonal skills

• Excellent analytical and troubleshooting skills

• Ability to balance multiple demands and work both independently and as part of a team to develop solutions

• Excellent analytical and troubleshooting skills

Thanks & Regards, Ramyasree US IT RECRUITER Thought wave Software and Solutions 314 N. Lake St, Suite 6, Aurora IL 60506 Desk: 6302164696 Email:ramyasree@thoughtwavesoft.com LinkedIn: https://www.linkedin.com/in/ramya-sree-kolla-519839221/

A Certified Minority Business Enterprise, Disadvantaged Business Enterprise, SAM.gov, SOC2 & ISO2005, Vendors for: · STATES: IL, PA, TN, AK, OR, CT, GA, VA, ID, IA, UT, FL, MN & CO, · NATIONAL LABS: ARGONNE & FERMI, · COUNTIES: HENNEPIN, MN, FULTON & GA, · PUBLIC SCHOOLS: ATLANTA.