We provide IT Staff Augmentation Services!

Etl Developer/integration Specialist Resume

Plano, TX

PROFESSIONAL SUMMARY:

  • Highly skilled ETL Developer with total 10+ years of proven work experience with expertise in Informatica and Salesforce Integration as a specialist in projects like Commercial Data Warehouse, Operational Data Store and Informatica Integration using Power Exchange and Informatica Cloud Services.
  • Have 10+ years of work experience on ETL tool Informatica Power Center Ver 8.x, 9.x and 10.1.
  • Currently working in Confidential in an Integration project, which integrates Salesforce with multiple other systems like Mainframe and Oracle DB using Informatica 10.1.
  • Have experience in working on an Operation Data Store (ODS) project on MS SQL Database which integrates ERP systems like JD Edwards and SAP and CRM system like Siebel.
  • Previously working as the developer and support specialist in a Salesforce Integration team which supports and maintains Operation Data Store (ODS) for a CRM project.
  • Have worked on various Informatica Power Center tools like, Developer Console for build and diagnosis of ETL logic and various business Validation rules, Workflow Manager to schedule Informatica workflows and also manually hold and execute Informatica workflows, Informatica Workflow Monitor to monitor and re - execute executing Informatica workflows and verify run statistics and logs of session and workflows.
  • Have worked on debugger mode in developer console to debug complex mapping and read through Session logs to figure out the exact reason of failure of workflow.
  • Have implemented and supported error reporting, audit control and rejection mechanism in ETL flow.
  • Have worked on ODS system which also loads data from users and disparate system by Mass Data Update functionality using Flat files.
  • Knowledge and experienced in cloud technology like Salesforce.com, as it is the source system of Operational Data Store, which is a conduit to transfer data to ERP like SAP and JD Edwards and other CRM system like Siebel.
  • Trained in EBS systems like Kafka for data streaming in TFS.
  • Hands on experience of AWS technology and way to extract data out of Amazon RDS and S3 using Informatica Power center and Nifi.
  • Trained in File System DB like MongoDB and have worked on tools like Compass and Atlas.
  • Have worked on Data Replication system which synchronizes data between Salesforce and ODS database.
  • Have worked as an Admin in Salesforce.com and thus is involved in User maintenance, performing manual tasks and debugging of real time integration using Web service by Boomi Integration tool.
  • Have worked on Control M, Autosys and Automic Scheduling tools and have used Enterprise Manager and Desktop application to schedule control-M jobs (manual and automatic) and also control job flows.
  • Have also worked in a Commercial Data Warehouse (CDW) Production support team for 4 years and have led the team for a year.
  • Have worked on job monitoring using scheduler like UC4 V6 and V9 (Automic) for 2 years in the Commercial Data Warehouse project.
  • Have worked on build and implementation of Perl script which supported multiple functionality of file system, including FTP and SFTP.
  • Have worked on JCL (Job Control language) script in UC4 V6 and V9 to perform various job control activities like automatic scheduling, execution of Perl and Unix Script and Job status reporting via email to users etc.
  • Have performed system analysis and programming tasks to maintain and control the use of integration systems as a support analyst.
  • Excellent debugging and diagnostic skills and understanding complex ETL designs in Informatica Developer Console and Batch\Unix and Perl script codes.
  • Have also performed FTP and SFTP of files related to prescriber data from IMS using FileZilla and IPSwitch.
  • Have performed Admin activities in a short term role as a programmer in BI-COE project which included using Admin Console of Informatica and Active Directories.
  • Extensive work experience in Informatica with MS SQL and Netezza as database.
  • Well conversant with debugging of Batch, Perl and Unix Scripting.
  • Have also worked with the project enhancement team conducting testing of ETL code and batch scripts to be sure they will produce the desired results.
  • Have done design and implementation for many components of ETL integration using Deployment Group in Informatica Repository Manager in Lower environments.
  • Experienced in working on Test Plans, Functional Specifications, Use cases, User Acceptance Testing (UAT), Involved in performing the code review using Informatica code compare.
  • Solid management skills, demonstrated proficiency in leading and mentoring individuals to maximum levels of productivity, while forming cohesive team environments.
  • A team player with concern for quality at all levels and ability to perform under stress. Good communication and interpersonal skills, commitment, dedication, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.
  • Excellent experience in various SDLC phases like requirement analysis, Functional Design, Development, Unit Testing, Validation testing and OQ PQ documents.
  • Assign duties, responsibilities, and spans of authority to project personnel.
  • Identify need for initial or supplemental project resources.

