ETL Informatica Developer

6plus Yrs. Of experience relevant to developing and managing ETL on Informatica Power Center Design, develop, and implement complex mappings, sessions, and workflows using ETL processes using Informatica PowerCenter. Identify the problems and Optimize ETL processes for maximum efficiency and performance through performance tuning. Perform data analysis and data profiling to ensure data quality and integrity. Must be able to use Informatica Data Quality tools. Develop and maintain reusable data mappings, workflows, and sessions. Proficiency in SQL and experience with relational databases Oracle, SQL Server with Strong SQL skills for data extraction, transformation, and loading. Should have experience with data warehousing concepts and techniques. Must have Knowledge of data modeling and data architecture principles. Knowledge of big data technologies Hadoop, Spark, Cloudera. Troubleshoot and resolve data issues and ETL process failures. Implement error handling and recovery strategies in ETL processes. Collaborate with business analysts, data architects, and other stakeholders to understand business requirements and translate them into technical solutions. Must be able to create detailed requirement documentations like FSD, SDD, TDD, Test Cases, Data Mappings for the requirements to develop and maintain proper versioning. Ensure compliance with data governance and security policies, data masking, encryption. Participate in code reviews and provide constructive feedback to peers. Adhere to coding standards and best practices. Stay updated with the latest developments in Informatica and data integration technologies. Ability to work on Service tickets and provide resolution of production issues within defined SLA. Ability to manage more than one application as primary and secondary owner. Ability to analyze the problems and provide Root Cause Analysis for the incidents and implement the same. Proactively check the server status and make sure the applications / systems are 100% up and running and available for users. Make sure servers are patched according to patch management cycle. Needs to make sure needed proactive alerts are identified and configured. Adhere audit, lean, ISG and other procedure defined in the organization. Ability to understand the business requirement and translate it into technical specification and implementation. Planning and estimation for the projects, change requests etc. and tracking the same. Classification Internal Use Prototyping and researching alternative implementation strategies. Reporting daily call status to Team leads. Getting the inspections/reviews done as per the plan

Industry knowledge of products / solutions in the field of Banking

Strong verbal and written communication skills

Ability to collaborate and manage senior stakeholders

About Virtusa

Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 27,000 people globally that cares about your growth — one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.

Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.

Virtusa was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.