
Analyst IT
- Bangalore, Karnataka
- Permanent
- Full-time
- Development of new ETL/data transformation jobs, using PySpark and IBM DataStage in AWS.
- Enhancement and support on existing ETL/data transformation jobs.
- Perform technical code reviews for peers moving code into production.
- Perform and review integration testing before production migrations.
- Provide high level of technical support, and perform root cause analysis for problems experienced within area of functional responsibility.
- 3+ years of ETL experience. A certification with less experience may also be considered. Experience with PySpark or IBM DataStage preferred.
- Strong knowledge of SQL fundamentals.
- Able to write SQL code sufficient for most business requirements for pulling data from sources, applying rules to the data, and stocking target data
- Proven track record in troubleshooting ETL jobs and addressing production issues like performance tuning, reject handling, and ad-hoc reloads.
- Proficient in developing optimization strategies for ETL processes.
- Strong knowledge of core Python programming for data transformation.
- Beginning PySpark skills. Can read/understand existing code and do simple debug and code fixes.
- Basic AWS technical support skills. Has ability to log in, find existing jobs and check run status and logs
- Will run and monitor jobs running via Control-M
- Can create clear and concise documentation and communications.
- Ability to coordinate and aggressively follow up on incidents and problems, perform diagnosis, and provide resolution to minimize service interruption
- Ability to prioritize and work on multiple tasks simultaneously
- Effective in cross-functional and global environments to manage multiple tasks and assignments concurrently with effective communication skills.
- A self-starter who can work well independently and on team projects.
- Bachelors of Science in computer science or equivalent
- 3+ years of ETL and SQL experience
- 2+ years of python experience
- 1+ years of AWS and unix experience.
- Preferred certifications:
- Certified DataStage Professional
- Python programming certification