Key Facts

Remote From:

Washington (USA)

Category: Data Engineer

Full time

Mid-level (2-5 years)

English

Roles & Responsibilities

Experience in data engineering and data migration.
Strong SQL and relational database skills.
Proficiency in Informatica, Informatica S3 Connector, AWS CLI, Cloud (AWS), CloudBees Jenkins, Jira, Confluence, GitLab, PostgreSQL, Oracle, SQL, Tableau, TOAD, Linux.
Bachelor's degree and 3 years of experience.

Requirements:

Support data assessment, source-to-target mapping, transformation, cleansing, trial migrations, validation, reconciliation, cutover support, and post-migration issue resolution.
Collaborate with developers, testers, business stakeholders, and teams to execute migration activities.
Document migration strategies, mappings, scripts, and results.
Monitor and troubleshoot data pipelines to ensure performance and reliability.

ARK Solutions, Inc.

Human Resources, Staffing & Recruiting

About ARK Solutions, Inc.

WE'RE A COMPANY THAT CARES FOR OTHERS BEYOND STAFFING OUR CULTURE SHAPES EVERYTHING WE DO. Our people, clients, and consultants matter to us more than anything. We are driven by a culture of purpose, shared values, and growth. OUR CLIENTS ARE OUR DRIVING FORCE Whether it’s finding the right candidate for a job or seamlessly managing a project end to end, our conviction and commitment to our clients runs deep. No matter what it takes, we’re devoted towards the success of your business. OUR PEOPLE ARE OUR FAMILY Our team members are our family. We’re here for you and we won’t stop until you’re exactly where you want to be. We believe in your potential and we are devoted to helping you achieve your ambition. IT’S ALL ABOUT YOU Your business is our business. We believe in making our relationship and understanding strong, and we know just how to do that. Our mantra is: analyze, identify, recruit, execute. Our mission is to create relationships, not transactions. Our promise is that we'll be there, as questions or issues arise, every step of the way. With experience in staffing and implementing projects, we thrive on sharing our experience and knowledge to help you make a success of your business. Our track record proves that clear communication and expert collaboration will boost your bottom line. ARK was formed in 2003 with the goal of becoming the supplier of choice for clients, employer of choice for our employees and contingent workforce. We provide high-volume staffing, SOW and payrolling services to structured contingent workforce programs and projects across USA. With our deep industry knowledge, business process expertise, comprehensive resources and a proven track record, ARK Solutions, Inc. can mobilize the right talent across various skills. ARK Solutions, Inc. is a certified Minority Women Owned Firm by NMSDC, State of VA, PA, NY and MD.

Company type: SME

Industry: Human Resources, Staffing & Recruiting

Founded: 2018

Company size: 201 - 500

Website LinkedIn See all jobs →

Job description

Data Pipeline Engineer - Remote, Washington, DC

Duration: 12+ months

Seeking for a skilled Data Pipeline Engineer to join our team. In this role, you will be responsible for planning, developing, and maintaining ETL workflows and data pipelines. You will work on migrating legacy application data from MS SQL and Oracle environments into the Pega platform while ensuring alignment with IRS business rules and PGLD/RIM requirements.

Key Responsibilities:

Support data assessment, source-to-target mapping, transformation, cleansing, trial migrations, validation, reconciliation, cutover support, and post-migration issue resolution.
Collaborate with developers, testers, business stakeholders, and teams to execute migration activities.
Document migration strategies, mappings, scripts, and results.
Monitor and troubleshoot data pipelines to ensure performance and reliability.
Support deployment, cutover activities, and post-migration issue resolution.

Must-Have Skills:

Experience in data engineering and data migration.
Strong SQL and relational database skills.
Proficiency in Informatica, Informatica S3 Connector, AWS CLI, Cloud (AWS), CloudBees Jenkins, Jira, Confluence, GitLab, PostgreSQL, Oracle, SQL, Tableau, TOAD, Linux.
Bachelor's degree and 3 years of experience.
Strong understanding of data mapping, transformation, and data quality processes.
Ability to work independently and meet project deadlines.
Strong analytical and problem-solving skills.