Data Analyst (Informatica MFT, DBT & Snowflake)

Data Analyst (Informatica MFT, DBT & Snowflake)Location: Cary NC (Local Only - Face to Face interview) Duration: 6 months (Extendable) Pay Range: $45-50/Hour on W2Position Summary:Key Responsibilities:Work with business/data product team to translate given business problem into analytical solution with defined outcomes.Analyze the data in depth, informatica MFT, using SQLs and other exploratory tools against various platforms such as Bigdata, Oracle, SQL Server and others.Convert business requirements to functional requirements, with detailed transformation rules for ETL team. This is a very technical hands-on role and mandatory to have Informatica MFT, DBT and snowflakeWork closely with the ETL and data science teams to review the requirements and data integrations.Understand the requirements from Business and Data Science. Understand the business and business impact on use cases.Write validation scripts to validate the data loaded by ETL team an assess using MFT / DBT.Work with IT and business customers to develop and design requirements to formulate technical design.Skills to understand the right functional domain knowledge of the business to be able to gather right requirements for the design.Capture meta data, data lineage, reference data management and data quality rules as part of data governance.Work with team spread across the globe in driving the delivery of projects.Required Skills/Knowledge:Bachelor's degree in computer science, Engineering, or related discipline. 8+ years of solutions development / analysis experience, including 5+ years in data management/engineering organization. Proficient understanding of distributed computing principles and informatica Scripts / MFT Extensive experience in data analysis and data modeling (table design). Proficiency in SQLs and data exploratory tools. Extensive experience writing functional requirements and high-level design documents. Experience in writing validation scripts to validate the data, data integrations and ETL transformations. Analytical skills to analyze situations and come to optimal and efficient solution based on requirements. Strong data analysis and profiling skills. Data warehouse concepts. Strong analytical skills related to working with unstructured datasets. SQL knowledge and data analysis skills for data anomaly detection and data quality assurance. Excellent communication skills, both written and verbalPreferred:Experience working on MFT and DBT skills and should posses cloud knowledge. Strong background or working experience in Insurance Industry as a Lead analyst. Ability to interact with senior leadership teams in IT and business raise the required defect and track project end to using manual or automation design creation. Should have good SQL knowledge/ AWS and snowflake. Should be good in Agile methodologies and SDLC process.