Job Description

Role description

Work Description DSE ETL Advanced SQL Python AWS Services UNIXLINUX and Data Cloud



Work with business stakeholders Business Systems Analysts and Developers to ensure quality delivery of software



Interact with key business functions to confirm data quality policies and governed attributes



Assemble large complex sets of data that meet nonfunctional and functional business requirements



Identify design and implement internal process improvements including redesigning infrastructure for greater scalability optimizing data delivery and automating manual processes



Build required infrastructure for optimal extraction transformation and loading of data from various data sources using AWS and SQL technologies



Design development of Reports and dashboards



Analyzing and evaluating data sources data volume and business rules



Build analytical tools to utilize the data pipeline providing actionable insight into key business performance metrics including operational efficiency and customer acquisition



Interpret and analyses data from various source systems to support data integration and data reporting needs



Experience in testing Database Application to validate source to destination data movement and transformation



Work with team leads to prioritize business and information needs



Develop and summarize Data Quality analysis and dashboards



Knowledge of Data modeling and Data warehousing concepts with emphasis on Cloud On Prem ETL



Execute testing of data analytic and data integration on time and within budget



Troubleshoot determine best resolution for data issues and anomalies



Has deep understanding of data architecture data modeling best practices and guidelines for different data and analytic platforms



Job Requirements



Must Haves Skills



Preferred Experience in Spark SQL Python Cloud Formation



Extensive experience with Python scripting and Cloud Technologies



Extensive experience with AWS components like S3 Athena EMR Glue Redshift Kinesis and Sagemaker



Experience in Automating ETL process with Python and Automation around AWS Data Infrastructure



Extensive Experience with SQLUnixLinux scripting is a must



Extensive experience on Developingtesting CloudOn Prem ETL Ab Initio AWS Glue Informatica Alteryx



Extensive Experience in Data migration is a must Teradata to Redshift preferred



Experienced in largescale application development testing Cloud On Prem Data warehouse Data Lake Data Science

Skills

Mandatory Skills :

Flask, Apache Spark, Python, Nginx, Django, Jupyter Notebook, Scala, Apache Spark Scala, Python - Data Science

About LTIMindtree

LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700 clients, LTIMindtree brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world. Powered by 83,000+ talented and entrepreneurial professionals across more than 40 countries, LTIMindtree -- a Larsen & Toubro Group company -- solves the most complex business challenges and delivers transformation at scale. For more information, please visit https://www.ltimindtree.com/. Please also note that neither LTIMindtree nor any of its authorized recruitment agencies/partners charge any candidate registration fee or any other fees from talent (candidates) towards appearing for an interview or securing employment/internship. Candidates shall be solely responsible for verifying the credentials of any agency/consultant that claims to be working with LTIMindtree for recruitment. Please note that anyone who relies on the representations made by fraudulent employment agencies does so at their own risk, and LTIMindtree disclaims any liability in case of loss or damage suffered as a consequence of the same. Recruitment Fraud Alert - https://www.ltimindtree.com/recruitment-fraud-alert/