ETL/Informatica Developer Resume

OBJECTIVE

Looking for a career in Cassandra Modeling and Development.

SUMMARY

Certified Cassandra Developer with experience in modeling, design and development of NoSQL databases.
Nearly 6 years of IT experience in Data Warehouse/Data Mart design, System analysis, design, development, Database design, SQL, PL/SQL programming.
Over 3 Years of extensive experience in Informatica PowerCenter 9.x / 8.x, with strong business understanding in Retail, insurance and Healthcare sectors.
3 Years of experience in Cognos Suite 10, OLAP/Data Warehousing, reporting tools of Impromptu Administrator, Power play, Transformer, Access Manager, Powerplay Cubes, Upfront, and Cognos Scheduler.

TECHNICAL SKILLS

ODS/DataMart: Cassandra 2.1 (Datastax - NoSQL)

ETL Tools: Informatica (Power Center 8.X/ 9.X)

Operating Systems: Windows 2003/2008, UNIX

RDBMS: Oracle 11i (SQL, PL/SQL, Stored Procedures, Functions), MS-Access, SQL Server 2005/2008

Data Base Tools: SQL Loader

Reporting tools: Business objects, Cognos 10.x

Languages: PL/SQL

PROFESSIONAL EXPERIENCE

ETL/Informatica Developer

Confidential

Responsibilities:

Creating folders, user groups and users within them and assigning selective privileges and permissions.
Used Informatica Designer to develop jobs for extracting, transforming, integrating and loading data to targets.
Involved in development of Informatica Jobs with required Transformations like Aggregator, Filter, Expression, Lookup, and Sorter Transformer etc.
Did the scheduling according to the requirement as daily, weekly or monthly basis depending on the precedence diagrams, Metadata reporting.
Gathered requirements, analyzed requirements, prepared technical documentations for Corporate Reporting Project.

Environment: Windows, Oracle 11i, Informatica 8.x/9.x, Workflow Manager, and Workflow Monitor.

BI Reports Developer

Confidential

Responsibilities:

Worked closely with client resources to understand, gather, document business requirements, develop technical specifications, recommendations on the preferred solution for development, deploy efficient BI solutions
Involved in the analysis, design, develop, testing of analytical & transactional reporting systems and user training.
Involved in building models, packages using Framework Manger and published the packages to ReportNet Server.
Used Cognos Connection to administer and scheduling reports to run at various intervals as well as the ReportNet Server.
Created list reports, cross tab reports, chart reports and reports with lot of conditional formatting using Report Studio.
Created Query Prompts, calculations, Conditions using Report Studio.
Used Framework Manager to administer security.
Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler.
Involved testing, validation and documenting test results
Involved in the process of design, develop and testing ReportNet reports

Environment: Cognos 10 (Framework Manager, CognosConnection, Cognos Configuration, Report Studio and Query Studio), Informatica 9.x, Oracle, IIS, Windows 2003/2008 Professional.

ETL Developer

Confidential

Responsibilities:

Involved in developing Data Warehouse using Star schema.
Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager
Scheduled the batches to be run using the Workflow Manager
Involved in Performance tuning for mappings and sessions
Extensively used transformations like lookups, update strategy, sorter

Environment: Windows 2005/2008/2012 , Informatica 8.x/9.x,Oracle 11i/10i, SQLServer 2005/2008

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship