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.
Skills Required
- Expert in SQL and PL/SQL on Snowflake or Netezza
- UNIX shell scripting skills
- Working knowledge of Hadoop, HDFS, and Spark
- Experience with PySpark
- Good knowledge of Python
- Good knowledge of AWS and experience using EC2, S3, EMR
- Experience with NoSQL databases
- Experience with Control-M or similar scheduling tools
- Experience with NiFi and Informatica PowerCenter
- Experience in query tuning and optimization in an RDBMS (Oracle or DB2)
- Strong database and data warehousing concepts
- Proven analytical and problem-solving skills
- Ability to work independently in a globally distributed environment
- Understand business needs and incorporate into technical solutions
What We Do
Photon.com has emerged as one of the world’s largest and fastest-growing Digital Agencies. We work with 40% of the Fortune 100 on their Digital initiatives and are known for our ability to integrate Strategy Consulting, Creative Design, and Technology at scale. Please visit www.photon.com to learn more about us, how we work, and our customer case studies. Digital Transformation Starts Here.
