Data Engineer/Analyst

Posted On: 17th Sept 2022 Role: Data Engineer/Analyst Job ID: Sep16417 Location: NJ (On-Site) Desired Qualification: Bachelor’s degree or equivalent in related field. Required Experience: Minimum of 4-5 years in information technology. Minimum 2-3 years of hands-on design & development experience. Experience working in an IT development & support environment. Experience in issue management, root cause analysis and troubleshooting. Data Analysis and Software Development (SDLC) experience a must. Technical Skills: The following are MUST have SKILLS - Google Cloud Platform, Apache Airflow, Cloud Composer, Python, Terraform. Hands-on programming skills using SQL, Python, T-SQL, PL-SQL, Unix/C/C#, Scripting tools. Coding, Debugging, Root Cause analysis. Data Analysis, Support & Issue Resolution. Basic skills in software design & development using RDBMS. Interpreting data models, relationships, data lineage & database connectivity details. Working knowledge of Cloud and networking technologies. Technologies – Oracle/SQL Server, TSQL/PLSQL, ETL tools/scripts, Unix/Linux/Windows, Scripting (VBScript, PowerShell, etc), RDMS, C/C#. Job Description: Develop, implement and optimize data solutions using SQL, Shell Scripting, ETL Tools and other cloud data pipeline and transformation tools. Analyze, Research, Review and Interpret data consumption and usage requirements. Design data schemas for high performance and identify improvements to existing structures. Develop solutions for data migration, movement and exchange. Document data flow diagrams at various levels of detail from source to target systems. Develop procedures and programs and scripts to extract/integrate/share data from PeopleSoft, CRM and Web Applications. Troubleshoot performance and scalability issues and develop scripts and code to track, monitor & troubleshoot issues. Fine-tuning of SQL code used in SQL based objects, ETL processes, data virtualization tools, and other programs. Work individually and with team in developing procedures to upload, monitor and track data uploads in/out of data repositories. Work on Products/Programs by functional areas to provide development & support. Willingness to learn new tools & technology and perform other duties as required. Contact: If interested please mail resume and Job ID to: us@esveetech.com