Sign in

Data Manager

Jersey City, New Jersey, United States
January 31, 2017

Contact this candidate


Mobile: 925-***-****

LinkedIn profile --

Visa status --EAD


Five years of IT experience in Information Technology as software engineer performing analysis, design and development of various applications in client-server environment. Good experience in providing Business Intelligence solutions in Data Warehousing for decision support systems and OLAP application developments.

Expertise in Analysis, Design and Development of Data warehousing solutions and developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Power Center Informatica.

Actively involved in design meeting with clients, provided various technical solutions in end-to-end implementation.

Well versed with SDLC phases like planning, analysis, design, implementation and maintenance.

Strong knowledge on Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema.

Good exposure to loading and maintaining Data Warehouses in Teradata and Oracle. Experience with Unix shell scripting and basics of PL/SQL programming. Good understanding of tools MLoad, BTEQ, FastExport and FastLoad to design and develop dataflow paths for loading transforming and maintaining data warehouse in Teradata.

Experienced in Full life cycle of Data warehousing involving all stages of SDLC using Informatica Power Center (8x/9x).

Highly experienced in ETL tool Informatica in using Mapping Designer, Workflow Manager and Monitor. Expertise and well versed with various transformations like Experssion, filter, sorter, aggregator, Lookup, Normalizer, Joiner, Union and Update Strategy etc.

User Acceptance Tests (UAT) for various application and reports on a daily/weekly or monthly basis along with preparation of Ad-hoc reports.

Coordinating with testing team for System Integration (SIT) and Regression testing.

Used various Performance Tuning techniques to improve the overall performance.

Strong Technical and Analytical skills and a quick learner and excellent team player.

Excellent knowledge on using MS office tools and utilities.

Excellent written and oral communication, interpersonal and presentation skills.


Bachelors of Technology in Computer Science and Engineering, graduated with 78% from JNTU University.

Trained on Data warehouse concepts from TATA Consultancy Services.

Trained on Power center Informatica and Relational Databases form TATA Consultancy Services.


ETL Tools

Informatica 8x/9x


Oracle 11g and Teradata

Operating System

Linux, Windows 98/NT/2000/XP

Scripting Languages

Unix Shell Scripting

Internet Technologies


Data Extraction Tools

Oracle SQL Developer, Teradata SQL Assist.

Scheduling Tools

Autosys and related scheduling tools.


Citi Bank - Irving, TX

Project : Customer Profile Project

Duration : Aug - 2014 to Dec 2016

Role : Informatica ETL Developer

Project Overview:

The purpose of the Customer Profile project is to capture and provide basic customer information and customer attributes for use in email and online marketing campaigns. Customer profiles will be comprised of customer contact information plus customer attributes such as purchase history, product and brand affinity, response to promotions, and online activity. This information will facilitate marketing outreach efforts such as event triggered email campaigns and targeted online marketing. It will include data enhancements to the CDW for customer returns, promo codes, and Ecommerce product catalog which are needed for customer profiles.


Involved in the requirement analysis and outlining the changes on the technical front.

Documented and translated user requirements into system solutions.

Extracted the data from Files, Oracle and Teradata into Data warehouse.

Used Informatica Designer to create complex mappings using different transformations to move data to a Data Warehouse

Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Look up, Aggregator, Stored Procedure, Update Strategy, Joiner, Filter.

Scheduling the sessions to extract, transform and load data into warehouse database on Business requirements.

Loaded the flat files data using Informatica to data warehouse

Setting up Batches and sessions to schedule the loads at required frequency using Power Center server Manager.

Handled common data warehousing problems like tracking dimension change using SCD type2 mapping.

Used e-mail task for on success and on-failure notification.

Used decision task for running different tasks in the same workflow.

Assisted team member with their various Informatica needs.

Developed and maintained technical documentation regarding the extract, transformation and load process.

Responsible for the development of system test plans, test case creation, monitoring progress of specific testing activities against plan, and successfully completing testing activities within the requisite project timeframes.

Citi Bank - Irving, TX

Project : Feed Controls Implementation

Duration : Dec- 2013 to Jul - 2014

Role : Informatica ETL Developer

Project Overview:

Our team is currently building the data marts to store data from front / back office feeds. I am currently designing the process to load feeds and creating the control dash board framework to capture and report the statistics of the load process (Staging through normalization). The control dash board is used by the users to identify the run statistics at each stage of the load process. The users will be able to identify the data errors at each and every phase at very granular level.


Designing and creating the stage load and enhancing normalization process with error handling and control dashboard maintenance for all the front and back office feeds.

Designing and implementing error data mart in star schema model to report errors at granular level.

Designing/implementing the control board dashboard to capture and report input errors at field level.

Created Informatica Mappings to load data from flat files, oracle and Sybase. Use of transformations like Stored procedure transformation, Connected and Unconnected lookups, Source Qualifier, Expression, Sorter, Aggregator, Joiner, Filters, Sequence, Router, Normalizer, rank and Update Strategy transformations.

Worked with Variables, Parameters, Parameter files and File list on Informatica.

Extensively used Stored Procedures, Functions and Packages using PL/SQL for creating Connected and Unconnected Stored Procedure Transformations.

Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.

Weekly status meeting with the client to communicate the development progress and any issues arising during Design, Development and Testing phases.

Environment: Informatica Power Center, Oracle 11g, SQL, PL/SQL and UNIX shell scripting.

Citi Bank – Mexico

Project : Support and Maintenance

Duration : Jun - 2012 to Nov - 2013

Role : Entry Level ETL Developer

Project Overview:

Designed and built complex ETL mappings using Informatica which load the Data warehouse with data received from different sources. The program’s main aim was to calculate the Waiver Amount for the BANAMEX accounts based on some prerequisites.

The generic design solution for this architecture was accomplished by loading source systems information to oracle tables using business rules/ETL logic. ETL Development involved creation/ modification of existing Informatica mappings. After pre-processing, the input source feeds gets processed one after another as determined based on the business rules. Primary key constraints and integrity constraints are created as needed. Data Transformation involved validation of the fields, trimming of fields (removing spaces), formatting data, removing the duplicates using Sort Component and calculating the Waiver Amount. After the calculation is done the file is transferred to another system for getting the approval. Once the approval process is completed the data in the response file which is sent by the approval team is loaded to the EDW table.


Involved in Onsite-Offshore coordination model in designing and developing the ETL systems

Performed Data profiling, creation of informatica mappings and related DB modules

Application of complex business rules into informatica using components like Lookup, joiner etc.,

Involved in all phases of testing life cycle which include unit testing, system integration testing and user acceptance testing.

Performance enhancing the existing/new features of application.

Creation of Automation jobs using Autosys scheduler.


A quick learner who enjoys learning new things.

Dedicated and passionate towards work.

Contact this candidate