ETL Developer

The Judge Group - Boston, MA

Full-time

Boston, MA

Administrative and Support Services

About the position

The client is seeking an ETL Developer to enable digital transformation for partners in a global delivery model. This role involves researching technologies independently, recommending appropriate solutions, and providing technology-specific best practices and standards. The ETL Developer will interface with key stakeholders and apply technical proficiency across different stages of the Software Development Process. The position is part of a learning culture that encourages partnership and collaboration, rewards excellence, and respects and values diversity. In this role, the ETL Developer will participate in crafting application architecture documents to ensure that the work aligns with architectural requirements. They will create design artifacts and support prototyping through the creation of Proofs of Concept (POCs). The developer is expected to deliver high-quality code and support peers in quality checks to ensure that design requirements are met. Additionally, they will create documentation for assigned modules and lead validation activities for all types of testing, including Functional, Integration, System, and User Experience testing. The ETL Developer will also support the creation of the "Go Live" plan and lead assigned activities within that plan. They will perform root-cause analysis of any issues that arise post-implementation and work on appropriate solutions. Participation in Knowledge Transfer sessions, preparation of system appreciation documents, and support for the transition process are also key responsibilities. The developer will conduct impact analysis of logged issues, prioritize them, and ensure that production support is provided as per committed Service Level Agreements (SLAs). Furthermore, they will lead data integration projects and support and mentor other team members to enhance the team's effectiveness.

Responsibilities

• Participate in crafting application architecture documents to align work with architectural requirements.
• Create design artifacts and support prototyping through the creation of POCs.
• Deliver high-quality code and support peers in quality checks to meet design requirements.
• Create documentation for assigned modules.
• Lead validation activities for assigned modules for all types of testing (Functional, Integration, System, User Experience, etc.).
• Support the creation of the 'Go Live' plan and lead assigned activities in the plan.
• Perform root-cause analysis of issues that arise post-implementation and work on appropriate solutions.
• Participate in Knowledge Transfer sessions and prepare system appreciation documents to support the transition process.
• Conduct impact analysis of logged issues, prioritize them, and ensure production support is provided as per committed SLAs.
• Lead data integration projects and support and mentor other team members.

Requirements

• Bachelor's degree or equivalent from an accredited institution; will consider three years of dynamic experience in the specialty in lieu of every year of education.
• At least 3 years of experience in Informatica IICS ETL.
• Experience with other ETL platforms (SSIS, ODI, CDATA).
• Good experience in end-to-end implementation of data warehouse and data marts.
• Strong knowledge and hands-on experience in SQL and Unix shell scripting.

Nice-to-haves

• Good understanding of data integration, data quality, and data architecture.
• Experience in Relational Modeling, Dimensional Modeling, and Modeling of Unstructured Data.
• Good understanding of Agile software development frameworks.