ETL/Informatica Developer

1 month ago

Springfield, United States DATAMAXIS Full time

Rate: Depends on Experience

Work location: Remote w/ occasional travel to client site (Springfield, IL).

Required Qualifications:

  • 7+ years of Informatica PowerCenter / ETL Experience
  • 5+ years of complex SQL and Performance Tuning Experience
  • 2+ years of Teradata Version 15+ experience, including Teradata Utilities (Fastload, TPT, Multiload)
  • 2+ years of ETL/Informatica PowerCenter administrative experience
  • Excellent verbal/written communication skills, end-client facing, team collaboration, and mentoring skills.
  • Strong organizational skills and ability to set priorities and schedule work deadlines.
  • Bachelors or Advanced Degree in a related field such as Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business Technology
  • Adapting to the team and organizational culture

Preferred Qualifications:

  • 5+ years of Data Warehouse experience
  • Experience in Reporting/Analytics tool shall be a plus (SAP BO, Tableau, SAS, PowerBI)
  • Experience in Windows, Unix/Linux scripting, R, React, or Python
  • Experience in Informatica Data Quality (IDQ), Address Doctor, Metadata Manager
  • Experience with State Medicaid / Medicare / Healthcare applications.
  • ETL/Informatica or SQL or BI or Teradata Certification
  • Experience working in Agile.
  • Experience with Data Warehouse technologies within the domain of ETL/data integration, Business Intelligence, relational and multi-dimensional database systems.

Primary Responsibilities:

  • Use Informatica PowerCenter to Extract, Transform, and Load (ETL) source data from agency sources, applying numerous transformations to the data that are required, applying corrections to the source files, and adding new fields via the change request process.
  • Automate the staging of data by scheduling scripts to run at optimal times, enhancing overall system performance and efficiency.
  • Create, maintain, and support an ETL/Informatica architectural and system environment for development and production.
  • Perform domain/repository backups and recovery operations.
  • Implementing ETL jobs by creating mappings, mapplets, sessions, and workflows
  • Working with different ETL transformations, including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter
  • Scheduling and monitoring ETL/Informatica jobs in development, system testing, and production environment
  • Developing proactive processes for monitoring capacity and performance tuning
  • Supporting and advising the development teams on technical issues
  • Troubleshoot production support issues post-release deployment and comes up with solutions.
  • Developing and maintaining complex SQL queries and scripts used to create data marts in Teradata.
  • Participating in project discussions to document and recommend alternative technical solutions or requirements.
  • Participating in unit, integration, and system testing
  • Maintaining effective communication and relationships with all individuals involved with the project.
  • Learning new technologies as needed to be able to perform job duties effectively.
  • Providing status progress and meeting deliverables to Optum’s leadership and Optum’s customer
