Responsibilities
- 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
General & 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#.
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