Aug 2013 – Jun 2016 · 2 yrs 10 mos · Falls church

• Responsible for ETL development using Informatica ETL tool in an Oracle and UNIX environment.
• Migrated data from flat files (COBOL, complex flat files) to Oracle database.
• Developed ETL mappings for moving and transforming data from Source to Staging, Staging to Data mart areas.
• Well versed in writing Shell scripts in UNIX environment.
• Written complex SQL and PLSQL scripts for writing packages, procedures and functions.
• Extensively used BULK Collect and Fetch, triggers, cursors for building the PLSQL blocks.
• Responsible for fixing bugs on a daily basis both in Informatica and SQL/PLSQL.
• Improved performance by implementing best practices for coding in both Informatica ETL and Oracle database
• Participated in various customer facing meetings to discuss production issues and developing solutions.
• Extensively used Unix Shell scripts to run the ETL jobs.
• Developed test cases and prepared Unit test documents for deployments into test, UAT and Production environments.
• Attended various status meetings to update the project team and project manager about possible issues and defect status.
• Prepared deployment packages to deploy code into Test, UAT and Production environments.
• Prepared and maintained technical specification documents, mapping documents and data dictionary.
• Participated in data modeling sessions for developing dimensional models for various data marts.
• Participated in peer review sessions for reviewing code of other developers on the project.
• Written adhoc scripts for handling various adhoc requests from the user which required fast delivery.

Mar 2012 – Aug 2013 · 1 yr 5 mos · Washington dc

• Responsible for ETL development using Informatica ETL tool in an Oracle and UNIX environment.
• Migrated data from flat files (COBOL, complex flat files) to Oracle database.
• Developed ETL mappings for moving and transforming data from Source to Staging, Staging to Data mart areas.
• Well versed in writing Shell scripts in UNIX environment.
• Written complex SQL and PLSQL scripts for writing packages, procedures and functions.
• Extensively used BULK Collect and Fetch, triggers, cursors for building the PLSQL blocks.
• Responsible for fixing bugs on a daily basis both in Informatica and SQL/PLSQL.
• Improved performance by implementing best practices for coding in both Informatica ETL and Oracle database
• Participated in various customer facing meetings to discuss production issues and developing solutions.
• Analyzed and discussed the business requirements with the client and prepared requirements documents. Maintained all documents in Serena Dimensions configuration tool.
• Extensively used Serena for tracking defects and communicating the issues and status.
• Extensively used Unix Shell scripts to run the ETL jobs.
• Developed test cases and prepared Unit test documents for deployments into test, UAT and Production environments.
• Attended various status meetings to update the project team and project manager about possible issues and defect status.
• Prepared deployment packages to deploy code into Test, UAT and Production environments.
• Prepared and maintained technical specification documents, mapping documents and data dictionary.

Jul 2011 – Apr 2012 · 9 mos · Fairfax virginia

• Responsible for ETL development using Pervasive ETL tool in an SQL Server environment.
• Migrated data from flat files to SQL Server database.
• Well versed in writing T-SQL programming scripts in SQL server database.
• Expert in creating batch jobs in Windows.
• Responsible for fixing bugs on a daily basis using JIRA PMR Tracker.
• Improved performance by implementing best practices for coding in both Pervasive ETL and SQL Server database
• Participated in various customer facing meetings to discuss production issues and developing solutions.
• Analyzed and discussed the business requirements with the client and prepared requirements documents. Maintained all documents in Visual Source Safe (VSS) tool.
• Extensively used JIRA for tracking defects and communicating the issues and status.
• Extensively used batch files to run the ETL jobs in the Windows environment.
• Developed test cases and prepared Unit test documents for deployments into test, UAT and Production environments.

Sep 2010 – Jul 2011 · 10 mos · Reston virginia

• Implementing the data model required by the application
• Creating schema objects and implementing rules for data integrity
• Choosing a programming environment for a new development project
• Writing server-side PL/SQL or Java subprograms and client-side procedural code that use SQL statements
• Creating the application interface with the chosen development tool
• Establishing a Globalization Support environment for developing globalized applications
• Instantiating applications in different databases for development, testing, education, and deployment in a production environment

Apr 2010 – Sep 2010 · 5 mos

• Responsible for ETL development using Informatica ETL tool in an Oracle and UNIX environment.
• Migrated data from flat files (COBOL, complex flat files) to Oracle database.
• Developed ETL mappings for moving and transforming data from Source to Staging, Staging to Data mart areas.
• Well versed in writing Shell scripts in UNIX environment.
• Written complex SQL and PLSQL scripts for writing packages, procedures and functions.
• Extensively used BULK Collect and Fetch, triggers, cursors for building the PLSQL blocks.
• Responsible for fixing bugs on a daily basis both in Informatica and SQL/PLSQL.
• Improved performance by implementing best practices for coding in both Informatica ETL and Oracle database
• Participated in various customer facing meetings to discuss production issues and developing solutions.
• Extensively used Unix Shell scripts to run the ETL jobs.
• Developed test cases and prepared Unit test documents for deployments into test, UAT and Production environments.
• Attended various status meetings to update the project team and project manager about possible issues and defect status.
• Prepared deployment packages to deploy code into Test, UAT and Production environments.
• Prepared and maintained technical specification documents, mapping documents and data dictionary.
• Participated in data modeling sessions for developing dimensional models for various data marts.
• Participated in peer review sessions for reviewing code of other developers on the project.
• Written adhoc scripts for handling various adhoc requests from the user which required fast delivery.