HYDERABAD · FULLTIME
Sr - Data Engineer
HCA Healthcare
Hyderabad · onsite · Posted 20d ago
Sourced from
Undisclosed5–8 yrsfulltimeHyderabad
About a minute. You'll make an account on the way through.
agent · working
- Read this posting0.8s
- Found the form on Naukri · 7 questions to answer1.4s
- Decided the answers for all of them2.8s
- Tailor your résumé to this role
- Waiting for you
Section · 01
About this role
Data Engineer to support the HIM Datamart used by ParallonHIM Operations. This critical role is responsible for creating, maintaining,monitoring, and supporting data pipelines that pull data from Teradata,multiple SQL Server environments, various GCP Datamarts, and other enterprisedata sources into the HIM GCP Datamart.
The successful candidate will design and support ETL and ELTprocesses using Airflow, DAGs, Google Cloud Dataproc, Python, PowerShell, SSIS,SQL, and other data integration technologies. The ideal candidate must becomfortable supporting production data pipelines, troubleshooting complex dataissues, improving data quality, and ensuring timely and accurate dataavailability for HIM operations.
This position is best suited for a data engineeringprofessional who can balance development, production support, automation, dataquality, cloud data engineering, documentation, and operational reliability ina critical healthcare operations environment.
;
Responsibilities:
- Design, develop, maintain, and support ETL/ELT data pipelines for the HIM GCP Datamart.
- Extract, transform, and load data from Teradata, SQL Server, GCP Datamarts, and other enterprise data sources into HIM data platforms.
- Develop and support data workflows using Airflow, DAGs, Dataproc, Python, PowerShell, SSIS, SQL, and related data integration tools.
- Create, schedule, monitor, and troubleshoot Airflow DAGs for recurring data ingestion, transformation, validation, reconciliation, and delivery processes.
- Develop and optimize SQL queries, stored procedures, views, functions, and transformation logic across SQL Server, Teradata, PostgreSQL, BigQuery, and other relational platforms.
- Support on-premise to GCP data integration using Google Cloud Dataproc and related GCP services for large-scale data processing and transformation.
- Monitor data pipelines for failures, delays, performance issues, data quality problems, schema changes, and source system impacts.
- Troubleshoot production data issues, including missing data, late-arriving files, failed jobs, transformation errors, data mismatches, and performance bottlenecks.
- Perform root cause analysis and implement long-term fixes to improve pipeline reliability, reduce recurring failures, and improve operational stability.
- Implement data validation, reconciliation, and quality checks to ensure HIM data is complete, accurate, consistent, and timely.
- Collaborate with Parallon HIM Operations, source system owners, and technical teams to understand data needs, dependencies, refresh schedules, reporting impacts, and business priorities.
- Create and maintain data pipeline documentation, data flow diagrams, source-to-target mappings, job schedules, support procedures, and operational runbooks.
- Participate in release management, change control, defect resolution, enhancement delivery, incident response, and production support activities.
- Improve automation, monitoring, alerting, logging, and operational visibility across HIM data pipelines.
- Ensure data engineering solutions follow enterprise standards for security, privacy, compliance, data governance, change control, and production readiness.
- Identify opportunities to modernize legacy ETL processes and improve scalability, maintainability, reliability, and cost efficiency.
Education Experience:
- Bachelorsdegree in Computer Science, Information Systems, Data Engineering, Engineering,Healthcare Informatics, or a related field is required.
- Fiveor more years of experience in data engineering, ETL/ELT development, datawarehousing, data integration, or supporting enterprise data platforms, datamarts, data lakes, or operational data stores.
- Stronghands-on experience designing, developing, maintaining, and troubleshootingproduction data pipelines using SQL, Python, PowerShell, SSIS, Apache Airflow,DAGs, and other ETL/ELT technologies.
- StrongSQL experience across SQL Server, Teradata, PostgreSQL, BigQuery, or similarplatforms, including complex queries, joins, aggregations, stored procedures,views, functions, performance tuning, and source-to-target validation.
- Experienceextracting, integrating, and migrating data from Teradata, SQL Server,file-based sources, GCP Datamarts, and other enterprise data sources intoGCP-based data platforms.
- Experiencewith Google Cloud Platform data services, including Dataproc, Cloud Composer,Cloud Storage, BigQuery, Cloud SQL, Cloud Logging, and Cloud Monitoring.
- Experiencewith batch processing, job scheduling, dependency management, error handling,logging, alerting, data validation, reconciliation, data quality checks, andproduction support for critical business operations.
- Experiencewith file-based integrations, including CSV, fixed-width files, Excel, JSON,XML, Parquet, Avro, and delimited files.
- Experiencewith CI/CD and source control practices using GitHub, Azure DevOps, Git, YAMLpipelines, or similar tools.
- Stronganalytical, troubleshooting, problem-solving, written communication, and verbalcommunication skills, with the ability to work independently andcollaboratively with technical and business teams.
Must Have Skills
- Experiencewith Spark, PySpark, Hadoop, or distributed data processing frameworks.
- Experiencewith Teradata SQL, BTEQ, FastExport, TPT, or other Teradata data extractionpatterns.
- Experiencedesigning scalable data ingestion frameworks and reusable pipeline components.
- Experiencewith incremental loads, full refreshes, CDC patterns, SCD handling,partitioning, and data archival strategies.
- Experiencewith secure file transfers, file watchers, landing zones, staging tables, anddata lake patterns.
- Experiencewith data modeling, dimensional modeling, star schemas, snowflake schemas, andreporting-friendly data structures.
- Experiencewith BI/reporting platforms and downstream analytics dependencies.
- Experiencewith monitoring, alerting, operational dashboards, and data pipelineobservability.
- Experiencewith healthcare data, HIM operations, revenue cycle, coding, clinicaldocumentation, billing, or Parallon operational data is strongly preferred.
- Experiencewith data privacy, HIPAA, PHI handling, role-based access, encryption, auditlogging, and healthcare compliance requirements.
Experienceworking in Agile/Scrum or Lean delivery environments
- Cloud/DataPlatforms: Google Cloud Platform, HIM GCP Datamart, GCP Datamarts,BigQuery, Cloud SQL, Cloud Storage, Data Lakes, Data Marts, Data Warehousing
- OrchestrationProcessing: Apache Airflow, DAGs, Cloud Composer, Google CloudDataproc, PySpark, Batch Processing, Job Scheduling
- ETL/ELTIntegration: ETL, ELT, SSIS, File-Based Integrations,Source-to-Target Mapping, Data Validation, Data Reconciliation, Data QualityChecks
- DatabasesSQL: SQL Server 2019, Teradata, Teradata SQL, PostgreSQL, StoredProcedures, Views, Functions, Indexes
- ScriptingAutomation: Python, PowerShell, YAML
- File/DataFormats: JSON, XML, CSV, Parquet
- DevOpsSupport: GitHub, Azure DevOps, CI/CD Pipelines, Cloud Logging, CloudMonitoring, Monitoring and Alerting, Production Support
Nice to Have Skills
- Fiveor more years of relevant data engineering, ETL development, or datawarehousing experience.
- Hands-onexperience with SQL, Python, Airflow, DAGs, SQL Server, and ETL development isrequired.
- Experiencewith Teradata and SSIS is strongly preferred.
- Experiencewith Google Cloud Platform, Dataproc, Cloud Composer, Cloud Storage, BigQuery,or related GCP data services is preferred.
- Experiencesupporting production data pipelines and critical business operations isrequired.
- Experiencewith data validation, reconciliation, monitoring, alerting, and productiontroubleshooting is required.
- HealthcareIT, HIM, revenue cycle, or Parallon operational data experience is preferred.
Knowledge, Skills, Abilities, Behaviors:
- Strongownership mindset with the ability to support critical operational dataprocesses.
- Abilityto understand business workflows and translate them into reliable dataengineering solutions.
- Abilityto communicate data issues, risks, dependencies, and resolution plans clearlyto technical and non-technical stakeholders.
- Strongattention to detail, especially when working with operational, financial,healthcare, or compliance-sensitive data.
- Abilityto troubleshoot complex data issues across source systems, ETL processes, cloudplatforms, databases, and downstream consumers.
- Abilityto prioritize production support issues based on business impact andoperational urgency.
- Abilityto create clear documentation, data flow diagrams, source-to-target mappings,and support runbooks.
- Abilityto work effectively with business teams, source system owners, cloud teams,database teams, reporting teams, and application support teams.
- Self-motivatedlearner who stays current with data engineering, cloud data platforms,orchestration tools, and automation practices.
- Abilityto work with minimal supervision while managing multiple priorities.
- Collaborativeteam player with strong analytical and problem-solving skills.
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Sourced from naukri
Section · 02
Skills
BTEQCdcAutomationAzure DevopsAgileBatch processingCI/CD PipelinesApacheapache airflowChange ControlbigqueryCloud ComposerAnalyticsCloud DataApplication SupportcloudBusiness OperationsMicrosoft Azure
Section · Company
About HCA Healthcare
HCA Healthcare
Healthcare
4.0k+
employees
Nashville, TN
USA
₹17.9L PA avg
Avg at HCA Healthcare
About
HCA Healthcare - India is an integral innovation and operational hub in support of HCA Healthcare and our mission: Above all else, we are committed to the care and improvement of human life. HCA Healthcare is a company focused on creating healthier tomorrows through the delivery of patient-centered care across approximately 190 hospitals and 2,400 sites of care in the United States and United Kingdom.
Every day, our colleagues around the world go to work with a collective focus: our patients. This focus positively impacts the care experience at the bedside and beyond. HCA Healthcare - India serves as a vital hub for operations and supports HCA Healthcares work to enhance healthcare delivery through technology and innovation.
Industries
Healthcare
Employee ratings
9 reviews
4.7/ 5
Culture
4.3
Career growth
3.3
Work-life
4.1
Employees rate it well for
Company Culture47Job Security47
Find them on