The Baer Group - Washington, DC

posted 4 months ago

Full-time - Mid Level
Remote - Washington, DC
Professional, Scientific, and Technical Services

About the position

The Baer Group is seeking a highly skilled Sr. ETL Developer-Architect for a 12-month remote project focused on federal initiatives. This role is crucial for leading and mentoring a team of junior developers, ensuring the successful execution of ETL projects. The ideal candidate will possess extensive hands-on experience with ETL tools, particularly Informatica Intelligent Cloud Services (IICS) and Informatica Data Management Cloud (IDMC). The position requires the development of complex ETL pipelines for data integration and transformation, necessitating a deep understanding of data architecture and ETL processes. In this role, you will be responsible for creating comprehensive design documentation and collaborating with cross-functional teams, including data analysts, business analysts, and QA teams. This collaboration is essential to ensure robust design, testing, and validation processes are in place. The Sr. ETL Developer-Architect will also be expected to utilize advanced SQL skills for complex queries, data manipulation, and performance tuning, as well as manage Oracle database development and management tasks. The successful candidate will have a proven track record in data migration and conversion projects, along with familiarity with Salesforce applications. Leadership experience is critical, as you will guide a development team and oversee the deployment processes, particularly using GitHub. This position offers a unique opportunity to work on pivotal programs that leverage the latest technologies in the field, providing a platform for professional growth and skill enhancement.

Responsibilities

  • Lead, guide, and mentor junior developers to ensure project success.
  • Develop comprehensive design documentation.
  • Utilize hands-on experience with ETL tools, specifically Informatica Intelligent Cloud Services (IICS) and Informatica Data Management Cloud (IDMC), to build and optimize ETL pipelines.
  • Develop complex ETL pipelines for data integration and transformation.
  • Collaborate with cross-functional teams, including data analysts, business analysts, and QA teams, to ensure robust design, testing, and validation processes.

Requirements

  • 4 years of relevant experience in ETL development and data architecture.
  • Proficiency with Informatica IICS/IDMC for ETL development and data integration.
  • Strong experience in Oracle database development and management.
  • Advanced SQL skills for complex queries, data manipulation, and performance tuning.
  • Experience in data mapping, data modeling, and data design.
  • Proven experience in data migration and conversion projects.
  • Familiarity with Salesforce applications, including Object Manager and Workbench.
  • Experience leading a development team, providing guidance and oversight.
  • Experience with source control and deployment processes, particularly using GitHub.

Benefits

  • Hourly rate plus expenses reimbursed
  • Remote work flexibility
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service