Software Engineering Analyst Resume
5.00/5 (Submit Your Rating)
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
ETL developerResponsibilities:
- 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.