Informatica Developer

4 months ago


Cincinnati, United States Diverse Lynx Full time
Job Title: Informatica Developer
Location: Cincinnati, OH-Onsite
Duration: Full Time-Only

Job Description:

Languages: SQL, Unix Shell
Tools: Informatica PowerCenter
Databases: Oracle, SQL Server, and Teradata.
Big Data: Cloudera Hadoop, Hive
Dev Methodologies: Agile, Waterfall
Others: Toad, SVN, Control-M, Dollar Universe or Autosys

- 7+ years of development experience in delivering ETL/database/programming solution.
- 5+ years of hands-on experience with /designing/development of informatica applications.
- Read and translate logical data models and use ETL skills to load the physical layer, based on an understanding of timing of data loads, data transformation and optimization of ETL load performance.
- Collaborates with development teams and business units to identify, define, develop and implement new data source feeds.
- Work in a global team setting to design, develop and support ETL architecture for data integration, data warehouse, and data Marts for the organization.
- bility to create Mappings, Workflows, Sessions, Reusable components, Parameters and Variable using Informatica.
- Responsible for loading and validating data into the data warehouse
- Conduct unit testing and coordinate with quality assurance teams to ensure accuracy and completeness of ETL processes.
- Coordinate with infrastructure teams to ensure adequate capacity and performance planning.
- Provides support for technical issues and ensuring system availability.
- Create and support the associated scheduling logic for the ETL using CA Autosys scheduler.
- Responsible for timely project deliveries
- Document ETL packages and processes deployment and support instructions.
- Provides guidance to more junior staff.
- bility to think and communicate critically in order to support and facilitate strategic data warehouse extension and analytical initiatives.
- Expert knowledge of data modeling concepts, data warehouse and data aggregation processes and strategies
- Good knowledge on UNIX scripting
- ble to write complex relational Oracle/SQL server queries to help with data validation.
- Working experience in tools like TOAD, SVN, for day-to-day activities is recommended.
- Keep abreast of Informatica best practices and new features to continuously improve development processes.

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.
  • MLOps Engineer

    2 weeks ago


    Cincinnati, United States Saxon Global Full time

    . Informatica PowerCenter . IICS. Tivoli workload scheduler . PL/SQL. Linux This resource is going to be focused on Informatica Development on a daily basis so ideally looking for a Sr. level resource with 6+ years working in Informatica PowerCenter & IICS. Evaluate user requests for new/existing integrations and lead Design and code reviews Expected to be...


  • Cincinnati, United States Munich Re Full time

    Title: Technical Data Steward Location: current schedule is hybrid (40-50% in the Amelia, Ohio office) Exempt position American Modern Insurance Group, Inc., a Munich Re company, is a widely recognized specialty insurance leader that delivers products and services for residential property - such as manufactured homes and specialty dwellings - and the...

  • ETL- DEVELOPER

    5 months ago


    Cincinnati, United States ShiftCode Analytics Full time

    Excellent SSIS skills AND excellent communication. Thanks! Responsibilities: Design, develop, and implement ETL processes using SSIS to extract, transform, and load data from various sources into the data warehouse. Collaborate with business stakeholders and data analysts to gather requirements and translate them into technical specifications. Perform...

  • Data Engineer

    1 week ago


    Cincinnati, United States JobRialto Full time

    Job Summary: We are seeking a highly skilled Data Engineer specializing in unstructured data processing to enhance our enterprise data governance framework. This role involves designing and implementing scalable workflows to transform unstructured data into valuable assets while integrating their metadata into cataloging systems like Informatica CDGC. The...


  • Cincinnati, United States Saxon Global Full time

    Job Description Support a broader team of data scientists and and ML engineers focused on leveraging the power of ML models. Ability to optimize and analyze deep learning workloads on advanced hardware and software platforms .Design and set up ML environments in unison with data scientists and other architects to support ML applications using industry best...

  • Data Engineer

    2 days ago


    Cincinnati, United States Apex Systems Full time

    Job#: 2055521 Job Description: Apex Systems is looking for a Data Engineer for one of our large clients in Cincinnati, OH. Job Title: Data Engineer Role Overview: We are looking for a Data Engineer with a focus on processing unstructured data to enhance our enterprise data governance framework. You will design and implement scalable workflows that...


  • 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...

  • Senior Data Architect

    2 weeks ago


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

    This hybrid position is open to any qualified applicant in the United States. A qualified applicant must be local to Columbus, Ohio, or be open to relocation to Columbus. Practice - AIA - Artificial Intelligence and Analytics About AI & Analytics: Artificial intelligence (AI) and the data it collects and analyzes will soon sit at the core of all intelligent,...

  • Oracle EBS Specialist

    2 weeks ago


    Cincinnati, Ohio, United States Saxon Global Full time

    Key Responsibilities:We are seeking an experienced Oracle EBS technical professional with expertise in Oracle Forms, Reports, and PL/SQL/Unix. The ideal candidate will have at least 10 years of experience in Oracle EBS Technical (CEMLI development) or Core Oracle Tech stack (PL/SQL packages & procedures and Forms 10g/12C, Reports 10g/12C).Technical...


  • Cincinnati, United States UC Health Full time

    UC Health is hiring a Full Time Data Architect The purpose of this position is to function as an advanced technical lead to coordinate, validate and deliver short and long-term enterprise data management initiatives. This individual designs, develops, implements, maintains and continuously refines data warehouse architectures using the Epic Caboodle...

  • Data Modeler I

    1 day ago


    Cincinnati, United States Western & Southern Life Full time

    Overview Accountable for analyzing and developing complex logical database designs, logical data models and relational data definitions in support of corporate and customer information systems requirements. Understands the methodologies and technologies that depict the flow of data within and between technology systems and business functions/operations....


  • Cincinnati, United States MAPSYS Inc. Full time

    Contract to hire (6-12 months). 5 days a week in office in downtown Cincinnati Ohio.Qualifications:Organizationally savvy - comfortable, experienced, and accomplished at working with business executives, and able to push back in a professional and diplomatic mannerAbility to communicate, influence, and persuade — both business and IT leaders, as well as...

  • Data Architect

    2 weeks ago


    Cincinnati, United States Western & Southern Life Full time

    Overview Responsible for leading the development of data models to support business intelligence systems, ensuring that data models, data architectures and data classifications are aligned to the Enterprise business activities. Responsible for mentoring application and infrastructure teams skills, a comprehensive understanding of the company's business...

  • Data Consultant

    2 months ago


    Cincinnati, United States Catch Resource Management Full time

    Our end user client are seeking a Data Consultant to play a critical role in the successful implementation of our new ERP solution. The role will be primarily focused on data cleansing and the ideal candidate will have a strong background in data extraction, transformation, and loading (ETL) processes.The role will typically involve 3 days per week on-site...


  • Cincinnati, Ohio, United States Western & Southern Financial Group Full time

    Unlock the Full Potential of Salesforce Enterprise ArchitectureWe are seeking a seasoned Cloud Architect and Technical Strategist to drive our enterprise capabilities forward, leveraging expertise in Salesforce architecture, technology standardization, and strategic leadership.About the Role:Strategic Leadership: Collaborate with key stakeholders to identify...


  • cincinnati, United States Western & Southern Financial Group Full time

    Join Our Team as a Salesforce Enterprise Architect!Are you a visionary in the world of technology, ready to drive innovation and efficiency? We seek a dynamic Salesforce Enterprise Architect to lead and align our enterprise capabilities with our business strategies. If you're passionate about technology standardization, architectural excellence, and...


  • Cincinnati, United States Western & Southern Financial Group Full time

    Join Our Team as a Salesforce Enterprise Architect!Are you a visionary in the world of technology, ready to drive innovation and efficiency? We seek a dynamic Salesforce Enterprise Architect to lead and align our enterprise capabilities with our business strategies. If you're passionate about technology standardization, architectural excellence, and...