Informatica Developer

Primary Technical Skills: Informatica RDBMS Unix/Linux Control-M Gitlab Experience in Insurance domain and knowledge in Guidewire ClaimCenter and its conversion process. Nice To have: Experience in Insurance domain and knowledge in Guidewire Claimcenter. Responsibilities: Analyzing the business requirements design develop and implement highly efficient highly scalable ETL processes Required to perform daily project functions with a focus on meeting the business objectives on time in rapidly changing work environment Thorough understanding of DWH/Data migration concepts and Data Models Design and Develop detailed ETL specifications based on business requirements Analyze functional specifications and assist in designing potential technical solutions Works with source system team and data analyst to define data extraction methodologies Advanced Oracle database skills including PL/SQL packages procedures indexing and query tuning (5+ years) Enhance/Re-architect existing components to satisfy new performance and scalability requirements Regular meeting with team and stakeholders to avoid impediments Innovative ideas on automation and Proof Of concepts to get it implemented Proficient in ETL Informatica Well versed in Unix shell scripting Knowledge of GW CMT(Claims Migration Tool) is a plus Deploying workflows to Control-m and good knowledge of gitlab pipeline configuration Interact with multiple teams and translate reported problems/issues into JIRA items to implement to meet enterprise standards. Good knowledge in writing complex queries. Experience in Oracle SQL is value added Maintain highest levels of software quality and stability through continuous improvement of the SDLC Build and maintain design standards and best practices and ensure the team adhere these standards Evaluates and recommends unique hardware /software configurations; defines special hardware/software requirements capacities capabilities etc. to meet user needs while adhering to technical standards Unit Integration testing activities and assist in User Acceptance Testing Effective time management skills to manage multiple priorities with flexibility on time zones and timelines Must have strong interpersonal skills and outstanding communication skill Technical Skill Informatica Strong hands on experience in Informatica 10.x +. Strong understanding of concepts and techniques for design development and implementation of ETL Ability to perform detailed data analysis (i.e. determine the structure content and quality of the data through examination of source systems and data samples) Involved in coding testing implementing debugging and documenting the complex programs. RDBMS Strong hands on experience in any of the database like DB2 Oracle etc and interested to work in all databases Should be well-versed in data analysis and query methods Strong knowledge in data warehousing concepts Use of Data Modeling Database Query Optimization and Data Access techniques and Concepts Unix/Linux Good knowledge in Unix Linux Shell Scripting