Sr Data Engineer Columbus, OHVisa status: U.S. Citizens and those authorized to work in the U.S. are encouraged to apply.
Tax Terms: W2, 1099 Corp-Corp or 3rd Parties: YesAbout the Data Engineer RoleAs a Data Engineer with ETL/ELT background, the candidate needs to design and develop reusable data ingestion processes from variety of sources and build data pipelines for Synapse Azure cloud data warehouse platform and reporting processes. The ideal candidate should be proficient in writing SQLs so they can be embedded into the informatica (IICS) for data transformation. Ideal candidate should be willing to learn open source technologies on the fly as job demands.ResponsibilitiesDesign, develop & implement ETL/ELT processes on Azure Cloud using IICS (informatica cloud) and Azure SynapseWrite complex SQL's and performance tuning of jobsPerform source analysis, create informatica mapping to source data, Regression test and debug issuesWork with offshore team, business analysts and other data engineering teams to ensure alignment of requirements, methodologies and best practicesRequirementsBachelor's Degree or master's degree in Computer Science.10+ years of hands-on software engineering experience.5+ years of strong ETL experience on InformaticaExperience in designing solutions for multiple large data warehouses with a good understanding of cluster and parallel architecture as well as high-scale or distributed RDBMSStrong database fundamentals including SQL, performance and schema design.Proficiency in SQL codingAbility to interpret/write custom shell scripts.
Python scripting is a plus.Experience with Azure platform and SynapseExperience with Git / Azure DevOpsTo be able to work in a fast-paced agile development environment.