Etl Developer Resume
San Francisco, CA
SUMMARY
- Extensive experience of 6+ Years in Data Warehousing, Decision support Systems and has wide experience in implementing Data Warehousing solutions for large corporate clients using Informatica Power Center.
- Strong Consulting experience in Implementing Full Life cycle Data Warehousing Projects..
- Developed Strategies for Data conversions, Extraction, Transformation and Loading (ETL) processes.
- Experience in developing complexMapplets, Workletsand re - usable Tasks, re-usable mappings.
- Experience in Performance tuning of sources, mappings, transformations, targets and sessions.
- Proficient in SQL, PL/SQL Procedures/Functions, Triggers and Packages.
- Experienced in interacting with Business users, Business Analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
- Excellent communication and interpersonal skills.
TECHNICAL SKILLS
RDBMS: Oracle 8i/9i/10g, Microsoft SQL Server 2000/2005, DB2 and MS Access
ETL Tools: Informatica Power Mart/Power Center 9.x/8.x/7.x
Reporting Tools: Business Objects, OBIEE
Operating Systems: Sun Solaris 8, Windows NT/98/95, WIN 2000
Languages/Utilities: SQL, PL/SQL, UNIX shell scripts, HTML
Other Tools/Utilities: TOAD, RapidSQL 7.1, Microssoft Office
PROFESSIONAL EXPERIENCE
Confidential, San Francisco, CA
ETL Developer
Responsibilities:
- Involved in the architectural redesign of the ETL for Wealth compensation application reporting to include the Legacy Wachovia’s Wealth trust and Brokerage transactions to compensate the financial advisors.
- Strong business and analytical skills including direct interaction with business end users for requirements analysis.
- Extensively used Informatica PowerCenter 8.6 to load extract data from Flat Files, Oracle, server, db2 and Teradata databases and load to Oracle, DB2 and Flat Files.
- Developed and maintained metadata content for data warehouse data sources
- Designed/developed, tested and implemented the ETL’s for the short term/long term solution to help support the Legacy Wachovia’s business reporting.
- Extensively used Informatica PowerCenter 8.6 to load extract data from Flat Files, Oracle, server, db2 and Teradata databases and load to Oracle, DB2 and Flat Files.
- Designed and developed shell scripts for loading the data from file transfer and handling.
- Responsible for Designing, Developing and testing all modules involved in the data acquisition process.
- Used Informatica Repository Manager to create new Folders, Users/Privileges and repositories.
- Documenting and deploying new ETL processes into a production environment.
- Worked with various Transformations like Aggregator, Expression, Filter, Source Qualifier, Joiner, Look Up and Stored Procedure, normalizer etc to in corporate the business rules into the mappings.
- The Scheduled and Ran Extraction and Load process and monitored sessions using Informatica Sever Manager.
- Fine-tuned existing Informatica Maps for performance optimization by partitioning the mappings.
- Validated the data in the reports against the databases.
- Developed PL/SQL procedures, packages for GL.
Environment: Informatica PowerCenter 8.6, Toad 9.1, Business Objects 5, Oracle 10g, DB2, SQL*Plus, PL/SQL
Confidential, Albany, NY
ETL Specialist III ETL Developer
Responsibilities:
- Involved in the Design and Development of EDW warehouse environment.
- Involved in full SDLC life cycle right from Planning/Analysis, Design, and Development, Testing, UAT, Implementation and Post Implementation Support activities.
- Used Technical transformation document to Design the Logical and Physical data models using Erwin/ER studio and design the architecture for ETL modules.
- Performed Data Profiling on the source systems to get a sense of the source application data for creating the business rules for the ETL.
- Design multidimensional data warehouse structures such as star schemas etc
- Develop mappings as per the design to meet the business requirements with expertise in SQL, stored procedures, indexes, partitioning, database design and tuning.
- Created Functions, Packages to automate the pull from TP, push to Data Mart, manage indexes, manage keys, Truncate tables, partitions.
- Designed/integrated the Shared Conformed facts and dimensions across all the application/source systems and staging to datamarts.
- Experience developing ETL processes using ETL control tables, error logging, auditing, data quality.
- Guided and helped the DBA, Testing and Software Configuration Management teams during Testing cycle.
- Involved in User Acceptance Testing (UAT) to support the UAT process and answer/clarify any questions raised by business users, test team and functional architects.
- Extensively used Informatica PowerCenter 8.6 to load extract data from Flat Files, Oracle db2 and Sybase databases and load to Oracle, DB2 and Flat Files.
- Used Mapping/sessions parameters and variables to perform the initial and incremental loading of data.
- Performance Tuned mappings and sessions to achieve best possible performance.
- Created Tasks, Worklets and Workflows and scheduled Workflows to run the jobs at required frequency using Workflow Manager.
- Used Informatica Repository Manager to create new Folders, Users, Privileges and repositories.
- Administered PowerCenter Server and resolved any issues when they arise.
- Developed PL/SQL procedures, Stored Procedures, Triggers, Views and UNIX Shell Scripts.
- Designed and deployed various UNIX Shell Scripts.
- Created new reports for new report development for different DataMarts.
Environment: Informatica PowerCenter 8.1, Oralce 10g, DB2, Toad 9.1, SQL*Plus, PL/SQL
Confidential, Portage, MI
ETL Architect/Modeler/Lead Data Warehouse Developer
Responsibilities:
- Participated in the review and approval of the technical transformation requirements document. Used technical transformation document to design and build the extraction, transformation, and loading ETL modules.
- Performed source data assessment and identified the quality and consistency of the source data.
- Extensively utilized Informatica PowerCenter 7.1 to load data from Flat files and Oracle database into Oracle database.
- Developed complex Informatica mappings and also tuned for better performance.
- Worked with various transformations like Aggregator, Expression, Filter, Source Qualifier, Joiner, Look Up and Stored Procedure etc to in corporate the business rules into the mappings.
- Created Mapping variables to perform the incremental loading of data.
- Scheduled and ran the extraction and load process using Server Manager.
- Created the Sessions and Batches and monitored them using Informatica Sever Manager.
- Developed PL/SQL procedures, Packages to extract data from multiple sources into ODS.
- Worked with business analysts to validate that the data extracts produce correct results.
- Fine-tuned existing Informatica Maps and Sessions for performance optimization.
- Resolved production issues by analyzing the issues thereby identifying the root cause of the problem and possible a work around to resolve the same.
- Used Erwin to update the existing Data Model.
- Imported all the necessary Fact and Dimension tables into the PowerAnalyzer from Informatica repository and defined business relationships among them so that they can be used for creation of a report.
Environment: Informatica PowerCenter 8.1.1SP2, Toad 9.1, Oracle 10g, DB2, SQL Server, SQL*Plus
Confidential, Kansas City, KS
ETL Developer
Responsibilities:
- Involved in requirements gathering in support of data warehousing to develop ETL.
- Involved in creating logical and physical data models using Erwin based on business requirements.
- Used Informatica 5.0 to load data from different source databases, flat files into the Confidential Oracle database.
- Worked with various transformations like Router, Expression, Aggregator, Filter, Sequence generator, connected and unconnected lookups to implement simple and complex business logic.
- Created Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
- Created, configured Workflows, Worklets and Sessions to transport the data to Confidential using Informatica Workflow Manager.
- Performance tuning of Sources, Targets, Mappings and Sessions. Improved performance by identifying performance bottlenecks and tuned various jobs at session level.
- Used PMCMD command in UNIX to schedule jobs and sessions using Autosys scheduler.
- Monitored the jobs on a daily basis and looked at the session logs to see if jobs completed successfully.
- Trouble shoot problems by checking the session log files. Also used debugger for complex troubleshooting.
- Created test data and unit test cases to ensure successful data loading process.
- Developed test plans and test scripts by decomposing the business requirements to support quality deliverability.
Environment: Informatica Power Center 7.1.1, Erwin 4.0, Oracle 9i, DB2, MS SQL Server 2000, PL/SQL, SQL Plus, Toad
Confidential, Minneapolis, MN
Data Warehouse Developer
Responsibilities:
- Involved in design of database using Entity Relationship Diagrams.
- Involved in creating logical and physical data models using Erwin based on business requirements.
- Extensively used Informatica (ETL) to load data from Oracle and flat files into the Confidential Oracle 8i database.
- Monitored the jobs on a daily basis and looked at the session logs to see if jobs completed successfully.
- Documented the number of source / Confidential rows and analyzed the rejected rows and worked on re-loading the rejected rows.
- Various transformations like Joiner, Aggregator, Expression, Lookup, Filter, Update Strategy, Stored Procedures and Router were used to solve simple and complex business logic.
- Wrote PL/SQL stored procedures to fulfill the iterative process and to solve complex business logic.
- Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
- Created and scheduled workflows using Workflow Manager to load the data into the Confidential Database.
- Implemented Type II Slowly Changing Dimensions Methodology to keep track of historical data and to load incremental data.
- Involved in performance tuning of Targets, Sources, and Mappings. Improved performance by identifying performance bottlenecks.
- Worked on different tasks in Workflows like sessions, events raise, event wait, e-mail and timer for scheduling of the workflow.
- Created UNIX shell scripting and automation of scheduling processes.
- Extensively used Calculations, Variables, Break points, and Sorted inputs.
Environment: Informatica Power Center 7.1.1, Business Objects5.x, Web Intelligence. Erwin 4.0, Oracle 9i, DB2, MS SQL Server 2000, PL/SQL, SQL Plus, Toad