What are the responsibilities and job description for the Senior Ab Initio ETL Developer position at VDart?
Mandatory Areas
Must Have Skills –
Skill 1 – 12 Yrs of Exp – Ab Initio ETL Development
Skill 2 – 12 Yrs of Exp – UNIX systems
Skill 3 – 12 Yrs of Exp – Ab Initio Graphical Development Environment (GDE).
Skill 4 – 12 Yrs of Exp – Ab Initio Meta Data Hub (MDH).
Skill 5 – 12 Yrs of Exp - Ab Initio EME (Enterprise Meta>Data Environment) and Control Center
Skill 6- 12 Yrs of Exp-- developing web services using Ab Initio Continuous Flows.
Skill 7 – 12 Yrs of Exp – Control-M Scheduler
Skill 8 – 12 Yrs of Exp – Ab Initio tools, such as Query>IT, MDH, and BRE
Skill 9- 12 Yrs of Exp- designing end-to-end data warehousing and reporting solutions utilizing databases, ETL tools, and reporting frameworks
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.
