User details
SS
SS
sapna sukumaran
@sapna_sukumaran_y5olzd367
Data Entry Administrator
South Windsor, NY, United States
1Follower0Following0Mutual0Post
Member since: Jan 21, 2025Results-driven ETL Test Lead with over 7 years of experience in data warehousing and testing methodologies within the healthcare domain. Proven expertise in guiding teams through thorough ETL testing processes, ensuring optimal data integration and quality assurance. Recognized for exceptional problem-solving abilities and a strong focus on process optimization, leading to significant enhancements in data accuracy and operational efficiency. Committed to delivering projects on time while continuously improving performance metrics.
• Developed test plans and strategies for ETL testing processes.
• Documented, triaged, and managed defects in software and worked with developers to facilitate timely resolutions.
• Conducted validation of data mapping rules, transformations, stored procedures, functions.
• Worked with business users to ensure that their expectations are met through successful implementation of projects.
• Performed back-end database testing using SQL queries to verify data accuracy in target systems.
• Provided support in production environment by troubleshooting any issue related to ETL processing or data migration from source systems into target databases.
• Approached customers and engaged in conversation through use of effective interpersonal and people skills.
• Collaborated closely with team members to achieve project objectives and meet deadlines.
• Demonstrated strong problem-solving skills, resolving issues efficiently and effectively.
• Provided support to junior staff during peak periods of workloads.
• Set specific goals for projects to measure progress and evaluate end results.
• Managed monthly production deployments in Informatica.
• Crafted comprehensive test cases based on business requirements and source-
target mappings.
• Performed verification of Datastage job/sequence functionality using pre-defined Rational test scenarios.
• Documented discrepancies in queries and performance swiftly.
• Ensured seamless transition by migrating jobs post-testing.
• Utilized Oracle, Informatica, Datastage, SQL, Teradata, Rational Manual Tester and Linux.
• Facilitated migration of data processes from Informatica to Datastage (version 8.1).
• Created source-to-target data mappings for effective mirroring.
• Construct and implement targeted Oracle database queries.
• Generated test scripts with Rational Manual Tester.
• Engineered mirrored data transfers across diverse settings using DataStage.
• Ensured Datastage job accuracy against Informatica mappings.
• Conducted validation of Datastage transformation against Informatica transformation.
• Ensured alignment of Datastage and Informatica codes through thorough validation.
• Identified behavior discrepancies in DataStage jobs with Rational Manual Tester.
• Utilized Informatica, Datastage, SQL, Teradata, Linux, Rational Manual Tester.
• Created E-R diagrams from detailed requirement analysis.
• Authored queries utilizing Oracle Toad per specified requirements.
• Designed mappings, sessions, and workflows to meet stipulated criteria.
• Executed workflows and sessions as per daily/weekly/monthly criteria.
• Engaged in the Unit and System Integration Testing stages of the development process.
◦ Generated unit tests tailored to specific mappings and workflow designs.
• Leveraged diverse tools including Informatica and Oracle alongside Unix and Linux systems.