ETL Solutions Architect

2 weeks ago


Cincinnati, Ohio, United States Diverse Lynx Full time

Job Title:
Informatica Developer

Location:
Cincinnati, OH-Onsite

Duration:
Full Time-Only


Job Overview:

As an Informatica Developer, you will play a crucial role in the design and implementation of ETL processes that support our data warehousing initiatives. Your expertise will contribute to the seamless integration of diverse data sources, ensuring high-quality data for analytical purposes.

Key Responsibilities:
  • Leverage 7+ years of experience in developing ETL solutions to deliver robust database and programming solutions.
  • Utilize 5+ years of hands-on experience in designing and developing Informatica applications.
  • Translate logical data models into physical implementations, optimizing ETL load performance through effective data transformation techniques.
  • Collaborate with cross-functional teams to identify and define new data source integrations.
  • Participate in a global team environment to design and support ETL architecture for data integration, data warehousing, and data marts.

Technical Skills:
  • Proficient in creating Mappings, Workflows, Sessions, and Reusable components using Informatica.
  • Responsible for data loading and validation within the data warehouse environment.
  • Conduct unit testing and work closely with quality assurance teams to ensure the integrity of ETL processes.
  • Coordinate with infrastructure teams for performance planning and capacity management.
  • Provide technical support to resolve issues and ensure system availability.
  • Document ETL processes and deployment instructions comprehensively.
  • Mentor junior staff and provide guidance on best practices.

Qualifications:
  • Expertise in data modeling concepts and data aggregation strategies.
  • Strong knowledge of UNIX scripting.
  • Ability to write complex SQL queries for data validation purposes.
  • Familiarity with tools such as TOAD and SVN for daily operations.
  • Stay updated on Informatica best practices and new features to enhance development efficiency.

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination.

All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role.

