Sr. Data Migration And Reporting Specialist

Company Description Career Guidant, an internationally acclimed, trusted multi-faced orgiansation into Information Technology Custom Learning Services for Enterprises, Lateral Staffing Solutions, Information Technology Development & Consulting, Infrastructure & Facility Management Services and Technical Content development as core competencies. Our experienced professionals bring a wealth of industry knowledge to each client and operate in a manner that produces superior quality and outstanding results.

Career Guidant proven and tested methodologies ensures client satisfaction being the primary objective. Committed to our core values of Client Satisfaction, Professionalism, Teamwork, Respect, and Integrity.

Career Guidant with its large network of delivery centres,support offices and Partners across India, Asia Pacific, Middle East, Far East, Europe, USA has committed to render the best service to the client closely to ensure their operation continues to run smoothly. Our Mission"To build Customer satisfaction, and strive to provide complete Information Technology solution you need to stay ahead of your competition" If you have any queries about our services.

Job Description 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 ServicesBIDS 2008+ (Visual Studio 9+) expertise

Preferred

Insurance/Claims Management Industry Application experience and competencyCRM & Accounting Enterprise Financial application experience

Claims Management XML competency Team Foundation Services (TFS) Code Repository Visual Studio (VS) 2013/ competency

Windows Server 2008R2/2012

IBM Web Sphere Application Server (WAS) 8.5+API Experience SOAP/Web Services

SoapUIPostmanREST-ful API exposure

Messaging/Integration Middleware experience or exposure

MulesoftESBAnypoint Studio Cloudhub Java  1.6/1.7 Exposure Able to read Java code Rels/ObjectsBIRTPersonal AttributesA 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.

Abili…