KARTHEEK ALLA kartheekalla93@gmail.

com
Sr Informatica Developer +1 205 316 9894

SUMMARY:
 Over 6+ years of experience in the field of Information Technology with good hands on
experience with ETL Informatica administration/design/development/mapping and Data
Warehouse Implementation and development and ICDI.
 Expertise in designing and Developing complex Mappings using Informatica Power Center
Transformations -Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored
Procedure, Sorter, Sequence Generator and Slowly Changing Dimensions.
 Experience in Analyzing designs and architectural implementation of data marts on Teradata
Database and develop the ETL mappings. Source Data included files from Oracle, SQL Server and
Flat Files
 Hands on experience with Creating folders, Groups, Roles, Users in Admin console and
granting them permissions.
 Good experience with change management, deploying code from DEV to TEST and PROD –
using deployment groups in Informatica Repository manager.
 Excellent knowledge and experience in data warehouse development life cycle, requirement
analysis, dimensional modeling, Repository management and administration.
 Knowledge about Software Development Lifecycle (SDLC), Agile.
 Expertise on Informatica client tools Admin Console, Developer tools, Mapping Designer,
Workflow Manager, Repository Manager and Workflow Monitor. Experienced in overall Data
Warehouse, Database, ETL and performance tuning.
 Expertise as Informatica Administrator to setup new Informatica environments and Upgrade
existing Informatica environments to new versions.
 Expertise in installing, configuring and maintaining Informatica PowerCenter (9.x & 10.x)
versions.
 Experience with Metadata Manager, Business Glossary, IDQ, and Data Analyst.
 Experience with data load performance tuning in Informatica
 Understanding and Working knowledge of InformaticaCDC (Change Data Capture)
 Quick understanding of Relational Source Database Systems and data models for building
accurate transformation logic that can be used in Data Migration and Data Integration.
 Working experience in using Informatica Workflow Manager to create Sessions, Batches and
schedule workflows and Worklets, developing complex Mapplets, Worklets, Re-usable Tasks, Re-
usable Mappings, Define Workflows &Tasks, Monitoring Sessions, Export & Import Mappings &
Workflows, Backup & Recovery, Power Exchange.
 Pertinent experience using heterogeneous databases such as Oracle 9i/10g/11g, DB2/UDB, MS
SQL Server 2012/2008, XML and various Flat File (Structured/Unstructured) systems for
integration into Enterprise/Business Analysis DWH.
 In-depth knowledge and understanding of dimensional modeling (Star schema and Snowflake
schema, SCD types- 1, 2, 3), and data modeling (star schema) at logical and physical level.
 Experience in writing shell scripting for various ETL needs.
 Proficient in applying performance tuning concepts to Informatica Mappings, Session properties,
and database.
 Well exposed and worked closely with testing teams in performance unit testing, user
acceptance testing and system integration testing.
 Used AutoSys for automatic job management, event driven scheduling and programmable error
recovery.
 Expertise in working with Linux shell scripts.
  Support the Testers, Deployers and KT to the Team about the best Practices.
 Exclusively worked on different flavors of UNIX and Windows operating systems and good
Experience in UNIX shell scripting.
 Team player with good interpersonal and problem-solving skills, ability to work in team and also
work individually.
 Participated in 24x7 on-call rotation, off-hour production problem resolution activities
 A self-motivated, responsible and reliable team player with a set of strong technical skills.
 Enthusiasm in learning new technologies.

TECHNICAL SKILLS:
ETL Tools Informatica Power Center 10.1/9.6.1/9.1/8.x, IICS, Data Analyst, Metadata
Manager, IDQ, IDD, Informatica MDM HUB 9.1/ 9.7/10.2.

Dimensional Data Star Schema Modeling, Snow-Flake Schema Modeling, Fact and Dimension
Modeling Tables, Logical and Physical Data Modeling.

Languages C, C++, Java, VB, PHP, XSLT, XML, SQL, PL/SQL, UNIX Shell Scripting

RDBMS Oracle 12c/11g/10g/, SQL Server 2012/2008/2005, DB2 10.1/9.7 FP1, Sybase
15.x.

Operating Systems HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3, 5.4, Red Hat Linux
6.x/5.x, MS SQL Server, Windows 98/ME/NT/2000/XP