We promote and support a diverse workforce across all levels in the company.

  • Cincinnati, Ohio, United States Diverse Lynx Full time

    Job Title: Informatica DeveloperLocation: Cincinnati, OH-OnsiteDuration: Full Time-Only Job Overview:We are seeking a skilled Informatica Developer with extensive experience in ETL processes and data integration solutions. The ideal candidate will possess a strong background in SQL and Unix Shell, along with proficiency in Informatica PowerCenter. Key...


  • Cincinnati, Ohio, United States Diverse Lynx Full time

    Job Title: Informatica DeveloperLocation: Cincinnati, OH-OnsiteDuration: Full Time-Only Job Overview:We are seeking a skilled Informatica Developer with extensive experience in ETL processes and data integration. The ideal candidate will possess a strong background in database programming and will be responsible for the design, development, and...


  • Cincinnati, Ohio, United States Diverse Lynx Full time

    Job Title: Informatica DeveloperLocation: Cincinnati, OH-OnsiteDuration: Full Time-Only Job Overview:We are seeking a proficient Informatica Developer with extensive experience in ETL processes and data integration. The ideal candidate will possess a strong background in database programming and data warehousing solutions.Technical Skills...


  • Cincinnati, Ohio, United States Diverse Lynx Full time

    Job Title: Informatica DeveloperLocation: Cincinnati, OH-OnsiteDuration: Full Time-Only Job Overview:We are seeking a skilled Informatica Developer to join our team at Diverse Lynx. The ideal candidate will possess extensive experience in ETL development and data integration processes.Key Responsibilities:Over 7 years of experience in delivering robust...


  • Cincinnati, Ohio, United States Diverse Lynx Full time

    Job Title: Informatica DeveloperLocation: Cincinnati, OH-OnsiteDuration: Full Time-Only Job Overview:We are seeking a skilled Informatica Developer with extensive experience in ETL processes and data integration. The ideal candidate will possess a strong background in SQL and Unix Shell, alongside proficiency in Informatica PowerCenter.Key Skills:Languages:...


  • Cincinnati, Ohio, United States Ascendum Solutions Full time

    Key Responsibilities: Evaluate the existing on-premises data warehouse framework and propose a strategic design for migration to Google Cloud Platform (GCP).Assess the architecture for scalability, efficiency, and cost management.Offer insights to enhance the architecture, emphasizing BigQuery and other GCP offerings.Examine integration methodologies between...


  • Cincinnati, Ohio, United States Ascendum Solutions Full time

    Key Responsibilities: Evaluate the existing on-premises data warehouse framework and devise a strategy for its transition to Google Cloud Platform (GCP).Assess the architecture for scalability, efficiency, and financial viability.Offer insights to enhance the architecture, emphasizing BigQuery and other GCP offerings.Examine integration methodologies between...

  • Solutions Architect

    2 weeks ago


    Cincinnati, Ohio, United States SLK Software Services Pvt LTD Full time

    About SLK Software Services Pvt LTD SLK Software Services Pvt LTD is a worldwide technology solutions provider dedicated to integrating AI, intelligent automation, and analytics to deliver cutting-edge technology solutions for our clients through a collaborative culture and an innovative mindset. With over two decades of experience, we have assisted...


  • Cincinnati, Ohio, United States NTT DATA Business Solutions Full time

    Unlock Your Career Potential: Explore Exciting Opportunities with Us *Candidates may reside in any U.S. location and should be prepared for extensive travel as required by client and project demands* Position Overview: The Senior SAP Solutions Architect will leverage a comprehensive understanding of SAP capabilities along with cross-functional and technical...


  • Cincinnati, Ohio, United States NetGain Technologies, LLC Full time

    Position Overview NetGain Technologies, LLC is a leading technology service provider in the Southeast and Midwest regions of the United States. We prioritize assembling a high-caliber team that embodies values such as extreme ownership, continuous improvement, teamwork, exceptional client service, and family prioritization. The Professional Services Team...


  • Cincinnati, Ohio, United States NetGain Technologies, LLC Full time

    Position Overview NetGain Technologies, LLC is a leading technology service provider in the Southeast and Midwest regions of the United States. We are dedicated to assembling a high-caliber team that embodies values such as accountability, ongoing development, teamwork, exceptional client service, and prioritizing family. The Professional Services Team (PSE)...


  • Cincinnati, Ohio, United States Ascendum Solutions Full time

    About the RoleWe are seeking a highly skilled Senior M365 Engineer to join our team at Ascendum Solutions. As a Senior M365 Engineer, you will play a key role in delivering custom Microsoft Power Platform Solutions to our clients.Key ResponsibilitiesTechnical Leadership: Lead clients as a trusted partner and act as a technical lead, focusing on delivering...


  • Cincinnati, Ohio, United States Hexaware Technologies Full time

    What Hexaware Technologies Offers:Hexaware Technologies is a forward-thinking IT firm dedicated to providing innovative solutions to clients globally. We take pride in nurturing a collaborative and inclusive workplace where every employee is appreciated and empowered to thrive.We offer access to a wide range of tools that enhance and elevate professional...


  • Cincinnati, Ohio, United States Hexaware Technologies Full time

    What Hexaware Technologies Offers:Hexaware Technologies is a forward-thinking IT organization dedicated to providing innovative solutions to clients globally. We emphasize a collaborative and inclusive workplace where every team member is recognized and empowered to thrive.We provide access to a comprehensive suite of tools that enhance and elevate...


  • Cincinnati, Ohio, United States CUSHMAN AND WAKEFIELD OF OHIO INC Full time

    Job Title: Microsoft Azure Solutions Architect Job Description Summary: As a Microsoft Azure Solutions Architect, you will be instrumental in the design, implementation, and management of cloud-based solutions utilizing Microsoft Azure and VMware technologies. Your expertise will be vital in establishing a robust, secure, and scalable cloud infrastructure...


  • Cincinnati, Ohio, United States Western & Southern Life Full time

    Overview The Salesforce Solutions Architect plays a pivotal role in leading and supporting Salesforce and Marketing Cloud initiatives that strategically influence business models, personnel, processes, and technology. This role collaborates closely with IT and business executives to ensure alignment between business objectives and IT capabilities. The...


  • Cincinnati, Ohio, United States Diverse Lynx Full time

    Job Title: Senior Mainframe Solutions Architect Location: Cincinnati, OHKey Qualifications: 1. Senior Mainframe Solutions Architect 2. z/VM and z/Linux Systems AdministratorPosition Overview: We are in search of a Program Manager with extensive experience in Business Associate roles, ideally possessing between 11 to 12 years of relevant expertise. The...


  • Cincinnati, Ohio, United States Medpace Full time

    Exciting Opportunity for an AI Solutions ArchitectCompany Overview:Medpace is a premier clinical contract research organization (CRO) that excels in delivering comprehensive Phase I-IV clinical development services tailored for the biotechnology, pharmaceutical, and medical device sectors.About the Role:Oversee the deployment of advanced language models...


  • Cincinnati, Ohio, United States Diverse Lynx Full time

    We are looking for a highly skilled Architect with a robust background in mainframe technologies, possessing 12 to 16 years of relevant experience. The successful candidate will demonstrate significant proficiency in Mainframe Utilities, Mainframe Modernization, Mainframe CICS, and Mainframe auto engineering with CAOPS/MVS. This position is pivotal in...


  • Cincinnati, Ohio, United States MongoDB Full time

    MongoDB is hiring a Pre-Sales Solution Architect to join their innovative teamThe data management software market is huge, and MongoDB is playing a key role in transforming industries and empowering developers to create amazing apps. As the leading developer data platform and the first database provider to IPO in over two decades, MongoDB is at the forefront...