Computer Programmer ETL
Company: DK Consulting, LLC
Location: Baltimore
Posted on: March 20, 2023
Job Description:
DK Consulting Overview: Founded in May 2003, DK Consulting, LLC,
a woman-owned small business, was formed to provide management and
technology solutions based on industry best practices. DK
Consulting, LLC works with multiple State, Federal, and Commercial
customers, and our services range from providing customers with
that one 'critical resource' to assuming responsibility for an
entire IT project. We offer excellent benefits and provide
exceptional employee management.
Start Date: July 1st, 2023
Length of contract: 5 years
Location: 750 East Pratt Street, 6th Floor, Baltimore, Md 21202
(the resource may be required to work on-site or remotely on
specific days as determined by the client)
Duties/Responsibilities
- Design, develop, automate, support, and monitor performance
tuning using Informatica.
- Develop stored procedures, triggers, and functions in SQL in
PostgreSQL or other databases.
- Architect Extract, Transform, and Load (ETL) solutions and data
conversion strategies for integrating disparate systems.
- Create data mapping and modeling for data migrations.
- Create an end-to-end solution for ETL transformation jobs that
involve writing Informatica workflows and mappings, SQL procedures,
and functions.
- Develop, maintain, and enhance Informatica Mappings,
Work-flows, and processes.
- Adhere to all security, change control, and MHBE Project
Management Office (PMO) policies, processes, and
methodologies.
- Note: The candidate must be flexible to work overtime as
needed, including weekends, holidays, and off-hours.
Minimum Qualifications
- Six (6) years of experience in enterprise application
development.
- Four (4) years of hands-on experience in Extract, Transform,
and Load (ETL) design, development, performance tuning, monitoring,
and supporting using Informatica.
- Two (2) years of hands-on experience in creating complex and
efficient SQL queries, stored procedures, triggers, and
functions.
- Two (2) years of hands-on experience in ETL platform
administration and integration for performance monitoring and
analysis.
- Four (4) years of experience as a database or reports developer
utilizing SQL.
- Four (4) years of hands-on experience using Informatica
PowerCenter.
- Experience in establishing and maintaining reporting databases
and data warehouses.
- Demonstrated ability to manage multiple critical priorities and
tight deadlines.
- Demonstrated analytical and problem-solving skills.
Preferred Qualifications
- Eight (8) years of experience developing, maintaining, and
enhancing Informatica Mappings, Workflows, and processes.
- Six (6) years of hands-on experience using Informatica
PowerCenter.
- Four (4) years of experience in developing ETL solutions and
data conversion strategies of disparate systems and creating data
mapping and modeling for data migrations.
- Four (4) years of hands-on experience in ETL design,
development, performance tuning, monitoring, and supporting using
Informatica.
- Four (4) years of hands-on experience in creating complex and
efficient SQL queries, stored procedures, triggers, and
functions.
- Four (4) years of ETL-related experience supporting health
exchange, health care EDI (Electronic Data Interchange), or Health
and Human Services applications.
- Experience in analyzing, converting, and transforming EDI
transaction sets such as the 834 and 999 IRS datasets, such as the
H36, H41, 1095-A, 1095-B, and SBMI.
- Knowledge of the Affordable Care Act (ACA) eligibility
rules.
- Experience with data quality assurance, quality control, and
large-scale Healthcare IT Systems data compliance
processes.
- Experience working with the Project Management Office (PMO)
processes, policies, and procedures.
Keywords: DK Consulting, LLC, Baltimore , Computer Programmer ETL, IT / Software / Systems , Baltimore, Maryland
Didn't find what you're looking for? Search again!
Loading more jobs...