SQL Data Analyst

Company: Synechron Inc.
Location: Charlotte, North Carolina, United States
Type: Full-time
Posted: 17.MAR.2020
< >

Summary

Synechron is one of the fastest-growing digital, business consulting technology firms in the world. Specialized in financial services, the b...

Description

Synechron is one of the fastest-growing digital, business consulting technology firms in the world. Specialized in financial services, the businessrsquo focus on embracing the most cutting-edge innovations combined with expert knowledge and technical expertise has allowed Synechron to reach 500+ million in annual revenue, 8,000 employees and 18 offices worldwide. Synechron is agile enough to invest RD into the latest technologies to help financial services firms stand at the cuttingz-edge of innovation yet, also large enough to scale any global project. Learn more at http Synechron draws on over 15 years of financial services IT consulting experience to provide expert systems integration expertise and technical development work in highly-complex areas within financial services. This includes Enterprise Architecture Strategy, Application Development Maintenance, Quality Assurance, Infrastructure Management, Data Analytics and Cloud Computing. Synechron is one of the worldrsquos leading systems integrators for specialist technology solutions including Murex, Calypso, Pega, and others and also provides traditional offshoring capabilities with off-shore development centers located in Pune, Bangalore, Hyderabad, and Chennai as well as near-shoring capabilities for European banks with development centers in Serbia. Synechronrsquos technology team works with traditional technologies and platforms like Java, C++, Python, and others as well as the most cutting-edge technologies from blockchain to artificial intelligence. Learn more at httpsynechron.comtechnology httpsynechron.comtechnology20 Synechron Inc is seeking SQL Data Analyst in financial services to join our Charlotte, NC team. Job Responsibilities Work as a Business AnalystData Analyst interacting with businessSME and relaying the information back to developers. 60 to 70 working as Business AnalystData Analyst and the remaining 40 to 30 as a developer(PLSQLSQLOracle) Prepare source to target mapping document with transformation rules. Create pseudo code with all lsquoWHERE clausesrsquo, lsquoJOINsrsquo etc. based on business requirements. Work with SQL development team to get the database objects createdunit tested Note there is a separate team of Oracle SQL developers. Perform unit testing by executing SQL queries of database objects prior to handing over to QA team. Work with QA team as and when defects are raised to understand if it is a lsquocode errorrsquo, lsquologic errorrsquo or lsquodata errorrsquo. Hand over lsquocode errorrsquo to development team. Resolve lsquologic errorrsquo by working with business team. Resolve lsquodata errorrsquo by bringing in mini-workshop. Work with UAT team and lsquohand holdrsquo them during their testing by providing correct data and explaining the possible scenarios. Work with ETL team if there is any data movement. Experience of Agile process and hands on Jira application. Create features, stories, and its life-cycle etc. Skills Required Investment Management domain experience is a plus. Experience using collaboration tools like jira andor confluence. Must have strong SQL skills to analyze data but not expected to create any database views or stored procedure. Experience with agile development methodology which includes story grooming, story creation, story prioritization As part of the job, candidate should be part of daily stand-up, Sprint planning and Sprint retrospective meeting.

 
Apply Now

Share

Free eBook

Flash-bkgn
Loader2 Processing ...