Informatica ETL Developer

Infrastructure Setup: Lead and contribute to the implementation and configuration of the infrastructure for the Data Integration Hub. Agile Development: Perform Design, Development, and Implementation (DD&I) tasks using Agile methodology across all phases of the Software Development Life Cycle (SDLC). ETL Development: Develop ETL workflows and mappings using Informatica PowerCenter or IICS for automating data acquisition and transformation processes.

Data Integration: Acquire and integrate data from various sources including Oracle, SQL Server, Excel, Access, and PDFs for analytics and visualization use cases. SQL Scripting: Write and optimize complex SQL scripts in Oracle and/or Snowflake . Testing & Deployment: Conduct integration, load, and stress testing; deploy robust data solutions for both internal and external stakeholders.

Support & Enhancement: Provide ongoing support and continuous enhancements to the Data Integration Hub. Agile Participation: Actively participate in Agile ceremonies such as sprint planning, daily stand-ups, sprint reviews, and retrospectives. Documentation: Create and maintain technical documentation, architecture diagrams, and data models using tools like Visio , Erwin , etc.

Collaboration: Work closely with architects, analysts, and data engineers to design implementations and define data acquisition strategies. Automation Support: Assist in automating the verification and validation processes for data pipelines and transformations. Tool Configuration: Support the setup and configuration of development tools and environments.

Requirements Analysis: Interpret evolving business requirements and recommend scalable and efficient technical solutions. Team Collaboration: Collaborate with team members to troubleshoot technical issues and implement enhancements. Minimum Qualifications: ETL Development: 8+ years of experience developing ETL workflows using Informatica PowerCenter or IICS .

Data Integration: 8+ years acquiring and integrating data from multiple sources for reporting or BI visualization tools (e.g., Tableau). SQL Expertise: 8+ years developing complex SQL scripts in Oracle and/or Snowflake . Systems Analysis: 8+ years as a System Analyst on data analytics, performance management, or data warehousing projects.

Documentation & Modeling: Strong skills in technical writing , data modeling , and diagramming using tools like Visio , Erwin , MS Office , and MS Project . Enterprise Delivery: Proven experience delivering enterprise software solutions across multiple organizational units. Clean Code Practices: Demonstrated ability to write clean, testable, and efficient code using modern development standards.

Preferred Qualifications: Communication Skills: Excellent oral and written communication abilities. Agile Experience: Hands-on experience working in Agile/Scrum development environments. Data Security Awareness: Understanding of data security principles, especially in the context of healthcare , PII , or PHI data.

Industry Background: Experience in the healthcare industry or public sector is highly desirable. Educational Background: Bachelor’s degree in Computer Science , Information Systems , or a related discipline. Technical Skills: Proficiency with Python scripting , JIRA , and data visualization tools.

Integration & BI Tools: Experience with Mulesoft and working in performance metrics or BI dashboard environments. #J-18808-Ljbffr