About the Role
Job Description:
Experience:
2-3 years. Interface with BSAs, solution designers, data architects, and other business stakeholders to understand the business requirements. Assist with the analysis and profiling of various source data and understand high-level relationships between data sources. Parse unstructured and semi-structured data such as JSON, XML, etc. Design & develop efficient mapping and workflows to load data onto Data Marts. Design and develop an ETL/ELT pipeline for CI/CD. Develop, test, and document ETL/ELT solutions in a complex data warehouse environment with numerous disparate source systems. Use MS SQL Server 2012, Snowflake, and SSIS/ADF/DBT for data integration, Control-M for package scheduling, and TFS or Azure GIT repository for version control and task management. Perform DB modifications in accordance with team processes and standards.