Data Analyst (Informatica MFT, DBT & Snowflake) at Alpha Consulting Corp. in Cary, NC
- Company: Alpha Consulting Corp.
- Location: Cary, NC
- Posted: Sep 24, 2026
- Type: Contract
- Salary: $45-$50 per hour
- Experience: 8+ years
Overview
Position Summary: • 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.
Job description
- Position Summary:
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 snowflake
- • Work 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.
Requirements
- • 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 verbal
- • 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.
Skills
Required
- Informatica MFT
- DBT
- Snowflake
- SQL
- Data analysis
- Data modeling
- Data profiling
- Data warehouse concepts
- Distributed computing principles
- Writing functional requirements
- Writing high-level design documents
- Writing validation scripts
Preferred
- MFT
- Cloud knowledge
- AWS
- Agile methodologies
- SDLC process
- Insurance industry experience