About Me
Informatica power center,Oracle teradata,netezza,Unix -8 years of experience
Informatica BDM-less than Year.
... Show MoreSkills
Development Tools
Others
Software Engineering
Database
Positions
Portfolio Projects
Company
Blue shield of California
Role
Frontend Developer
Description
- Over 5 years of experience of leading multiple ETL projects of team members between 5 members.
- Requirement gathering, data modelling and designing (Technical Design) reports and ETL interfaces as well as leading the team in coding, testing in both ETL and reporting phase.
- Extensive involvement on Infrastructure monitoring, configuration, maintenance, load optimization and load balance.
- Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques and pushdown optimization, and also identifying performance bottlenecks.
- Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
- Designing and developing automation tools to generate a report to which is accurate data for various analysis which helps to optimize the process.
- Experience with setting up access roles and privileges, code page setups, appropriate ETL migration activities and scheduling jobs using TIDAL or Auto-sys.
- Developed mappings, sessions, worklet and workflows in Informatica as per STTM.
- Developed Technical Design document.
- Unit Test Case Document and performed unit testing.
- Used Netezza and Oracle database for back end and provided extensive training for the peers on Netezza.
- Prepared SQL query as part of development
- Used UNIX to navigate around the system and check for specific files, the file’s contents, change permissions and see who the current users are.
- Seeking clarification from the clients regarding STTM requirements in the daily status call.
- Addressing and clearing the QA clarifications raised as part of development
- Performed data loading activities manually as well as through Tidal.
- Played a tester role in Member book of Records Project which needed writing test cases, sql queries.
- Used Application Lifecycle Management tool for uploading test cases
- Used JIRA for creating defects and seeking clarification from developers.
- Managed Version control in different environments using SVN.
Skills
Informatica Oracle 11g Netezza TeradataTools
JIRACompany
Telstra
Description
- Over 4 months of experience of leading ETL projects of team members 7.
- Requirement gathering, data modelling and designing (Technical Design) reports and ETL interfaces as well as leading the team in coding, testing in both ETL and reporting phase.
- Extensive involvement on Infrastructure monitoring, configuration, maintenance, load optimization and load balance.
- Experience in Performance Tuning of Analysis, and rearchitecting the process model and node by implementing various techniques like partitioning techniques and adding required nodes, also identifying performance bottlenecks.
Skills
Data 3sixty AWS S3 HiveTools
JIRACompany
Pfizer
Description
- Requirement gathering, designing (Technical Design) reports and ETL interfaces as well as leading the team in coding, testing to till deployment.
- Extensive involvement on Infrastructure monitoring, configuration, maintenance, load optimization and load balance.
- Maintained compliance with quality as per the project specifications and ensured deliverables are delivered on time
- Coordinated with ETL architects and process analysts for development and execution of system and integration test plans
- Evaluated daily ETL development processes, design and code review procedures and mentoring team members
- Coordinated with external business partners for enhancement of ETL development activities
- Participated in all phases of ETL process development lifecycle
- Provided extensive support for dry runs in production
Tools
HP service managerCompany
Blue shield of California
Description
- As part of Admin Communicating to Business on the Infrastructure requirement and status.
- Responsible to manage Development, QA and Production environments.
- Making sure that code is sync in all the environments.
- Work on the Outages Handling, Patch installation and updates handling.
- Handles Password Changes.
- Bouncing Activities or Restarting the Services
- Constantly keeping eye on whether the infrastructure is having readiness in the environment.
- System level parameter checks CPU spike, Memory utilization, Number of parallel loads (sessions) running on each node.
- Monitoring the loads (workflows) whether the loads are scheduled to respective timings.
- Recovery or Re-start in loads in case of any failures.
- Identifying the tardiness in loading process in case of any sessions are in hung status.
- Monitoring Alerts, Load and Servers in regular basis
Skills
Informatica Power CenterTools
HP service manager