Looking for, Data Analytics Engineer || Remote at Remote, Remote, USA |
Email: [email protected] |
From: Mayank, Pivotal Technologies [email protected] Reply to: [email protected] Role : Data Analytics Engineer Location: Remote Interview Mode: Virtual Visa : No H1 Manager Notes: Experience with cloud computing platforms, preferably AWS with prior experience developing and optimizing DynamoDB, Lambdas, Step Functions, Glue, S3, Redshift Strong proficiency in developing, debugging ETL pipelines using Data Integration tool Pentaho or similar ETL tools such as Talend, Informatica Hands-on programming experience in Python or Java with focus towards building ETL workflows and data driven solutions Experience with big data batch computing tool Spark and developing distributed data processing solutions In-depth knowledge of warehousing concepts such as star schema and experience using variety of data stores (RDBMS, analytic database, scalable document stores) Strong expertise in developing and debugging SQL scripts, functions, stored procedures, triggers Solid understanding of software engineering tools, workflows (CI/CD, git) Good understanding and business acumen in financial industries, preferably insurance Proficiency in Data visualization tools preferably Tableau, and Pentaho or similar tools such as Power BI, looker Other preferred skills: Working knowledge on shell scripting, TCP/IP networking concepts, Jenkins ETL (DataStage & Autosys) Python SQL Data Modeling with Oracle and SQL Databases Data & Analytics Development Engineer Primary Role Definition: Data & Analytics developers are people who works with ETL (extract data, transform it, and load it) tools like DataStage, Autosys scheduling tools. Skills required: o Very skilled in Python and DataStage coding and development o Very skilled in performing Python/Data Stage Code reviews o Very skilled in SQL o Very skilled in Data Modeling with both Oracle and SQL Databases o Database query tuning o Cloud experience (AWS/GCP) is a plus. Hit ground running, self-starter, great communicator (verbally and written Will have to support nightly production batch cycles on a rotation basis Rajesh or Tamil will screen for interviews; schedule hands on coding interview and technical screening after short screen with candidates they like. Hands on coding should include SQL and Python. A lot of moving parts, scrum calls, tasks to do, meetings to discuss successes and failures Impact to AmFam: expand sales channel capabilities to utilize IA channel Interviews will be conducted via Teams video calls. Remote work is permitted with 8 hours workday (excl breaks), No Overtime hours Very strong in the following areas DW methodologies, Data Marts, Cloud experience (preferably GCP), Data Ingestion via multiple sources like SQL server, mainframe files, APIs, JSON feeds etc using Python, DataStage, Linux Nice to have Guidewire, Autosys, developing Architecture and Dataflow diagrams Self-motivated, thorough with quality work they do, work with minimal supervision Strong verbal and communication skills, effective communication is essential as team dynamics change quickly No customer service skills are needed but will interact with internal business partners Insurance is strongly preferred but not mandatory 10 years of experience Work Environment: o Small team o Very dynamic o Need to support other team members as needed o Must be a strong team player o Good communication skills Thanks & Regards, Mayank Mer Technical Recruiter Keywords: continuous integration continuous deployment business intelligence sthree information technology Iowa |
[email protected] View all |
Wed Aug 23 23:16:00 UTC 2023 |