We provide IT Staff Augmentation Services!

Etl Developer/production Support Analyst Resume

PROFILE SUMMARY:

  • A competent professional with over 10+ years of experience in design, development, implementation, testing, and maintenance using Informatica Power Center 10.2/9.X/8.X/7.X, Oracle 12c/11i/10g/9i, UNIX. Autosys, SQL Server and SSIS.
  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate large datasets with attention to detail and accuracy.
  • Expert in Batch Operation Support.
  • Troubleshoot moderate to complex issues found internally and reported by customers. Apply fixes to resolve issues. Work with Software Developers and IT staff to troubleshoot/resolve issues.
  • Provide broad understanding of platforms and applications across all technologies.
  • Expertise on Installation, configuration, migration & upgrades of Informatica products.
  • Extensively worked with ETL Informatica Tools - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer and Informatica Repository Manager.
  • Experienced in Data Extraction, Transformation, and Loading (ETL) from disparate Data sources like Multiple Relational Databases Oracle, Teradata, DB2, SQL Server, Main Frame and Worked on integrating data from flat files and COBOL files into a common reporting and analytical Data Model using Informatica / Informatica Power Exchange tools.
  • Expertise in Creation, Modification and Testing of Informatica Mappings, Mapplets, Workflows, Worklets and debugging and performance tuning of Informatica Mappings and Sessions.
  • Direct user assistance in navigating the system, resolving technical issues related to data and/or the system itself.
  • Assist in Quality Assurance testing and Technical document reviews and code migration to production.
  • Strong skills in resolving Database issues, providing workaround for the problems, knowledge on diagnostics, Database Tuning, SQL Tuning and Performance Monitoring.
  • Experience in Database Programming, SQL, ORACLE PL/SQL (Stored Procedures, Functions and Triggers) for faster transformations and Development.
  • Strong knowledge in Star & Snowflake schema creation.
  • Experienced in UNIX shell scripts to write wrapper scripts for automation of batch jobs & ETL Jobs.
  • Troubleshoot and root cause analysis of critical production issues like batch job failure/hanging, system errors.
  • Experienced in creating and maintaining operational run books for distributed batch operations Provide functional product support for Scheduling Software.
  • An effective communicator with interpersonal, leadership, planning, problem solving and motivational skills

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center/Power Mart 7.1/8.x/9.x/10.2, SSIS

DB Tools: SQL*Plus, SQL*Loader, Toad, Oracle SQL Developer

Databases: Oracle8i/ 9i/10g/11g/12c, MS-SQL Server, MS Access, Teradata

Developing Languages: SQL, T-SQL,PL/SQL, JAVA, Unix Shell Scripting, VBA

Business Reporting Tool: Excel, Access, Informatica Power Analyzer, SSRS

Operating System: Unix, Linux, Windows XP/7/8/10, Windows Server 2003/2008

Other Tools: MS Office Suite, GitHub, Autosys, Jira, Confluence, uDeploy, Netcool,PAC2000

ORGANIZATIONAL EXPERIENCE:

Confidential

ETL Developer/Production Support Analyst

Responsibilities:

  • Accountability for all applications (4 applications) under INFA Tower.
  • Participate in a 24x7 on-call rotation, including weekends, evenings and holidays
  • Accountability for all client facing applications (11) under INFA Tower.
  • Involved in developing Informatica ETL Code using Informatica 10.2 like creating mappings, sessions & workflows and reviewed & tuned other team member’s code.
  • On-Call support for all INFA/MS Applications
  • Participated in problem and incident management support and reassignment of tasks and tickets when required to keep overall tower healthy as possible.
  • As a SME of 4 applications, accepted accountability for understanding and compliance with IT Service Management practices including Incident, Problem, Change, and Release processes
  • Participated in change management and production release activities for multiple applications (4 applications)
  • Worked closely with DBAs, Informatica Admin team to migrate Informatica code /database tables from Dev to QA and QA to UAT and UAT to Production.
  • Deployed application code and configurations in UAT & Production environments
  • Conducted post deployment validation of production applications and configurations and participated in rollback activities if needed.
  • Tracked all planned and unplanned releases and outages and worked with cross-functional IT teams to isolate and resolve unplanned application outages
  • Crated and worked on Jira Items for Code fixes & data fixes.
  • Involved in Code Reviews & suggested best practices.
  • Maintained relationship with Application team leads and Business stake holders.
  • Involved in application and database server migration activity.
  • Participate in security scan remediation and was responsible for all THR/TREX activities (end to end)
  • Make sure all PROD Batch loads completed and not missed any SLA
  • Gather repeated issues/Long running jobs and come up with solutions
  • Responsible for updating Applications run book and KEDB on periodic basis.
  • Mentoring all news resources and L1 resources
  • Create, modify and troubleshoot complex Oracle SQL queries, PL/SQL stored procedures and jobs
  • Writing Shell scripting & Unix files and deploying in Production environment.
  • Assist in troubleshooting and impact analysis of any changes made to the database Objects
  • Optimize SQL (Oracle 12c) performance, integrity and security of the project’s databases/schema.
  • Make sure all PROD Batch loads completed and not missed any SLA
  • Making sure all PTs / JIRAs are closed with in SLA timelines
  • Handled Offshore Teams and Co-ordinated with them on critical issues.
  • Manage support cases through all phases to resolution / close including escalations to management and or other teams
  • Performed disaster recovery tests to ensure system availability and functionality, participated as a lead in BCP simulation activities twice a year for multiple applications.
  • Gather repeated issues/Long running jobs and come up with solutions.
  • Perform tuning and trouble-shooting of applications, modules and reports to improve performance and minimize system resource constraints.
  • Ensure data quality by writing and executing SQL procedures for cross checking and identifying data anomalies. Triage data related issues
  • Assist in troubleshooting and impact analysis of any changes made to the database (Oracle 12c) Objects
  • Optimize SQL performance, integrity and security of the project’s databases/schema.
  • Make sure all PROD Batch loads completed and not missed any SLA
  • Responsible for updating Applications run book and KEDB on periodic basis.
  • Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification

