Senior Ab Initio ETL Developer

HCL Global Systems Inc
US - Illinois - Chicago
January 4, 2025

Responsibilities:

As an Ab Initio ETL Senior Developer, you will:

" Data Management: Oversee the extraction, transformation, and loading (ETL) processes for data warehousing.

" Component Design: Design and integrate ETL components while addressing and resolving data-related issues, collaborating closely with project leads.

" Technical Expertise: Utilize experience with ETL tools in a DB2 environment to support and enhance ETL processes.

" Code Development: Implement and develop efficient Ab Initio code by performing source and target analysis.

" Application Development: Contribute to the development and optimization of the ETL application, ensuring it meets business requirements.

" Testing and Quality Assurance: Create and execute comprehensive system and integration test plans to validate the ETL application.

" Specification Documentation: Develop detailed ETL specifications based on business needs to guide implementation.

" Collaboration: Assist in the overall design of the ETL application and actively participate in all project meetings to ensure alignment and progress.

Mandatory Technical Skills:

" Experience with DB2 and Postgres databases.

" Familiarity with handling PHI (Protected Health Information) and PII (Personally Identifiable Information) and sensitive data.

" 10+ years' experience working in data warehousing environment using Ab Initio suite.

" Knowledge of business intelligence and analytics tools such as Cognos or Tableau.

" In-depth knowledge of the U.S. healthcare system, including medical and prescription claims processing, healthcare enrollments, and provider operations.

" Awareness of security standards in data handling.

" Strong knowledge of UNIX systems.

" High proficiency in the Ab Initio Graphical Development Environment (GDE).

" Hands on experience with Ab Initio Meta Data Hub (MDH).

" Experience with Ab Initio EME (Enterprise Meta>Data Environment) and Control Center.

" Basic understanding of developing web services using Ab Initio Continuous Flows.

" Knowledge of Control-M Scheduler.

" Strong knowledge with additional Ab Initio tools, such as Query>IT, MDH, and BRE.

" Understanding of the Software Development Life Cycle (SDLC).

" Ability to create high-level and detailed designs represented as flow diagrams (preferably using Visio).

" Capability to translate business requirements into functional and technical specifications.

" Ability to breakdown complex issues into manageable components and designing solutions.

" Experience in designing end-to-end data warehousing and reporting solutions utilizing databases, ETL tools, and reporting frameworks.

" Ability to provide time estimates for development tasks based on design specifications.

" Experience collaborating with Production Validation (PV) and User Acceptance Testing (UAT) teams.

" Proficient in conducting detailed system impact analyses for change requests and providing accurate estimates.

" Leadership skills to mentor junior developers and provide feedback across multiple projects.

Soft Skills:

" Strong analytical and problem-solving abilities.

" Excellent written and verbal communication skills.

" Strong Technical design and facilitation skills with driving technical solutions while working with Business and IT leadership.

" Exceptional written and verbal communication skills.

" Effective documentation skills.

" Proficient in English for communication purposes.

" Open and honest communication with peers and management regarding estimations and project timelines, including proactive updates on issues and concerns.

" Assertiveness in presenting ideas, estimates, project scope, and timelines.

Read the full job description and apply online on the recuiter's web-site

Related Job Postings

Travel Registered Respiratory Therapist 1,899 per week

Fusion Medical Staffing Cardio

US - IL - IL - Chicago
January 4, 2025

Fusion Medical Staffing-Cardio is seeking a travel Registered Respiratory Therapist for a travel job in Chicago, Illinois. & Requirements • Specialty: Registered Respiratory Therapist • Discipline: Allied Health Professional • Start Date: 02/03/2025 • Duration: 13 weeks • 36 hours per week • Shift:...

Find Jobs Hiring Now Near You!

Get Jobilize Job Search Mobile App Now