We provide IT Staff Augmentation Services!

Etl Developer Resume

5.00/5 (Submit Your Rating)

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

We'd love your feedback!