The Sr. Data Migration And Reporting Specialist candidate is responsible for analyzing, mapping, transforming and migrating legacy data (various formats) E2E, as well as developing and delivering reusable client-facing Management Information (MI), Bordereaux (bdx) reports, and internal Operational Business and Accounting reports. The candidate will also provide support as-needed for databases and reports, and will focus on both the logical and physical aspects of the database and application data.
Responsibilities
- Create scripts for new database migrations and/or changes to existing scripts.
- Understand the needs and requirements of the applications using the databases and provide support for these applications.
- Author, enhance and debug complex SQL code for data migration and reporting projects.
- Performance tuning and optimizing reporting queries.
- Ensure accurate check-ins, useful commenting and timely updating of shared development code repositories for documentation, data migration files, and report deliverables.
- Gather requirements, create documentation and specifications, develop, test and deliver required reports in response to business user needs.
- Provide guidance to junior members of the team.
- Work within and/or enhance existing data migration methodologies for new data migration projects.
- Work with development staff to develop, maintain and enhance data migration and reporting methodologies, coding standards, and quality assurance policies and procedures.
Knowledge & Experience
Minimum
- Microsoft SQL Server 2008/2008R2/2012+
- Data Migration experience
- Relational database experience
- Microsoft SQL Server Reporting Services
- BIDS 2008+ (Visual Studio 9+) expertise
Preferred
- Insurance/Claims Management Industry
- Application experience and competency
- Enterprise Financial application experience
- Team Foundation Services (TFS) Code Repository
- Visual Studio (VS) 2013/2015
- Windows Server 2008R2/2012
- IBM WebSphere Application Server (WAS) 8.5+
- Messaging/Integration Middleware experience or exposure
Personal Attributes
- A self-starter with the ability to work independently
- Good written and oral communication skills.
- Strong technical documentation skills.
- Good interpersonal skills.
- Ability to conduct research into database issues, standards, and products as required.
- Ability to present ideas in user-friendly language.
- Highly self-motivated and directed.
- Keen attention to detail.
- Proven analytical and problem-solving abilities.
- Ability to effectively prioritize and execute tasks in a high-pressure environment.
- Strong customer service orientation.
- Experience working in a team-oriented, collaborative environment.
Work Conditions
- Varied work hours to accommodate meetings or conference calls from various time zones.
- Sitting for extended periods of time.
- Dexterity of hands and fingers to operate a computer keyboard, mouse, power tools, and other computer components.
- Lifting and transporting of moderately heavy objects, such as computers and peripherals.
Basic
• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
Additional Information
** U.S. citizens and those authorized to work in the U.S. are encouraged to apply.
Note:-
1.This is a Full-Time Permanent job opportunity for you.
2.Only Citizen and Green Card Holder can apply.
3.No OPT-EAD & H1B Consultants please.
4.Please mention your Visa Status in your email or resume.
