Neelima J Email and Phone Number
A seasoned QA Developer with over 8+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application system.Dedicated QA professional with a proven track record of ensuring the accuracy, reliability, and performance of data transformation processes. Adept at designing and implementing comprehensive testing strategies to validate ETL workflows and guarantee data integrity. Proficient in using industry-standard tools and methodologies to identify and resolve issues, ensuring high-quality data delivery.Key Skills:ETL Testing: Extensive experience in testing end-to-end ETL processes, including data extraction, transformation, and loading phases. Proficient in validating data movement across various stages and identifying anomalies.Data Quality Assurance: Expertise in implementing data quality checks and validations to guarantee the accuracy, completeness, and consistency of transformed data. Skilled in developing and executing SQL queries to assess data integrity.Test Planning and Execution: Proven ability to create comprehensive test plans, test cases, and test scripts for ETL processes. Execute test scenarios to validate data accuracy and identify defects, ensuring adherence to project requirements.Automation: Familiarity with ETL automation tools and frameworks to streamline testing processes, increase efficiency, and reduce manual efforts. Experience in leveraging tools like Apache Nifi, Talend, or Informatica for automated ETL testing.Performance Testing: Competent in conducting performance testing to assess the scalability and efficiency of ETL processes. Proficient in identifying and resolving bottlenecks for optimal data processing performance.Collaborative Team Player: Effective collaborator with cross-functional teams, including data engineers, developers, and business analysts. Proven ability to communicate complex technical concepts to non-technical stakeholders.Issue Tracking and Resolution: Proficient in using defect tracking tools to log, monitor, and manage issues throughout the testing life cycle. Skilled in working closely with development teams to ensure timely resolution of identified defects.Professional Accomplishments:Successfully led the ETL QA efforts, resulting in a 20% improvement in data accuracy and a 15% reduction in processing time.Collaborated with cross-functional teams to establish and enforce data quality standards, resulting in improved data consistency and trustworthiness.
-
Qa DeveloperGenuine Parts Company Jul 2021 - PresentAtlanta, Georgia, UsNeelimaEmail: neelimajettipalli@gmail.com | Phone: 804-334-6428Professional SummaryA seasoned ETL QA Developer with over 8 years of IT experience specializing in the analysis, design, development, testing, and implementation of business applications. Proficient in all stages of the Software Development Life Cycle (SDLC), including business requirement analysis, data mapping, unit testing, system integration, and user acceptance testing.Strong expertise in Data Warehousing, ETL processes, and tools such as Informatica PowerCenter, with a deep understanding of data modeling, performance tuning, and SQL. Adept in working with Google BigQuery (GBQ), Informatica Intelligent Cloud Services (IICS), and Power BI to ensure seamless data flow across systems. Proven ability to automate test scenarios and create comprehensive test strategies to enhance efficiency in cloud-based data integration and management.Key Skills:ETL Tools: Informatica PowerCenter (10.x/9.x/8.x), IICS, Power Mart, Power Exchange, SQLData Warehousing: Dimensional Modeling (Star & Snowflake schemas)Testing: ETL Testing, Performance Testing, Regression Testing, Test AutomationDatabases: Google BigQuery, Oracle (11c/10g), SQL Server, DB2, SybaseLanguages: SQL, PL/SQL, T-SQL, UNIX Shell ScriptingMethodologies: Agile, WaterfallReporting Tools: Power BIOperating Systems: UNIX, WindowsTechnical SkillsETL & Data Integration Tools: Informatica PowerCenter 10.x/9.x/8.x/7.x, Informatica Intelligent Cloud Services (IICS), SSIS, SQLPlus, SQLLoader, ToadDatabases: Google BigQuery, Oracle (11c/10g), SQL Server, DB2, SybaseLanguages: SQL, PL/SQL, T-SQL, UNIX Shell ScriptingData Modeling: Star-Schema, Snowflake Modeling, ErwinTesting Tools: Test Automation, ETL Testing, Performance Testing, Regression TestingReporting Tools: Power BIMethodologies: Agile, WaterfallEducationBachelor of Electronics and Communication EngineeringAnna University, India | 2007 -
Qa DeveloperCaterpillar Inc. Feb 2020 - Jul 2021Irving, Texas, Us• Participate in design and analysis sessions with business analysts, source-system technical teams, and end users.• Designing, developing, maintaining and supporting Data Warehouse or OLTP processes via Extract, Transform and Load (ETL) software using Informatica.• Manage and expand current ETL framework for enhanced functionality and expanded sourcing.• Translate business requirements into ETL and report specifications. Performed error handing using session logs.• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.• Done Code reviews of ETL and SQL processes. Worked on upgrading Informatica from version 9.x to 10.x.• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence• Identifying performance issues in the code and tuning it to complete the jobs within the given SLA time.• Performance tuning at Informatica and database levels depending on the bottlenecks identified with the jobs.• Developed mappings using Informatica Power Center Transformations - Lookup (Unconnected, Connected), Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, and Sequence Generator.• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.• Worked with the testing team to resolve bugs related to day one ETL mappings before production.• Maintained ETL release document for every release and migrated the code into higher environments through deployment groups.• Created change request before code deployment into production to get required approvals from business.• Created weekly project status reports, tracking the progress of tasks according to schedule and reported any risks and contingency plan to management and business users. -
Etl DeveloperPnc Bank P N C Bank Dec 2018 - Jan 2020• Extensively Working on Informatica tools such as Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer• Using Informatica Power center 10.1 to make the changes to the existing ETL Wrote PL/SQL procedures which are called from Stored Procedure transformation to perform database actions such as truncate the target before load delete records based on a condition and re-name the tables.• Create ETL mappings with complex business logic for high volume data loads using various transformations such as Aggregator, Sorter, Filter, Normalizer, SQL Transformation, Lookup, Joiner, Router, Update Strategy, Union, Sequence Generator, transformation language likes transformation expression, constants, system variables, data format strings etc.• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 10.x.• Extensively worked on building workflows, worklets, sessions, command tasks etc.• Designed and developed Informatica mappings including Type-I, Type-II and Type-slowly changing dimensions (SCD).• Extensively worked on ETL performance tuning for tune the data load, worked with DBAs for SQL query tuning etc.• Supported monthly data load activity using SSIS for Account Assignment System.• Involved in writing SQL Stored procedures and Shell Scripts to access data from various sources.• Assisted other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.• Performed System, Integration testing and supported User Acceptance Testing.• Managed stakeholder communication and validated the fixed issues in order to ensure support availability as per agreed SLAs.Environment: Informatica Power Center 10.x/9.x, Oracle, MS SQL Server 2014, Business Objects, MS Access, Windows. -
Qa TesterMolina Healthcare Jul 2017 - Nov 2018Long Beach, California, Us• Interacted with business analysts, data architects, application developers to develop a data model. • Involved in the warehouse design using a Star Schema. • Joined relational tables existing in separate database using Joiner Transformation. • Used the Router Transformation to load user-defined groups for the business units based on group filter conditions. • Involved in Performance Tuning of sources, targets, mappings and sessions.• Performed unit testing to validate mappings and populate the database. • Documentation of Technical specification, business requirements, functional specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables.• Performed data analysis based on the source systems and existing OLTP database systems.• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.• Tested data and data integrity among various sources and targets. -
Qa SpecialistHome Away Jan 2016 - Jun 2017• Extracted Data from Different Sources by using Informatica.• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer and Mapplets Designer.• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update Transformation rules.• Developed schedules to automate the update processes and Informatica sessions and batches.• Analyze, design, construct and implement the ETL jobs using Informatica.• Developed mappings/Transformations/mapplets by using mapping designer, transformation developer and mapplets designer in Informatica Power Center 6.1.• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.• Created Users, user groups, database connections and managed user privileges using supervisor.
Frequently Asked Questions about Neelima J
What company does Neelima J work for?
Neelima J works for Genuine Parts Company
What is Neelima J's role at the current company?
Neelima J's current role is QA Test Engineer.
Who are Neelima J's colleagues?
Neelima J's colleagues are Troy Mclendon, Curt Haen, Remigio Buestán Gpc, Mario Figueredo, John Conrad, Monika Pietrzyk, Stan Echols.
Free Chrome Extension
Find emails, phones & company data instantly
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial