Be part of a team of Engineers and Architects and provide leadership in creating data integration and application integration solution, conduct proofs of concepts, evaluate options with pros and cons and provide recommendations through design, development and/or Operations of complex technology environments with Data Governance Strategy & toolsets.
Participate in Solutioning team to partner with client in work efforts, provide data management experience, including an understanding of concepts, practices, procedures, and tools providing strong analytical, innovative, and creative problem-solving to the Customer needs.
Work in a blended team with business and technical resources, responding to requirements with concrete designs and implementing those designs.
Participate in training and workshop sessions for business and technology partners covering enterprise data governance, Data management, Metadata management, Data quality, standards, guidelines, and processes.
Provide guidance on data entry protocols to upstream system owners as it relates to impacts to downstream data consumers.
Skills and attributes for success
Design, develop and maintain Informatica cloud data integration processes using the appropriate data load technique, including Push-Down Optimization for performance optimization
Analyse the impact of changes on existing ETL/ELT processes and systems.
Debug and tune data integration processes, analyse data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, dimensional surrogate key handling, exception data processing, troubleshoot and recommend improvements and alternate methodologies
May prepare or review product documentation, written instructions or technical literature for accuracy and completeness
Maintenance of business rules associated with data integration
Participate in the fulfilment of ad-hoc data requests from internal business owners
Participate in design reviews and provide input to the design recommendations; provide input to information/data flow, understand and comply with Project Life Cycle Methodology in all planning steps
Data Quality management - Experience in Data quality tools, including data profiling, cleansing, standardization, and identity resolution.
Well versed with Data domains, Metadata extraction and data integration on wide range of resources and toolsets.
Excellent communication, presentation, interpersonal and organizational skills.
To qualify for the role, you must:
Be an Engineering graduate or equivalent with 3 – 6 yrs years of industry experience.
Must have 3 - 6 yrs years of a hands-on developer/designer experience as well as experience working with industry’s popular Data Quality and IICS services.
Strong analytical skills and ability to solve complex problems at scale.
Must have good understanding of Clinical Data Experience (Pharma Domain).
Able to Define, develop and maintain data quality policies & protocols. Produce data quality metrics including usage audits, compliance/risk audits.
Partner with IT Quality Assurance (QA) teams to create UAT test plans, design test cases, and manage testing project schedule
Have a flexible and proactive/self-motivated working style with strong personal ownership of problem resolution.
Lead a Team of Data Engineers to develop and deliver the Data Management solutions to the Customer.
Excellent written and spoken communication skills; an ability to communicate with impact, ensuring complex information is articulated in a meaningful way to wide and varied audiences including senior executives, business, architecture governance bodies and IT delivery Ability to work globally and across cultures
Participate in all aspects of Data solution delivery life cycle including pre-studies, analysis, design, development, testing, production deployment, and support.