AppDev Engineer II - Informatica IDMC - Snowflake - SQL - 100% Remote 15+ Month Contract $52/hr W2

AppDev Engineer II - Informatica IDMC - Snowflake - SQL 100% Remote We have a 15 month contract, opportunity to extend or convert, for a detail-oriented and collaborative professional with 2–4 years of experience designing, developing, and implementing enterprise software solutions. They have strong expertise in Informatica IDMC (or Power Exchange) for data sourcing, Snowflake for cloud-based data warehousing, and SQL for managing and transforming relational data. This individual excels at sourcing data from diverse platforms such as Oracle, SQL Server, MongoDB, and Kafka, and is skilled at building stored procedures in Python to manage and refine datasets. They thrive in agile, sprint-based environments, work independently after onboarding, and actively engage in team discussions to drive projects forward. With a strong foundation in software design and programming concepts, they bring both technical skill and problem-solving abilities, enabling them to support complex data integration initiatives with minimal guidance. 100% Remote. MUST HAVES: • 2-4+ years of experience • Informatica IDMC or Power Exchange • Snowflake • SQL NICE TO HAVES: • Healthcare • GIT • Disqualifiers:Missing Informatica / IDMC background About the Role: • The Data Sourcing team is established to help source data into our Snowflake environment. We source from multiple source applications that are rooted as relational sources like Oracle / SQL Server or JSON based sources from Mongo/Kafka. We leverage different utilities to write the data to Snowflake that include, but not limited to, Upsolver and Informatica IDMC. Once the data is in Snowflake, we write data to different layers of our Snowflake applications leveraging stored procedures written in Python. • We work with different source team who are SMEs on the data sets and downstream teams who help further refine the data into different datasets for reporting needs. Our team works in an agile fashion in two-week sprints leveraging agile best practices. Responsibilities: • This specific role would be more focused around our Oracle/SQL based sourcing into Snowflake leveraging different tools in the AWS ecosystem and the Informatica IDMC platform. They would also be working within Snowflake platform to write data to different Snowflake tables via stored procedures. • For this role, you are expected to be able to take on work independently or in a group fashion after a comprehensive onboarding process. The team is always working together but the level of expectation for this role is higher than an entry level position where there should be less basic explanations required. We’d also look for this individual to be engaged in team conversations and helping add perspective to discussion around projects.