EDW Informatica ETL Developer

Cloud Hybrid Technologies, LLC; Wilmington (NC); On-site; USD 90,000 - 120,000; Full time

Job summary

A technology consultancy is seeking an ETL Consultant with over 7 years of Informatica PowerCenter experience. The ideal candidate will have strong SQL skills, experience in data warehousing, and knowledge of state healthcare experience, specifically Medicaid and CHIP. Strong communication and organizational skills are essential. This position is located in Wilmington, North Carolina, and may involve remote work depending on candidate location.

Qualifications

• 7+ years of experience with Informatica PowerCenter and ETL development.
• 5+ years of experience writing complex SQL and performance tuning.
• 5+ years of experience with relational database management systems.
• 5+ years of Informatica PowerCenter administration experience.
• 5+ years of data warehouse development experience.
• 2+ years of Unix Shell (Bash/Korn) scripting experience.
• 2+ years of experience with Azure Data Factory and Snowflake.

Responsibilities

• Develop and implement ETL processes using Informatica PowerCenter.
• Optimize SQL queries for performance across various databases.
• Administer and maintain Informatica PowerCenter environments.

Skills

Informatica PowerCenter

ETL development

Complex SQL

Performance tuning

Data warehouse development

Data modeling using ERWIN

Unix Shell scripting

Azure Data Factory

Snowflake

Communication skills

Collaboration skills

Mentoring skills

Organizational skills

Time management skills

Education

Bachelor's or advanced degree in IT, Computer Science, Mathematics, or related field

Tools

Informatica Data Quality

Address Doctor

Metadata Manager

Job description

Note : Need consultant with state healthcare experience State Medicaid, CHIP, PERM and CMS. Locals and nearby states

Required Qualifications

7+ years of experience with Informatica PowerCenter and ETL development.

5+ years of experience writing complex SQL and performance tuning.

5+ years of experience with Enterprise Relational Database Management systems (Teradata, DB2, Oracle, or SQL Server)

5+ years of Informatica PowerCenter administration experience.

Strong communication, collaboration, and mentoring skills.

Bachelor's or advanced degree in IT, Computer Science, Mathematics, or a related field.

Strong organizational and time management skills

Preferred Qualifications

Residing in or near Springfield, IL.

5+ years of data warehouse development experience.

5+ years of data modeling experience using ERWIN or similar tools.

2+ years of Unix Shell (Bash/Korn) scripting experience.

2+ years of experience with Azure Data Factory and Snowflake.

Familiarity with Informatica Data Quality (IDQ), Address Doctor, and Metadata Manager.

Experience with Medicaid, Medicare, or healthcare data systems.

Experience working in Agile environments.

Knowledge of BI and data integration technologies across relational and multidimensional systems.

Cloud Hybrid is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. Cloud Hybrid will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will Cloud Hybrid require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract