Informatica Automation Developer

Remote, but must reside in the Metro DC Area

Active Secret Clearance Required

@Orchard LLC is seeking an Informatica Automation Developer to support an HHS contract. While the role is work from home, the strong preference is for someone located in the Washington, DC Metro Area. You must hold an active secret clearance to be considered.

As the Informatica Automation Developer, you will: 

• Design and implement end-to-end automated workflows across Informatica and non-Informatica applications using IICS/IDMC or PowerCenter to support payroll integration data. 
• Review, modify, and optimize Informatica procedures. 
• Diagnose and resolve Informatica and database-related issues that may arise during payroll processing, particularly during the high-risk stabilization window following deployment. 
• Implement complex data transformations. 
• Automate the build, versioning, and delivery of ETL objects into production environments using tools like GitLab CI/CD, Jenkins, or Azure DevOps. 
• Develop and maintain automated test frameworks (often using Python or Informatica Data Validation) to verify data accuracy, schema validation, and transformation logic. 
• Use Infrastructure as Code (IaC) tools like Terraform or Ansible to automate the provisioning and scaling of Informatica Secure Agents and cloud environments. 
• Manage Informatica user accounts and security administration, such as patching and upgrades as needed. 
• Implement database backup and recovery procedures for Informatica PowerCenter. 
• Develop and maintain technical artifacts as needed.
• Perform other duties as assigned from time to time by the manager.

Your background will include:

• Bachelor's degree with 8+ years of professional IT experience, with at least 3–5 years specifically focused on automation and data engineering. In place of a degree, an additional 4 years of related experience or relevant professional certification may be substituted
• Deep expertise in Informatica Intelligent Data Management Cloud (IDMC), IICS, or PowerCenter
• Proficiency in Python, Unix/Linux shell scripting, or PowerShell for custom automation tasks
• Hands-on experience with AWS, Azure, or GCP services (e.g., Lambda, S3, EC2) to support cloud-native data solutions
• Expert use of Informatica command-line tools like infacmd and pmcmd for remote job control and scheduling
• Advanced SQL skills and experience with modern data warehouses like Snowflake, Redshift, or BigQuery
• Outstanding interpersonal communication with analysts and senior leaders
• Possess a demonstrated ability to work collaboratively across a large organization, managing diverse tasks, requirements, and commitments
• Available to work under tight deadlines and work during evenings and weekends when necessary. 
• Demonstrate active listening skills to gain an understanding of key customer issues. 
• Creative problem-solving ability and a consultancy mindset. 
• Ability to view problems from multiple angles and apply a variety of solutions to solve them.

Compensation: The base salary is dependent on qualifications and experience and is expected to be in the range of $100-150K. Benefits are provided, including health, dental, vision, and 401K.

@Orchard is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status, and will not be discriminated against based on disability.

Established in 2010, @Orchard LLC  has an exceptional reputation, providing staffing solutions to time-sensitive, talent scarcity issues to deliver better talent management ROI.  Our specialty lies in the critical area of program talent acquisition and resource management, not in one narrow skillset, but across many areas of technical and functional delivery. To learn more about our other exciting opportunities, visit our Jobs Page at www.atOrchard.com.