Sheba Rani Appikatla
Dallas,TX
Summary
ETL Experience: Overall 12 years experience Around 11+ years experience of IT in Development and Implementation, Integration of Applications of Datawarehouse, Analysis, design, development, testing, production and implementation services using ETL tools. Extensive work experience in the areas of Banking, Finance, Insurance and Manufacturing Industries. Proficient in supporting Extract, Transform, and Load environments using Informatica Power Center (Designer, Repository Manager, Workflow Manager, Workflow Monitor). Capable of Developing, Designing, Performing Code Reviews, Peer reviews, and documenting Informatica work products like Mappings, Mapplets, Reusable transformations, Sessions, Workflows, Worklets, and Schedulers, along with experience in using Mapping parameters, Mapping variables, Session parameter files. Expertise in Implementing Complex Business rules by creating complex Mappings/Mapplets, Reusable transformations, and Partitioning Sessions. Strong understanding of Data warehousing concepts, dimensional Star Schema and Snowflake Schema methodologies, fact and dimension tables, Dimensional modeling, OLAP, and OLTP processes. Extensively used SQL and PL/SQL for writing Stored Procedures, Functions, Packages, and Triggers. Experience with SQL Plus and TOAD interfaces to databases for analyzing, viewing, and altering data. Experienced in UNIX/LINUX environments, file transfers, job scheduling, and error handling. Use of PowerCenter Clients and objects in managing users, accounts, groups, roles, privileges, and permission. Create and manage user accounts, Infacmd utility to manage domain objects and security. Installing Informatica 10 domain, clients. Manage tab options, Domain view options, Services and Nodes view. Proficient in several databases like Oracle, DB2, SQL server, Teradata (BTEQ and TPT), Flat files, XML, CSV, PGP files encrypted and decrypted. Experienced on Azure designing maps by Informatica cloud to load information. Configuring PowerCenter Application Services, creating a PowerCenter Repository Service, configuring domain folders and Repository and Integration Service. Experience with Informatica - IICS task flows development and maintenance. Comprehensive knowledge and have skills on SSIS packages to Informatica migration services and using mapping parameters and variables in IICS to manage dynamic values, similar to SSIS. Comprehensive knowledge of the Software Development Life Cycle (SDLC), Conceptual and logical thinking skills, goal-oriented, self-motivated, Capable of working independently or as part of a team. Certified in SAFe Agile, with the ability to manage large software development projects at the enterprise level, meeting demanding time restraints and exceeding expectations using the SAFe Agile Framework and lean Agile mindset. Technical Expertise: Proven history in monitoring applications in data warehouses on AWS using Cloud Watch, along with strong proficiency in ETL/ELT processes and modern data stack technologies (SQL, Python, etc.). I have a good knowledge of cloud platforms (e.g., AWS, Google Cloud, Microsoft Azure, Denodo). PowerBI Experience: 3 years work experience gained from current and previous projects Dashboard and Report Development Design, develop and implement interactive, user-friendly Power BI dashboards and reports. Convert complex business requirements into effective visual representations using advanced Power BI features and custom visuals. Ensure data accuracy and consistency throughout all reports. Data Modeling and Integration Create and maintain robust data models in Power BI Desktop, including relationships, calculated columns and DAX measures. Integrate data from various sources such as relational databases, data warehouses, APIs and flat files into Power BI. Optimize data models to enhance performance, especially for large datasets. Collaboration with Stakeholders Collaborate with business stakeholders, including data analysts, business analysts, and decision-makers, to gather and understand reporting requirements. Partner with IT, Data Warehouse, and other teams to ensure seamless data flow and system integration. Communicating complex technical concepts to non-technical stakeholders effectively. ETL and Data Preparation Design and execute ETL processes using Power Query and other tools to clean, transform and load data into Power BI. Ensure high data quality and consistency throughout the ETL process. Knowledge of or experience with data virtualization technology tools. Performance Optimization Monitor and enhance the performance of Power BI reports and dashboards, ensuring fast load times and efficient query execution. Work with DBAs and other technical teams to optimize database objects (views, tables) and SQL queries. Governance and Security Maintain compliance with data governance and security protocols, including row-level security and access control. Implement data validation and quality checks to ensure data integrity. Training and Best Practices Provide training and mentorship on Power BI best practices, including design, performance optimization and report customization. Stay updated on new Power BI features and incorporate them into projects where appropriate. Troubleshooting and Support Resolve issues related to data refresh, connectivity, and performance in Power BI reports. Offer ongoing support and maintenance for existing dashboards and reports. Innovation and Continuous Improvement Explore advanced analytics features such as machine learning, AI-driven insights and automation in Power BI. JavaScript/ Python: Worked experience gained from current and previous projects 1 year of experience in application code development using scripting languages such as JavaScript, Python, PHP. Three years of experience working with MS SQL databases and MS SQL Server Management Studio. Application Development: Design, develop, evaluate, and maintain applications utilizing modern programming languages (e.g., Python, Java, C#, JavaScript). API Integration: Integrate third-party services, data sources, and AI models into applications through RESTful and SOAP APIs.
Overview
12
12
years of professional experience
1
1
Certification
Work History
SR ETL Informatica Lead Developer
Ucare
05.2025 - Current
- Coordination Between Onsite & Offshore: Daily/weekly sync meetings, maintain documentation (Confluence / SharePoint), Clear handoffs across time zones, Escalation management before issues reach client.
- Offshore Lead Responsibilities (Execution-Focused): Translate business requirements into technical designs, assign tasks, and manage workload distribution, conduct code reviews, and enforce coding standards, monitor productivity and delivery metrics, Mentor junior team members, Ensure performance optimization and best practices, Handle defect triage, and production support coordination.
- Onsite Lead Responsibilities (Client-Facing): Function as primary point of contact for business stakeholders, Gather and clarify requirements, conduct requirement workshops, and design discussions, provide status updates to client leadership, manage escalations and risk communication, Align offshore team with business priorities, Drive change management, and scope control.
- Delivery & Ownership: Lead end-to-end project execution across onsite and offshore teams, Own delivery timelines, quality, and stakeholder expectations, break down requirements into actionable tasks, Track sprint progress and remove blockers, Ensure SLA adherence and milestone commitments.
- Worked on Oracle, Flat files, XML, CSV, PGP files encrypted and decrypted. Experienced on Azure designing maps by Informatica cloud to load information.
- Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
- Used various transformations like Source Qualifier, Joiner, Lookup, SQL, and router, Filter, Expression and Update Strategy.
- Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools. Tuned the Informatica mappings for optimal load performance.
- Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
- Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
- Environment: Informatica Power Center Designer 10.x, Business Objects Data Services 4.0, Informatica Repository Manager, Oracle10g/9i, DB2 6.1, Erwin, TOAD, SAP Version: 3.1.H, Unix-SunOS, PL/SQL, SQL Developer.
Data Engineer/Application SME
Farmers Insurance
12.2021 - 04.2025
- Lead complex ETL requirements and design. Identify, recommend, and implement ETL process and architecture improvements.
- Determine if requirements are right for ETL team to design and build the application. Gathered the information necessary to understand what your project requirements should be.
- Good knowledge of data collection methods, data models, types, and outlines the transformation process.
- Understand concepts of Cloud and good exposure with AWS services and certified in AWS cloud Practitioner.
- Good knowledge of writing shell scripts, Ability to design, test, debug and migrate Informatica code.
- Ability to develop test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance, and scalability.
- Good analytical and critical thinking skills.
- Acts as the primary focal point for both internal and external customers for software development tasks. This includes estimates of feasibility, time, and effort of tasks.
- Provide updates to both the user community and the programmers.
- Mentor and evaluate staff performance - Continues to work hands-on doing programming and analysis work themselves. Tracks all project requests in functional area and updates the status of projects on a regular basis.
- Assists in estimating work effort associated with new project requests. Assists in planning for the development and support of a functional systems area. Participate in planning and budgeting.
- Expert level SQL knowledge on databases such as but not limited to Oracle, SQL Server, MySQL, Teradata
- Worked on the development of IICS mappings, workflows, and tasks, ensuring adherence to design specifications and coding standards.
- Preferably experienced in SLA driven Production Data Pipeline or Quality support.
- Dashboard and Report Development. Design, develop and implement interactive, user-friendly Power BI dashboards and reports. Solve complex data problems to deliver insights that help the organization's business to achieve their goals.
- Create data products for analytics and data scientist team members to improve their productivity. Advise, consult, mentor and coach other data and analytic professionals on data standards and practices.
- Foster a culture of sharing, re-use, design for scale stability, and operational efficiency of data and analytical solutions.
- Lead the evaluation, implementation and deployment of emerging tools and processes for analytic data engineering to improve the organization's productivity as a team.
- Partner with business analysts and solutions architects to develop technical architectures for strategic enterprise projects and initiatives.
- Experience with modern cloud development and design concepts; software development lifecycle; multi-developer code versioning and conflict resolution; planning, design, and problem resolution enterprise data applications / solutions.
- Monitoring tools like AppDynamics, Dynatrace, Splunk, AWS Cloud Watch, Service now, and experienced in automating deployments and working in an Agile/Scrum environment.
- Proficiency in using JIRA, GitHub, Confluence, production support, and vulnerabilities management.
- Knowledge and hands on experience in building metadata driven data pipelines using Azure Data Factory, Databricks / Spark for Cloud Data Lake. Good Knowledge on experience with using one or more of the following for data analysis and wrangling Databricks, Python / PySpark, Jupyter Notebooks.
Sr. Informatica developer/Technology Lead
Cognizant / JPMC
12.2020 - 12.2021
- Experience in Data Management/ data warehouse. Knowledge and understanding the concepts of developing and designing ETL methodology for supporting data transformations using Ab Initio and/or Informatica/ JAVA/Spark/ Big Data Technology
- Experience in Logging, Monitoring and Automation tools. Experience with Batch Scheduling tools such as Control-M. Experience with Linux platforms, Unix Scripting.
- Ability to multi-task /change focus quickly and collaborator.
- I have experience with tools including TOAD, SQL Developer and SQL Loader and working in an agile development model. Informatica PowerCenter, Oracle, SQL, PL/SQL, PowerShell, and Unix.
- Experience with Informatica PowerCenter 9.x or higher large Data Warehouse and managing high data volumes. Experience with SQL/Stored Procedures on Oracle database.
- Advanced knowledge of application, data, and infrastructure architecture disciplines. Understanding of architecture and design across all systems
- Working proficiency in developmental toolsets. Knowledge of industry-wide technology trends and best practices. Ability to work in large, collaborative teams to achieve organizational goals.
- Enthusiastic about building an innovative culture. Understanding of software skills such as business analysis, development, maintenance, and software improvement
- Design, develop, and deploy BI solutions, including dashboards, reports, and data visualizations using tools such as Power BI, Tableau, or similar platforms. Create and maintain data models, KPIs, and metrics to meet business needs.
- Create and maintain robust data models in Power BI Desktop, including relationships, calculated columns, and DAX measures.
- Integrate data from various sources such as relational databases, data warehouses, APIs and flat files into Power BI.
Informatica Developer
Oakbrook, IL
03.2019 - 11.2019
- Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
- Work with the DBA for requirements gathering, business analysis and designing of the data warehouse.
- Create Logical and Physical models for Staging, Transition and Production Warehouses using Erwin 4.0.
- Use Repository manager to create user groups and users and manage users by setting up their privileges and profile.
- Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length, and target-based commit interval.
- Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
- Maintained source and target mappings, transformation logic, and processes to reflect the changing business environment over time.
- Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
- Led design meetings focused on developing projects that mapped sources to targets. Generated process flow designs
- Converted the PL/SQL Procedures to Informatica mappings and at the same time created procedures in the database level for optimum performance of the mappings.
- Investigating and fixing the bugs that occurred in the production environment and providing on- call support.
- Environment: Informatica Power Center 9.6.1, Informatica B2B Data Exchange, Pentaho, Unix, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Data Analyzer 8.1, PL/SQL, Oracle 10g/9i, Erwin, Autosys, SQL Server 2005, Sybase, UNIX AIX, Toad 9.0, Cognos 8.
Data Analyst/ Informatica Developer
Maximus, Austin, TX
08.2016 - 02.2019
- Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
- Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in an efficient manner.
- Converted Stored Procedures into Informatica, having knowledge in understanding views, indexes, parameters, variables, and Synonyms.
- Communicated with management, business resources, client resources, and staff to ensure effective development and deployment of requested changes, on time and delivered.
- Used sorter transformation and newly changed dynamic lookup. Developed Informatica mappings and tuned them for better performance with PL/SQL Procedures/Functions to build business rules to load data.
- Worked with oracle CDC with Power Exchange and Oracle, SQL Server, CSV files as source system. Worked extensively on Power Center Designer, Workflow Manager, and Workflow Monitor creating mapplets, mappings, tasks, reusable tasks, and workflows.
- Have valuable experience in Creation of parameter files, mapping variables, parameters and Scheduling jobs and implemented High Availability.
- Having good knowledge in understanding UNIX work environment, file transfers, job scheduling and error handling. Involved in Unit, Integration, System, and Performance testing levels. Used PL/SQL with Informatica Power Center 9.6 for Oracle databases.
- Developed mapping using Informatica Power Center Designer to normal load data from Oracle and Flat file source system to target database.
- Configuring domains, adding repositories, communicating with Informatica environment team and DataMart team. Setting ODBC Connection for different environments and databases.
- Debugging the errors in session log, testing the code, fixing the Production issues, and involved in Data migration, data Integration, and deployments. Testing the code in PL/SQL, involved in Performance tuning in oracle and in Informatica.
- Environment: Informatica Power Center 9.6.1, Workflow Manager, Workflow Monitor, Informatica Power Connect /Power Exchange, Informatica B2B Data Exchange, Pentaho, Data Analyzer 8.1, PL/SQL, Oracle 11g/9i, SQL Server, SQL developer, Unix.
Informatica Developer
Veteran Affairs, Hines, IL
10.2014 - 03.2016
- Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
- Parsed high-level design specification to simple ETL coding and mapping standards.
- Designed and customized data models for Data warehouse supporting data from multiple sources in real time.
- Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
- Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
- Designing and developing the ETL framework and processes using Informatica 8.6.0, to run on the Domain, Integration Services and Nodes, on a Highly Available Grid ETL Infrastructure.
- Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
- Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
- Developed mapping parameters and variables to support SQL override.
- Experienced in scheduling Sequence and parallel jobs on Autosys Production and Lower environments using UNIX Perl scripts.
- Understanding web application based on J2EE Struts framework.
- Developed mappings to load into staging tables and then to Dimensions and Facts.
- Used existing ETL standards to develop these mappings.
- Worked on Informatica B2B Data Exchange that allows supporting the expanding diversity of customers and partners.
- Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, Assignment, Timer and scheduling of the workflow.
- Extensively used SQL
- Loader to load data from flat files to the database tables in Oracle.
- Involved in Performance tuning at source, target, mappings, sessions, and system levels.
- Two years’ experience in configuring and testing Hadoop ecosystem components.
- Environment: Informatica Power Center 8.6.1, OBIEE 11g, Workflow Manager, Workflow Monitor, Informatica Power Connect /Power Exchange, Informatica B2B Data Exchange, Business Objects Data Services 4.0, Data Analyzer 8.1, PL/SQL, Oracle 10g/9i, Erwin, Autosys, SQL Server 2005, Teradata.
Education
Masters - computers applications
Osmania University
Hyderabad, IndiaSkills
- Power Center/IICS/ILM
- ETL Informatica Development
- Data management
- Microsoft Power BI on Azure/Copilot
- ETL Development
- Data Management
- UNIX/LINUX
- PLSQL
- MS SQL Server/Python/Java Script
- Informatica Master Data Management
- Informatica Data Services
Accomplishments
- Performance Tuning: Played a key role in the development and enhancement of the Informatica application, improving its performance by 30%.
- Team Leadership: Successfully led a team, effectively able to deliver projects on time and within budget.
- Problem Resolution: Successfully troubleshooted and resolved complex data issues, enhancing the overall efficiency of the data management process.
Certification
- AWS CLOUD CERTIFICATION
- SAFe SCRUM AGILE CERTIFICATION
- IICS
Timeline
SR ETL Informatica Lead Developer
Ucare
05.2025 - Current
Data Engineer/Application SME
Farmers Insurance
12.2021 - 04.2025
Sr. Informatica developer/Technology Lead
Cognizant / JPMC
12.2020 - 12.2021
Informatica Developer
Oakbrook, IL
03.2019 - 11.2019
Data Analyst/ Informatica Developer
Maximus, Austin, TX
08.2016 - 02.2019
Informatica Developer
Veteran Affairs, Hines, IL
10.2014 - 03.2016
Masters - computers applications
Osmania University
Training
TRAINING AND HANDS ON EXPERIENCE.