Job Description
Title: ETL developer (Informatica)
Primary Location: Onshore
Position Overview:
Looking for an ETL lead developer who will be part of our GHS group and will be expected to actively work and lead in a multi-disciplinary fast paced environment for Relational and health care ecosystem. This role requires a broad range of skills and the ability to step into different roles depending on the size and scope of the project; its primary responsibility is to provide ETL solutions and guidance on data architecture, data modeling and Data Integration.
Skills and responsibilities:
- Design, develop, and support conceptual/logical/physical data models for ETL and analytics solutions.
- Work closely with the rest of the teams to provide data services for our ETL solutions, including modeling, stored procedures, data ingestion and other assistance to progress and meet technical and business goals.
- Support presentations to Customers and Partners
-Develop SSIS projects to implement ETL including, transmission, encryption, and archiving of files received and generated
-Design, develop, and maintain database tables, stored procedures, and supporting objects
-Unit test to ensure the ETL code delivered is running and conforms to specifications and design guidelines
-Document deployment procedures
-Provide support to Business Analyst(s) in gathering and/or clarifying data and requirements from subject matter experts
-Develop SQL queries and support ad hoc requests for data
-Develop test plans to ensure functionality has been implemented correctly
- Able to lead the developers part of ETL (Informatica) team.
- Good communication and client interfacing skill is a must.
Preferred qualification and experience:
- Al least 5+ years of related experience is required.
- BE/ME degree in Computer Science or related technical discipline is required
- Should have at least 2 years of experience as a technical lead in ETL (Informatica) area.
- Demonstrated experience with ETL development with data integration to support data marts & extracts.
- Should be strong on PL/SQL
-Shell scripting is added advantage.
- Exposure to Cognos or any other BI tools is added advantage
- Demonstrated in depth skills with Relational with the ability of all aspects of design and development. Fully versed and prepared to demonstrate a technical knowledge of database management.
- Demonstrated experience with different data models like normalized, de-normalized, stars, and snowflake models.
Additional Requirements
- Demonstrated ability to have successfully completed multiple, complex technical projects
- Prior experience with application delivery using an Onshore/Offshore model
- Experience with business processes across multiple Master & non-master data domains in a services based company
- Demonstrates a rational and organized approach to the tasks undertaken and an awareness of the need to achieve quality.
- Demonstrates high standards of professional behavior in dealings with clients, colleagues and staff.
- Is able to make sound and far reaching decisions alone on major issues and to take full responsibility for them on a technical basis.
- Strong written communication skills. Is effective and persuasive in both written and oral communication.
- Experience with gathering end user requirements and writing technical documentation
- Time management and multitasking skills to effectively meet deadlines under time-to-market pressure