Build and design data warehouse modules and data marts based on user requirements and updating existing data model for CRM/SFMC data needs.
Implement the ETL pipelines using Azure data factory, databricks - Python/Spark notebooks and load data every hour and real time integrations.
Performance tune integrations using various tools and techniques including data analysis, ETL design improvement, data model improvements and partitioning strategies.
Act as key contributor on the Delivery Application Programming Interfaces (APIs) team, responsible for design, implementation and on-going enhancements of digital products and enhancing the digital experience.
Experience on ETL Data Integration Projects from projects initiation to requirement gathering, analyze, design, develop, implementation and Support the projects post implementation. Assist and interact with business users to analyze and gather the data in data warehouse and document the functional and technical requirements. ETL Data integration solutions for Retail, Manufacturing and Financial Services domains. Perform hands-on scripting, participate in design sessions, code review, system testing during various phases of development, and follow best industry practices and publish API documentation.
Build automated process for data imports using python. Drive the analytics road map for the customer requirements. End to end delivery of ETL development projects of varying complexity. Collaborate with Quality, Product, and cloud engineering teams to keep digital assets fully functional, secure, and up to date with business needs. Performing pair programing, effectively communicate ideas with team, assist in system integration, performance testing and product releases. Need to work with different azure technologies to get data into a single destination. Understand and analyze data quality issues, and assist implementing processes to improve incrementally. Provide Operations support in performing scheduled/adhoc code deployments to higher environments, running the jobs and monitoring them.
Bachelors in Technology or any computer related field and 60 months experience.
Valid Till: 06/15/2022