TECHNICAL SKILLS:

Operating System: Windows 98, XP, 7 and 10

ETL Tool: Informatica 9.5 Power Center and Power Exchange

Language:: Perl, Unix and Batch Script.

Database:: MS SQL Server, Netezza, RDS, MongoDB

Cloud Technology:: Salesforce.com, Veeva, AWS RDS, S3, EC2

Salesforce tools: Data Loader and Work bench

Automation Tool: Control M Enterprise and Desktop & UC4(Automic) V6 and V9

Modeling Tools: MS Visio 2010/2007

Business Domain Areas:: Life Sciences, Automobile Financing

Programming Languages: Perl, Batch and Unix

FTP Tool: FileZilla and IPSwitch

Bug Tracking Technologies: Knowledge Base(KB) in Salesforce

Ticketing tool:: Remedy on Demand, Jira, ServiceNow

Others:: Salesforce Integration with ERP and CRM systemCDW Application Support in a Life Science project

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

ETL Developer/Integration Specialist

Technologies: Informatica PowerCenter 10.1, Informatica PowerExchange Salesforce Connector, Informatica Cloud, Autosys Workload Automation, Shell Script, Salesforce.com and Oracle 11g Enterprise Edition, Service Now.

Responsibilities:

  • Work on code development, bug fixes and enhancements for the TFS integration environment for CEP (Customer Engagement Platform) in an Agile environment.
  • Have developed and executed unit and system tests in development and QA environments respectively.
  • Analyze business data requirements to produce relevant ETL architecture deliverables (source analysis, source to target mappings, ETL flows). Have used ETL methodology for all data loads and work on enhancements based on business requirements
  • Writing and maintaining SQL and Shell script code to meet system requirements, system designs and technical specifications in accordance with quality accredited standards.
  • Writing, updating and maintaining technical program, end user documentation and operational procedures
  • Debugging, diagnosing and correcting errors and faults in an applications programming language like SQL and Shell script within established testing protocols, guidelines and quality standards to ensure programs and applications perform to specification.
  • Closely working with Business Development team to capture and understand user stories and provide resolutions every release using Agile Methodology.
  • Change request implementation in non - production environment in Salesforce and Informatica.
  • Using Service Now and Jira to submit Request for Change for migration and raising tickets for issues.

Confidential, Fort Worth, TX

Team Lead/Technical Lead

Technologies: Informatica PowerCenter 9.5, Informatica PowerExchange Salesforce Connector, Control M Enterprise Manager and Desktop, Batch Script, Salesforce.com and MS SQL Server 10, BMC Remedy.

Responsibilities:

  • Work on code development, bug fixes and enhancements for the ODS application.
  • Have developed and executed unit and system tests in development and QA environments respectively.
  • Analyze business data requirements to produce relevant ETL architecture deliverables (source analysis, source to target mappings, ETL flows). Have used ETL methodology for all data loads and work on enhancements beased on business requirements
  • Writing and maintaining MS SQL and Batch script code to meet system requirements, system designs and technical specifications in accordance with quality accredited standards.
  • Writing, updating and maintaining technical program, end user documentation and operational procedures
  • Debugging, diagnosing and correcting errors and faults in an applications programming language like SQL and batch script within established testing protocols, guidelines and quality standards to ensure programs and applications perform to specification.
  • Joined Global Production Support analyst at Confidential Business Services Level 3 support at Fort Worth, Texas, USA.
  • Daily monitoring of integration jobs and root cause analysis submission in case of any failure.
  • Handling P1 and P2 tickets based on SLA decided.
  • Helping out L2 support in case of ticket resolution required for their end.
  • Helping out project deployment team during Go live for a country, by coordinating the cut over activities and smoke test.
  • Closely working with enhancement team by suggesting resolutions and fixes needed for bug fix or enhancements of present code.
  • Change request implementation in production environment in Salesforce and Informatica.
  • Environnent maintenance of post production Environnent.
  • Remedy on Demand queue monitoring and triaging of tickets.

