| Hi Greetings from InfoLogitech, Inc. Here is our open requirement which can be filled immediately. Kindly respond to this requirement with your resume, contact and current location info to speed up the interview process. Job Position : Business Analyst Job Location : Columbus, OH Duration : 3 months contract *******Candidate must be local.*********** Job Description: Participate in Team activities, Design discussions, Stand up meetings and planning Review with 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 Analyst to create Test Plan, 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 development team to 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. Required skill sets: • 8+ years Business Data Analysis experience in Waterfall and Agile Methodology in various domains (prefer Healthcare) in a data warehouse environment. • Good knowledge of relational database, Hadoop big data platform and tools, data vault and dimensional model data analysis and design. • 5+ years’ experience (prefer Oracle, Hive and Impala) in creating DDL’s and DML’s in Oracle, Hive and Impala preferred. • 3+ years’ experience in analysis, design, development, support and enhancements in data warehouse environment with Cloudera Bigdata Technologies (Hadoop, MapReduce, Sqoop, PySpark, Spark, HDFS, Hive, Impala, Stream Sets, Kudu, Oozie, Hue, Kafka, Yarn, Python, Flume, Zookeeper, Sentry, Cloudera Navigator) along with Informatica. • 3+ years’ experience in migrating data from relational database (prefer Oracle) to big data –Hadoop platform is a plus. • 8+ years’ experience eliciting, analyzing and documenting functional, non-functional and data requirements. • Ability to document business, functional, non-functional and data requirements, meeting minutes, and key decisions/actions. • 5+ years’ experience in identifying data anomalies. • 5+ years’ experience in building data sets and familiarity with PHI and PII data. • Ability to establish priorities & follow through on projects, paying close attention to detail with minimal supervision. • Effective communication, presentation, & organizational skills. • 8+ years’ experience in working with Visio, Excel, PowerPoint, Word, etc. • Effective team player in a fast paced and quick delivery environment. Required Education: BS/BA degree or combination of education & experience Regards, Vinayak Reddypally InfoLogitech, Inc. Phone: 908-864-0137 Ext 406 Email: rvinayak@infologitech.com | ||
| Change/Remove Subscription | Powered by Zoniac |
InfoLogitech, Inc, 3, Independence Way, Suite 117, Princeton, New Jersey 08540 Phone: 908-864-0137
No comments:
Post a Comment