ETL/Informatica Developer-NYC or Remote - Georgia IT Inc.

ETL/Informatica Developer
Location: NYC or Remote
Duration: 6 months - Long term
Rate: DOE
Key Technology: Relational Databases, Informatica Power Center or Informatica Cloud, CICD, AWS
 
Job Responsibilities:
The developer will join the IM Pharmacy team (which is aligned with the Information Management, IM Release Train).  The IM Pharmacy team owns the processes needed to enable administration and oversight of delegated vendors.  This requires development and maintenance of very complex outbound eligibility ETL processes, as well as inbound processes enabling consumption of Pharmacy claims and other data used to enable/support downstream consumption. 
 
Duties & Responsibilities:

• Work as member of Agile Scrum Team by embracing principles of agile mindset and actively participate in ceremonies (e.g. daily stand up, refinement, planning and other meetings) that ensure alignment and understanding across Team and Agile Release Train
• Perform full stack design, development, and implementation of complex applications. Develop a deep understanding of the relationship between various business process, systems and the underlying data.
• Solve for complex business requirements/rules by writing strong and efficient SQL queries, stored procedures, functions, and triggers.
• Optimally design and create database tables, views, stored procedures, use defined functions and other database objects.
• Monitor the performance, troubleshoot, and tune SQL queries and Informatica ETL processes.
• Design and develop Informatica ETL processes (mappings, queries, workflows, data objects) to support data loading and processing based on business rules. Work with different sources and formats (databases, XML, JSONS, Amazon S3, Athena etc)
• Research and investigate any Informatica issues, ability to debug log files and issues relating to the system.
• Create and deploy builds on prem/Kubernetes cluster using CI/CD pipelines. Work with DevOps team to trigger pipelines using GitHub, Jenkins, Docker files/images, Jfrog Artifactory, ECR and Helm charts.

 
Skills and Experience Required:

• 7+ years of experience and proficiency with Relational Databases (Postgres, Oracle, SQL servers etc)
• 5+ years' experience working with Informatica Power Center or Informatica Cloud (Optional experience on Informatica Data Quality, Product 360/PIM, Power Exchange, MDM, Other BI tools)
• Experience with working through formal SDLC pipeline from development, QA deployment and defect resolution, and documenting requirements per Enterprise Release Management protocols
• Ability to manage changing priorities as new needs and opportunities are identified and communicated by team leads (Product Owner, Scrum Master, Lead Developer/Data Engineer and QA Lead)
• Experience with Continuous Integration/Deployment pipelines.
• Knowledge/Experience on Amazon Web Services and its different services including but not limited to S3, Athena, EC2 instances.
• Any experience with PBM and/or health insurance company where eligibility and/or claims data is highly preferred.
• Excellent communication skills and ability to work independently, as well as part of a team with proven ability to influence with impact across functions and disciplines.
• Ability to manage multiple projects/deadlines, identifying the necessary steps and moving forward through completion.