SUMMARY

• 6 years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Powercenter.
• Proficiency in developing SQL with various relational databases like SQL and PL/SQL.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experience with dimensional modeling using star schema and snowflake models.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Strong with relational database design concepts.
• Proficiency in developing Tableau report with various relational databases like GreenPlumand Oracle
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Strong business understanding on Finance Vertical.
• Independently perform complex troubleshooting, root - cause analysis and solution development.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Comprehensive technical, oral, written and communicational skills

TECHNICAL SKILLS

ETL : Informatica 9.0.1 (Informatica Certified Developer)

OLAP Tool: Tableau desktop 9.0

Databases: Oracle 9i/10g 9(OCA Certified), Exudates,Green plum

Languages: SQL, PL/SQL and UNIX.

Operating Systems: Windows 2000/XP, Linux.

PROFESSIONAL EXPERIENCE

Confidential

Software Engineering Analyst

Responsibilities:

• Working as an ETL developer.
• Created mappings to pull the data from various flat & relational sources.
• Created the mapping to load data into staging area and then to the target table.
• Performed Unit Test Cases for mapping
• Involved in the migration process of Informatica Mapping, Database change.

Confidential

Responsibilities:

• Working as an ETL developer.
• Created mappings to pull the data from various flat & relational sources.
• Created the mapping to load data into staging area and then to the target table.
• Performed Unit Test Cases for mapping
• Involved in the migration process of Informatica Mapping, Database change.

Confidential

ETL developer

Responsibilities:

• Working as an ETL developer.
• Created mappings to pull the data from various flat & relational sources.
• Created the mapping to load data into staging area and then to the target table.