Confidential, Chesterbrook, Pennsylvania

Software Engineer

Technologies: Informatica PowerCenter 9.1, Netezza ODBS connectors, UC4 V6 and V9, Perl Script, Netezza Database, JIRA.

Responsibilities:

  • To support develoment, bug fixing and enhancements in CBI (Commercial Business Insights) application.
  • Develop and execute unit, system tests in development and integration environments.
  • Analyze business data requirements to produce relevant ETL architecture deliverables (source analysis, source to target mappings, ETL flows). Use ETL methodology for all data loads and work on enhancements beased on business requirements
  • Writing and maintaining SQL, UNIX script and Perl script code to meet system requirements, system designs and technical specifications in accordance with quality accredited standards.
  • Writing, updating and maintaining technical program, end user documentation and operational procedures
  • Debugging, diagnosing and correcting errors and faults in an applications programming language like SQL, UNIX script and Perl script within established testing protocols, guidelines and quality standards to ensure programs and applications perform to specification.
  • Provide SME support for CBI, BI SP and ICBI to the testing team during software upgrades.
  • Maintaining and Supporting CBI Application as we receive updates from various source systems.
  • Was responsible to maintain Call, Customer, Employee, Time off Territory, Product and Sales data.
  • Developing High level Design & Low level design documents as well as code development for various requirement of change and process improvement.
  • Prepare effective test cases and execute them in order to approach for defect free delivery to vendor and business within agreed SLA.
  • I had worked on tools: Informatica Power Centre, UC4, WinSQL For Netezza, Business Objects and Perl scripting.
  • I had established self as a key contributor to Shire's UC4 Knowledge base, which acts as a sole automation tool, as it handles various heterogeneous environment within Shire

Confidential, Chesterbrook, Pennsylvania

Associate Software Engineer

Technologies: Informatica PowerCenter 9.1 Admin Console, Netezza DB, UC4 V6 and V9 Admin, Perl Script,

Responsibilities:

  • Development, and Maintainence of Administration Activities of Informatica using Admin Console and UC4.
  • Writing and maintaining SQL, UNIX script and Perl script code to meet system requirements, system designs and technical specifications in accordance with quality accredited standards.
  • Writing, updating and maintaining technical program, end user documentation and operational procedures
  • Debugging, diagnosing and correcting errors and faults in an applications programming language like SQL, UNIX script and Perl script within established testing protocols, guidelines and quality standards to ensure programs and applications perform to specification.
  • Migration of ETL workflows of Informatica using Informatica Repository manager, either by XML or by Deployment Group.
  • Have worked in ADMIN team BI- Corp for 4 months which supported UC4, Informatica and Windows, Perl and Unix Scripting support to users in US and UK.

Confidential

Trainee

Technologies: Informatica PowerCenter 9.1, PL-SQL, Business Objects

Responsibilities:

  • To get trained and complete 2 months of Green Field Training organized by Confidential Learning Team.
  • Training included classroom courses like computer science basic and advanced subjects as well.
  • A trainee is to complete all classroom trainings and qualify in the weekly tests organized by Confidential .
  • Training also included mock case subjects to analyze case requirements to produce relevant ETL architecture deliverables (source analysis, source to target mappings, ETL flows). Use ETL methodology for all data loads and work on enhancements based on case scenarios.
  • Building SQL, UNIX script and Perl script code to meet case requirements, designs the program flow in accordance with expected training standards.
  • Writing, updating and maintaining technical documentation.
  • Training included to develop and execute unit and system tests in development and QA environments respectively.

Confidential

Intern

Technologies: Black Box Testing

Responsibilities:

  • To analyze case requirements to produce relevant testing strategies and test scenarios.
  • Lead the test team and peer review the unit test documents produced by developers.
  • Creating Operational Qualification test script to test the code based on the provided requirements, and as per expected standards.
  • Writing, updating and maintaining technical documentation for toll gate.

Hire Now