Tata Consultancy Services
Developer
Tata Consultancy Services, Armonk, New York, United States, 10504
Sr Oracle PL/SQL Developer
Responsibilities:•Collaborate with stakeholders to gather and understand business requirements, ensuring that solutions align with organizational goals, particularly in the reinsurance domain.•Lead the design and development of complex Oracle PL/SQL packages, procedures, and queries, with a strong focus on performance tuning and scalability.•Manage data transformation and migration processes, ensuring data integrity and consistency, while handling large data volumes using advanced partitioning techniques.•Drive the performance optimization of PL/SQL code by tuning queries and procedures to efficiently manage high data volumes and resolve performance bottlenecks.•Implement and debug intricate financial routines, working closely with cross-functional teams to deliver robust solutions.•Provide expert insights into PL/SQL best practices, data management strategies, and integration solutions, contributing to technical discussions and solutioning efforts.•Work with the change management team to ensure smooth implementation of system changes, adhering to project timelines and maintaining high-quality standards.•Communicate technical concepts and solutions effectively to both technical and non-technical stakeholders.
Qualifications:•Extensive hands-on experience with Oracle PL/SQL, including performance tuning, dynamic SQL, and advanced query development.•Proven ability to manage large volumes of data, with expertise in data partitioning and performance optimization.•Strong background in Data Warehousing projects with a deep understanding of Data Warehousing concepts, including ETL processes, data modeling, and data integration.•Experience with ETL tools is a plus, with a preference for Informatica PowerCenter.•Solid background in data transformation and migration, particularly with complex financial datasets.•In-depth understanding of reinsurance processes and valuation systems is highly desirable.•Demonstrated leadership in technical discussions and effective collaboration with business stakeholders.•Excellent problem-solving skills with a proactive approach to identifying and addressing challenges.
Responsibilities:•Collaborate with stakeholders to gather and understand business requirements, ensuring that solutions align with organizational goals, particularly in the reinsurance domain.•Lead the design and development of complex Oracle PL/SQL packages, procedures, and queries, with a strong focus on performance tuning and scalability.•Manage data transformation and migration processes, ensuring data integrity and consistency, while handling large data volumes using advanced partitioning techniques.•Drive the performance optimization of PL/SQL code by tuning queries and procedures to efficiently manage high data volumes and resolve performance bottlenecks.•Implement and debug intricate financial routines, working closely with cross-functional teams to deliver robust solutions.•Provide expert insights into PL/SQL best practices, data management strategies, and integration solutions, contributing to technical discussions and solutioning efforts.•Work with the change management team to ensure smooth implementation of system changes, adhering to project timelines and maintaining high-quality standards.•Communicate technical concepts and solutions effectively to both technical and non-technical stakeholders.
Qualifications:•Extensive hands-on experience with Oracle PL/SQL, including performance tuning, dynamic SQL, and advanced query development.•Proven ability to manage large volumes of data, with expertise in data partitioning and performance optimization.•Strong background in Data Warehousing projects with a deep understanding of Data Warehousing concepts, including ETL processes, data modeling, and data integration.•Experience with ETL tools is a plus, with a preference for Informatica PowerCenter.•Solid background in data transformation and migration, particularly with complex financial datasets.•In-depth understanding of reinsurance processes and valuation systems is highly desirable.•Demonstrated leadership in technical discussions and effective collaboration with business stakeholders.•Excellent problem-solving skills with a proactive approach to identifying and addressing challenges.