#J-18808-Ljbffr

  • Etl Developer

    3 days ago

    Springfield, United States Syms Strategic Group, LLC (SSG) Full time

    **Syms Strategic Group (SSG) **is seeking a talented **Extract, Transform, and Load (ETL) Developer** **Department**:Veterans Affairs **Location**:On-site, Washington, DC **Type**:Full Time **Min. Experience**:Experienced **Security Clearance Level**:Public Trust (MBI) **Salary Range**:$75,995 - $89,000 **Military Veterans are highly encouraged to...

  • Informatica Developer

    4 weeks ago

    Springfield, United States MASSMUTUAL Full time

    **The Team** The Life Product team within the Life Platform Technology organization is a cross functional team of technology professionals including project managers, business analysts, developers, and testers across 2 global locations. The team supports projects, business as usual, and production support for the suite of Life Products and Billing &...

  • GEOINT Standards Developer Senior Level

    5 days ago

    Springfield, United States CASE Management Consulting, LLC Full time

    Position:GEOINT Standards Developer Senior Level Location:Springfield, VA Clearance: Top Secret/SCI Current General Responsibilities: Writes GEOINT requirements as Standards adopted by U.S. and International organizations. Ensure capability Standards for GEOINT data, geospatial data, GEOINT, and for APIs satisfy requirements across AGENCY and partners....

  • Senior GEOINT Standards Developer

    4 days ago

    Springfield, United States UPSLOPE ADVISORS, INC Full time

    Job DescriptionJob DescriptionSalary: UpSlope Advisors is seeking an experienced senior level GEOINT Standards Developer to join our team!  This person will be responsible for writing requirements, ensuring capability Standards, and satisfying requirements across the government agency and partners, among other things.  Security Requirement:An active...

  • GEOINT Standards Developer, Senior-Level with Security Clearance

    1 month ago

    Springfield, United States Squires Group, Inc Full time

    Senior GEOINT Standards Developer12210 Our client has an IMMEDIATE NEED for a CLEARED Senior-Level GEOINT Standards Developer to provide operational services to the Intelligence Community. Work with our client on a project supporting mission critical activities. You will write and ensure capability Standards for GEOINT data, geospatial data, and for APIs to...

  • GEOINT Standards Developer, Senior-Level with Security Clearance

    2 days ago

    Springfield, United States Squires Group Inc Full time

    Senior GEOINT Standards Developer12210 Our client has an IMMEDIATE NEED for a CLEARED Senior-Level GEOINT Standards Developer to provide operational services to the Intelligence Community. Work with our client on a project supporting mission critical activities. You will write and ensure capability Standards for GEOINT data, geospatial data, and for APIs to...

  • GEOINT Standards Developer

    2 weeks ago

    Springfield, United States Mission Intelligence Group Full time

    Are you a problem solver with a TS/SCI Clearance who thrives on excellence? Join Mission Intelligence Group as a Full Time GEOINT Standards Developer - Senior Level . As part of our team, you'll have the opportunity to tackle complex challenges and contribute to cutting-edge solutions in the Information Technology industry. Work onsite in Springfield, VA,...

  • Python Application Developer | TS/SCI

    5 days ago

    Springfield, United States Connect Talent Solutions Full time

    Job DescriptionJob DescriptionConnect Talent Solutions is a fast growing, innovative staffing firm offering direct placement, contract and contract to hire solutions. We are uniquely positioned and experienced to support your requirements from IT and engineering to general labor and customer service positions. At Connect, people are the center of our...

  • GEOINT Standards Developer

    2 weeks ago

    Springfield, United States Mission Intel Full time

    Job DescriptionJob DescriptionAre you a problem solver with a TS/SCI Clearance who thrives on excellence? Join Mission Intelligence Group as a Full Time GEOINT Standards Developer - Senior Level. As part of our team, you'll have the opportunity to tackle complex challenges and contribute to cutting-edge solutions in the Information Technology industry....

  • Senior GEOINT Standards Developer

    5 days ago

    Springfield, United States Modern Government Solutions Full time

    TITLE: Senior GEOINT Standards Developer LOCATION: Springfield, VA CLEARANCE REQUIRED: Active DoD TS/SCI security clearance EMPLOYMENT TYPE: Full-time, On-site POSITION SUMMARY Modern Government Solutions (MGS) is seeking an experienced senior level GEOINT Standards Developer to join our team! This person will be responsible for writing requirements,...

  • Senior GEOINT Standards Developer

    5 days ago

    Springfield, United States Modern Government Solutions Full time

    Job DescriptionJob DescriptionTITLE: Senior GEOINT Standards DeveloperLOCATION: Springfield, VACLEARANCE REQUIRED: Active DoD TS/SCI security clearanceEMPLOYMENT TYPE: Full-time, On-sitePOSITION SUMMARYModern Government Solutions (MGS) is seeking an experienced senior level GEOINT Standards Developer to join our team! This person will be responsible for...

  • Data Engineer | TS(SCI Eligible)

    1 month ago

    Springfield, United States Connect Talent Solutions Full time

    Job DescriptionJob DescriptionConnect Talent Solutions is a fast growing, innovative staffing firm offering direct placement, contract and contract to hire solutions. We are uniquely positioned and experienced to support your requirements from IT and engineering to general labor and customer service positions. At Connect, people are the center of our...

  • Oracle Business Intelligence Expert

    5 days ago

    Springfield, United States PotomacWave Consulting Full time

    PotomacWave is looking for an Oracle Business Intelligence Expert to join our team supporting our Federal Client’s Data Warehouse located in Springfield, VA (Metro Accessible)! A successful candidate will have experience with Oracle Business Intelligence Applications (OBIA). Responsibilities: Ability to advise the client on matters relating to the design...

  • Oracle DBA with Security Clearance

    1 month ago

    Springfield, United States Case Management Consulting, LLC Full time

    Primary Place of Performance: Springfield, VA. Security: Contractor personnel are required to have active TS/SCI clearances for access to NGA facilities, when performing duties within classified environments, and for access to classified NGA computer systems. Contractor personnel are subject to initial and random CI polygraphs at any time, depending upon...

  • Oracle Business Intelligence Expert

    5 days ago

    Springfield, United States PotomacWave Consulting Full time

    Job DescriptionJob DescriptionPotomacWave is looking for an Oracle Business Intelligence Expert to join our team supporting our Federal Client’s Data Warehouse located in Springfield, VA (Metro Accessible)! A successful candidate will have experience with Oracle Business Intelligence Applications (OBIA).Responsibilities:Ability to advise the client on...

  • Oracle DBA

    4 weeks ago

    Springfield, United States CASE Management Consulting, LLC Full time

    Job DescriptionJob DescriptionScope: Oracle DBA (Data Engineer L4)Primary Place of Performance: Springfield, VA.Security: Contractor personnel are required to have active TS/SCI clearances for access to NGA facilities, when performing duties within classified environments, and for access to classified NGA computer systems. Contractor personnel are subject to...

  • Oracle DBA

    1 day ago

    Springfield, United States CASE Management Consulting, LLC Full time

    Job DescriptionJob DescriptionScope: Oracle DBA (Data Engineer L4)Primary Place of Performance: Springfield, VA.Security: Contractor personnel are required to have active TS/SCI clearances for access to NGA facilities, when performing duties within classified environments, and for access to classified NGA computer systems. Contractor personnel are subject to...

  • Technical GEOINT Analyst

    7 days ago

    Springfield, United States Associates Systems LLC Full time

    Technical GEOINT Analyst Job Category: Scientific/Analytical Posting Details Technical Ge Full-Time Locations Showing 1 location Springfield, VA 22150, USA Job Details Description We have an immediate need for a highly qualified individual who can successfully support supplier onboarding activities and integration test events for the new Commercial Analytic...

  • Oracle Business Intelligence Expert

    5 days ago

    Springfield, VA, United States PotomacWave Consulting Full time

    PotomacWave is looking for an Oracle Business Intelligence Expert to join our team supporting our Federal Client’s Data Warehouse located in Springfield, VA (Metro Accessible)! A successful candidate will have experience with Oracle Business Intelligence Applications (OBIA). Responsibilities: Ability to advise the client on matters relating to the design...

  • Tableau Analyst with active TS/SCI

    1 month ago

    Springfield, United States CareerBuilder Full time

    RTI is seeking a TS/SCI cleared individuals with a Strong Tableau Experience who will manage the life cycle of Tableau analytics dashboards, including business requirements gathering, functional specification write-up, prototyping, development, quality testing, user acceptance testing, roll-out and post-launch enhancements implementation to support customer...