Principal Data Engineering null

Responsibilities

• Perform hands-on ETL solution design, development, test execution and production deployment.
• Lead and manage a small/medium-sized team of ETL developers
• Lead and provide technical guidance and supervision to ETL developers
• Plan and manage end-to-end delivery and work assignments within the ETL development team
• Communicate and build strong positive rapport with various business and technology stakeholders.
• Provide BAU support for existing and new data platforms
• Collect multiple streams of data and decompose them into concise specifications.
• Assist in identifying data quality problems and in determining options for how they will be handled
• Ensure that the final product meets required specifications.
• Follow company and industry-defined best practices to ensure smooth and continuous product development operations.
• Develop process improvements that ensure product quality and productivity.
• Communicate product efficiency or enhancement ideas and concepts to the Manager.
• Review and recommend changes to current product development processes.
• Maintain expert knowledge on product development procedures.
• Maintain product requirements, technical and functional documentation for release management.
• Analyze and troubleshoot product issues in a timely fashion.
• Understand and evaluate existing SQL and or Data Modeling.
• Design and develop queries for a high-performance environment.
• Develop, manage and maintain data dictionaries, metadata, and process flow documentation.
• Design, develop and implement complete solutions throughout the product life cycles.
• Maintain and manage revisions of code in production, testing and development environments.
• For a data consolidation based project who can provide skills to drive solutions from the requirements phase through delivery, with preferred financial industry experience. The developer will be responsible for delivering high-quality solutions that meet design requirements and technical specifications within the stipulated timelines.
• Contribute to the specification and software design phases of the software development life cycle and perform and aid in quality assurance testing, performance testing, troubleshoot application and environment issues, and production support.
• Accountable for development and delivery of solutions that meet and exceeds quality standards
• Deliver multiple projects on time, on budget and with targeted zero defects
• Coordinate with offshore resources on development projects from requirements through delivery.
• Provide support for Quality Assurance testing
• Provide support for ETL batch job issues in lower environments and in Production if the need arises
• Provide estimation and coordination of technical activities related to system development
• Ensure solutions alignment to Enterprise Architecture policies and best practices; ensure that process methodologies are followed in system development
• Create technical documentation including the Technical Design document
• Manage day to day technical challenges and communicate to the project manager any risks or issues associated with the development activities
• Participate in Code Reviews and provide inputs on necessary corrections if needed
• Identify opportunities for system reuse and system simplification
• Collaborate with IT partners to devise a capacity plan and ensure appropriate infrastructure for the end to end system delivery

Job Requirements

• Strong experience in PL/SQL in Oracle and MS SQL.
• Informatica ETL hands-on development.
• Sound experience in execution of IT projects with a high level of expertise in system application and technology implementation delivery.
• Strong communication skills with the ability to communicate with stakeholders. 
• Strong analytical and problem-solving skills.
• Domain proficiency in the insurance business and its operations including distribution channels modus operandi is essential.
• Experience in Informatica would be added advantage.
• Able to work independently and highly self-motivated.
• Able to work with peers and other stakeholders, a team player.