PROFESSIONAL EXPERIENCE:
Project Name – Project Levi Backbook Conversion Feb 2023- Present
Client: Santander Consumer USA – Dallas, TX
Sr Informatica Developer

Responsibilities:
 Understanding business requirements and converting them into technical specifications and
reverse engineering the existing systems or processes for documenting.
 Upgrading Informatica MDM from 9.1,9.7 to 10.2 HF2.
 Configuring security access manager, resource loading and monitoring operations of MDM HUB.
 Creating users and setting profiles to users and assigning roles to those profiles.
 Implementing Informatica MDM platform staging (Validation Rules/Mappings for
cleansing/standardization) to directly loading source data to MDM staging tables by passing
landing tables.
 Designing and configuring Informatica Data Director for management of MDM data.
 Configured batch jobs using batch group utility.
 Implementing Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and
Automation Processes.
 Designing MDM data model and created base objects, mappings, defined trust setting for sources,
customized user exists, customized IDD applications.
 Working on Data cleansing and Standardization using cleanse functions in Informatica MDM.
 Defining the Trust and Validation rules and setting up the match/merge rule sets to get the right
master records.
  Creating queries and packages in the Master Data Management HUB Console
 Developing ETL to create an Enterprise Data Store as L3. Implemented SCD type 2.
 Converting Oracle PL/SQL logic into Power Center mappings.
 Writing PL/SQL scripts, indexes, and complex queries for data analysis and extraction
 Creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter,
Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica
Designer and processing tasks using Workflow Manager to move data from multiple sources into
targets.
 Developing store procedures, configuration files, tables, views, and functions; implement best
practices to maintain optimal performance
 Developing source to target mappings and scheduling Informatica sessions
 Performance tuning of mapping and sessions by optimizing source, target bottlenecks and
implementing pipeline partitioning.

Environment: Informatica Power Center 10.4.1, Informatica MDM 10.2, IDD, Oracle 11g, 12c,
Toad, SQL Developer, Windows XP, UNIX/Linux, DB2, MS SQL Server, AWS, Java.

Project Name - Lotus & Ienos Feb 2022- Jan 2023

Client: Santander Consumer Dallas Tx
Sr Informatica Developer

Responsibilities:
 Understanding business requirements and converting them into technical specifications and
reverse engineering the existing systems or processes for documenting.
 Upgrading Informatica MDM from 9.1,9.7 to 10.2 HF2.
 Configuring security access manager, resource loading and monitoring operations of MDM HUB.
 Creating users and setting profiles to users and assigning roles to those profiles.
 Implementing Informatica MDM platform staging (Validation Rules/Mappings for
cleansing/standardization) to directly loading source data to MDM staging tables by passing
landing tables.
 Designing and configuring Informatica Data Director for management of MDM data.
 Configured batch jobs using batch group utility.
 Implementing Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and
Automation Processes.
 Designing MDM data model and created base objects, mappings, defined trust setting for sources,
customized user exists, customized IDD applications.
 Working on Data cleansing and Standardization using cleanse functions in Informatica MDM.
 Defining the Trust and Validation rules and setting up the match/merge rule sets to get the right
master records.
 Creating queries and packages in the Master Data Management HUB Console
 Developing ETL to create an Enterprise Data Store as L3. Implemented SCD type 2.
 Converting Oracle PL/SQL logic into Power Center mappings.
 Writing PL/SQL scripts, indexes, and complex queries for data analysis and extraction
 Creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter,
Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica
Designer and processing tasks using Workflow Manager to move data from multiple sources into
targets.
 Developing store procedures, configuration files, tables, views, and functions; implement best
practices to maintain optimal performance
 Developing source to target mappings and scheduling Informatica sessions
  Performance tuning of mapping and sessions by optimizing source, target bottlenecks and
implementing pipeline partitioning.

Environment: Informatica Power Center 10.4.1, Informatica MDM 10.2, IDD, Oracle 11g, 12c,
Toad, SQL Developer, Windows XP, UNIX/Linux, DB2, MS SQL Server, AWS, Java.

Client: Santander Consumer USA – Dallas, TX Mar2021 –Jan 2022

Project Name–Core Accounting
Informatica ETL Developer

