Associate Principal - Data Engineering

Role Technical AnalystExperience 7 YearsLocation Cincinnati OHIO USA Eastern Time ZoneTechnical Skills PrimaryInformatica experience of atleast 5 years and 2 years in IDMC Strong understanding of Informatica Intelligent Data Management Cloud IDMC including CDI and data integration conceptsGood knowledge of Snowflake architecture data modeling data ingestion and data transformation conceptsExperience gathering analyzing and documenting business and functional requirements for data engineering initiativesAbility to perform impact analysis across source systems ETL processes and reporting platformsStrong SQL skills for data analysis data validation and troubleshootingUnderstanding of Data Warehousing concepts Dimensional Modeling and ETLELT methodologiesExperience working with Agile methodologies user stories backlog grooming and sprint planningKnowledge of data integration workflows and enterprise data architecturesExperience creating functional specifications process flows and solution documentationAbility to coordinate between business stakeholders architects developers and QA teamsExperience supporting solution validation UAT and requirement traceabilityFamiliarity with Azure AWS or GCP cloud data platformsTechnical Skills Secondary Nice to have NOT MANDATORYExposure to Informatica Data Quality Data Governance or Metadata Management solutionsKnowledge of Python or scripting for data analysisFamiliarity with Jira Azure DevOps Confluence or similar project management toolsUnderstanding of Data Quality Data Governance and Master Data Management conceptsExperience in Insurance or Financial Services domain Soft SkillsStrong communication and stakeholder management skillsExcellent analytical and problemsolving abilitiesAbility to translate business requirements into technical requirementsStrong documentation and presentation skillsAbility to facilitate discussions between business and technical teamsCollaborative mindset with strong interpersonal skillsAbility to manage multiple priorities and work in a fastpaced environmentProactive attitude with strong ownership and accountabilityQualifying Questions1Does the candidate have around 7 years of experience gathering analyzing and documenting business and functional requirements for Data Engineering ETL or Data Warehouse projects2Does the candidate have working knowledge of Informatica IDMCIICS Snowflake SQL and Data Warehousing concepts including data modeling and ETLELT processes3Does the candidate have experience working with Agile methodologies and coordinating requirements between business stakeholders architects developers and QA teams