Data Integration Architect

6 days ago

Cincinnati, Ohio, United States ApTask Full time

About Client: A Leading Global IT Services and Consulting Company

The client is a prominent global provider of comprehensive IT services and consulting solutions. With a strong presence in various industries, including banking, financial services, retail, manufacturing, healthcare, and more, the company has established itself as one of the largest employers in the IT industry.

Client emphasizes employee training and development, ensuring that its vast and diverse workforce stays ahead of technological advancements through continuous innovation and investment in research and development.

The company offers a wide range of services, including:

  • IT Services: Application development, maintenance, and testing.
  • Consulting: Business consulting, IT strategy, and digital transformation.
  • Business Process Outsourcing (BPO): Outsourcing of business processes to improve efficiency.
  • Enterprise Solutions: Implementation and support of enterprise-level software solutions.
  • Digital Services: Services related to digital technologies, such as analytics, cloud, and IoT.

Salary Range: $120K-$130K/Annum

Job Description:

Technical/Functional Skills:

  • Languages: SQL, Unix Shell
  • Tools: Ab Initio software suite - Co Op, EME, BRE, Conduct It, Express It, Metadata Hub, Query It, Control Center
  • Ab Initio frameworks - Acquire It, DQA, Spec-To-Graph, Testing Framework
  • Databases: Db2, Oracle, MySQL, Teradata, and MongoDB
  • Big Data: Cloudera Hadoop, Hive
  • Dev Methodologies: Agile, Waterfall
  • Others: JIRA, Service Now, Linux 6/7/8, SQL Developer, AutoSys, and Microsoft Office

Roles & Responsibilities:

  1. Total of 7+ Years of IT Experience predominantly in Data Integration/Data Warehouse area
  2. Must have 6+ years of ETL Design and Development experience using Ab Initio
  3. 2+ years of Data Integration project experience on Hadoop Platform, preferably Cloudera
  4. Experience in Ab Initio EME, GDE, parallelism techniques, Graphs using Data, Pipeline & Component parallelism
  5. Ability to design and build Ab Initio graphs (both continuous & batch) and Conduct it Plans, and integrate with portfolio of Ab Initio softwares
  6. Complete understanding and analytical ability of Metadata Hub metamodel
  7. Build graphs interfacing with heterogeneous data sources - Oracle, Snowflake, Hadoop, Hive, AWS S3
  8. Parse XML, JSON & YAML documents including hierarchical models
  9. Build and implement data acquisition and transformation/curation requirements in a data lake or warehouse environment and demonstrate experience in leveraging various Ab Initio components
  10. Build Control Center Jobs and Schedules for process orchestration
  11. Build BRE rulesets for reformat, rollup & validation use cases
  12. Ability to identify performance bottlenecks in graphs and optimize them
  13. Rigor in high code quality, automated testing, and other engineering best practices, ability to write reusable code components
  14. Ability to unit test the code thoroughly and to troubleshoot issues in production environments
  15. Code management and development for Extract, Transform, & Load (ETL) routines using Ab Initio
  16. Ensure Ab Initio code base is appropriately engineered to maintain current functionality and development that adheres to performance optimization, interoperability standards and requirements, and compliance with client IT governance policies
  17. Build automation pipelines for Continuous Integration & Delivery (CI-CD), leveraging Testing Framework & JUnit modules, integrating with Jenkins, JIRA and/or ServiceNow
  18. Successful project implementation of Ab Initio CDC (Change Data Capture) in a Data Integration/ETL project

About ApTask:

ApTask is a leading global provider of workforce solutions and talent acquisition services. As an African American-owned and Veteran-certified company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development.

