Informatica Team Lead

Greater Boston Area, MA

Posted: 01/18/19 Category: Software/Application Development and Architecture Job Number: 7166

Position: Informatica Team Lead
Location: Lexington, MA
Type: Direct Hire 
Local: Strong preferred 
Required:10+ year experience,  Informatica, Oracle, data warehousing, 


The Informatica Team Lead / Lead Integration Engineer assists with the identification, development and customization of complex systems solutions to address business requirements. Oversees design activities that may involve application/system architecture or process designs for integration of very large complex IT solutions and integrating architecture.


IT/Integration focus
  • Understands and internalizes the project mission and associated company objectives for the effort.
  • Transforms business-oriented functional specifications into detailed technical specifications.  Diagrams technical decompositions, describes technical process and data components, and designs exception handling and controls.
  • Participates in functional design reviews and lead technical design reviews.
  • Assigns, coordinates, controls and reviews work deliverables for developers. 
  • Evaluates and estimates change orders.
  • Ensures software flexibility, scalability and reuse.  Works with colleagues to promote best practices and standards in software design and development.
  • Leads developers in unit and string testing.  Supports system integration and quality assurance testing.  Accountable for deliverable quality.
  • Provides technical guidance and mentoring to developers for both integrations techniques and tools. 
  • Works collaboratively with internal integrations groups to deliver high-value solutions that conform to all requirements.  Works collaboratively with external IT groups to successfully implement solutions into the environment.
  • Provides integrations tool/product expertise related to design, development, testing and deployment.
  • For a specific project assignment this role will include:
  • Work with business analysts to identify business requirements.
  • Participate in functional specifications review.
  • Design of the project or project track technical solution collaboratively or independently.
  • Define individual technical solution components.
  • Document the design, approach and components in technical specification documents.
  • Assign individual tasks/components to the technical team developers.
  • Provide technical team developers with direction on day-to-day activities.
  • Conduct technical code reviews.
  • Provide project related status reporting and documentation.
  • Coordinate all release planning.
  • Lead the development team through all project phases.
  • Maintains software versions in version control tool.
  • Maintains an in-depth understanding of company/division technical strategy and direction in order to deliver consistency, maintainability, reuse and quality balanced against delivery deadlines.
  • Provides assistance to other staff with complex tasks that require considerable judgment and initiative.
  • May escalate difficult/complex issues to supervisor/manager for resolution, as deemed necessary.
  • Review and comply with the Code of Business Conduct and all applicable company policies and procedures, local, state and federal laws and regulations.
  • Assist with various projects as assigned by a direct supervisor.
  • Other duties as assigned.



Bachelor’ s Degree required; Advanced Degree preferred


  • Experience with the Informatica suite, comprised of PowerCenter Repository Manager, Designer, Workflow Manager, Workflow Monitor, and Meta Data Manager.
  • Strong experience in building PL/SQL packages and SQL tuning. Experience writing and executing UNIX shell scripts and managing job scheduling.
  • Identifies technical alternatives/improvements and presents them to tech leads and architects. Experience with data profiling to establish data models by analyzing data patterns and anomalies.
  • With little supervision, develops, tests and deploys high-quality software for integration processes that range in complexity from low to high.
  • Follow the best practices and guidance for development.  A thorough understanding of ETL framework including hands on experience with performance optimization.
  • Works collaboratively with team developers, Architects, DBAs, Integrations Administrators and others to achieve cohesive, compliant software deliveries.
  • Conducts thorough unit and string tests. Supports system integration and quality assurance testing.
  • For a specific project assignment this role will include:
    • Complete final technical design details for assigned components
    • Write, debug and unit test complicated Informatica or other code independently
    • Participate in technical code reviews – your code and others’ codes
    • Create test data and run code to support SIT and QA testing
    • Provide task related status reporting and documentation
    • Participate in software deployment, conversion and verification
  • 8 – 12 years’ related experience; or a Master’ s degree with 6 years’ experience; or a PhD with 3 years’ experience; or equivalent directly related work experience.
  • Experience managing teams of technical developers.
  • Very strong relational database development experience.
  • Demonstrable knowledge and experience of software development lifecycle and methodologies spanning development, testing, release and deployment management.
  • Author technical specifications, designs and diagrams.
  • Strong technical development and relational platform design experience – especially with systems integration and interface development.
  • Ability to determine tradeoffs, estimates and overall technical approaches.
  • Ability to work effectively with people from peer IT organizations.
  • Health Care development experience preferred.
  • Good communication and writing skills.



Kristin Murphy
Senior Technical Recruiter

Contact Kristin today about this great opportunity with Queen Consulting Group!

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.