Software Engineer-PLSQL, Snowflake, Python, AWS -BLR

The Purpose of This Role

We use data and analytics to personalize incredible customer experiences and develop solutions that help our customers live the lives they want. As part of our digital transformation, we have significant investments to build cloud data lake platforms. We are looking for a hands-on data engineer who can help us design and develop our next generation Cloud Data Lake and Analytics Platform for Workplace Solutions.

The Value You Deliver

· You will be participating in end to end development which includes design, development, testing and deployment.

· You will be working closely with Technical Lead/Architects to ensure that solutions are consistent with IT Roadmap.

· You will be participating in technical life cycle processes, which include impact analysis, design review, code review, and peer testing.

· You will be participating in hands on development of application framework code in Oracle PL-SQL, Snowflake, pySpark, Python, NiFi, Informatica Power Center, along with Control-M and UNIX shell scripts.

· You will be troubleshooting and fixing any issues reported on data issues and performance.

· You will be presenting the findings and outcome to Senior Leadership teams and provide insights from the data to the business.

· You will be helping business teams optimize their current tasks and increase their productivity.

 

The Skills that are Key to this role

Technical / Behavioral

· You must be an expert in using SQL and PLSQL on Snowflake or Netezza with UNIX shell scripting skills.

· You should be having working knowledge in Hadoop, HDFS, Spark, NoSQL DBs,

· Good knowledge on Python and AWS is MUST

· You should have experience of using AWS services like EC2, S3, EMR to move data onto cloud platform

· Experience of query tuning and optimization in one of the RBMS (oracle or DB2)

· You should be having experience in Control-M or similar scheduling tools.

· You should have proven analytical and problem-solving skills

· You should be strong in Database and Data Warehousing concepts.

· You must be able to work independently in a globally distributed environment

· You should have clear understanding of the business needs and incorporate these into technical solutions.