add photo
Sushmitha
Sushmithar45@gmail.com
657-859-9150
Columbus, OH 43201
Sr Informatica Developer
15 years experience C2C
0
Recommendations
Average rating
396
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
Education
Computer science
JNTU
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