Go Intellects Inc · 4 days ago

ETL Developer

Washington, DC

Full-time

Onsite

Senior Level

10+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

ConsultingProject Management

Insider Connection @Go Intellects Inc

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Create data mapping and workflows using Informatica Powercenter to extract, transform and load data into the target environments (batch files, databases)

Create Technical design documents and develop test plans for ETL unit testing and integration testing.

Work and Interact with functional and integration teams on architecture and design.

Tune and optimize ETL batch jobs for performance and throughput.

Conform to Informatica workflow and mapping standards so that development is done in a consistent manner across all development resources (no hard coding, leverage of mapplet / reuse concept)

Develop ETL workflows and mappings from ODS to Datawarehouse using Informatica Powercenter.

Provide development support and mentor junior developers.

Assist with troubleshooting ETL batch job issues in production, PreProd, QA, and UAT.

Work and Support Infrastructure and development teams.

Experience in Informatica Powercenter Installation, Administration and Configuration is a plus.

Familiarity with Informatica Powercenter HTTP Adapter, JMS Adapter, Webservices Hub is good to have.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Informatica PowerCenterWorkflow DevelopmentMapping DesignTestingAdministrationInstallationConfigurationHTTP AdapterJMS AdapterWebservices HubProject Management Professional (PMP) Certification

Required

Bachelor’s degree in Information Technology or related field or equivalent experience

At least 10+ years of proven professional experience in the design, development, testing and administration of Informatica PowerCenter workflows and mappings