Data Engineer - Hadoop

KNOWLEDGE, SKILLS, AND EXPERIENCE 8plus 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.