Senior Ab Initio ETL Developer - HCL Global Systems Inc.
Chicago, IL
About the Job
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.
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.
Source : HCL Global Systems Inc.
