ETL Developer Job at ACS Consultancy Services, Austin, TX

WHFLMWdaZEZYVkgzOW1kajZSUDd5ZGd1S3c9PQ==
  • ACS Consultancy Services
  • Austin, TX

Job Description

Job Title: ETL Developer

Location: Austin TX (Hybrid)

We are currently seeking candidates who meet the following qualification

Key Responsibilities:
  • Acquire data from various sources for multiple uses and ensure its transformation into a dimensional model.
  • Develop complex SQL scripts to transform data and create views and materialized views in Oracle.
  • Automate data integration and transformation processes using Informatica IICS IDMC or Power Center.
  • Collaborate with the Data Engineering Team on optimal data design and acquisition strategies.
  • Perform verification and validation of SQL scripts Informatica workflows and database views.
  • Develop automated verification and validation processes.
  • Enhance and maintain Java websites that host Tableau dashboards for multiple user roles.
  • Work closely with customers to develop mockups and validate designs.
  • Address technical problems by collaborating with team members.
  • Implement and configure development tools to support the project.
  • Create and maintain technical specifications diagrams and other documentation.
  • Participate in requirements and design sessions.
  • Interpret new business requirements assess their impact and propose enhancements.
  • Participate in all sprint ceremonies.
Minimum Requirements:
  • Experience developing mappings and workflows to automate ETL processes using Informatica IICS IDMC or Power Center.
  • Proficiency in acquiring and integrating data from multiple sources including Snowflake Oracle SQL Server Excel Access and Adobe PDF.
  • Expertise in designing and developing efficient SQL scripts.
  • Strong analytical and problemsolving skills as a system analyst for data analytics or data warehousing projects.
  • Proficiency in technical writing diagramming tools (e.g. Visio Erwin) and Microsoft Office Suite.
  • Experience planning and delivering software platforms used across multiple organizational units.
  • Experience designing and developing Python scripts.
  • Handson experience on agile sprint teams using JIRA.
Preferred Qualifications:
  • Excellent oral and written communication skills.
  • Ability to write welldesigned testable and efficient code using best practices.
  • Understanding of security principles especially concerning healthcare data.
  • Experience with modern software components for data visualization or business intelligence environments.
  • Strong organizational skills with the ability to manage multiple responsibilities and prioritize conflicting tasks.
  • Bachelors degree in Computer Science Information Systems Business or equivalent experience.
  • Prior experience in the healthcare industry or with an HHS agency.
  • Familiarity with PII or PHI data handling.
  • Expertise in web applications and programming languages such as HTML CSS JavaScript JQuery and APIs.
  • Functional knowledge or experience with Web Services (REST SOAP).
  • Experience developing dashboards and reports in Tableau including connecting to external data sources.


    If you meet these qualifications please submit your application via link provided in Linkedin.
    Kindly do not call the general line to submit your application.

Job Tags

Similar Jobs

T. W. Frierson Contractor, Inc.

Construction Laborer Job at T. W. Frierson Contractor, Inc.

 ...This role is an entry-level role into the construction craft. You would perform a variety of basic tasks related to commercial construction as directed by supervisor. This involves tasks using your hands and tools such as demolishing buildings, sawing lumber, dismantling... 

SeekTeachers

School Librarian Job at SeekTeachers

Description Librarian | Teach in Africa | Teach in DjiboutiAre you looking to explore amazing teaching opportunities overseas ? Search no more ,this wonderful opportunity is for you . Join our amzing team of staff in Djibouti ,... 

Domino's Franchise

General Manager - 53 Winn St Job at Domino's Franchise

Job Description You've been working your way up in the restaurant world for awhile. Maybe you even have a little college under your belt on the subject. Whatever the case may be, you know you want to manage a restaurant. Which is perfect for us because we (we being...

Nebraska Oral & Facial Surgery

Scheduling Coordinator Job at Nebraska Oral & Facial Surgery

 ...with all of their oral surgery needs. Previous oral surgery experience is a plus but not required. The role of the Scheduling Coordinator is critical in providing exceptional patient care resulting in the best clinical outcomes and meeting the needs of our patients.... 

ColumbiaCare Services

Mental Health Associate - 4779 Job at ColumbiaCare Services

APPLY TODAY AND MAKE A DIFFERENCE IN THE MENTAL HEALTH FIELD! What We Offer Enjoy our many benefits and incentives including: ~ Affordable Medical/Dental/Vision plans ~ Flexible Spending Account ~ Generous Paid Time Off ~ Whole Health & Wellness Reimbursement...