Job Summary:
Proficiency in Informatica Big Data Management or related tools with strong ETL capabilities including familiarity with Spark Blaze and Hive execution engines.
Experience in developing and deploying dynamic mappings in Informatica BDM from multiple sources to Data Lake.
Responsible for developing and maintaining robust ETL processes using Informatica BDM and transforming and loading complex and unstructured data sources including NoSQL databases.
Management and optimization of Hive databases including DDL partitioning and query language.
Execution of complex SQL/PLSQL queries and working with various databases like Oracle SQL Server.
Performing performance tuning in SQL and Informatica to optimize ETL processes.
Collaboration with crossfunctional teams to understand business considerations.
Development and implementation of complex quality rules with cleansing parsing standardization validation etc.
3 to 5 years of professional experience in Informatica BDM development required.
Bachelors or Masters degree in Computer Science Engineering or a related field.
Knowledge of Data Lake architecture and Dimensional data modeling.
Understanding of data warehousing data modeling and ETL processes.
Experience with cloud platforms such as AWS Azure GCP is a plus.
Experience with Informatica Data Quality is a plus.
Excellent problemsolving and analytical skills.
Strong communication and collaboration skills.
Ability to work independently and as part of a team.