Sr. Data Migration And Reporting Specialist

Company DescriptionCareer 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 DescriptionThe 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.ResponsibilitiesCreate 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 & ExperienceMinimumMicrosoft SQL Server 2008/2008R2/2012+ExpertData Migration experience Complex SQL writing Relational database experienceProficient Replication experienceMicrosoft SQL Server Reporting ServicesBIDS 2008+ (Visual Studio 9+) expertisePreferredInsurance/Claims Management IndustryApplication experience and competencyCRM & AccountingEnterprise Financial application experienceClaims Management XML competency Team Foundation Services (TFS) Code RepositoryVisual Studio (VS) 2013/2015VB.net competencyWindows Server 2008R2/2012IBM WebSphere Application Server (WAS) 8.5+API Experience SOAP/Web ServicesSoapUIPostmanREST-ful API exposureMessaging/Integration Middleware experience or exposureMulesoftESBAnypoint StudioCloudhubJava 1.6/1.7 ExposureAble to read Java code Rels/ObjectsBIRTPersonal AttributesA self-starter with the ability to work independentlyGood 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 ConditionsVaried 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.QualificationsBasic• 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 InformationAdditional 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.SummaryType: Full-timeFunction: Information TechnologyExperience level: Mid-Senior LevelIndustry: Staffing And Recruiting