ICONMA
Our Client, a Healthcare company, is looking for a Senior Data Engineer for their McLean, VA/Remote location.
Responsibilities:
Design and deploy scalable ETL pipelines on AWS using services such as Glue, Lambda, S3, and Redshift.
Ingest and process UDP-based data sources via EC2 instances or containerized ingestion services.
Configure and optimize AWS infrastructure for performance, reliability, and cost-effectiveness.
Develop and maintain efficient PL/SQL code including stored procedures, packages, triggers, and functions.
Design and optimize relational database schemas for scalability and normalization.
Perform query tuning and performance optimization across SQL and PL/SQL workloads.
Build and schedule robust ETL jobs and data workflows using cron or enterprise orchestration tools.
Develop and support integration of disparate data sources (flat files, third-party databases).
Conduct data validation and cleansing operations to ensure accuracy and completeness.
Troubleshoot and resolve data quality issues across systems.
Support SIT, UAT, and performance testing of Oracle Financial Applications.
Work autonomously within well-defined system design frameworks to implement Unified Data Platform (UDP) components.
Collaborate with development and business analysis teams to understand functional and technical design.
Participate in code review sessions and implement feedback for quality improvements.
Perform impact and gap analysis in response to system software changes.
Maintain technical documentation, coding standards, and system architecture artifacts.
Ensure compliance with industry regulations and internal governance policies (e.g., HIPAA).
Communicate technical impacts, root cause findings, and resolutions effectively to leadership.
Read, understand, and adhere to all corporate policies including policies related to HIPAA and its Privacy and Security Rules
Requirements:
Bachelor’s degree in computer science, Information Systems, or related field.
Requires 7+ years of experience with PL/SQL development, performance tuning, troubleshooting, and working with large datasets in RDBMS.
Experience with AWS services such as Glue, Redshift, Lambda, S3, IAM, EC2 for data processing and pipeline development.
Ability to write and optimize complex SQL queries efficiently.
Solid foundation in relational schema design, indexing strategies, and scalable architecture.
Skilled in applying data validation, cleansing techniques, and quality frameworks.
Understanding of SDLC and STLC processes for structured development and testing.
Excellent interpersonal skills with a demonstrated ability to work effectively across technical and business teams.
Experience developing listener services and managing real-time data.
Proven background designing, implementing, and scheduling ETL workflows and data integration solutions.
Proficient in Unix environments with hands‑on shell scripting experience.
Knowledge of business intelligence and data warehouse methodologies
Knowledgeable of the healthcare industry, managed care, and operational systems
Excellent verbal and written communication skills
Why Should You Apply?
Health Benefits
Referral Program
Excellent growth and advancement opportunities
As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or express, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws.
#J-18808-Ljbffr
Responsibilities:
Design and deploy scalable ETL pipelines on AWS using services such as Glue, Lambda, S3, and Redshift.
Ingest and process UDP-based data sources via EC2 instances or containerized ingestion services.
Configure and optimize AWS infrastructure for performance, reliability, and cost-effectiveness.
Develop and maintain efficient PL/SQL code including stored procedures, packages, triggers, and functions.
Design and optimize relational database schemas for scalability and normalization.
Perform query tuning and performance optimization across SQL and PL/SQL workloads.
Build and schedule robust ETL jobs and data workflows using cron or enterprise orchestration tools.
Develop and support integration of disparate data sources (flat files, third-party databases).
Conduct data validation and cleansing operations to ensure accuracy and completeness.
Troubleshoot and resolve data quality issues across systems.
Support SIT, UAT, and performance testing of Oracle Financial Applications.
Work autonomously within well-defined system design frameworks to implement Unified Data Platform (UDP) components.
Collaborate with development and business analysis teams to understand functional and technical design.
Participate in code review sessions and implement feedback for quality improvements.
Perform impact and gap analysis in response to system software changes.
Maintain technical documentation, coding standards, and system architecture artifacts.
Ensure compliance with industry regulations and internal governance policies (e.g., HIPAA).
Communicate technical impacts, root cause findings, and resolutions effectively to leadership.
Read, understand, and adhere to all corporate policies including policies related to HIPAA and its Privacy and Security Rules
Requirements:
Bachelor’s degree in computer science, Information Systems, or related field.
Requires 7+ years of experience with PL/SQL development, performance tuning, troubleshooting, and working with large datasets in RDBMS.
Experience with AWS services such as Glue, Redshift, Lambda, S3, IAM, EC2 for data processing and pipeline development.
Ability to write and optimize complex SQL queries efficiently.
Solid foundation in relational schema design, indexing strategies, and scalable architecture.
Skilled in applying data validation, cleansing techniques, and quality frameworks.
Understanding of SDLC and STLC processes for structured development and testing.
Excellent interpersonal skills with a demonstrated ability to work effectively across technical and business teams.
Experience developing listener services and managing real-time data.
Proven background designing, implementing, and scheduling ETL workflows and data integration solutions.
Proficient in Unix environments with hands‑on shell scripting experience.
Knowledge of business intelligence and data warehouse methodologies
Knowledgeable of the healthcare industry, managed care, and operational systems
Excellent verbal and written communication skills
Why Should You Apply?
Health Benefits
Referral Program
Excellent growth and advancement opportunities
As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or express, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws.
#J-18808-Ljbffr