SUMMARY

• More than 10 years of experience in Data Warehousing and Reference Data management specializing in Informatica PowerCenter ETL in Insurance domain.
• Extensively used Informatica client tools - Repository Manager, Mapping Designer, Workflow Manager, Workflow Monitor.
• Strong understanding of the Analytical tools and their implementation
• Strong working knowledge in providing ETL based solution, ETL process design, development.
• Expert knowledge on Data Warehousing concepts and ETL process.
• Expertize in design of ETL framework - Audit framework, Error logging, CDC, Reprocessing
• Experience in working directly with customer site as a Senior ETL expert. Responsible in providing solutions, design and development in different client locations. Additional responsibility of Release Planning, coordinating with the multiple teams.
• Experience working with the client SMEs and fellow team members.
• Experience in Managing Project and Organizational Activity like participating in several Audits, Forecasting, Resourcing, contributing Technology Best Practices.
• Excellent communication and leadership skills, strong analytical and design skill and problem solving abilities
• Outstanding interpersonal skills, ability to learn quickly, good analytical reasoning and managing team members and contribute as a team.
• Highly Proficient in Informatica PowerCenter 9x development, Unix Shell Scripting and very good experience working on different relational databases: Oracle, DB2 databases
• Experience in other Tools: CA Workload, BMC Change/Incident Management, ASG-Zena Workstation, Service Now, Putty
• Post-Graduation from Bengal Engineering and Science University, Shibpur, Howrah, WB, India
• Bachelor of Technology from West Bengal University of Technology, Kolkata, India

PROFESSIONAL EXPERIENCE

Sr. Data Engineer

Confidential, Boston, MA

Technology Used: Informatica PowerCenter 9x, Informatica Developer 9x, MS SQL Server, CA Workload, Unix using Putty, Composable Analytics

Responsibilities:

• Understanding the functional and technical requirement from business requirement specification documents.
• Working as business analyst for some of the modules and coordinate with business team to come up with the solution and design.
• Write up the code to implement the functionality
• Create code development checklist
• Guide team to maintain best practices
• Review final codes written by the team members to ensure adherence to standards/functionality and approve for testing.
• Review Unit Testing logs and provide sign off
• Monitor code merge for functionality Implementation
• Release planning and the initial load run
• Additional responsibility to perform POC for new tools and evaluate adaptability to the client IT framework
• Coordinate with infrastructure team for the cloud migration effort
• Build up data ingestion processes for the non-traditional data sources through composable analytics
• Build up user interface through composable analytics platform

ETL Tech Lead

Confidential

Technology Used: Informatica PowerCenter 9x, Informatica Developer 9x, DB2, Oracle, CA Workload, Unix using Putty.

Responsibilities:

• Closely coordinate with clients’ application SMEs to ensure correct understanding of requirements and contributing in finalizing the solutions.
• Provide inputs in designing end to end solution from a technical perspective.
• Create code development checklist
• Guide team in coding as per design.
• Define the Development framework, reusable templates based on the organization repository and past experience.
• Allocate modules to developers for coding and coordinate between the different team members
• Provide inputs for setting up development environment.
• Provide guidance to developers and set standards.
• Review pseudo codes written by developers and provide a go ahead for code development.
• Review final codes written by developers on adherence to standards/functionality and approve for testing.
• Review Unit Testing logs and provide sign off
• Monitor code merge for functionality Implementation
• Working with the release team, adhering to the release process and protocol, post implementation validation
• Providing warranty support

ETL Sr. Developer

Confidential, Shelton, CT

Technology Used: Informatica 9x, DB2, SQL Server, ASG Zena

Responsibilities:

• Requirement understanding working with the Tech leads to finalize the Source to Target data map document.
• Co-coordinating with the offshore team member for detailed design review and ETL Development.
• Code review with team members.
• Unit Testing log validation for the ETL mappings/workflows and providing sign off
• Working with the release team for the code installation

ETL Developer

Confidential

Technology Used: Informatica 8x, DB2, SQL Server, ASG Zena.

Responsibilities:

• Requirement understanding and data analysis
• Designing the ETL process as per technical document USING Informatica PowerCenter Tools.
• Coordinate with team members for any query clarification, module distribution and merging before implementation
• Parallel work on service requests for ETL jobs including new development, performance tuning for long running job, code fix.
• Provide application, technology, product and/or domain specific specializations for a set of applications/product to ensure availability for business use as per agreed SLAs or requirements.
• Preparing the necessary documents like Analysis and Design Documents, Unit & Integration test Plans, Functional test cases and translate them into ETL design specification.
• Delivery of the developed technical designs to the client.