Responsibilities:
 Installed/Upgraded Informatica products 9.6.1 HF3 to 10.2
 Configured Informatica Services for Power Center, Data Quality (IDQ), Data Profiling
 Configured Enterprise Grid clustering and High Availability
 Worked on Security management, creating Groups, Users and Folders
 Created shell scripts for file cleanup and archival
 Involved in code reviews and migrations from DEV -> TEST -> PROD
 Worked on capacity planning and performance tuning
 Worked on Root Cause Analysis for Production down time
 Implemented Disaster Recovery, Backup and Restore strategy
 Worked on monthly scheduled maintenance
 Created Shell scripts to automate code deployment, monitoring, backups and cleanup
 Worked with different teams on any POC for new implementations
 Support for Informatica environment Maintenance
 Configured Reporting and Dashboard services for Power Center, Metadata Manager and Model
Repository (Data Quality)
 Worked with project teams for reviewing their design and provide support to any development issues
 Did performance review for any long running workflows

Environment: Informatica PowerCenter 10.2/9.6.1, Power Exchange, Metadata Manager,

IDQ, Oracle12c, Toad, SQL Developer, Windows XP, UNIX/Linux, DB2 9.7, SQL Server 2012

Project Name–Project Levi Aug 2018- Feb2021.

Client: Santander Consumer USA – Dallas, TX

Responsibilities:
 Extracted data from flat files and oracle database, applied business logic to load them in the
Operational Data Store.
 Performed Extraction, Transformation and Loading (ETL) operations.
 Worked extensively with complex mappings using expressions, aggregators, filters, lookups to
develop and feed to the Data Warehouse.
 Created reusable transformations and Mapplets and used them in the mappings
 Implemented error handling in ETL mappings.
 Good hands-on experience in writing SQL queries.
 Involved in Unit, System & Integration Testing of Mappings & Sessions.
 Preparing unit test cases
 Experience in Unix with the help of Putty tool.
 Used Informatica Designer to create, Load, Update mappings using different transformations to
move data to Data Warehouse
  Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and
Lookup, Update strategy and Sequence generator
 Environment: INFORMATICA POWERCENTER 9.x & 10.1.1, Oracle 11g, UNIX, Control-M Scheduler
and Excel reporting. Developing ETL to create an Enterprise Data Store as L3. Implemented SCD
type 2.
 Converting Oracle PL/SQL logic into Power Center mappings.
 Writing PL/SQL scripts, indexes, and complex queries for data analysis and extraction
 Creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter,
Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica
Designer and processing tasks using Workflow Manager to move data from multiple sources into
targets.
 Developing store procedures, configuration files, tables, views, and functions; implement best
practices to maintain optimal performance
 Developing source to target mappings and scheduling Informatica sessions
 Performance tuning of mapping and sessions by optimizing source, target bottlenecks and
implementing pipeline partitioning.
 Monitoring loads which include loading daily and weekly data into data warehouse.
 Automated loads using schedulers.
 Give support to admin team while adding objects to deployment groups.

Environment: Informatica PowerCenter 10.2/9.6.1, Power Exchange, Control-M Scheduler and

Excel reporting, Oracle12c, Toad, SQL Developer, Windows XP, UNIX/Linux, DB2 9.7, SQL Server
2012

Project Name – Project Genysis May2017- July2018.

Client: Santander Consumer USA – Dallas, TX

Responsibilities:
 Monitored Jobs in Informatica Monitor and find the error cause.
 Monitored Jobs in UNIX environment and fixed job failures.
 Supported the Application Daily Activities like Monitoring jobs and
 Interacted with the client on daily basis to gather requirements on automation related activities.
 Resolved all queries and provided alternative measures to overcome any hurdles faced during
project execution.
 I have worked in operations support of P&G account in analysing data and solving issues occurred
in the data warehouse proactively and stabilize the data for downstream reports and analysis.

Environment: Informatica PowerCenter 10.2/9.6.1, Power Exchange, Control-M Scheduler and

Excel reporting, Oracle12c, Toad, SQL Developer, Windows XP, UNIX/Linux, DB2 9.7, SQL Server
2012

EDUCATIONAL SUMMARY:
Masters of science in Information technology Management, Campbellsville University, USA, 2017