Position: Associate
Job Description
- Troubleshoot ETL jobs using Informatica PowerCenter, AWS Glue, Apache Spark, Pyspark.
- Automate manual tasks using Python3 to enhance operational efficiency.
- Develop data quality checks and reconciliations using SQL, PL/SQL to maintain data integrity.
- ISG Annuities Application Maintenance & Support for all ISG and IMBI applications such as ISG ETL, AFT, e-delivery, CRM, USBIE-SAAS, CR, AML, BPC, NEPS.
- Manage and update prudential scheduling tables like holiday, cycle date and batch job schedules using AutoSys
Qualification
- Bachelor’s degree
- Proficiency in ETL tools such as Informatica PowerCenter, Informatica Cloud, AWS Glue with a solid understanding of ETL concepts.
- Experience with relational databases (Oracle , MS SQL Server, IBM DB2, AWS Redshift, AWS Athena).
- Strong skills in Python, PySpark, and shell/ bash scripting for automating tasks and data processing.
- Hands on with AWS services ( S3, CloudWatch, Glue, SPLUNK, Bit bucket) and experience with AutoSys Scheduler and Request IT/MyPru IT for efficient job scheduling and management.