Etl Tech Lead

Key responsibilities:

• An expert in solution design with the ability to see the big picture across the portfolio; providing guidance and governance for the analysis, solution design, development and implementation of projects
• A strategic thinker who will be responsible for the technical strategy within the portfolio; ensuring it aligns with the overall architecture roadmap and business strategy.
• An effective communicator who will utilize their technical/business knowledge to lead technical discussions with project teams, business sponsors, and external technical partners in a manner that ensures understanding of risks, options, and overall solutions.
• An individual with the ability to effectively consult/support technical discussions with Account Delivery and Business Sponsors ensuring alignment to both technology and business visions.
• Collaborate with Designers, Business System Analysts, Application Analysts and Testing specialists to deliver high quality solutions
• Able to prepare high-level and detailed-level designs based on technical/business requirements and defined architectures and maintain documentation
• Have been instrumental in platform migration work and technical migration work in the past and understands the involved intricacies.
• Analyze, define and document requirements for data, workflow, logical processes, interface design, internal and external checks, controls, and outputs
• Ensure information security standards and requirements are incorporated into all solutions
• Stay current with trends in emerging technologies and how they could apply to Sun Life.

Key experience:

• A Bachelors or master’s degree in Computer Science or related field
• 8 -11 years of progressive information technology experience with full application development life cycle.
• Domain knowledge of Insurance and Retail Wealth Management.

• Experience in Informatica Powercenter / IDMC Development.

• Experience of applying various informatica transformations and different type of sources.
• Ability to write complex T-SQL and stored procedures, views.
• Experience in SQL Server 2014 and above.
• Exposure to DevOps and API architecture
• Should have experience leading small teams (5-8 developers).
• Good knowledge and experience of Java1.8 or above.
• Experience in PostGRE SQL and No-SQL DB like MongoDB etc.
• Good knowledge of coding best practices and should be able to do code review of peer.
• Produce clean, efficient code based on specifications and troubleshoot, debug and upgrade existing software.