Application Development Advisor

What you'll do

• Translate complex business requirements into efficient ETL architecture, workflows, and data transformation rules.
• Develop and optimize data extraction, transformation, and loading processes within parallel processing frameworks.
• Write and maintain advanced SQL scripts for data manipulation and validation.
• Schedule ETL jobs using ESP and manage testing and deployment in Production environments.
• Design and implement CI/CD pipelines and methodologies for ETL deployments.
• Perform comprehensive application test planning, execution, and defect resolution.
• Execute data mapping activities, including source-to-target mapping and conversions to multiple output formats.
• Review and validate design specifications and code deliverables from development teams to ensure compliance.

What we're looking for

• Bachelor’s degree in any field and 5 years of experience.
• Experience in the healthcare domain.
• Experience developing ETL solutions using IBM DataStage.
• Experience with Master data management using Reltio, Apache Kafka, and Amazon S3.
• Experience writing complex SQL queries to develop and test ETL requirements.
• Experience using relational databases including Teradata, Oracle, DB2, and SQL Server.
• Experience using CA WA Workstation to create, manage, and schedule ESPs.
• Experience using SQL editors, Postman, WinSCP, Putty, UltraEdit, and NotePad++.