Environment: Informatica power center 10.2/9.5.1, SQL Server 2017,Exadata/Oracle 12C/11g, Flat files, UNIX Shell scripting, HP Quality Center, TFS, AutoSys-CA Workload, Confluence, DCM, PAC2000, Jira, AppDynamics, SharePoint,uDeploy,Netcool.

Confidential, Madison, WI

ETL Developer

Responsibilities:

  • Involved in design and development of data warehouse environment, liaison to business users and/or technical teams gathering requirement specification documents and presenting and identifying data sources, targets and report generation.
  • Developed advanced SQL queries with multi-table joins, group functions, subqueries, set operations and stored procedures, user defined functions (UDFs) for data analysis.
  • Loaded flat and Excel files into Oracle database and developed SQL scripts to create desired queries (views) for data analysis
  • Assign task to team members with in module and coordinate with them complete assign task.
  • Responsible for Coding/Development and for the final files delivery.
  • Worked closely with various teams like ETL-Admin, Security Variance, and DBA, Data modelers, Architects and MFT Admin teams.
  • Worked on Informatica Workflow and mapping development and also database development.
  • Interacted with end users, regularly in order to generate the reports required. Technologies Involved: Informatica Power Center 9.6/9.5.1/9.1.0 , Oracle 11g (SQL and PL SQL), Flat-files

Environment: Informatica Power Center 9.6/9.5.1/9.1.0 , Oracle 11g (SQL and PL SQL), Flat-Files, UNIX, HP Quality Center, TFS, AutoSys

Confidential, Modesto, CA

Programmer Analyst

Responsibilities:

  • Aided in development and management of Data Warehousing solutions using SSIS ETL tool.
  • Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
  • Develop GUI interfaces using Open Database Connectivity (ODBC) to connect to SQL Server Relational Database Management Systems (RDBMS).
  • Collaborate with program and department staff in the creation of data reports and/or dashboards.
  • Creating monthly and yearly reports from Intake Board Database and creating presentation for stakeholders.
  • Indexing, profiling, reorganizing, classifying uploaded data.

Environment: MS SQL Server, SSIS, MS Access, MS Office Suite, PeopleSoft

Confidential, Modesto, CA

Informatica Developer

Responsibilities:

  • Interacted with the business people and database administrators to identify the business requirements and data realties.
  • Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
  • Prepared functional specifications and Mapping documents scope documents and Involved in creating High level and low level design of the ETL process
  • Defined Target Load Order Plan for loading data into different Target Tables.
  • Designed and developed various kinds of mappings using transformations like Expression, Aggregator, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, and Update Strategy.
  • Automation of job processing, establish automatic email notification to the concerned persons.
  • Performed tuning and optimization of complex SQL queries using Explain plan
  • Performance Tuning of sources, Targets, mappings and SQL queries in transformations
  • Extensively configured physical and logical joins using the Join Manager in OBIEE Administration
  • Developed UNIX shell scripts to run batch jobs in production.

Environment: Informatica Power Center 9.1/8.6, OBIEE 11.1.1.5, SQL Work Bench, Oracle 11i/10g, PL/SQL, SQL Developer, TOAD 7.0, UNIX Shell Scripts, Flat files

Confidential, CA

Informatica Developer

Responsibilities:

  • Understanding present process flow and business functionalities and prepare ETL process flow for Predictive analysis.
  • Involved in designing Conceptual, Logical and Physical model for Staging and Target data base.
  • And developed the mapping specifications from the business requirements and the data model.
  • Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations, maintaining Informatica workflows.
  • Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
  • Developed PL/SQL stored procedures for database updates and to create the necessary indexes in the target tables.
  • Used Change Data capture (CDC) option to capture the data whenever the inserts, updates, and deletes underlying these events as soon as they occur and transfer in to multiple targets without intermediate queues or staging tables.
  • Used volatile table and derived queries for breaking up complex queries into simpler queries.
  • Extensively involved in performance tuning on both Informatica side and Database side.
  • Worked with production support in finalizing scheduling of workflows and database scripts using Autosys.
  • Wrote test scripts to validate the data for the testing team. Did unit testing, system integrated testing.

Environment: Informatica 8.6/8.1, Erwin, Oracle 10g,DB2, PL/SQL, OBIEE, SQL Server 2005, DB2,Toad, UNIX Shell Programming.

Hire Now