Database Developer

2 weeks ago

Charlotte, NC, United States Northern Base Full time

Require an experienced Developer to support the design and implementation of data load and transformation processes, workflow mappings, data analytics and/or end-user reporting, per project scope. Individual contributor role, working as part of Agile scrum team on a Pega BPM platform, with underlying Oracle database.

Develop mappings using needed transformation in informatica tool according to technical specifications.

Good hands-on experience in Transformations like joiner, aggregation, filter, lookup, expression, and update strategy.

Effectively use informatica parameter file for defining mapping variables and relational databases.

Develop Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.

Design mappings to load the data from one server to another server using informatica tool.

Skillset Details

Required Skills and Experience we are Looking For:
• 7 + years' experience with DB ETL Development tools like PL/SQL, Informatica, Data Warehouse. Hands on shell scripting experience. Unix/Linux experience.
• Strong analytical, troubleshooting, and problem-solving skills.
• Strong knowledge of data management concepts, including database structure, and proficiency with Oracle SQL and other standard database query tools.
• Experience in data analysis, data mapping techniques.
• Work experience with Business Intelligence (data architecture, entity relationship planning, dimensional modeling, ETL, OLAP, analytical reporting) preferred
• Solid background in ETL Informatica and database development (Oracle / SQL Server)
• Experience in Trading/Banking technology will be an added plus
• Experience in Compliance/Independent Testing area will be an added plus

  • Database Administrator V

    2 weeks ago

    Charlotte, NC, United States Apex Informatics Full time

    • Ability to perform analysis of performance bottlenecks, propose options, and implement performance tuning recommendations for Oracle database queries/code and batch processes. • ETL Design and Development: Informatica and/or DataStage o Monitoring performance, troubleshoot and tuning ETL processes as appropriate o Developing ETL workflows for periodic...

  • Senior Database Engineer

    2 weeks ago

    Charlotte, NC, United States U.S. Bank Full time

    At U.S. Bank, we're on a journey to do our best. Helping the customers and businesses we serve to make better and smarter financial decisions and enabling the communities we support to grow and succeed. We believe it takes all of us to bring our shared ambition to life, and each person is unique in their potential. A career with U.S. Bank gives you a wide,...

  • Principal Cloud Operations Engineer Databases

    2 weeks ago

    Charlotte, NC, United States Pegasystems Full time

    Principal Cloud Operations Engineer Databases Job Category: Engineering & Cloud Location: US - New Hampshire - Remote | US - Connecticut - Remote | US - Massachusetts - Remote | US - North Carolina - Remote | US - Virginia - Remote | US - Maine - Remote | US - Vermont - Remote | US - Virginia - Dulles Meet Our Team: As a member of Cloud Operations, you will...

  • IT Application Developer

    1 week ago

    Charlotte, NC, United States E-Solutions Full time

    City of Charlotte-I&T Application Developer Position Description: We are seeking an Application Developer to work on creating a case management solution for our Code Enforcement division. The case management solution will interface with a custom service request intake solution as well as additional databases containing address and geospatial data. The new...

  • IT Application Developer

    2 weeks ago

    Charlotte, NC, United States E-Solutions Full time

    City of Charlotte-I&T Application Developer Position Description: We are seeking an Application Developer to work on creating a case management solution for our Code Enforcement division. The case management solution will interface with a custom service request intake solution as well as additional databases containing address and geospatial data. The new...

  • IT Application Developer

    2 weeks ago

    Charlotte, NC, United States E-Solutions Full time

    City of Charlotte-I&T Application Developer Position Description: We are seeking an Application Developer to work on creating a case management solution for our Code Enforcement division. The case management solution will interface with a custom service request intake solution as well as additional databases containing address and geospatial data. The new...

  • IT Application Developer

    1 week ago

    Charlotte, NC, United States E-Solutions Full time

    City of Charlotte-I&T Application Developer Position Description: We are seeking an Application Developer to work on creating a case management solution for our Code Enforcement division. The case management solution will interface with a custom service request intake solution as well as additional databases containing address and geospatial data. The new...

  • Java Developer

    3 hours ago

    Charlotte, NC, United States Saxon Global Full time

    Developer Java, Microservices, API Key Skills: Strong Java programming skills. Knowledge of J2EE technologies, Spring framework. Good understanding of software development methodologies and practices. Good knowledge of databases and SQL. Strong analytical and problem-solving skills. Good communication and interpersonal skills. Requirements: Bachelor's...

  • Sr ETL Developer

    2 weeks ago

    Charlotte, NC, United States eTeam Full time

    Job Summary The Senior Technical Lead will be responsible for overseeing and leading technical teams in the implementation, integration, and maintenance of Informatica Intelligent Cloud Services. This role will also involve utilizing SQL, Oracle PL/SQL, and Unix Shell Scripting to develop and enhance data solutions. (1.) Key Responsibilities 1. Lead and...

  • Application Consultant

    1 week ago

    Charlotte, NC, United States CapB InfoteK Full time

    For one of our ongoing multiyear projects we are looking for an Application Consultant - Databases out of Charlotte, NC.Job Duties Include but not limited to the following: Standing up cutting-edge analytical capabilities, leveraging automation, cognitive and science-based techniques to manage data and models, and drive operational efficiency by offering...