Senior Software Engineer Resume

EXPERIENCE SUMMARY:

Assistant Consultant having 12+ years of experience as Data Warehouse professional.
Vast experience in development, testing, deployment and support of ETL jobs using Informatica PowerCenter (Versions 10.2, 9.1, 8.6 & 7.1).
Has 6+ years of experience in agile work environment being part of all the agile ceremonies.
Good experience in performance tuning of ETL jobs by identifying bottlenecks, usage of partitioning and other performance improvement techniques.
Has good understanding of Kimball and Inmon data modeling techniques and working with the same.
Has very good knowledge and experience in working with Slowly Changing Dimensions.
Experienced in performing business analysis and designing Source to Target documentations.
Has good understanding of Data Governance and work experience in Informatica Metadata Manager and Business Glossary.
Good business knowledge in Healthcare domain, completed AHM250 certification and have experience in performing business analysis.
Has vast experience in working through all the life cycles of application development and production support activities.
Have experience in Oracle PL/SQL procedures, UNIX shell scripting and Python, automated various manual activities using scripting.

TECHNICAL EXPERTISE:

Primary Skills: Informatica PowerCenter, Metadata Manager and Business Glossary.

Additional Hands - on Experience: Informatica Data Quality, Tableau Reporting, Business Object Reporting, BO Data Integrator

Operating Systems: Windows

Languages: PL/SQL and Basic Unix Shell Scripting

Databases: Oracle (12c Exadata, 11g, 10g), MS SQL Server and Teradata

Domain Knowledge: Healthcare and Manufacturing

Other Tools and Applications: Tortoise SVN, SharePoint, Rational Team Concert (RTC), Remedy and Service Now

EXPERIENCE DETAILS:

Confidential

Senior Software Engineer

Tools: Informatica PowerCenter (10.2, 9.1, 8.6 & 7.1), Informatica Metadata Manager & Business Glossary (10.2 & 9.1), Rational Team Concert (RTC), Tableau, Mainframe (Basics), Remedy and Service Now

Responsibilities:

Requirement clarification with onsite coordinators and end users for gathering the requirements in requirement phase.
Perform business and technical analysis during analysis phase and work with product owners and business users on resolving issues. Have used IDQ analyst for profiling and analysis.
Preparing source to target and technical requirements document in design phase.
Developing Informatica code based on requirements document and ETL patterns during development phase.
Preparation of test cases and test data and performing unit testing for all test cases in testing phase.
Clarifying the tester queries in regression testing phase.
Preparation of deployment plan, attending deployment meetings, execution of deployment steps and post deployment validation during release phase.
Servicing enhancement and production fix requests in Informatica.
Peer reviewing of Informatica codes and Unit Test documents.
Actively participating in agile ceremonies.
Participating in Architecture meetings and providing inputs, suggestions and implementing data warehouse architectural changes where ever necessary.
Identifying and implementing process improvements.
Analyze and respond to user queries.
Clarifying Team members on technical and business related queries.
Creating and maintaining production support documents and run books.
Assigning and reviewing works for offshore team members.
Training new associates.
Status reporting to customers on tasks assigned.
Automated various manual activities.
Did Proof of Concept on various tools as per customer request.
Developed PL/SQL procedure for Test Data Management.

Confidential

Tools: Data Integrator XI, Business Objects Reports, Informatica 7.1, Informatica 8.6

Databases: Oracle, MS SQL Server

Team Member

Responsibilities:

Servicing enhancement requests in Data Integrator XI, Informatica and BO Reports.
Creating of dashboards in Business objects.
Completed an end to end Informatica project called BGA as a single resource.
Issues clarification with onsite coordinators and end users for getting the requirements in requirement phase.
Preparing design documents in design phase.
Developing and unit testing of the code (Mappings, Dataflows, Workflows, Jobs) using Informatica 7.1, Informatica 8.6 and Data Integrator XI during coding phase.
Preparation of test data and performing system testing for all test cases in system testing Phase.
Handling SQA for design documents, implementation plans and code review and testing for Mapping, Workflow and Jobs.
Peer reviewing the design documents, implementation plans and testing of Mappings, Workflows and Jobs.
Have given transitions to new team members and other organizations.
Worked in generating reports and universes using Business Objects Reports XI and has fixed production issues reported by customers.
Have worked in UNIX scripts and PL/SQL for automating the monitoring activities.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship