Job description

Title: ETL Informatica Developer

Duration : long term

Type : W2

Project Responsibilities:

• Design complex ETL workflows and ETL patterns including Audit Controls and Error Handling utilizing industry and tool standards and best practices.
• Code complex ETL workflows.
• Review ETL code for standards, best practices, and efficiencies.
• Collaborate with other leads and senior resources for design and coding efficiencies.
• Experience in solving the business problem with the right Data architecture.
• Minimum 5 years experience with SQL and relational databases like PostgreSQL, MySQL, Teradata, SQL Server, and Oracle.
• Experience managing backlog in Jira is a big plus:
• Outstanding programming and debugging skills.
• Strong knowledge of common algorithms and data structures.
• Good understanding of job scheduling and workflow
• Have a good understanding of Data modeling concepts.

Effective oral and written communication skills requiredJob Description Job Description Job Description6+ years overall experience and 4+ years of ETL Informatica development
Knowledge in warehouse and containerization
Metadata management and data integrity skills will be an added benefit.
General Duties/responsibilities:Creates prototypes/ETL specifications based on requirements and analysis of data Designs and develops ETL mappings and workflows/sessions
Creates scripts for Oracle database tables and unit tests them Creates/modifies UNIX scripts
Ensures adherence to locally defined standards for all developed components
Supports the development and design of the internal data integration framework Performs unit tests and initial QA tests with test data Participates in DI design of new Data Warehouse projects
Participates in design and development reviews Creates change controls and coordinates approvals for implementation Works with source system owners to resolve source data issues and refine transformation rules Support all on-call production duties
Other Requirements:Bachelor’s degree in CS or relevant discipline 4+ years of experience as an ETL developer Informatica, Oracle and Unix skills essential
Informatica Certification preferred Metadata management and data integrity skills will be an added benefit

Job Type: Contract

Salary: $41.76 - $78.61 per hour

Benefits:

• 401(k)
• 401(k) matching
• Employee assistance program
• Flexible spending account
• Health insurance
• Professional development assistance

Experience level:

• 7 years
• 8 years
• 9 years

Schedule:

• 8 hour shift

Ability to commute/relocate:

• Honolulu, HI 96816: Reliably commute or planning to relocate before starting work (Required)

Experience:

• Informatica: 1 year (Preferred)
• SQL: 1 year (Preferred)
• Data warehouse: 1 year (Preferred)

Work Location: One location

seankuhnke.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, seankuhnke.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, seankuhnke.com is the ideal place to find your next job.