Get job as soon as 2 days (HURRY UP) ENROLL NOW or Call   +1 (804)-454-3215
+

Business Analyst,Data warehouse, ETL


Job ID : 27476

Location : Lewis Center

Company Name : Infoprompt Inc

Job Type : Parttime, Contract

Industry : Computer/Software

Salary : $50,000 - $60,000  per year

No. of Positions : 1


Required Skills : Business Analyst, Data Warehouse , ETL

Benefits : No benefits are available


Job Description :

The Business Analyst will be responsible for Medicaid Enterprise data warehouse design, development, implementation, migration, maintenance, and operational activities. The candidate will closely with Data Governance and Analytics team. Will be one of the key business/technical resources for data warehouse projects for various Enterprise data warehouse projects and building critical data marts, data ingestion to Big Data platform for data analytics, and exchange with State and Medicaid partners. This position is a member of Medicaid ITS and works closely with the Business Intelligence & Data Analytics team.

Responsibilities:

• Participate in Team activities, Design discussions, Standup meetings, and planning Review with the team.

• Eliciting, analyzing, and documenting functional, non-functional, and data requirements.

• Document business requirements, meeting minutes, and key decisions/actions.

• Perform business data analysis, data profiling, data cleansing, and data quality analysis in various layers using Database queries both in Oracle and Big Data platforms.

• Lead client meetings and sessions with data-driven analysis to clarify requirements and design decisions.

• Perform data gap and impact analysis due to new data addition and existing data changes for any new business requirements and enhancements.

• Follow the organization design standards document, create data mapping specification document, pseudo-codes for the development team(s), and design documents.

• Create logical & physical data models.

• Review and understand existing business logic used in Oracle and Hadoop ETL platforms to verify against the business user needs.

• Review PySpark programs that are used to ingest historical and incremental data.

• Review SQOOP scripts to ingest historical data from Oracle database to Hadoop IOP, created HIVE tables and Impala view creation scripts for Dimension tables.

• Assist Data Analysts to create Test plans, Design Test scenarios, SQL scripts (prefer Oracle and Hadoop), test or mockup data, executes the test scripts.

• Validate test results and records as well as log and research defects.

• Analyze production data issues, report problems, and find solutions to fix the issues, if any.

• Create incidents and tickets to fix production issues, create Support Requests to deploy code for the development team to the UAT environment.

• Participate in meetings to continuously upgrade the Functional and technical expertise.

• Establish priorities & follow through on projects, paying close attention to detail with minimal supervision.

• Create and present project plan, project status, and other dashboards as necessary.

• Perform other duties as assigned.

Detailed Day-To-Day Job Duties to be performed:

Responsibilities:

• Participate in Team activities, Design discussions, Stand up meetings, and planning Review with the team.

• Eliciting, analyzing, and documenting functional, non-functional, and data requirements.

• Document business requirements, meeting minutes, and key decisions/actions.

• Perform business data analysis, data profiling, data cleansing, and data quality analysis in various layers using Database queries both in Oracle and Big Data platforms.

• Lead client meetings and sessions with data-driven analysis to clarify requirements and design decisions.

• Perform data gap and impact analysis due to new data addition and existing data changes for any new business requirements and enhancements.

• Follow the organization design standards document, create data mapping specification document, pseudo-codes for the development team(s), and design documents.

• Create logical & physical data models.

• Review and understand existing business logic used in Oracle and Hadoop ETL platforms to verify against the business user needs.

• Review PySpark programs that are used to ingest historical and incremental data.

• Review SQOOP scripts to ingest historical data from Oracle database to Hadoop IOP, created HIVE tables and Impala view creation scripts for Dimension tables.

• Assist Data Analysts to create Test plans, Design Test scenarios, SQL scripts (prefer Oracle and Hadoop), test or mockup data, executes the test scripts.

• Validate test results and records as well as log and research defects. • Analyze production data issues, report problems, and find solutions to fix the issues, if any.

• Create incidents and tickets to fix production issues, create Support Requests to deploy code for the development team to the UAT environment.

• Participate in meetings to continuously upgrade the Functional and technical expertise.

• Establish priorities & follow through on projects, paying close attention to detail with minimal supervision.

• Create and present project plan, project status, and other dashboards as necessary.

• Perform other duties as assigned.

 

Latest Jobs For You

  • Project Engineer

    Journey Group Sioux Falls, SD

    Essential Duties and Responsibilities: Assist the Project Manager with project procurement, ...

    View Job
  • Software/Database Developer

    CSL SOFTWARE SOLUTIONS Burlington, VT

    Ideal Experience/Skills: Knowledgeable in SQL, preferably Microsoft Transact-SQL Server 2012....

    View Job
  • Entry Level Computer Programmer

    Revature Chattanooga, TN

    Job Requirements: College degree (Associates or Bachelors) Must be authorized to work in the...

    View Job
  • Software Developer - Entry Level

    360 View Nashville, TN

    Job Description: Looking for talented graduates who are hungry to be challenged and grow their...

    View Job
  • Electrical Engineer – Entry and Mid-Level

    Elliott Bay Design Group Entry, WV

    Responsibilities & Duties: Work will primarily be in an office environment (5 days per ...

    View Job

Thanks For Your Feedback

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.