SUMMARY:

• Highly motivated ETL Developer with strengths in data analytics, reporting, software development life cycle, relational database development, product support, and ability to quickly learn technologies.
• Other strengths include data modeling, data warehouse expertise, and the ability to solve business problems.
• Technical skills range from various programming languages to incorporating computer networking technologies.

TECHNICAL SKILLS:

Core Technical: Informatica PowerCenter, OBIEE, Oracle 11g, MySQL, Apache Tomcat, Unix/Linux

Methodologies: SDLC, Waterfall, Agile, Scrum, Rational Rose (UML)

Programming: Java/J2EE, C, C#, Pro *C, XML, Spring, Web Services, Databases, SQL, and PL/SQL

User Interface: JSP, Servlets, HTML, CSS, Java Script, AJAX, ASP.NET, Silverlight

Source Control: Clearcase, SVN, Git, Subversion

Non Technical: Troubleshooting, Requirements Gathering, Collaboration, Testing

Personal: Parallel Tasking, Strong Work Ethic, Adaptable and Flexible, Optimism and Integrity

PROFESSIONAL EXPERIENCE:

Confidential

ETL - Software Engineer

Responsibilities:

• Involved in gathering and analyzing the requirements and business rules.
• Responsible for designing and developing mappings, sessions and work flows to load the data from source to target database using Informatica Power Center and tuned mappings for improving performance.
• Involved in ETL process from development to testing and production environments.
• Extracted date from various sources like Flat files, Oracle, DB2 and loaded it into Target systems using Informatica PowerCenter 9.1.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.
• Tuned mappings and SQL queries for better performance and efficiency.
• Performed Unit testing and validated the data.
• Developed shell scripts in UNIX environment for various command tasks.
• Developed Workflows using Workflow manager in Informatica, maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Created tables and partitions in database Oracle ad also updated existing tables to fit into the existing data model.
• Written stored procedures in Oracle.
• Generated queries to check data consistency in development and test environments.
• Performed data research in source systems to meet business needs.
• Documented technical designs for extraction, transformation and loading.
• Involved in designing the Physical layer, BMM and Presentation layers using OBIEE Admin tool.
• Usage of session and repository variables in the Reports.
• Created summary and detailed reports to suit business requirement and also provide data level security.
• Creation of dashboard prompts in UI.
• Navigation between reports and passing values from one report to another.
• Experienced in star and snow flake schema data modeling.

Confidential

ETL Developer

Responsibilities:

• Created mappings by cleansing the data and populate that into populating the staging to Archive and then to Enterprise Data Warehouseby transforming the data into business needs & Populating theData Martwith only required information.
• Contributed to the development ofETLmappings aggregator, union,both connected and unconnectedlookupandfilter transformations.
• Worked using Parameter Files, Mapping Variables, and Mapping Parameters for Incremental loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Participated in Joint Analysis Design with user community and Business users.
• Updated numerous BTEQ/SQL scripts, making appropriate DDL changes and completed unit and system test.
• Created tables, access views and update views in the development database for unit and system test.
• Worked on the shell scripts for the data loading in the staging areas using Putty.
• Developed Fast Export, Fast Load and Multi Load scripts to extract and load the data.
• Performed unit and system test for the modified code and loaded shadow data marts for testing prior to production implementation.
• Prepared conceptual design document for implementing new data elements to EDW.
• Re-wrote the complex process thru BTEQ for modular approach.
• Extensively involved in ETL testing, Created Unit test plan to test the business functionality, created test data.
• Participated in build of the Data Warehouse, which includes the Design of Data mart using Star Schema.
• Prepared number of ETL Technical design documents for loading data from DW and flat files to stage tables and then from Stage tables to the Target tables.
• Written complex MLOAD scripts to load data from existing DW source tables and flat files to stage tables. Created several TD system usage reports for monitoring and capacity planning and for the higher management.

Confidential

ETL Developer

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data Consolidation, standardization, matching Trillium for the unstructured flat file data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Experience in integration of heterogeneous data sources like Oracle, DB2, B2B, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Managed the Metadata associated with the ETL processes to populate the Data Warehouse.
• Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping. Also managed to load the data using PERL scripts.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.

Confidential

Data Analyst

Responsibilities:

• Worked on Informatica - Source Analyzer, Mapping Designer, Mapplet and Transformations.
• Involved in the development of Informatica mappings and also tuned them for better performance.
• Extensively used ETL to load data from MSSQL Server, Oracle, and flat files to DB2.
• Used slowly changing dimensions to upload the data from Source to Target.
• Schedule the Data Warehouse to reflect changes from Source to Target every fortnight.
• Gather and analyze business requirements.
• Participated in design sessions where decisions are made involving the transformation from source to target.
• Develop mappings, workflows and sessions to load data from source to target tables.
• Created detailed process flow designs and high level operation procedures.
• Manage and compile documentation for all ETL processes.
• Designed and implemented the error handling strategy for ETL team.
• Monitor the usage of database space and performance.
• Design, develop and implement database systems based on customer requirements.
• Develop database tables and dictionaries.
• Created detailed Entity-relationship diagrams for data models.
• Participate in database design and architecture to support application development projects.
• Develop best practices for database design and development activities.
• Identify any issues related to database performance and provide corrective measures.