SUMMARY

• Highly motivated, solution driven software engineer wif over 9 years of Data Warehousing experience in the area of ETL Design and Development.
• Involved in complete SDLC of various projects wif an ability to remain highly focused & self - assured in fast-paced and high-pressure environments.

SKILL HIGHLIGHTS

• IBM Infosphere Datastage
• Informatica Power Center
• PL/SQL Programming
• Unix Shell Scripting
• Agile/Scrum Methodology
• Python Programming
• ESP/Autosys Scheduling
• Strong Decision Maker

PROFESSIONAL EXPERIENCE

Sr.ETL Developer

Confidential - Chittanoonga,TN

Responsibilities:

• Developing ETL datastage jobs for Pharmacy benefit management where they migrated from Express scripts to CVS.
• Rewriting the ETLs to pull the data from various systems and integrate them into the data warehouse.
• Write Unix shell scripts to automate the data loads and call Datastage sequences.
• GIT tool to promote the code to higher environments.
• Developed ETL programs using Informatica and Datastage to implement the business requirements
• Create new mapping designs using Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Hands-on experience in core Python programming language.
• Writing Python scripts to parse XML documents as well as JSON based REST Web services and load the data in the database.
• Extensive knowledge Python Data manipulation libraries (Pandas, numpy, petl etc)
• Profiling Python code for optimization and memory management and implementing multithreading functionality.
• generating the complex SQL queries and building reusable code and libraries in Python for future use.
• Performed data manipulations using the Filter, Expression, Lookup, Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union Transformations.

Sr.Technical Lead

Confidential - Charlotte,NC

Responsibilities:

• Extensively used ETL methodology for supporting extract, Transform and load environment using IBM Infosphere Datastage.
• Built Transactional, Dimension Data Modeling and ETL
• Designed star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture.
• Developed Logical and Physical data models for new requirements.
• Worked on identifying Facts, Dimension tables from Existing relational Models and subModels of data marts.
• Integrate the details of tax reporting requests from various applications, allow the forms to be edited,adjusted as required, and file a final record wif the IRS and state fillings as well as archiving the final document.
• Proposed efficient solutions when the business decisions effect the current workload also implemented Dynamic solutions to deal wif new products in future.Integration wif java and SQL teams while implementing new database and business rules.
• Reduced unnecessary intervention of other applications by implementing the required functionality wifin datastage which in turn improved the performance.

Datastage Developer

Confidential - Portland, OR

Responsibilities:

• Involved in implementing data warehouse along wif architects and data governance teams and consulted the team on the design issues and implementations.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
• Involved as primary on-site ETL Developer during the analysis, planning, design, development, and implementation stages of projects using IBM Infosphere Datastage.
• Worked on SCDs to populate Type me and Type II slowly changing dimension tables from several operational source files.
• Utilized Parallelism through different partition methods to optimize performance in a large database environment.
• Analyze and identify what all changes required in each Datastage job to accommodate 11.5 version and also as we moved from Solaris to Linux environment, gone through each stage to see if any UNIX commands were used and converted them to Linux commands.
• Captured the performance and test results before and after the changes, compared them wif the business users to get trusted concurrence.
• Optimized the existing jobs for better performance and implemented new business logic in the production environment.Tuned DataStage transformations and jobs to enhance their performance.
• Filtered bad data from legacy systems using SQL and implemented constraints and triggers into new systems for data consistency.

System Engineer

Confidential

Responsibilities:

• Upgrade the IDS - Integrated Data Store to use Datastage instead of the Data integrator & ETL tool Business Objects Data Integrator 11.5v(BODI).
• Experienced in integration of various data sources (DB2-UDB, SQL Server, PL/SQL, Oracle, Teradata, XML and MS-Access) into DataStage.
• Identify the field/column level data quality issues of the source systems to drive the data quality, data cleansing and error checking in the ETL mappings. Identify and document the source to target mapping data lineage.
• Identified source systems, their connectivity, related tables and fields and ensure data suitability for mapping.
• Creating technical documentation such as Data Flow diagrams, Database diagrams. Created the template of the mapping document and also generated a sample mapping document which is approved by the client.
• As a graduate hire, me has spent a good amount of time in understanding the process, tools and the project scope.
• Worked on a client specific tool named ELMO (electronic movers), which is a platform to exchange the files/data between Confidential and third parties. ELMO is basically developed using .Net and runs on UNIX shell scripting.
• Creation and installation of encryption, SSL and SSH keys.
• Control-M scheduling between mainframe and midrange systems.
• Automated the existing functionality of absence management application to run on its own, wifout any manual intervention and wif the database update by the business team.
• Optimized the performance of various SQL scripts, Stored Procedures and triggers.