Requirement: Experience in developing ETL mappings using Informatica Designer Strong understanding on ETL and Data Engineering Concepts and ability to learn new ETL tools on the Job.Proficient in Informatica Cloud, Informatica Power Center Strong proficiency in ETL/ELT development and cloud-based data services (e.g., AWS, Azure, GCP environments). Configuring and sessions/workflows using Workflow Manager Good Understanding on the Complete Project life cycle, business' process and workflow Understanding of / exposure to Reporting a plus.Knowledge in DBT and MDM an added advantage Mentoring / Training the team in all aspects of knowledge needed for the project.
Additional requirement:Proficient in basic and advanced SQL programming concepts (Procedures, Analytical functions etc.) Good Knowledge and Understanding of Data warehouse concepts (Dimensional Modeling, change data capture, slowly changing dimensions etc.) Knowledgeable in Shell / PowerShell scripting Knowledgeable in relational databases, nonrelational databases, data streams, and file stores Knowledgeable in performance tuning and optimization Experience in Data Profiling and Data validation. Experience in requirements gathering and documentation processes and performing unit testing.Understanding and Implementing QA and various testing process in the project Knowledge in any BI tools will be an added advantage Sound aptitude, outstanding logical reasoning, and analytical skills.Willingness to learn and take initiatives.Ability to adapt to fast-paced Agile environment.