Data Integration Engineer

Backend DeveloperThis position is responsible for developing, integrating, testing, and maintaining existing and new applications; knowing one or more programming languages; knowing one or more development methodologies / delivery models alongside the domain expertise in healthcare. This position requires extensive data and integration experience. An integration or data architecture background is preferred, but not required.Required Job Qualifications:Bachelor Degree and 5 years Information Technology experience OR Technical Certification and/or College Courses and 7 year Information Technology experience OR 9 years Information Technology experience. Master’s degree (in a technical related subject) preferred but not required.Ability to manage workload, manage multiple priorities, and manage conflicts with customers/employees/managers, as applicable. Furthermore, ability to direct / manage a team of integration designers, developers, and testers in building large scale, complex integrations throughout a modern data ecosystem.Extensive hands on experience in designing, developing, and maintaining software solutions in Hadoop cluster with extensive experience in integration (integration includes ETL, message-based, streaming and API styles of integration) with tools preferable Talend Data Integration, Talend Big Data migration platform Edition 6.2.1 or comparable toolsets, and Data Warehousing. Talend is HCSC preferred tool for data integration and Integration.Experience with strong UNIX shell scripting, SQOOP, eclipse, HCatalog.Experience with NoSql Databases like HBASE, Mongo, CosmoDB, Graph Databases or Cassandra.Experience with Developing Pig scripts/Hive QL, UDF for analyzing all semi-structured/unstructured/structured data flows.Experience with Developing MapReduce programs running on the Hadoop cluster using Java/Python.Experience with Spark and Scala, or some other JVM based language with data integration experience.Working knowledge of cloud computing infrastructure (e.g. Amazon Web Services EC2, Azure) and considerations for scalable, distributed systems.Integration best practices with focus on Talend.Extensive knowledge working with version control tools like GIT and SVN.Hands on experience with PCF using Talend suite.Experience implementing complex business rules in Talend by creating Reusable Transformations and robust mappings/mapplets.Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Sorter, Normalizer, SequenceGenerator, Router, Filter, Expression, Aggregator, Joiner, Rank, Update Strategy, Storedprocedure, XML Source qualifier, Input and Output transformations.Expertise in Data Modeling concepts including Dimensional Modeling, Star and Snowflake schema, Experience in CDC and daily load strategies of Data warehouse and Data marts, slowly changing Dimensions (Type1, Type2, and Type3) and Surrogate Keys and Datawarehouse concepts.Hands-on experience in Performance tuning of Talend and Informatica ETL, Integration, Queries and Jobs.Broad knowledge of technical solutions, design patterns, and code for medium/complex applications deployed in Hadoop production. Additionally, experience in design for sustainability – minimize impact on operations crews in the event of systems outages, unexpected data, etc., as well as engineering the code base for straightforward extensions / expansions.Working experience in the data warehousing and Business Intelligence systems. Additionally, experience in building in data quality analysis in-line in integration flows. Experience in working with metadata across the integration landscape in support of data governance and operational needs.Participate in design reviews, code reviews, unit testing and integration testing.Assume ownership and accountability for the assigned deliverables through all phases of the development lifecycle.SDLC Methodology (Agile / Scrum / Iterative Development).System performance management.Systems change / configuration management.Business requirements management.Problem solving /analytical thinking.Creative thinking.Ability to execute.Preferred Job Qualifications:Master’s Degree in Computer Science or Information Technology.