Sign In
Looking for talent?
Check out our hiring section
Login to your account
Remember me?
Login
Forgot password?
Not a user yet?
Click here to register.
LOADING
Select Login
Uploaded File
Sushmitha
Sushmithar45@gmail.com
657-859-9150
Columbus, OH 43201
Sr Informatica Developer
16 years experience
C2C
0
Recommendations
Average rating
435
Profile views
Summary
8+ years
of IT Experience in
Data Warehousing
,
Database Design
and
ETL Processes
in various business domains like finance, telecom, manufacturing and health care industries.
Highly proficient in
Development, Implementation, Administration
and
Support
of ETL processes for Large-scale Data warehouses using Informatica Power Center.
Worked extensively on ETL process using
Informatica PowerCenter 9.x/8.x/7.x
.
Extensively used
ETL
methodologies for supporting
Data Extraction, Transformation
and
Loading
process, in a corporate-wide-ETL solution using Informatica Power Center.
Extensively worked on developing
Informatica Designer, Workflow manager
and
Workflow monitor
for data loads.
Worked on Informatica Data Quality 9.1(
IDQ
) tool kit and performed data profiling, cleansing and matching and imported data quality files as reference tables
Experience working with
Cloud
Computing
on Platform
Salesforce.com
Extensive experience in using various Informatica Designer Tools such as
Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer.
Extensive experience in Design, Development, Implementation, Production Support and Maintenance of Data Warehouse Business Applications in
E-commerce software, Utility,
Pharmaceutical,
Health Care, Insurance, Financial
and
Manufacturing
industries.
Experience in development and maintenance of
SQL, PL/SQL, Stored procedures, functions, analytic functions, constraints, indexes
and
triggers.
Experienced in
IDQ (9X, 9.5.1)
handing LDO’s PDO’s & some of the transformation to cleanse and profile the incoming data by using Standardizer, Labeler, Parser, Address Validator Transformations
8
years of experience in using different versions of
Oracle
database like
11g
/
10g/9i/8i.
Good knowledge on data quality measurement using IDQ and IDE
Excellent working knowledge of
c
shell scripting, job scheduling on multiple platforms, experience with UNIX command line and LINUX.
Experience
in creating
batch scripts
in
DOS
and
Perl
Scripting.
Experience in
ETL development
process using
Informatica
for
Data Warehousing
,
Data migration
and
Production support
.
Experience in both
Waterfall
and
Agile
SDLC
methodologies.
Sound knowledge of
Relational and Dimensional modeling
techniques of Data warehouse
(EDS/Data marts)
concepts and principles
(Kimball/Inmon) – Star/Snowflake schema, SCD, Surrogate keys
and
Normalization/De-normalization.
Data modeling experience
in creating
Conceptual, Logical
and
Physical Data Models
using
ERwin Data Modeler
.
Experience with
TOAD, SQL Developer database tools
to query, test, modify, analyze data, create indexes, and compare data from different schemas.
Performed the data profiling and analysis making use of Informatica Data Explorer (IDE).
Worked on
Slowly Changing Dimensions (SCD's
)
Types -1, 2
and
3
to keep track of historical data.
Knowledge in
Data Analyzer
tools like Informatica
Power Exchange (Power Connect
) to capture the changed data.
Proficiency in data warehousing techniques for data cleansing,
surrogate key
assignment
and
Change data capture (CDC).
Experience in integration of various data sources like
Oracle, DB2, Flat Files
and
XML Files into ODS
and good knowledge on
Teradata 12.0/13.0
,
SQL Server 2000/2005/2008
and
MS Access 2003/2007.
Expertise in implementing complex business rules by creating re-usable transformations, Mapplets and Mappings.
Optimized the Solution using various performance-tuning methods
(SQL tuning, ETL tuning (i.e. optimal configuration of transformations, Targets, Sources, Mappings and Sessions
), Database tuning using
Indexes, partitioning, Materialized Views, Procedures and functions
).
Designed and Developed
IDQ
mappings for address validation / cleansing, doctor master data matching, data conversion, exception handling, and report exception data.
Extensively used
Autosys
and
Tidal
for scheduling the
UNIX
shell scripts and Informatica workflows.
Extensive knowledge in all areas of
Project Life Cycle
Development.
Strong
analytical, verbal, written
and
interpersonal
skills.
Experience
Edit Skills
Non-cloudteam Skill
Education
Computer science
JNTU
Record has not been verified.
Skills
Data Marts
2021
6
ETL
2021
5
Informatica
2021
5
Informatica Developer
2021
5
Informatica Powercenter
2021
5
Oracle
2021
5
SQL
2021
5
SQL Server
2021
5
Stored Procedure
2021
5
UNIX
2021
5
XML
2021
5
Agile Methodology
2021
3
Data Profiling
2021
3
Data Warehousing
2021
3
IDQ
2021
3
Teradata
2021
3
TOAD
2021
3
BTEQ
2021
2
Data Cleansing
2016
2
Data Conversion
2016
2
FTP
2015
2
Metadata
2021
2
Scrum
2021
2
Windows
2015
2
Data Analysis
2016
1
Data Migration
2015
1
Data Validation
2015
1
Perl
2015
1
PL/SQL
2015
1
Production Support
2015
1
Snowflake
2016
1
Systems Integration
2016
1
XSD
2015
1
Data Modeling
0
1
DB2
0
1
Erwin Data Modler
0
1
Salesforce
0
1
SQL Developer
0
1
Triggers
0
1
Waterfall
0
1
Languages
English, Fluent/Bilingual
