Data Engineer/ DevOps - Enterprise Big Data Platform

I am looking for immediate joiners. Kindly share your notice period information while applying. 

The candidate needs to be strong on SQL Query and POWERBI

• Experience with PowerBI (Important)
• Experience with Relational databases like Mysql, MSSQL, etc (Important)
• Any scripting knowledge like (Python, shell scripting, etc) (Important)
• Experience on db connectors across multiple platforms.
• Knowledge on AWS Redshift is a plus

• Extensive exposure to at least one Business Intelligence Platform (if possible, QlikView/Qlik Sense) – if not Qlik, ETL tool knowledge, ex- Informatica/Talend
• At least 1 Data Query language – SQL/Python
• Experience in creating breakthrough visualizations
• Understanding of RDMS, Data Architecture/Schemas, Data Integrations, Data Models and Data Flows is a must

Data Engineer 

Mandatory Requirements  

• Experience in AWS Glue 

• Experience in Apache Parquet  
• Proficient in AWS S3 and data lake  
• Knowledge of Snowflake 
• Understanding of file-based ingestion best practices. 
• Scripting language - Python & pyspark 

CORE RESPONSIBILITIES 

• Create and manage cloud resources in AWS  
• Data ingestion from different data sources which exposes data using different technologies, such as: RDBMS, REST HTTP API, flat files, Streams, and Time series data based on various proprietary systems. Implement data ingestion and processing with the help of Big Data technologies  
• Data processing/transformation using various technologies such as Spark and Cloud Services. You will need to understand your part of business logic and implement it using the language supported by the base data platform  

• Develop automated data quality check to make sure right data enters the platform and verifying the results of the calculations  
• Develop an infrastructure to collect, transform, combine and publish/distribute customer data. 
• Define process improvement opportunities to optimize data collection, insights and displays. 
• Ensure data and results are accessible, scalable, efficient, accurate, complete and flexible  
• Identify and interpret trends and patterns from complex data sets  

• Construct a framework utilizing data visualization tools and techniques to present consolidated analytical and actionable results to relevant stakeholders.  
• Key participant in regular Scrum ceremonies with the agile teams   
• Proficient at developing queries, writing reports and presenting findings  
• Mentor junior members and bring best industry practices  

QUALIFICATIONS 

• 5-7+ years’ experience as data engineer in consumer finance or equivalent industry (consumer loans, collections, servicing, optional product, and insurance sales)  
• Strong background in math, statistics, computer science, data science or related discipline 
• Advanced knowledge one of language: Java, Scala, Python, C#  
• Production experience with: HDFS, YARN, Hive, Spark, Kafka, Oozie / Airflow, Amazon Web Services (AWS), Docker / Kubernetes, Snowflake   

• Proficient with 
• Data mining/programming tools (e.g. SAS, SQL, R, Python) 
• Database technologies (e.g. PostgreSQL, Redshift, Snowflake. and Greenplum) 
• Data visualization (e.g. Tableau, Looker, MicroStrategy) 
• Comfortable learning about and deploying new technologies and tools.  

• Organizational skills and the ability to handle multiple projects and priorities simultaneously and meet established deadlines.  
• Good written and oral communication skills and ability to present results to non-technical audiences  
• Knowledge of business intelligence and analytical tools, technologies and techniques. 

Familiarity and experience in the following is a plus:  

• AWS certification 
• Spark Streaming  
• Kafka Streaming / Kafka Connect  
• ELK Stack  
• Cassandra / MongoDB  

• CI/CD: Jenkins, GitLab, Jira, Confluence other related tools 

• Interpret data, analyze results using statistical techniques and provide ongoing reports
• Develop and implement databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality
• Acquire data from primary or secondary data sources and maintain databases/data systems
• Identify, analyze, and interpret trends or patterns in complex data sets
• Filter and clean data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems
• Work with the teams to prioritize business and information needs
• Locate and define new process improvement opportunities

• Minimum 3 year of working experience as a Data Analyst or Business Data Analyst
• Technical expertise with data models, database design development, data mining, and segmentation techniques
• Strong knowledge of and experience with reporting packages (Business Objects etc), databases (SQL, etc), programming (XML, JavaScript, or ETL frameworks)
• Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS, etc)
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• Excellent written and verbal communication skills for coordinating across teams.
• A drive to learn and master new technologies and techniques.

• Minimum 1 years of relevant experience, in PySpark (mandatory)
• Hands on experience in development, test, deploy, maintain and improving data integration pipeline in AWS cloud environment is added plus 
• Ability to play lead role and independently manage 3-5 member of Pyspark development team 
• EMR ,Python and PYspark mandate.
• Knowledge and awareness working with AWS Cloud technologies like Apache Spark, , Glue, Kafka, Kinesis, and Lambda in S3, Redshift, RDS

This person MUST have:

• B.E Computer Science or equivalent
• 5 years experience with the Django framework
• Experience with building APIs (REST or GraphQL) 
• Strong Troubleshooting and debugging skills
• React.js knowledge would be an added bonus 
• Understanding on how to use a database like Postgres (prefered choice), SQLite, MongoDB, MySQL.
• Sound knowledge of object-oriented design and analysis.
• A strong passion for writing simple, clean and efficient code.
• Proficient understanding of code versioning tools Git.
• Strong communication skills.

Experience:

• Min 5 year experience
• Startup experience is a must. 

Location:

• Remote developer

Timings:

• 40 hours a week but with 4 hours a day overlapping with client timezone.  Typically clients are in California PST Timezone.

Position:

• Full time/Direct
• We have great benefits such as PF, medical insurance, 12 annual company holidays, 12 PTO leaves per year, annual increments, Diwali bonus, spot bonuses and other incentives etc.
• We dont believe in locking in people with large notice periods.  You will stay here because you love the company.  We have only a 15 days notice period.

Roles and responsibilities:

1. Responsible for development and maintenance of applications with technologies involving Enterprise Java and Distributed  technologies.
2. Experience in Hadoop, Kafka, Spark, Elastic Search, SQL, Kibana, Python, experience w/ machine learning and Analytics     etc.
3. Collaborate with developers, product manager, business analysts and business users in conceptualizing, estimating and developing new software applications and enhancements..
4. Collaborate with QA team to define test cases, metrics, and resolve questions about test results.
5. Assist in the design and implementation process for new products, research and create POC for possible solutions.
6. Develop components based on business and/or application requirements
7. Create unit tests in accordance with team policies & procedures
8. Advise, and mentor team members in specialized technical areas as well as fulfill administrative duties as defined by support process
9. Work with cross-functional teams during crisis to address and resolve complex incidents and problems in addition to assessment, analysis, and resolution of cross-functional issues.