Senior Data Engineer

Company Profile:Quantiphi is an award-winning Data Science and Machine Learning Software and Services Company focused on helping organizations translate the big promise of Machine Learning technologies into quantifiable business impact. We were founded on the belief that machine learning and artificial intelligence are transformative technologies that will create the next quantum gain in customer experience and unit economics of businesses. We are one of the five global launch partners for Google in Machine Learning and one of the three global launch partners for the Google Cloud Contact Center AI solution. Our signature approach combines ground-breaking machine-learning research with disciplined cloud and data-engineering practices to create breakthrough impact at unprecedented speed.We believe in “Solving What Matters”Company Highlights: Quantiphi has seen 2.5x growth YoY since its inception in 2013 Winner of the “Machine Learning Partner of the Year” award from Google for two consecutive years - 2017 & 2018 Winner of the “Social Impact Partner of the Year” award from Google in 2019 Winner of the “Data & Analytics -Specialisation Partner of the Year” and “US Education - Public Sector Partner of the Year” award for 2020Role: Senior Data Engineer Experience Level: 4 to 7 Years Work location: Mumbai, Bangalore, Trivandrum (Hybrid)Role & Responsibilities:Work with business users and other stakeholders to understand business processes. Ability to design and implement Dimensional and Fact tables Identify and implement data transformation/cleansing requirements Develop a highly scalable, reliable, and high-performance data processing pipeline to extract, transform and load data from various systems to the Enterprise Data Warehouse Develop conceptual, logical, and physical data models with associated metadata including data lineage and technical data definitions Design, develop and maintain ETL workflows and mappings using the appropriate data load technique Provide research, high-level design, and estimates for data transformation and data integration from source applications to end-user BI solutions. Provide production support of ETL processes to ensure timely completion and availability of data in the data warehouse for reporting use. Analyze and resolve problems and provides technical assistance as necessary. Partner with the BI team to evaluate, design, and develop BI reports and dashboards according to functional specifications while maintaining data integrity and data quality. Work collaboratively with key stakeholders to translate business information needs into well-defined data requirements to implement the BI solutions. Leverage transactional information, and data from ERP, CRM, and HRIS applications to model, extract and transform into reporting & analytics. Define and document the use of BI through user experience/use cases, prototypes, tests, and deploy BI solutions. Develop and support data governance processes, analyze data to identify and articulate trends, patterns, outliers, and quality issues, and continuously validate reports, and dashboards and suggest improvements. Train business end-users, IT analysts, and developers.Required Skills:Bachelor’s degree in Computer Science or similar field or equivalent work experience. 4+ years of experience with Informatica Power Center on Data Warehousing or Data Integration projects. Expert with data warehousing standards, strategies, and tools. Expert with SDLC processes. Experience in Informatica Power exchange for Mainframe, Salesforce, and other new-age data sources. Experience in Informatica Webservices, XML, Java Transformations, etc. Strong knowledge of relational databases Strong SQL background. Strong experience in GCP & Google BigQuery. Strong problem-solving, multi-tasking, and organizational skills. In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework, and data-warehousing. Knowledge of SQL queries, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) is a must. Knowledge of the AWS data lake is a plus. Highly proficient in working with large volumes of business data and strong understanding of database design and implementation. Good written and verbal communication skills. Demonstrated experience in leading a team spread across multiple locations.