Sr. Data Migration And Reporting Specialist

About the role

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+
• Expert
• Data Migration experience
• Complex SQL writing
• Relational database experience
• Proficient
• Replication experience
• Microsoft SQL Server Reporting Services
• BIDS 2008+ (Visual Studio 9+) expertise

Preferred

• Insurance/Claims Management Industry
• Application experience and competency
• CRM & Accounting
• Enterprise Financial application experience
• Claims Management
• XML competency
• Team Foundation Services (TFS) Code Repository
• Visual Studio (VS) 2013/2015
• VB.net competency
• Windows Server 2008R2/2012
• IBM WebSphere Application Server (WAS) 8.5+
• API Experience
• SOAP/Web Services
• SoapUI
• Postman
• REST-ful API exposure
• Messaging/Integration Middleware experience or exposure
• Mulesoft
• ESB
• Anypoint Studio
• Cloudhub
• Java 1.6/1.7
• Exposure
• Able to read Java code
• Rels/Objects
• BIRT
• 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.

Qualifications

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: 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.