Data Engineer (Hybrid)

Key Responsibilities

• Design, develop, and maintain ETL mappings, workflows, and integrations using Informatica PowerCenter and Informatica IICS
• Develop optimized Snowflake SQL scripts for complex data transformation, processing, and analytics workloads
• Acquire, cleanse, transform, and integrate data from Oracle, SQL Server, Excel, Access, Adobe PDF, and enterprise systems
• Design and develop dimensional data models to support Tableau dashboards, analytics, and business intelligence reporting
• Collaborate with Agile teams, business analysts, architects, developers, and stakeholders to gather and analyze technical and business requirements
• Participate in Agile/Scrum ceremonies including sprint planning, backlog grooming, standups, sprint reviews, and retrospectives
• Validate system outputs and ensure data accuracy, integrity, reliability, and quality standards are maintained
• Create technical documentation, mapping specifications, workflow diagrams, and systems documentation using tools such as Visio and Erwin
• Support deployment, CI/CD automation, and version control processes using GitHub and GitHub Actions
• Develop automation scripts and integrations using Python, REST/SOAP web services, Java, and JavaScript where required
• Ensure compliance with healthcare security, privacy, PII, and PHI handling standards
• Support enterprise integration and interoperability initiatives involving Mulesoft and web services
• Troubleshoot ETL workflows, database performance issues, and data integration failures
• Participate in architecture discussions and recommend scalable data engineering solutions
• Evaluate modern analytics and AI-enabled tools including Snowflake Cortex and Informatica Claire
• Cookordination with stakeholders and project managers to prioritize deliverables and timelines
• Provide technical guidance, knowledge transfer, and best practice recommendations to team members
• Support continuous improvement initiatives across enterprise analytics and data engineering environments

Requirements

• Minimum 8 years of experience with Informatica PowerCenter or Informatica IICS ETL development
• Minimum 8 years of experience integrating enterprise data from Oracle, SQL Server, Excel, Access, Adobe PDF, and related sources
• Minimum 8 years of experience developing and optimizing Snowflake SQL scripts
• Strong experience with ETL development, data warehousing, dimensional modeling, and analytics systems
• Strong analytical, systems analysis, troubleshooting, and problem-solving capabilities
• Experience with technical documentation, Visio, Erwin, and Microsoft Office tools
• Experience supporting scalable software platforms and enterprise data integration environments
• Experience working in Agile/Scrum environments and using JIRA
• Knowledge of healthcare data security standards and PII/PHI handling requirements
• Experience with Python scripting, REST/SOAP services, Java, JavaScript, and API integrations
• Familiarity with GitHub, GitHub Actions, CI/CD pipelines, and Mulesoft integrations
• Experience with AI-powered data engineering tools such as Snowflake Cortex or Informatica Claire preferred

Qualifications

Bachelor’s degree in Computer Science, Information Systems, Business, or related field preferred (or equivalent experience)

Skills

• Agile/Scrum certification preferred
• Snowflake certification preferred
• Informatica certification preferred
• Tableau certification preferred

Benefits

Siritech Solutions Corp is a dynamic and innovative startup specializing in providing cutting-edge web, mobile, and software development solutions to clients worldwide. Established with a vision to revolutionize the digital landscape, we offer a comprehensive suite of services tailored to meet the diverse needs of businesses across various industries.

We pride ourselves on our ability to deliver high-quality, scalable, and cost-effective solutions that help our clients achieve their business objectives.