- Experience in analysis, design, development, support and enhancements in data warehouse environment with Cloudera Bigdata Technologies (with a minimum of 8+ years' experience in data analysis, data profiling, data model, data cleansing and data quality analysis in various layers using Database queries both in Oracle and Big Data platforms).
- Experience (minimum of 8+ years) in working Erwin Data Model tool, hive/impala queries, Unix commands, scripting and shell scripting etc.
- Participate in Team activities, Design discussions, Stand up meetings and planning Review with team.
- Perform data analysis, data profiling, data cleansing and data quality analysis in various layers using Database queries both in Oracle and Big Data platforms.
- Eliciting, analyzing and documenting functional and non-functional requirements.
- Document business requirements, meeting minutes, and key decisions/actions.
- 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 Business 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
- 8+ years Data analysis/architecture 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 design.
- Strong SQL experience (prefer Oracle, Hive and Impala) in creating DDL's and DML's in Oracle, Hive and Impala (minimum of 8 years' experience).
- Experience in analysis, design, development, support and enhancements in data warehouse environment with Cloudera Bigdata Technologies (with a minimum of 8-9 years' experience in Hadoop, MapReduce, Sqoop, PySpark, Spark, HDFS, Hive, Impala, Stream Sets, Kudu, Oozie, Hue, Kafka, Yarn, Python, Flume, Zookeeper, Sentry, Cloudera Navigator) along with Informatica.
- Experience (minimum of 8 years) in working with Sqoop scripts, PySpark programs, HDFS commands, HDFS file formats (Parquet, Avro, ORC etc.), Stream Sets pipelines, jobs scheduling, hive/impala queries, Unix commands, scripting and shell scripting etc.
- Experience in migrating data from relational database (prefer Oracle) to big data – Hadoop platform is a plus.
- Experience eliciting, analyzing and documenting functional and non-functional requirements.
- Ability to document business, functional and non-functional requirements, meeting minutes, and key decisions/actions.
- Experience in identifying data anomalies.
- Experience 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.
- Good experience in working with Visio, Excel, PowerPoint, Word, etc.
- Effective team player in a fast paced and quick delivery environment
- Demonstrate effective leadership, analytical and problem-solving skills.
- Required excellent written and oral communication skills with technical and business teams.
- Ability to work independently, as well as part of a team.
- Stay abreast of current technologies in area of IT assigned.
- Establish facts and draw valid conclusions.
- Recognize patterns and opportunities for improvement throughout the entire organization.
- Ability to discern critical from minor problems and innovate new solutions.
-
Database Architect
3 weeks ago
IntelliX Software Inc Columbus, United StatesJob Title: Database Architect · Duration: 3 Months + 12 Months Extension · Remote – Columbus, OH (Local Prefer) · Must be require First and Last day onsite at Columbus, OH · The Senior Database Architect is responsible for the analysis, design, development, and implementation ...
-
Database Architect
3 weeks ago
Infoprompt Inc Ohio City, United States Part time, contractThe Data Architect 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 technical resources for dat ...
-
Senior Database Architect- Remote
1 day ago
Proteam Solutions Columbus, United StatesThis position is now 100% remote. · Complete Description: · The Senior Database Architect will be responsible for Medicaid Enterprise Data Warehouse (EDW) · design, development, implementation, migration, maintenance, and operational activities. The · candidate will closely w ...
-
Sr Developer and Database Architect
2 weeks ago
General Dynamics Information Technology Home Office, United StatesOwn the opportunity as a Sr Developer and Database Architect and help ensure the mission is never interrupted. At GDIT, we deliver clarity with our cloud solutions and provide meaningful work. Your work will be an important part of transforming our clients for the modern age and ...
-
Sr. Technical Architect
2 weeks ago
Smith Commerce Columbus, United States Full timeSmith is searching for a cloud-native expert to help lead the design and implementation of a new-generation scalable eCommerce platform for a key client. As a Technical Architect (TA) and a key hire in our composable commerce practice, you'll not only play a lead role in this pro ...
-
Sr. Staff, Software Engineer
4 weeks ago
816 GPS Services, Inc. Ohio, United States Full timeAbout the Role · Responsible for design, development, and maintenance of software systems. Work in agile methodology with distributed teams. Solve relatively complex situations and analyze data to make effective decisions, keeping customer experience at the forefront. Mentor oth ...
-
NET Solutions Architect
6 days ago
Perceptive Recruiting, LLC Columbus, United StatesSolutions Architect position open at our clients Columbus, OH location, with a hybrid remote work option available. You'll play a pivotal role in shaping technical solutions within a collaborative, Agile environment, across multiple divisions within their enterprise. Leveraging y ...
-
Enterprise Data Architect
2 weeks ago
InsideHigherEd Columbus, United StatesScreen reader users may encounter difficulty with this site. For assistance with applying, please contact hr- If you have questions while submitting an application, please review these frequently asked questions. · Current Employees and Students:If you are currently employed or e ...
-
Java Architect
1 day ago
Avance Consulting Columbus, United States Full timeTitle- Java Architect · Location- Columbus, OH (Remote) · JD : · ● Strong experience with front-end web development and framework ( React/Vue etc) · ● Experience building scalable backend services with Java · ● Experience with headless and composable architecture · ● Experience w ...
-
Application Designer
2 weeks ago
Gainwell Technologies Ohio, United StatesBe part of a team that unleashes the power of leading-edge technologies to help improve the health and well-being of those most vulnerable in our country and communities. Working at Gainwell carries its rewards. Youll have an incredible opportunity to grow your career in a compan ...
-
IT Architect
6 days ago
Kimball Midwest Columbus, United StatesKimball Midwest, a national distributor of maintenance, repair, and operation products, is searching for an IT Architect on our Mobile team for our Columbus, OH location. · As a Kimball Midwest associate, you will experience why we have been recognized as one of the Top Workpla ...
-
Technical Manager of Data Warehousing
2 weeks ago
Plante Moran Ohio, United StatesTechnical Manager of Data Warehousing Contact | · Experienced Hires · Technical Manager of Data Warehousing · Location: United States, Michigan · Location: United States, Ohio · Location: United States, Illinois · Location: United States, Colorado · Make your mark.Plante Moran's ...
-
Data Engineer
4 weeks ago
Revel IT Columbus, United StatesThis is a contract-to-hire opportunity. · Preference is that candidates are local to Columbus or at least in the MidWest region. · Fully remote. · Our direct client is looking for a Data Engineer to help support the IT organization's data strategy in support of their business cus ...
-
Security Architect Manager
3 weeks ago
CBTS Ohio, United States Full timeJob Description · : · As a Security Architect Manager you'll play a dual role, shaping the security landscape and leading a team of skilled security engineers. Your expertise will be instrumental in safeguarding our corporate environment while guiding and mentoring your team. ...
-
Senior Data Science Architect
3 weeks ago
NTT Ohio, United States Full timeJOB DESCRIPTION NTT is a leading global IT solutions and services organisation that brings together people, data and things to create a better and more sustainable future. · In today's 'iNTTerconnected' world, connections matter more now than ever. By bringing together talented ...
-
Application Solution Architect
3 weeks ago
Ohio Department of Developmental Disabilities Columbus, United StatesPrimary Location · :United States of America-OHIO-Franklin County-Columbus Work Locations · :Health Department Building246 North High Street1st FloorColumbus43215 Organization · :HealthClassified Indicator:ClassifiedBargaining Unit / Exempt:Bargaining Unit Schedule · :F ...
-
Dir of Projects
2 weeks ago
InsideHigherEd Columbus, United StatesScreen reader users may encounter difficulty with this site. For assistance with applying, please contact hr- If you have questions while submitting an application, please review these frequently asked questions. · Current Employees and Students:If you are currently employed or e ...
-
Ohio Department of Developmental Disabilities Columbus, United StatesPrimary Location · :United States of America-OHIO-Franklin County-Columbus Work Locations · :James A Rhodes Office Tower 3330 East Broad Street33rd FloorColumbus43215 Organization · :Mental Health & Addiction ServicesClassified Indicator:UnclassifiedBargaining Unit / Exemp ...
-
Cloud Infrastructure Engineer
2 days ago
Battelle Ohio, United States Full timeJOB DESCRIPTION Battelle delivers when others can't. We conduct research and development, manage national laboratories, design and manufacture products and deliver critical services for our clients—whether they are a multi-national corporation, a small start-up or a government a ...
-
s is hiring for a Senior Data Arcitect
4 weeks ago
vTech Solution Columbus, United StatesJob Description · Job DescriptionThe Senior Database Architect is responsible for the analysis, design, development, and implementation of the data architecture in support of the agency mission. · The Senior Database Architect will architect the analytical data systems including ...
Senior Database Architect - Columbus, United States - Comtech Global
Description
Role:
Senior Database ArchitectLocation: Columbus, OH (Onsite)Please share resumes topgo AT THE RATE OF Comtechglobal DOT COMComplete Description:
Detailed Day-To-Day Job Duties to be performed:
REQUIRED Skill Sets:
Required Education:
BS/BA degree or combination of education & experience
DESIRED Skill Sets:
#J-18808-Ljbffr