Job Title: ETL Developer with AWS Expertise. Location: Vadodara. Job Type: Contract Role. About the Role: We are seeking a highly skilled ETL Developer with expertise in AWS Glue and related AWS services. The ideal candidate will have a strong background in designing, implementing, and managing ETL pipelines, data transformations, and data validation processes. You will work closely with data engineers, data scientists, and other stakeholders to ensure that our data infrastructure is robust, efficient, and scalable. Key Responsibilities: - Design and Develop ETL Pipelines: Build, deploy, and maintain ETL pipelines using AWS Glue and other AWS services. Ensure data is extracted, transformed, and loaded efficiently to meet business requirements. - AWS Services Management: Utilize AWS services like S3, Lambda, and Glue to manage and orchestrate data flows. Ensure data is securely stored, processed, and accessible. - Data Transformation and Validation: Perform data transformation tasks to convert raw data into meaningful insights. Implement rigorous data validation procedures to ensure data quality and integrity. - SQL and SSMS Proficiency: Write and optimize SQL queries to extract, manipulate, and analyze data. Use SQL Server Management Studio (SSMS) for database management and query execution. - Python Scripting: Develop Python scripts to automate ETL processes and handle complex data transformation tasks. Integrate Python-based solutions into the ETL pipelines as needed. - Collaboration and Documentation: Work closely with data teams to understand data requirements and implement solutions. Document ETL processes, data flows, and transformation logic for future reference and maintenance. Technical Skills: - Proficient in AWS Glue, AWS S3, and related AWS services. - Strong experience with SQL and SSMS. - Expertise in ETL pipeline design and development. - Proficiency in Python for data transformation and automation. - Knowledge of data validation techniques and best practices.