Title: SQL Developer
Location: Iselin, NJ (Hybrid onsite)
Duration: 9-month contract
JOB DESCRIPTION
- 3+ years of production application support using technologies Advanced SQL, Autosys, Big Data (Spark, Hadoop, Hive, Python, Scala)
- Advanced SQL and Stored Procs expertise is MUST
The position will form part of the Data Engineering team working with the global technology team, largely based in the US. The candidate will be expected to provide production support for the Data Engineering team. Resource will coordinate with various teams like Infrastructure, Network Security, Support teams across Market Surveillance technology and will be responsible for deployment of code, automation, monitoring batch jobs and ensure availability of application. Scope will include support, deployment, automation and migration to strategic platforms like cloud and well versed with ITIL standards like Incident, Change and Problem Management. The candidate will be required to ensure that the project complies with all company policies regarding the management of third-party solutions, Information Security and the Software Development Lifecycle.
- 5+ years of experience and deep understanding of Software Development Life cycle, data ingestion, storage, querying, processing and analysis.
- Advanced capabilities with:
SQL
Hadoop
Hive
Spark
- Expertise on scheduling tools like Autosys, Yoda and other standard industry scheduling tools
- Strong Unix/Linux skills and experience in writing shell scripts
- Oracle & SQL DB expertise and strong SQL skills and writing complex queries,
- Expertise in Data load management, importing & exporting data using SQL, ETL and Cloud Platforms.
- Experience with strategy, planning and execution of new infrastructure setup and Data Center/Cloud Migration
- Experience in configuring CS/CD pipelines, configure manage Kubernetes
- Involved in converting Hive/SQL queries into Spark transformations using Spark RDDs/Data frames, Scala.
- Experience developing, installing, and configuring Hadoop ecosystem components.
- Good knowledge on ETL procedures to transform the data in the intermediate tables according to the business rules and functionality requirements.
Nice to Have:
- Good interpersonal comm skills
- Jira
- Agile/Scrum methodologies
- Azure, GCP Knowledge/experience
- ITIL Certification, understanding of RTB & Support Functions