Informatica CDI (Cloud Data Integration) Location-Phoenix AZ at Phoenix, Arizona, USA |
Email: [email protected] |
Role name:Developer Role Description:In this role you will serve as a senior dedicated technical resource responsible for Oracle PL/SQL development for our Data Warehouse running on a Linux basedOracle 11g RAC 2 node cluster. The Data Warehouse is currently under development and you will be an integral part of its design and implementation.You will support key strategic initiatives, including the integration of new lines of business, design and implementation of data marts and subject areas,and key decisions around the future of the data warehouse. You will also be involved with the implementation of new reporting tools, new ETL routines and other projectsthat are core to developing and enhancing the data warehouse environment. Essential Job Functions:1. Utilize excellent hands-on PL/SQL skills to design and implement data warehouse subject areas.2. Develop high performing extraction, transformation and loading (ETL) routines for loading data from our production database into the data warehouse.3. Create PL/SQL that performs well with large data sets, is written to scale for future growth and adheres to business rules.4. Effectively integrate new lines of business into the DW requiring the addition of new data sources into existing tables and data marts.5. Share knowledge and PL/SQL expertise and mentor team members in the design of efficient reporting queries.6. Team with engineering, IT and business stakeholders to support projects of varying complexity; gather reporting and data warehousing requirements, evaluate best approach and propose solutions. Competencies:Informatica CDI (Cloud Data Integration), Oracle Data Integrator (ODI) Experience (Years):8-10 Essential Skills:Oracle Data Warehouses on Oracle, primarily in PL/SQL, Python, and Informatica Desirable Skills:Able to design and working with large data models, including ability to refine and tune these processes accordingly. Able to validate Data Quality each step of the process. Able to work independently, as well as lead small sub-teams. Must have demonstrated ability to build, modify, and interpret the data models associated with data warehouses, data marts, and reporting. Must be able to communicate effectively with technical and non-technical staff. Country:United States Branch | City | Location:TCS - Phoenix,AZ -- Tauheed Saleem | Talent Acquisition Teamware Solutions a division of Quantum Leap Consulting Pvt. Ltd 2838 E. Long Lake Road Suite 210, Troy, MI 48085 [email protected] LinkedIn- linkedin.com/in/tauheed-saleem-92ab546a/ Disclaimer This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. -- Keywords: information technology procedural language Arizona Michigan Informatica CDI (Cloud Data Integration) Location-Phoenix AZ [email protected] |
[email protected] View all |
Mon Apr 22 21:00:00 UTC 2024 |