Lead ETL/Ab Initio Developer

Title: Lead ETL/Ab Initio Developer

Location: Chicago, IL (100% REMOTE)

Description:

*****NO C2C ONLY ON OUR W2*****

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

- 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.

- 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.

- 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.

- Preferred Qualifications: Experience with DB2 and Postgres databases.

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

- 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.

- Qualifications: Preferred: master's degree in computer science or a related field.

- Required: bachelor's degree in computer science or a related field.