Blagspot Jobs
Excellent job opportunities for freshers and Professionals in top companies. IT jobs, BPO & call center jobs, engineering jobs, sales & marketing jobs
ETL experience using Informatica 9.6/9.1/8.6 Power Center client tool
summary:
Ø 11+ years of
experience IT Industry in various areas like Application Development,
Enhancement, Maintenance and Support, Application Management & Implementation
Ø Strong data
warehousing ETL experience using Informatica 9.6/9.1/8.6 Power Center client
tool.
Ø Extensively worked on
Informatica PowerCenter Transformations such as Source Qualifier, Lookup,
Filter, Expression, Router, Normalize, Joiner, Update Strategy, Rank,
Aggregator, Stored Procedure, Sorter, Sequence Generator, XML Transformations.
Ø Worked with different
data sources such as Oracle,SQL Server,DB2,SAP,Flat files,HDFS
Ø Having good
experience in writing UNIX script, AUTOSYS JILs.
Ø Experience in project
estimation and onsite, offshore team management.
Ø Strong experience in
the analysis, design, development, testing and implementation of Business
Intelligence solutions using Data Warehouse.
Ø Experienced in
performance tuning of mappings, sessions and workflows including partitioning.
Ø Involved in full life
cycle development of Data Warehousing.
Ø Excellent understanding
of Star Schema, Snowflake modeling. Fact, Lookup and Dimensions Tables.
Ø Excellent skills in
understanding business needs and converting them into technical solutions.
Ø Good exposure in Informatica
MDM.
Ø Exposure on Hadoop
ecosystems, HDFS, Big Data, HIVE, MR, SQOOP and RDBMS.
Ø Extensive experience
in developing Stored Procedures, Functions, Views and Triggers, Complex SQL
queries using SQL Server and Oracle PL/SQL.
Ø Good exposure in
project estimation, preparing BRD, FRD, Technical specs, project documentation.
Ø Very good domain
experience in Banking AML applications, Healthcare and Aviation Domains.
Ø Good experience in
handling AML/FRAUD applications like ACTIMIZE, CASE MANAGEMENT tools, etc.
Ø Good exposure in
handling vendors in multiple projects with cross platform technologies like
Informatica, MS.NET, OBIEE, UNIX, Mainframe-DB2 etc.
Ø Good experience in
Job scheduling tools like CA7, Autosys, Tivoli.
Ø Good experience in
ITIL Process.
Ø Good experience in
change management, incident management and problem management methodologies and
also part of CAB team defining the process as per ITIL methodologies.
Ø Good experience in
defining the new process as per business requirement to support the
applications.
Academic Profile:
ü
Master of Computer
Appllications (M.C.A)
ü
Bachelor of Science
(Mathematics,Physics,Chemistry)
Certifications:
ü
ITIL
Technical
Summary:
DW
Tools: Informatica
Power Centre 7x and 8x, 9x, OBIEE
DataModeling
Tools: ERWin, TOAD Data
Modler
BigData: Hadoop,
HIVE, SQOOP, MR
RDBMS: Oracle,
DB2, SQL Server, Ms-Access
Programming
Languages: C#.NET,
UNIX Shell Script, Batch Script
Scheduling
Tools: CA7,
AUTOSYS, TIVOLI
Operating
Systems: Windows
NT/2000/XP, MS-DOS, UNIX
Tools
& Utilities: PUTTY, VSS, Service Center 6.2, SM9, HPSA, Service
Now
Web
Related: ASP.Net,
HTML, XML
Server: WAS,
IIS, MOSS
Employment
History:
Freddie Mac, Mc Lean,VA Jul 2015 – Present
ETL Sr Developer
Project Name: UPR
Ø Team Size: 8
Ø Environment: Informatica-9.6,
UNIX,AUTOSY,ORACLE,SQL SERVER-2008,FlatFiles,DB2
Responsibilities:
Ø Involved in analysis,
LLD, HLD and documentation of mapping specs as per business rules.
Ø Creating inforamatica
mappings as per business requirements.
Ø developing SCD type 2, type 1 mappings using informatica.
Ø Prepare test strategy
and Test Directories
Ø Developed UNIX
scripts to handle source files.
Ø Developed AUTOSYS JIL
scripts to manage informatica workflow jobs
Ø Performed UNIT
Testing on developed mappings
Ø Extensively used CDC
on real time data.
Ø Extensively used Sql
server Database from source and target.
Ø Participate in review
of test document for the end-to-end testing
Ø Prepare project
status reports for the work carried out
Ø Collect and reporting
metrics on end-to-end testing.
Ø Involved in low-level
design and developed various jobs and performed data loads and transformations
using different transformation of INFORMATICA.
Ø Experienced in ETL auditing
process.
Ø Used most of the
transformations such as Source Qualifier, Filter, Joiner, Sequence Generator,
Expression, Aggregator, Connected & Dynamic Lookup, Rank, Router, and
Update Strategy, SQL Transformation, etc.
Ø Scheduled the
Informatica Workflows as per user requirement by using AUTOSYS scheduling tool.
Ø Performance tuning
has been done to increase the through put for both mapping and session level
and SQL Queries Optimization as well.
Ø Experienced in
deploying the code into releasing folder and placing it into Build and
troubleshooting the build issues.
Ø Involved in unit
testing to test the processed data and user acceptance testing.
Ø Experienced in
troubleshooting and fix the different Development/Production environment
issues.
Ø Involved in
environment creation of metadata manager.
Ø Involved in recycle
Repository, integration services and creation of automated scripts for
deployment using pmrep command.
Ø Involved in Workflow,
Mapping deployment by using deployment group from Dev to UAT and UAT to Quality
and production Repositories.
Ø Experienced in
writing Uniting Test Cases with multiple scenarios.
Citi Bank, SINGAPORE October 2014 – Jul,2015
ETL Technical Lead - AML Compliance
Project Name: ATHENA-G2
Ø Team Size: 14
Ø Environment: Informatica-9.6, OBIEE, Oracle11g, ERWin, TOAD Data
Modeler, UNIX, Mainframe-DB2, MS.Net, WAS, HIVE,SQOOP,HDFS ,AUTOSYS
Responsibilities:
Ø Involved in analysis,
LLD, HLD and documentation of mapping specs as per business rules.
Ø Involve in
understanding test requirements
Ø Prepare test strategy
and Test Directories
Ø Participate in test
case development and execution
Ø Participate in test
results document preparation for the project
Ø Participate in bug
reporting and tracking for the project
Ø Performed ETL data
loading into OBIEE Environment.
Ø Loading the data into
HIVE
Ø Extensively used CDC
on real time data.
Ø Extensively used Sql
server Database from source and target.
Ø Participate in review
of test document for the end-to-end testing
Ø Prepare project
status reports for the work carried out
Ø Collect and reporting
metrics on end-to-end testing.
Ø Involved in low-level
design and developed various jobs and performed data loads and transformations
using different transformation of INFORMATICA.
Ø Developed AUTOSYS JIL
scripts to manage informatica workflow jobs
Ø Experienced in ETL
auditing process.
Ø Used most of the
transformations such as Source Qualifier, Filter, Joiner, Sequence Generator, Expression,
Aggregator, Connected & Dynamic Lookup, Rank, Router, and Update Strategy,
SQL Transformation, etc.
Ø Scheduled the
Informatica Workflows as per user requirement by using AUTOSYS scheduling tool.
Ø Performance tuning
has been done to increase the through put for both mapping and session level
and SQL Queries Optimization as well.
Ø Experienced in
deploying the code into releasing folder and placing it into Build and
troubleshooting the build issues.
Ø Involved in unit
testing to test the processed data and user acceptance testing.
Ø Experienced in
troubleshooting and fix the different Development/Production environment
issues.
Ø Involved in
environment creation of metadata manager.
Ø Involved in recycle
Repository, integration services and creation of automated scripts for
deployment using pmrep command.
Ø Involved in Workflow,
Mapping deployment by using deployment group from Dev to UAT and UAT to Quality
and production Repositories.
Ø Experienced in
writing Uniting Test Cases with multiple scenarios.
Royal Bank of Scotland, (BLR-IND) May 2011 – August 2014
Sr. Analyst - Application Management
Project Name :GAML (GLOBAL
Anti-Money Laundering)
Ø Team Size: 10
Ø Environment:
Informatica-9.1,Hadoop-hiave,sqoop,Oracle11g,UNIX,DB2,OBIEE 11g, ERWin
Responsibilities:
Ø Involved in gathering
and analyzing requirements, prepared Technical Design document and Source
–Target Mapping docs and presented to BU team to finalize and get sign off
Ø Worked on project
plan to define the efforts and estimations tasks.
Ø Designed and
Developed the Batch and Incremental ETL process i.e., Mappings &Mapplets
using various Transformations and Workflows with Sessions / Tasks.
Ø Worked as a Senior
ETL Lead for onsite/offshore model and leading a team
Ø Participate in test
results document preparation for the project
Ø Participate in bug
reporting and tracking for the project
Ø Technical consultant
for the team to provide optimal solutions, design reviews, code reviews and for
any issues
Ø Provided inputs to
Project Stakeholders and Data Architects to accomplish the design of the
project
Ø Conducted design and
review meetings to get design approval from different stake holders in the
project
Ø Involved in planning,
effort tracking and estimations for the project
Ø Extensively used Sql
server Database from source and target.
Ø Participate in review
of test document for the end-to-end testing
Ø Prepare project
status reports for the work carried out
Ø Collect and reporting
metrics on end-to-end testing.
Ø Scheduled the
Informatica Workflows using CA7 scheduler tool
Ø Performance tuning
has been done to increase the through put for both mapping and session level
and SQL Queries Optimization as well.
Ø Experienced in
deploying the code into releasing folder and placing it into Build and troubleshooting
the build issues.
Project Name: GACM (Global Alert Case Management)
Ø Team Size: 6
Ø Environment: Informatica8.6,OBIEE,MS.NET, DB2, Oracle10g,
UNIX, Detica Front end
Project Description: GACM
is RBS Group Alert Case Management system to generate the alerts based
on the fraud cases, multiple cases can be grouped as single alert and send it
to alert management team to go through the cases based on the alerts.
Responsibilities:
Ø Requirement gathering
for enhancements.
Ø Review HLD & LLD
documents based on business requirements.
Ø Supported AML
investigation requirements.
Ø Conducted monitoring
of AML exception reports.
Ø Developing mappings,
workflows as per the requirement.
Ø Handling High
priority and criticality incidents.
Ø Handling work
requests and project requests.
Ø Provided backup
liaison with business and IT.
Ø Understanding the
functionality of the application from the business prospective.
Ø Monitoring and
maintaining the scheduled jobs.
Ø Providing 24x7
support.
Ø Resolving the issues
within the SLA time to avoid business loss.
Ø Managing critical
recovery call.
GE-Aviation, (MAHINDRA SATYAM,HYD-IND) April 2010 – May 2011
Informatica
– Team member
Project Name :GAMS
Ø Team Size: 8
Ø Environment: Informatica Power Center 8.6, SAP-ABAP, SQL,
Oracle9i, UNIX, TOAD, PUTTY, EDIT PLUS, HPSD 4.5
Project Description: GAMS-Finance Interface will create the
invoices by extracting the data from SAP and load it to SAP on monthly, weekly,
daily basis. It has two scenarios: a. Outbound b. Inbound. Outbound: In outbound SAP is the source and
the Informatica will extract the SAP data by using Interpreter transformation
and load it into flat file or Oracle tables.
Inbound: In Inbound source is either flat file or Oracle tables,
Informatica will Extract the files and load it into SAP target by using
preparer transformation. All the
invoices will be created and generated based on the batch number; it will be
handled by UNIX scripts.
Responsibilities:
Ø Understanding the
Business rules completely and implemented data transformation methodologies,
Involved in designing the E.T.L mapping documents.
Ø Involved in the
mapping with a slowly changing dimension Type2 to keep track of historical
data.
Ø Involved in
developing Mapplets, Mappings and Transformations as per the requirements.
Ø Extracting data from
different relational databases, Flat files using Informatica Power Center.
Ø Analyzing the issues
and resolve with the scheduled time to avoid SLC.
Ø Creating Various
Transformations like Interpreter, Preparer, Expression, Aggregator, Rank,
Joiner, Sequence Generator, Lookup, and Update Strategy etc.
Pfizer, (MAHINDRA SATYAM,HYD-IND)
April
2007 – March 2010
Informatica-Developer
Project Name: Clinical Trail
Operations February 2008 – March 2010
Ø Team Size: 6
Ø Environment: Informatica Power center 8.1, SQL Server
2005, UNIX, PUTTY, Service Center 6.5
Project Description: RightTrack II is web-based application used
to enter, maintain and retrieve the clinical study data within the Registry
(CCTR) database. Types of data that are
available via RightTrack II include Drug Programs, Protocols, Centers,
Investigators, Persons, Organizations and Brio Reports. Registry is the definitive source of
reference data for all of Pfizer's human clinical trials.
The Registry includes the
following data elements:
Ø Corporate clinical
identifiers for Drug program, protocols, centers and investigators.
Ø Identifiers for
uncommitted but planned human clinical trials.
Ø Study and
Center-level details, status and enrollment information.
Responsibilities:
Ø Understanding the
Business rules completely and implementing data transformation methodologies
Involved in designing the E.T.L mapping documents.
Ø Involved developing
Mapplets, Mappings and
Ø Extracting data from
different relational databases, Flat files using Informatica Power Center.
Ø Creating Various
Transformations like Expression, Aggregator, Rank, Joiner, Sequence Generator,
Lookup, and Update Strategy, etc.
Project Name: SAS (Sales
Analysis System) April 2007 – January 2008
Team Member
Ø Team Size: 10
Ø Environment: Informatica Power Center 8.1, Oracle 8i,
Unix, Putty, Toad
Description: This project sells their products in various
countries and maintains all the information. The company does high volume of
business, so it runs business statistics reports to aid in decision support.
Many of these reports are time based and non-volatile. That is, they analyze
past data trends. The company loads data into its database and then its data
warehouse regularly to gather statistics for these reports. Some examples of
these reports include annual, quarterly, monthly and weekly sales figures by
product. The company also runs reports on the distribution channels through
which its sales are delivered. When the company runs special promotions on its
products, it analyzes the impact of these promotions on sales. It also analyzes
sales by geographical area.
Responsibilities:
Ø Analyzed the existing
OLTP system.
Ø Transforming existing
data from Source database to Target database (Oracle).
Ø Performed data
cleansing and transformation using Informatica.
Ø Developed Mapplets,
Mappings and Transformations.
Ø Scheduled sessions to
update the target data using Informatica Workflow Manager.
Bank of America(TCS ,BLR-IND)
May 2006 – March 2007
Team Member
Ø Team Size: 5
Ø Environment: ASP.Net, C#.Net, Server-2000, Tools: SQL Profiler; O/s :Windows-2000
Project Name: Lean - BOA
(Bank of America)
Project Description: The LEAN application allows for efficient
access to high volume customer transactions like all linked accounts, access
channels recent transactions and pending transactions. LEAN will be used by BOA Call centers agents
to assist in customer calls this application is used to retrieve and modify
customer information using single screen. Lean Screen having multiple
applications like Merlin, USP and COIN.
Responsibilities:
Ø Involved in
developing the business logic layer and design the presentation layer.
Ø Involved in
Application maintenance and enhancement.
Ø Involved in preparing
the test cases and test scripts.
Ø Testing - unit
testing
Ø Representing Weekly
& Monthly Client meetings from Offshore.
Pegangan Electric and Gases(BLR-IND) Feb 2004 – May 2006
Team Member
Regional Manpower
Maintenance/Analysis System (Officers)
Ø Team Size: 5
Ø Environment: Asp.Net 2.0, C#.Net, Sql Server – 2000, VSS,
HTML
Project Description: This Project is about automating the Regional
Manpower Maintenance and Analysis Systems (officers). It gives Management
Information System on Manpower. Which is automating officers Database, Transferring
up to date, New Appointment details, Assignment details, Retirement details,
Region wise officers, Birthday alarms, Joining and relieving details,
Additions, Modifications, Cancellations of transfer order details.
Responsibilities:
Ø Involved in
requirement gathering and preparing the document
Ø Developing the
Application Layer and Business logic layer.
Ø Interaction with the
client
Ø Testing - unit
testing
Subscribe to:
Posts (Atom)
