Collaborate with data architects to optimize models
Job description
About Us:
Perfict Global is a leading IT consulting services provider focused on providing innovative and successful business workforce solutions to Fortune 500 companies. Our trained and experienced professionals constantly strive to bring together the best technologies available to manage client's complex business and technology, participate in implementation activities and collaborate in new ways to meet client needs.
We provide excellent benefits such as Medical, Dental, Vision ++ a fun company to work!!!
Job description: Role: Sr ETL Developer (only W2) Location: 100% remote PST Required Skills for ETL Developer
5+ years of experience as a ETL Developer in a Snowflake and Azure environment. Preference of Datawarehouse Development or Datawarehouse Consolidation effort preferred. Including Analysis, technical design, development, integration, testing
Strong SQL experience
Experience using ETLWorks – this is their ETL development tool (other ETL like Informatica is accepted)
Experience working in a scrum environment, using Jira
Experience working with version control tools; preferably - bitbucket
Familiarity with the current legacy platform; Microsoft SQL, SSIS
Experience building and maintaining technical documentation for all data processing workflows, ensuring they meet standards and best practices
Experience identifying and troubleshooting performance issues in the data pipelines, and work with data architects to optimize data models and database designs
Strong previous experience working remotely on a remote team across different time zones
Healthcare payor/insurance experience is highly preferred
Nice to have Skills for ETL Developer
Strong Python experience, nice to have
Familiarity with the Data Governance/Data Quality tool, Ataccama, nice to have
Familiarity with reading through a logical data model and have an understanding of multidimensional data models, nice to have
