Conversion ETL Developer

Integres - Crownsville, MD

Full-time
Save

Conversion ETL Developer

Integres, LLC, a SDVOSB, is looking for a Conversion ETL Developer to work on-site for a State of Maryland Government client in Crownsville, MD. This full-time position will work with ETL Developers, Business Analysts, DBAs, System Administrators, and Data Modeling Teams for ETL build and design. This Developer will translate business requirements into technical requirements and work closely with the team responsible for maintaining the data model, including data dictionary/metadata registry. They will contribute to the requirements elicitation process, create application architecture documents, design, develop, and test ETL mappings and workflows using Talend (5.x or 6.x). This position will conduct performance tuning of end-to-end ETL integration processes and determine optimal approach for obtaining data from diverse source systems.

The successful candidate will have the ability to understand data quality methodologies and data governance to ensure standardization of data. They will be a key contributor to initiatives that require technical expertise and will interface with business stakeholders to understand requirement and offer solutions. The candidate will have strong exposure working with relation databases Postgres, DB2, Oracle, & SQL Server including complex SQL constructs and DDL generation. They will have experience with the Talend in creating complex parallel loads and dependency creation using workflows and possess expertise in project migration and release coordination activities.

In order to be successful in this position, we expect you to have the following skills and experience:

  • Bachelor’s degree or higher in Information Systems, Computer Science, Engineering, Business, or other related discipline
  • Five (5) years of experience in ETL tools and with focus in legacy conversion and performance tuning of conversion run
  • Three (3) years with Linus/shell scripting complementary with Talend
  • SQL and conversion of SQL stored procedures into Talend and with File base conversion
  • Strong knowledge of relational databases and extensive experience with SQL scripting/stored procedures in PostgreSQL
  • Strong scripting skills with some experience in software engineering and experience with conversion data mapping design
  • Strong exposure working with web service sources/Targets, XML Sources, and Restful API’s
  • Ability to obtain Security Clearance

*
Desired/Preferred Qualifications:

  • Experience with Agile Methodologies*
  • Experience with HHS, CCWIS, SNAP, TANF, WIC, CHIP, EHR, or other Federal and/or State health and human services programs.**
  • Preference will be given to those individuals where their primary residency is located in a qualified HUBZone (https://maps.certify.sba.gov/hubzone/map#)*

Successful Integres employees will display the following characteristics:

  • Always display excellence and accountability in your job performance
  • Willingness to contribute to achieving corporate goals by interacting with our customers as true partners
  • Strive to become highly qualified in your field.

Integres Benefits:

Integres offers competitive salaries bolstered by a comprehensive benefits package, which provides safety and security for our employees and their families. Our generous benefits package includes:

  • Healthcare and Insurance: medical, dental, vision, short and long-term disability protection, basic life and AD&D insurance
  • Flexible Spending Account
  • 401(k) Savings Plan
  • Accrued Paid Time Off (PTO)
  • Employee Recognition and Rewards
  • Employee Referral Bonuses

Integres is an equal opportunity affirmative-action employer. We encourage Minority/Female/Protected Veteran/Disabled applicants to apply. Integres, LLC proactively fulfills its role as an equal opportunity employer. We do not discriminate against any employee or applicant for employment because of race, color, sex, religion, age, sexual orientation, gender identity and expression, national origin, marital status, physical or mental disability, status as a Disabled Veteran, Recently Separated Veteran, Active Duty Wartime, or Campaign Badge Veteran, Armed Forces services Medal, or any other characteristic protected by law.

Job Type: Full-time

Experience:

  • Linus/shell scripting complementary with Talend: 3 years (Required)
  • ETL tools for legacy conversion and performance tuning: 5 years (Required)
  • Postgres, DB2, Oracle & SQL Server: 3 years (Required)

Education:

  • Bachelor's (Required)

Work Location:

  • One location