Etl Data Engineer

Overview Job Title - Lead Engineer - ETLLocation - BengaluruAptean is changing Our bespoke ERP solutions are transforming a huge range of global businesses from food producers to manufacturers In a world of generic enterprise software we provide targeted solutions that bring together the very best technology and drive greater results With over 3000 employees 50 different products and a global client base theres no better time to advance your career at Aptean Aptean is seeking an experienced hands-on and outcome driven Data Engineering professional to design develop and maintain scalable data pipelines and infrastructure for our data platform The ideal candidate will have a deep understanding of data architecture principles extensive experience with data modeling DWH and Data Lake technologies and the ability to design and implement scalable data platform About the role Design build and maintain data warehouse data lake and data pipelines to ensure reliability consistency Implement end-to-end ETL ELT workflows to seamlessly extract transform and load data into data platform Analyse requirements to create technical designs data models and ETL migration strategies on DWH DL and cloud platform Maintain and enhance data warehouses for multiple data sources ensuring comprehensive integration ingestion pipelines data quality alerts and effective remediation strategies Implements database back-up recovery and archiving strategy Design Solutions to Ingest data into Data Lake from various source systems by performing source data analysis Support and maintain downstream integrations from our data lake for example business intelligence and visualization tools and business applications Evaluate identifying existing data gaps building new ETL data pipelines and providing automated solutions to deliver advanced analytical capabilities and enriched data to applications that support business operations Implement and streamline DevOps practices in Enterprise Data Platform Ensure that operational system integrations driven from the data stack are running monitored and available Monitoring and troubleshooting data integration processes to ensure the utmost accuracy and integrity of data 6 JOB SPECIFICATIONSEducation Indicate the minimum level of education necessary for this position Check all that apply and indicate specific degree as applicable to the side e g Bachelors in Computer Science Required Preferred Degree Certification xe2 x98 x92 xe2 x98 x90 Bachelors degree xe2 x98 x90 xe2 x98 x92 Masters degree xe2 x98 x90 xe2 x98 x90 Ph D xe2 x98 x90 xe2 x98 x90 J D law xe2 x98 x90 xe2 x98 x90 Certification xe2 x98 x90 xe2 x98 x90 Registration xe2 x98 x90 xe2 x98 x90 Licensure xe2 x98 x90 xe2 x98 x90 Other Work Experience7-10 YearsKnowledge Skills Abilities Competencies Strong knowledge of database engineering data modeling ETL data lake house and data warehousing Firsthand experience in the data engineering with demonstrated design and technical implementation of data warehouses Technical expertise in data modeling database design data extraction and segmentation techniques Experience with building deploying and troubleshooting reliable and consistent data pipelines working with disparate in-house and external data-sources Expert in developing large scale enterprise class distributed system or subsystems that require high availability low latency strong data consistency computing Advanced complex SQL knowledge and experience Working experience with both relational and NoSQL databases Strong knowledge of data visualization tools like Power BI and Tableau Strong knowledge of data validation techniques and processes Experience with data modeling warehousing and building ETL pipelines Effectively communicate complex technical artifacts to both technical non-technical audiences Participate in cross-functional meetings workshops and planning sessions to ensure data engineering activities support the overall objectives across data product and platform initiatives Experience with database back-up recovery and archiving strategy Shift details N ARequired to work in shift NOIf Yes Shift Timing N AIf you share our mindset you can share in our success To find out more about joining Aptean get in touch today Learn from our differences Celebrate our diversity Grow and succeed together Aptean pledges to promote a company culture where diversity equity and inclusion are central We are committed to applying this principle as we interact with our customers build our teams cultivate our leaders and shape a company in which any employee can succeed regardless of race color sex national origin sexuality and gender identity religion disability or age Celebrating our diverse experiences opinions and beliefs allows us to embrace what makes us unique and to use this as an asset in bringing innovative solutions to our customer base At Aptean our global and diverse employee base is our greatest asset It is through embracing and understanding our differences that we are able to harness our individual power to maximize the success of our customers our employees and our company - TVN Reddy