Senior Database Architect

4 weeks ago


Columbus, United States CareerBuilder Full time

Role: Senior Database ArchitectLocation: Columbus, OH (Onsite)Please share resumes topgo AT THE RATE OF Comtechglobal DOT COMComplete Description: 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.Detailed Day-To-Day Job Duties to be performed: 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.REQUIRED Skill Sets: 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 DDLs and DMLs 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.Required Education: BS/BA degree or combination of education & experience.DESIRED Skill Sets: 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.
Your Resume * (.doc,.docx,.pdf files are only allowed)

#J-18808-Ljbffr


  • Database Architect

    1 month ago


    Columbus, Ohio, United States Infoprompt Inc Full time

    The 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 data warehouse projects for various Enterprise data warehouse projects and building...


  • Columbus, United States CareerBuilder Full time

    Role: Senior Systems Architect (Need Columbus based Candidates)Location: Columbus, OH (Hybrid)Please share resumes topgo AT THE RATE OF Comtechglobal DOT COMComplete Description:The Senior Architect must provide exceptional expertise and leadership in the architectural design, development, and implementation of overall system of large-scale systems, and will...

  • Database Developer

    16 hours ago


    Columbus, United States Intelligence and National Security Alliance Full time

    Job Title: Database Developer Location: Columbus, OH Job Description: Are you a talented and creative problem solver with a passion for data, a knack for solving complex challenges, and a keen interest in the world of databases? If so, we have an exciting opportunity for you to join our growing team of data professionals. We're looking for individuals who...

  • Database Developer

    1 week ago


    Columbus, United States Emerald Resource Group Full time

    Job Title: Database Developer Location: Columbus, OH Job Description: Are you a talented and creative problem solver with a passion for data, a knack for solving complex challenges, and a keen interest in the world of databases? If so, we have an exciting opportunity for you to join our growing team of data professionals. We're looking for individuals who...


  • Columbus, United States Emerald Resource Group Full time

    Role: Senior Database Developer Location: Canton, OH Schedule: Hybrid Responsibilities:Strategy & Planning: Partner with business units to identify project requirements. Identify technical project requirements and conduct feasibility and cost/benefit analyses. Plan, organize, and report on project progress, coordinating with additional development teams....


  • Columbus, United States Smith Commerce Full time

    Smith 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 project—you’ll be a cloud-native pioneer, helping to build out and grow the...


  • Columbus, Ohio, United States Burns & McDonnell Full time

    Description The Senior Architect - Process will lead in the development of pharmaceutical and life science projects teams to create world-class designs for Life Science Clients. The Senior Architect - Process will lead the project team throughout the design and construction process and integrate process systems into the resulting architectural concepts and...


  • Columbus, United States Saxon Global Full time

    **Candidates must be located within a commutable distance of the central Ohio area. ***This is a contract-to-hire opportunity and will convert to a full-time position within 3-6 months. Our client is looking for a mid to senior-level SQL DBA to join their technical team, assisting the Senior DBA with all responsibilities that include but are not limited...


  • Columbus, United States Vaco Los Angeles Full time

    Data Architect | ETL | Data Warehouse | Azure | Columbus OH in Columbus, OH at Vaco **Location:** **Experience:** At least 5 year(s) **Job Description** **JOB SUMMARY:** Vaco Technology is currently seeking a Data Architect for a direct hire opportunity in Columbus, OH. **Location**: hybrid **Type**: direct hire / full time **Status**: W2 only. Unable to...

  • Architect

    5 days ago


    Columbus, United States Stellar Professionals Full time

    Job DescriptionJob DescriptionArchitectWe are looking for Local candidates in Columbus , Oh Applicant must have 5 years of experience with the following: 4 year college degree or equivalent technical study with advanced study preferred.ASP.NET.NET CoreAngularC#Object Orient JavaScriptProficient in the standard SQL (Structured Query Language): syntax used by...

  • .NET Architect

    4 days ago


    Columbus, United States Devcare Solution Ltd. Full time

    Summary: We are seeking a highly skilled Senior .NET Architect to join our dynamic team. The ideal candidate will have expertise in .NET Core, Angular, and Microservices architecture. This role will involve a blend of coding (70%) and architectural design (30%), with a strong emphasis on architecting scalable and resilient microservices...


  • Columbus, United States ProCorp Systems Inc. Full time

    Position : Java Architect Location: Columbus, OH (Need local candidates within 35 miles)RTTO: Day One OnsiteSource Mix: FTC / FTENumber of Positions : 1 PositionExperience Level : 15+ Years Detailed JD:Java FSD (Kafka, Gaia Kubernetes Platform, Splunk, IntelliJ) with Cassandra DB knowledgeTraditional Java Developer with cassandraFamiliary with Kafka, Gaia...

  • Data Architect

    5 days ago


    Columbus, United States Ringside Talent Acquisition Partners Full time

    Our Columbus client is seeking a Data Architect . The ideal candidate aligns with the responsibilities and qualifications outlined below. Responsibilities: Design, model, and implement scalable and efficient data structures to support business processes and reporting requirements. Oversee the design and optimization of databases, ensuring data integrity,...


  • Columbus, United States Atika Tech Full time

    JOB Title : Database Administration Duration: 6+ months Location: Columbus, Ohio 43229 Seeking candidates with prior State client experience Candidates willing to relocate are accepted Note: Hybrid Role -2-3 days a week Interview: Phone/Video Any candidate willing to relocate is fine Required Skills: DB2 Z/OS, Teradata, and SQL Database...

  • Solutions Architect

    2 days ago


    Columbus, United States VantageLinks Full time

    Solutions Architect The Solutions Architect designs, develops, implements, and oversees the operation of multiple applications within the company on multiple platforms. Provides technical leadership and consulting to team members and peers, including development and refinement of standards and participates or leads code and design reviews. Responsibilities:...

  • Salesforce Architect

    1 month ago


    Columbus, Ohio, United States Comtech Global, Inc Full time

    Complete Description:Salesforce Architect/StrategistThe IT Consultant will be responsible for advising clients on how to use various information technology processes, systems, and techniques to solve business problems or meet company objectives.DODD is currently seeking a Salesforce solution architect to provide staff augmentation.DODD location (Rhodes...

  • Data Modeler

    2 days ago


    Columbus, United States Vaco Technology Full time

    Data Modeler/Architect 6 month contact Westerville, OH (hybrid)Requirements * Experience data modeling based on a certain set of data attributes * Experience data modeling for data warehousing with a star schema / snowflake schema (dimensional modeling) * Experience data modeling for Azure SQL database, Azure Synapse, SQL Server platforms * Experience...


  • Columbus, United States Experis Full time

    Seeking Korber WMS Solution Architect for long term contract. Consultants located in EST time zone are highly preferred. Job Title: Korber WMS Solution ArchitectLocation: RemotePay Range:What's the Job? Seeking Korber WMS Solution Architect to lead the design and delivery of solutions, working collaboratively alongside a team of WMS Senior Solution...


  • Columbus, United States The Denzel Group Full time

    The Denzel Group is partnered with a growing long-term client in NJ. The Cisco Telecom Architect position will be a dedicated resource for integrating with external systems and telephony. Provide expert technical direction and guidance to the infrastructure team when implementing and upgrading systems. This is a remote position - must reside in USA....

  • Java Architect

    2 weeks ago


    Columbus, United States Tekgence Private Ltd Full time

    Job DescriptionJob DescriptionRole: Java Architect Location: Columbus, OH Hire Type: FulltimeJob Description: Java FSD (Kafka, Gaia Kubernetes Platform, Splunk, IntelliJ) with Cassandra DB knowledge Traditional Java Developer with Cassandra. Familiary with Kafka, Gaia Kubernetes Platform, Splunk, IntelliJ Should be able to work independenly to analyze and...