As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries.

  • Data Architect

    4 days ago

    Cincinnati, Ohio, United States Javen Technologies Full time

    Javen Technologies: Data Engineer IIJob SummaryAs a Data Engineer II at Javen Technologies, you will be responsible for designing and constructing scalable management systems that meet company requirements. You will ensure that all data systems are well-researched, utilizing industry best practices in data mining, algorithms, and data acquisition.Key...

  • Data Systems Architect and Engineer

    7 days ago

    Cincinnati, Ohio, United States Javen Technologies Full time

    Job Summary at Javen Technologies: Estimated Salary Range $120,000 - $180,000 per year. We are seeking a highly skilled Data Systems Architect and Engineer to design and construct scalable data products that meet company requirements and ensure data systems reliability.About the RoleThe successful candidate will have experience with non-relational &...

  • Senior Data Solutions Architect

    6 days ago

    Cincinnati, Ohio, United States Perfict Global, Inc. Full time

    About Us:Perfict Global, Inc. is an IT consulting services provider dedicated to delivering innovative business workforce solutions to Fortune 500 companies. Our team of professionals combines the best technologies available to manage clients' complex business and technology needs.We provide excellent benefits and a fun company culture.Must be local to the...

  • Lead Data Solutions Architect

    7 days ago

    Cincinnati, Ohio, United States ComResource Full time

    Job OverviewWe are seeking a highly skilled Lead Data Solutions Architect to join our team at ComResource.The successful candidate will be responsible for designing and constructing scalable data products, ensuring that all data systems meet company requirements.The ideal candidate will have a strong understanding of data mining practices, algorithms, and...

  • Data Solutions Architect

    6 days ago

    Cincinnati, Ohio, United States Fifth Third Bank Full time

    Join a dynamic team of data experts at Fifth Third Bank as a Data Solutions Architect. In this key role, you will design and build scalable data platforms, tools, and solutions that help the bank manage, secure, and generate value from its vast amount of data.About the Role:You will work closely with IT application teams, Enterprise architecture,...

  • Senior Data Architect

    2 days ago

    Cincinnati, Ohio, United States Insight Global Full time

    Job Summary: Insight Global is seeking a Senior Data Architect to support our fulfillment space with 40 individuals. This cloud-based solution architect will analyze, design, and develop enterprise data and information architecture deliverables. Key responsibilities include experience with scalable cloud-based solution architectures, Python programming, SQL,...

  • Senior Data Architect

    2 days ago

    Cincinnati, Ohio, United States enexusglobal Full time

    We are seeking an experienced Senior Data Architect to lead our data strategy and architecture initiatives at enexusglobal. This role will play a key part in shaping the future of our data landscape, driving digital innovation, and enhancing our ability to make data-driven decisions.Job Summary:The Senior Data Architect will be responsible for designing,...

  • Strategic IT Solutions Architect

    7 days ago

    Cincinnati, Ohio, United States NTT Data Business Solutions Full time

    About the RoleAt NTT DATA Business Solutions, we are seeking a highly skilled Enterprise Architect to join our team. As a key member of our organization, you will play a crucial role in designing and implementing innovative SAP solutions that drive business value for our clients.Job DescriptionCollaborate with cross-functional teams to identify business...

  • Data Architect

    6 days ago

    Cincinnati, Ohio, United States Saxon Global Full time

    Data Architect Role OverviewData Architects at Saxon Global design and implement scalable, repeatable, and well-documented data quality frameworks. They work closely with data scientists and other architects to support machine learning applications using industry best practices.Main Responsibilities• Participate in application technical design processes,...

  • Senior Data Solutions Architect

    2 days ago

    Cincinnati, Ohio, United States w3r Consulting Full time

    At w3r Consulting, we are seeking an exceptional Senior Data Solutions Architect to join our team. About the RoleThis is a challenging and rewarding role that requires a strong understanding of data engineering and architecture principles.The successful candidate will be responsible for designing and implementing scalable data solutions using cutting-edge...

  • Chief Data Architect

    6 days ago

    Cincinnati, Ohio, United States ACL Digital Full time

    About the RoleWe are seeking a highly skilled Chief Data Architect to join our team at ACL Digital.Job SummaryThe successful candidate will lead the development of data-driven solutions, utilizing machine learning and deep learning systems to drive business growth. Key Responsibilities:Develop and implement robust data pipelines and architectures to support...

  • Senior Data Architect

    7 days ago

    Cincinnati, Ohio, United States COGNIZANT TECHNOLOGY SOLUTIONS US CORP. Full time

    About the RoleWe are seeking a highly skilled Senior Data Architect to lead our data architecture and innovation efforts. This individual will be responsible for designing and implementing data solutions that meet business requirements, providing expertise in data structures and architecture, and collaborating with cross-functional teams to drive business...

  • Data Architect Level 2 Specialist

    6 days ago

    Cincinnati, Ohio, United States LeadStack Inc. Full time

    Data Architect Level 2 Specialist OpportunityLeverage your expertise as a Data Architect Level 2 Specialist to construct data monitoring and remediation reports, scorecards, and business rules.As a seasoned Data Architect, you will function as an on-site technical lead for the Data Assessment Team, collaborating closely with the technical framework team to...

  • Data Architect with Expertise in Cloud-Based Data Warehousing

    6 days ago

    Cincinnati, Ohio, United States LTIMindtree Full time

    About Us:LTIMindtree is a global technology consulting and digital solutions company that empowers enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing the potential of digital technologies. As a trusted digital transformation partner to over 700 clients, LTIMindtree brings extensive domain and...

  • Data Architect for Scalable Cloud Solutions

    6 days ago

    Cincinnati, Ohio, United States Apex Systems Full time

    Are you a skilled Data Scientist looking to drive business growth through innovative cloud-based solutions? At Apex Systems, we're seeking an experienced Data Architect to join our team.As a key member of our software delivery team, you will have the opportunity to design and implement scalable cloud-based solution architectures, leveraging your expertise in...

  • Senior Data Integrity Specialist

    6 days ago

    Cincinnati, Ohio, United States Saxon Global Full time

    Saxon Global Inc is seeking a Senior Data Integrity Specialist to join our data engineering team. This role will be responsible for validating ETL processes, ensuring data quality, and supporting data integration initiatives. The ideal candidate will have expertise in Python, Databricks, and Google Cloud Platform (GCP).Job DescriptionWe are looking for a...

  • Enterprise Architect with Expertise in Artificial Intelligence and Data Management

    6 days ago

    Cincinnati, Ohio, United States Intelliswift Software Full time

    About Intelliswift SoftwareWe are a leading software company that focuses on delivering innovative solutions to our clients. Our team of experts is committed to excellence and we are always looking for talented individuals to join us.Job Title: Enterprise Architect with Expertise in Artificial Intelligence and Data ManagementJob Summary:We are seeking an...

  • Senior Data Architect

    6 days ago

    Cincinnati, Ohio, United States Fox Cable Network Services, LLC Full time

    Company Overview: Fox Corporation is a global media and entertainment company that operates under the FOX banner. Our diverse range of brands includes FOX News Media, FOX Sports, FOX Entertainment, FOX Television Stations, and Tubi Media Group.Job Description: As a key member of our Data Platform team, you will be integral in envisioning, implementing, and...

  • ServiceNow Enterprise Architect

    6 days ago

    Cincinnati, Ohio, United States w3r Consulting Full time

    About w3r Consultingw3r Consulting is a dynamic company that specializes in providing top-notch services to our clients. As a leading player in the industry, we strive to deliver innovative solutions that exceed expectations.Job DescriptionWe are seeking an experienced ServiceNow Enterprise Architect to join our team. The ideal candidate will possess...

  • Mortgage Data Architect

    6 days ago

    Cincinnati, Ohio, United States Maintec Technologies Full time

    Mortgage Data Engineering RoleWe are seeking a skilled Data Engineer with a strong background in mortgage banking to join our IT team at Maintec Technologies. The candidate will be instrumental in constructing, testing, and maintaining our mortgage banking data architecture. This includes optimizing data flow and collection to ultimately support data...