Cloud Data Engineer

Location: Chennai

Exp needed: 14-18 Years

Salary Range: 27-33 LPA

Responsibilities:

• Gather business requirements and translate them into technical designs
• Collaborate as part of an Agile and DevOps team to provide data engineering support across the EU IT portfolio
• Design and implement technology standard methodologies, guidelines, and reusable processes
• Test and quality assess new Data & Analytics (D&A) solutions to ensure their readiness for release, including code assurance, unit and system integration testing, data testing, and support for user acceptance testing (UAT) processes
• Ensure business data and information assets are available as data services and artifacts for use by the wider organization

Essential Skills:

• Experience with AWS services such as EMR, EC2, S3, Athena, Lambda, and Redshift, as well as Pyspark
• Proficiency in working in a fully CI/CD managed environment using tools like git, Jenkins, Bitbucket, Code Commit, Bamboo, or similar
• Excellent SQL coding skills
• Strong data modeling skills, including knowledge of RDBMS concepts, normalization, dimensional modeling, and star/snowflake schema
• Experience scripting with Python, Unix, or similar languages
• Hands-on experience with an orchestration capability, preferably Airflow or similar tools
• Familiarity with a range of BI & analytics architectures, including traditional data warehousing, visualization, and analytics
• Understanding of data modeling techniques, such as entity relationship diagrams, conceptual models, logical models, star schemas, and third normal form
• Experience delivering data and analytics solutions using Agile or Waterfall methodologies
• Familiarity with one or more data visualization tools like Microstrategy and/or Power BI
• Strong problem-solving skills, with a focus on continuous improvement
• Analytical, creative, and self-motivated mindset
• Ability to work effectively independently or as part of a team
• Excellent communication and documentation skills
• Willingness to learn and adapt to new technologies as required

Desirable Skills:

• Domain knowledge in areas such as Pharma Compliance and Regulatory Reporting
• Working knowledge of Snaplogic, Databricks, and Snowflake
• Experience in stakeholder engagement and effective communication with business stakeholders
• Strong storytelling capability
• People and process management skills
• Proficiency in IT Service Management (ITSM) concepts
• Bachelors degree in Computer Science/IT or equivalent
• Preferable industry experience in IT

Overall Years of Experience: 10+ years of overall experience with at least 5+ years of experience in EMR, S3, Redshift, Postgres, AWS, and Datawarehouse projects